Courses / Beginner
SQL Mastery
From SELECT to production-grade queries.
Go from basic queries to advanced SQL — joins, window functions, CTEs, indexing, query optimization, transactions, and more. Covers PostgreSQL, MySQL, and SQLite differences.
Your progress
Click "Mark complete" at the bottom of each lesson to track progress. Progress is saved locally in your browser.
Syllabus
- 5 lessons
Module 1
SQL Foundations
Learn what SQL is, write your first queries, create tables, and understand how joins connect data across tables.
- 5 lessons
Module 2
Aggregation and Subqueries
Group and summarize data with aggregate functions, then break complex queries into manageable pieces using subqueries and CTEs.
- 4 lessons
Module 3
Window Functions
Master window functions to perform calculations across rows without collapsing your result set.
- 5 lessons
Module 4
Indexing and Performance
Understand how indexes work under the hood, read query plans, and optimize slow queries for production workloads.
- 5 lessons
Module 5
Transactions and Data Integrity
Ensure data correctness with transactions, isolation levels, normalization, and strategies for preventing deadlocks.
- 5 lessons
Module 6
Advanced SQL
Explore advanced features like JSON operations, materialized views, full-text search, row-level security, and stored procedures.
Certificate of completion
When every lesson is marked complete, the certificate becomes available below.
Get your certificate →