SQL
Course Index
45 Lessons · 3 Levels
Master SQL from fundamentals to advanced database engineering — queries, joins, subqueries, indexes, stored procedures, window functions and performance tuning.
45Lessons
3Levels
2Projects
FreeAccess
Level I
Beginner Level
Lessons 1–15
Lesson 01
Introduction to SQL
Lesson 02
Installation & Setup
Lesson 03
SQL Basics
Lesson 04
SELECT Queries
Lesson 05
WHERE Clause
Lesson 06
AND, OR, NOT
Lesson 07
ORDER BY
Lesson 08
LIMIT
Lesson 09
DISTINCT
Lesson 10
Basic Functions
Lesson 11
Aggregate Functions
Lesson 12
GROUP BY
Lesson 13
HAVING
Lesson 14
IN, BETWEEN, LIKE
Lesson 15
Basic SQL Project
Level II
Intermediate Level
Lessons 16–30
Lesson 16
Joins Overview
Lesson 17
INNER JOIN
Lesson 18
LEFT JOIN
Lesson 19
RIGHT JOIN
Lesson 20
FULL JOIN
Lesson 21
CROSS JOIN
Lesson 22
SELF JOIN
Lesson 23
Subqueries
Lesson 24
Views
Lesson 25
UNION / UNION ALL
Lesson 26
Indexes
Lesson 27
Normalization
Lesson 28
Constraints
Lesson 29
Transactions
Lesson 30
Intermediate SQL Project
Level III
Advanced Level
Lessons 31–45
Lesson 31
Stored Procedures
Lesson 32
SQL Functions
Lesson 33
Triggers
Lesson 34
Cursors
Lesson 35
Window Functions
Lesson 36
Recursive Queries
Lesson 37
Working with JSON in SQL
Lesson 38
Dynamic SQL
Lesson 39
Query Optimization
Lesson 40
Index Tuning
Lesson 41
Database Design
Lesson 42
Data Warehouse Basics
Lesson 43
ETL Basics
Lesson 44
Advanced SQL Projects
Lesson 45
Mini SQL Project