★★★★★
"The structure, the practice exams, the instructor — all top tier. Passed first try."
AS
Ranjan PradhanSenior Project Manager
— The journey
Course Outline
What the programme covers, module by module.
Module 1: Introduction to Databases & SQL
- Database concepts
- Relational databases
- Database management systems
- SQL overview
- Database applications
- SQL environments
Module 2: Database Structure Fundamentals
- Tables
- Rows and columns
- Primary keys
- Foreign keys
- Relationships
- Database schemas
Module 3: SQL Data Types
- Numeric data types
- Character data types
- Date and time types
- Boolean values
- Null values
- Choosing data types
Module 4: Retrieving Data with SELECT
- SELECT statements
- Selecting columns
- Selecting all columns
- Aliases
- Distinct values
- Basic queries
Module 5: Filtering Data
- WHERE clause
- Comparison operators
- Logical operators
- IN operator
- BETWEEN operator
- NULL handling
Module 6: Sorting Query Results
- ORDER BY clause
- Ascending sorting
- Descending sorting
- Multi-column sorting
- Sorting best practices
- Query readability
Module 7: Working with SQL Functions
- String functions
- Numeric functions
- Date functions
- Conversion functions
- Null functions
- Function applications
Module 8: Aggregate Functions
- COUNT
- SUM
- AVG
- MIN
- MAX
- Aggregate calculations
Module 9: Grouping & Filtering Groups
- GROUP BY
- HAVING clause
- Grouped results
- Aggregate analysis
- Multiple groupings
- Summary reporting
Module 10: SQL Joins
- Join concepts
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN concepts
- Multiple table queries
Module 11: Subqueries
- Subquery concepts
- Single-row subqueries
- Multiple-row subqueries
- Nested queries
- Correlated subqueries
- Practical examples
Module 12: Data Manipulation Language
- INSERT statements
- UPDATE statements
- DELETE statements
- Data modifications
- Data integrity
- Safe data updates
Module 13: Database Constraints
- Primary key constraints
- Foreign key constraints
- Unique constraints
- Not Null constraints
- Default values
- Data validation
Module 14: Views & Indexes
- View concepts
- Creating views
- Benefits of views
- Index concepts
- Query optimisation basics
- Performance considerations
Module 15: Transactions & Database Security
- Transaction concepts
- COMMIT
- ROLLBACK
- Transaction control
- Access control awareness
- Data protection concepts
Module 16: Database Design Fundamentals
- Database design principles
- Entity relationships
- Normalisation basics
- Schema design
- Data consistency
- Database best practices
— 01.2 · Is it right for you?
Who it's for & what's included
Pick a delivery method to see exactly who it suits and everything you receive.
Who it's for
Classroom
Best for learners who want face-to-face tuition and to network with peers in person.
What's included
Everything you get
- ✓ Live instructor on-site
- ✓ Printed workbook & materials
- ✓ Group exercises & case studies
Who it's for
Online Instructor-Led
Best for learners who want a live instructor and a fixed schedule, without the travel.
What's included
Everything you get
- ✓ Live instructor via video call
- ✓ Digital workbook & resources
- ✓ Session recordings
Who it's for
Self-Paced
Best for self-motivated learners who need maximum flexibility around work and life.
What's included
Everything you get
- ✓ On-demand video lessons
- ✓ Interactive quizzes
- ✓ 24/7 access on any device
— About this course
Course Overview
The SQL Programming Fundamentals Certification course provides beginners with essential knowledge of relational databases and Structured Query Language (SQL). Learners explore database concepts, tables, data types, querying, filtering, sorting, joins, aggregate functions, subqueries, views, indexes, data manipulation, constraints, transactions, and foundational database design practices.