sql Track Masterclass

Structured SQL Curriculum Roadmap

Follow our structured masterclass to learn Structured SQL from scratch. Choose a module below or navigate through lessons using the sidebar.

0 Modules•0 Total Lessons•100% Free & Open

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 Lessons

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

2. Advanced Filtering

6 Lessons

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

3. SQL Functions

5 Lessons

String Functions Numeric Functions Date Functions NULL Functions CASE Expression

4. Grouping & Aggregations

6 Lessons

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

5. Database Joins

8 Lessons

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

6. Subqueries

5 Lessons

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

7. Common Table Expressions

3 Lessons

CTE Basics Recursive CTE Multiple CTEs

8. Window Functions

9 Lessons

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

9. Set Operators

4 Lessons

UNION Operator UNION ALL Operator INTERSECT Operator EXCEPT Operator

10. Data Modification

4 Lessons

INSERT Statement UPDATE Statement DELETE Statement MERGE Statement

11. Database Objects

6 Lessons

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

12. Advanced SQL

5 Lessons

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