sql Curriculum Roadmap

Follow our structured pathway to learn sql from scratch. Choose a module from the curriculum below or select a lesson in the sidebar.

Interactive Hands-On Practice Bypasses Setup!

Put your knowledge to the test inside the browser

Don't just read about algorithms—build them. Write scripts in our Playground or challenge yourself on interactive exercises evaluated via WebAssembly.

1. SQL Fundamentals

6 structured lessons in this unit.

Introduction to SQL SELECT Statement WHERE Clause ORDER BY LIMIT / TOP DISTINCT

2. Advanced Filtering

6 structured lessons in this unit.

Comparison Operators Logical Operators IN Operator BETWEEN Operator LIKE Pattern Matching IS NULL Checks

3. SQL Functions

5 structured lessons in this unit.

String Functions Numeric Functions Date Functions NULL Functions CASE Expression

4. Grouping & Aggregations

6 structured lessons in this unit.

COUNT Function SUM Function AVG Function MIN & MAX Functions GROUP BY Clause HAVING Clause

5. Database Joins

8 structured lessons in this unit.

INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN SELF JOIN CROSS JOIN Semi Join Anti-semi Join

6. Subqueries

5 structured lessons in this unit.

Scalar Subqueries Correlated Subqueries EXISTS Operator NOT EXISTS Operator IN vs EXISTS

7. Common Table Expressions

3 structured lessons in this unit.

CTE Basics Recursive CTE Multiple CTEs

8. Window Functions

9 structured lessons in this unit.

ROW_NUMBER RANK DENSE_RANK LAG Function LEAD Function FIRST_VALUE LAST_VALUE NTILE Function Running Totals

9. Set Operators

4 structured lessons in this unit.

UNION Operator UNION ALL Operator INTERSECT Operator EXCEPT Operator

10. Data Modification

4 structured lessons in this unit.

INSERT Statement UPDATE Statement DELETE Statement MERGE Statement

11. Database Objects

6 structured lessons in this unit.

Views Indexes Primary Key Constraint Foreign Key Constraint Unique Constraint Check Constraint

12. Advanced SQL

5 structured lessons in this unit.

Pivot Basics Unpivot Basics Recursive Queries Dynamic SQL (Introduction)Stored Procedure