Booking options
£12
Course Images
SQL Programming: The SQL Database Programming Fundamentals Complete Training Course
By One Education
(1)- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
11 hours
All levels
Description
SQL Programming: The SQL Database Programming Fundamentals Complete Training Course is designed to introduce learners to the core language that powers modern data storage and retrieval. This course explains how structured query language operates within relational databases, focusing on how data is organised, accessed, and managed efficiently. Key SQL concepts such as tables, queries, relationships, and data integrity are presented in a clear and logical manner, making the subject approachable for those new to database programming. The content emphasises accuracy, structure, and clarity, ensuring learners understand how SQL supports reporting, data analysis, and information systems across industries.
The course also explores essential SQL commands and database logic used to handle datasets of varying complexity. Attention is given to writing clear queries, maintaining reliable data structures, and understanding how databases respond to instructions. With a strong focus on theory and application through examples, this training supports confidence in reading, writing, and interpreting SQL statements. Suitable for career development or knowledge enhancement, the course provides a solid foundation in SQL database programming fundamentals while remaining fully online and accessible on demand.
Expert Support
Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.
Key Benefits
Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.
Get 24/7 access to all content for a full year.
Each of our students gets full tutor support on weekdays (Monday to Friday)
This masterclass Mastering SQL Programming online training course is designed by industry experts and will give you an in-depth understanding of this topic. The course features easy-to-digest modules that break down each topic and ensure all our students receive an unrivalled and thorough learning experience.
If you want to work in this rapidly growing sector and stand out from the competition, then our Mastering SQL Programming is the perfect place to kickstart your dream career.
On the Mastering SQL Programming course, we guarantee that you will gain relevant skills and acquire tremendous knowledge on the subject. The certificate you'll achieve after completing the course will help you land the job you want in a related field.
Enjoy a pleasant and professional 100% online learning experience and enrol in our Mastering SQL Programming today and take control of your career!
Course Curriculum:
Unit 01: Introduction
Introduction
Tools Used in This Course
Unit 02: Setting up Course Tools
Download PostgreSQL
Install PostgreSQL
Download SQLectron
Install SQLectron
Connect to PostgreSQL - Credentials
Connect to PostgreSQL Using SQLectron
Import Course Data Using SQLectron
FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data
Unit 03: Browsing & Filtering Data
Check Imported Data
What is a Database?
Data Types
Finally Some Fun! Extracting Data Based on Requirements
Filtering Data using WHERE Keyword
Filter Data by Range Using BETWEEN
Filter Data by Set of Values Using IN
Filter Data by Date
More Filtering by Date
Another Query Filtering by Date
Filter Data by Strings
More Filtering by Strings
More Filtering by Strings 2
More Filtering by Strings 3
How to Ignore Caps when Filtering by String
Unit 04: Filter Data with AND, OR, NOT Operators
AND Operator
OR Operator
NOT Operator
AND, OR & NOT Operators: Which Has the Highest Priority?
Unit 05: Math Operations
Basic Math Operations
Modulo Operator
Calculate The Net Salary for Employees
Filter Data with Math Equations
Unit 06: String Concatenation
Concatenate Strings with '||' Operator
Concatenate Strings with Numbers
Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records
Give Your Report Fields A Cool Name
A Report for Payroll
Order Records by Column
Order Records by Multiple Columns
How Alias Names Cannot Be Used with WHERE
LIMIT Record Count Fetched by Your Query
Unit 08: NULL, DISTINCT & CASE Statements
Fetch A Field's Unique Values Using DISTINCT
Using DISTINCT Keyword with Multiple Columns
What is a NULL Value Anyway?
Build More Sophisticated Queries with CASE Statements
Your Knowledge So Far Under A Great Test
Unit 09: Functions in SQL: Multiple-Row Functions
Let Me Introduce You to Functions
SUM Function
AVG (Average) Function
COUNT Function
MIN & MAX Functions
How To Count Your Field's Unique Values
GROUP BY Clause: Use Functions with Dimensions
GROUP BY More Than One Dimension
Now For Some Tough Workout
Filter By Aggregate Functions with HAVING Clause
Unit 10: Functions in SQL: Single-Row Functions
Character Functions - UPPER, LOWER & INITCAP
Character Functions - CONCAT & LENGTH
Character Functions - LPAD & RPAD
Character Functions - TRIM
Character Functions - REPLACE
Character Functions - SUBSTR
Number Functions - MOD & ROUND
Number Functions - TRUNC
Unit 11: Nested Queries
Selectception: A Select Query inside another Select Query!
Unit 12: Casting & Data Conversion
Auto Data Conversion
Cast Date to Character
Cast Number to Character
Cast Timestamp to Character
Cast Character to Number
Cast Character to Date & Timestamp
Unit 13: Combination Relationships
UNION
UNION ALL
Important Note about Combining Queries
INTERSECT
EXCEPT
Unit 14: Joins in SQL
Employees & Departments Tables Revised
Entity Relationship Diagram (ERD)
Cartesian Join
Table Aliases with Joins
Why I Don't Recommend Cartesian Joins
Inner Join
In-Depth Look into Join Types in SQL
Outer Join - Right, Left & Full
Unit 15: Data Manipulation (DML)
INSERT a New Record to a Table
Insert Without Specifying Column Names
UPDATE a Record's Field Values
CAUTION! How an UPDATE Query Can Go Wrong
Update a Record Using Single-Row Functions
A Good Exercise: Extract Employee's Email Address
Solution: Extract Employee's Email Address
DELETE a Table's Record
Insert Records with Nested Select Queries
Unit 16: SQL Data Definition Language (DDL)
SQL Data Types Revised
Bookstore Data Set: Let's Move It to Database
Create Your First Table!
Insert Data to Your New Table
Change Column Data Type
Rename Column
Add a New Column to Table
Constraints in SQL
Primary Keys
NOT NULL Constraint
UNIQUE Constraint
DEFAULT Constraint
Foreign Keys
Use Foreign Keys with Joins - Books & Publishers
Foreign Keys - Properties
Drop Column
DROP Table
Create a New Table with Select Statement
A Trick to Create an Empty Table with Select Statement
Insert New Records Using Select Statement
Views
Schemas
Create & Use Schemas
Course Assessment
To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.
When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.
Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
Who is this course for?
This Mastering SQL Programming course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.
Requirements
This Mastering SQL Programming course is open to all, with no formal entry requirements.
Career path
Upon successful completion of the Mastering SQL Programming Course, learners will be equipped with many indispensable skills and have the opportunity to grab, such as:
SQL Developer
Database Administrator
Data Analyst
Business Intelligence Developer
Data Engineer
Data Scientist
Database Analyst
ETL Developer
SQL Server Developer
Reporting Analyst
Reviews
There are no reviews for SQL Programming: The SQL Database Programming Fundamentals Complete Training Course yet.Why not be the first one to review this course?
