Complete track · self-paced · project-driven

The Complete SQL Course, beginning to mastery.

From “what is a table?” all the way to designing production schemas, tuning slow queries, and understanding what the optimizer does under the hood. Real PostgreSQL runs live in your browser — every lesson ends with you querying an actual database, not just reading about one.

6parts
23sections
83lessons
4projects
~70hest. time
Start the course1.1 — Why SQL & Why It Endures
Start →View dashboard

The journey — six ascending stages

I

PART I

Foundations

Absolute beginner → Confident beginner

4 sections0%
II

PART II

Multi-Table SQL

Confident beginner → Intermediate

4 sections0%
III

PART III

Database Design

Intermediate → Advanced

4 sections0%
IV

PART IV

Advanced Querying

Advanced → Production-ready

4 sections0%
V

PART V

Real World

Expert tracks — pick your paths

5 sections0%
VI

PART VI

Mastery

Expert → Mentor

2 sections0%

Full curriculum

I

Foundations

Absolute beginner → Confident beginner
0%
1  Getting Started: Thinking in Tables4 lessons
1.1Why SQL & Why It Enduresopen →
1.2Tables, Rows & the Relational Modelopen →
1.3Setting Up Your Labopen →
1.4Your First SELECTopen →
2  Reading Data: The SELECT Statement4 lessons
2.1SELECT & FROM: Choosing Columnsopen →
2.2WHERE: Filtering Rowsopen →
2.3ORDER BY & LIMITopen →
2.4DISTINCT, Aliases & Expressionsopen →
3  Data Types, NULL & Conditional Logic4 lessons
3.1Core Data Types Across Dialectsopen →
3.2NULL & Three-Valued Logicopen →
3.3CASE: Decisions Inside Queriesopen →
3.4Casting & Type Pitfallsopen →
4  Aggregation: From Rows to Answers4 lessons
4.1Aggregate Functionsopen →
4.2GROUP BYopen →
4.3HAVING: Filtering Groupsopen →
4.4The Logical Order of a Queryopen →
Milestone project

The Data Detective

Solve 15 cafe POS questions with single-table SELECT, WHERE, ORDER BY, aggregates, GROUP BY, HAVING, and exact self-checks.

II

Multi-Table SQL

Confident beginner → Intermediate
0%
5  Joins: Combining Tables4 lessons
5.1Keys & Relationshipsopen →
5.2INNER JOINopen →
5.3LEFT, RIGHT & FULL OUTER JOINopen →
5.4Self-Joins, CROSS JOIN & Many-to-Manyopen →
6  Shaping Data: Functions in Depth3 lessons
6.1Text & Pattern Matchingopen →
6.2Dates, Times & Time Zonesopen →
6.3Numbers, Rounding & Moneyopen →
7  Subqueries, CTEs & Set Operations4 lessons
7.1Subqueriesopen →
7.2Correlated Subqueries & EXISTSopen →
7.3CTEs: Readable Query Pipelinesopen →
7.4UNION, INTERSECT & EXCEPTopen →
8  Writing Data: INSERT, UPDATE, DELETE4 lessons
8.1INSERT: Getting Data Inopen →
8.2UPDATE & DELETE — Safelyopen →
8.3Upsert & MERGEopen →
8.4RETURNING & Bulk Loadingopen →
Milestone project

The Library Ledger

Operate a five-table library ledger with joins, overdue reports, subqueries, safe checkout and return writes, fines, and payments.

III

Designing Databases

Intermediate → Advanced
0%
9  Creating Schemas: DDL4 lessons
9.1CREATE TABLE Done Rightopen →
9.2Constraints: Your Data's Immune Systemopen →
9.3Keys: Natural, Surrogate & UUIDopen →
9.4ALTER: Evolving a Live Schemaopen →
10  Data Modeling & Normalization4 lessons
10.1From Requirements to ERDopen →
10.2Normalization: 1NF → BCNFopen →
10.3Denormalization on Purposeopen →
10.4Schema Antipatternsopen →
11  Views, Functions & Triggers3 lessons
11.1Views & Materialized Viewsopen →
11.2Stored Functions & Proceduresopen →
11.3Triggers: Power & Perilopen →
12  Transactions & Concurrency3 lessons
12.1ACID & the Transactionopen →
12.2Isolation Levels & Their Anomaliesopen →
12.3Locks, Deadlocks & MVCCopen →
Milestone project

Design the Store

Design a store schema, enforce its rules, seed it, and script a transactional checkout from an empty database.

IV

Advanced Querying

Advanced → Production-ready
0%
13  Window Functions4 lessons
13.1OVER: Aggregates Without Collapsingopen →
13.2Ranking: ROW_NUMBER, RANK, DENSE_RANKopen →
13.3LAG, LEAD & Framesopen →
13.4Patterns: Top-N, Dedup, Gaps & Islandsopen →
14  Recursion & Series2 lessons
14.1Recursive CTEs: Trees & Graphsopen →
14.2Generating Series & Date Spinesopen →
15  Semi-Structured Data4 lessons
15.1JSON in SQLopen →
15.2Arrays & Composite Typesopen →
15.3Full-Text Searchopen →
15.4Pivot & Unpivotopen →
16  Performance & the Optimizer4 lessons
16.1How Your Query Actually Runsopen →
16.2Indexes in Depthopen →
16.3Reading EXPLAINopen →
16.4Tuning Patterns That Matteropen →
V

SQL in the Real World

Expert tracks — pick your paths
0%
17  SQL for Analytics4 lessons
17.1Thinking in Metrics & Grainopen →
17.2Funnels, Retention & Cohortsopen →
17.3Time-Series & Period-over-Periodopen →
17.4The Modern Data Stackopen →
18  SQL from Application Code4 lessons
18.1Drivers, Pools & Transactions in Codeopen →
18.2SQL Injection & Parameterized Queriesopen →
18.3ORMs vs Raw SQLopen →
18.4Migrations & Zero-Downtime Changesopen →
19  Operating a Database3 lessons
19.1Users, Roles & Permissionsopen →
19.2Backups & Recoveryopen →
19.3Monitoring & Slow-Query Huntingopen →
20  The Dialect Landscape3 lessons
20.1A Tour of the Dialectsopen →
20.2Writing Portable SQLopen →
20.3Beyond Relational: NoSQL & NewSQLopen →
21  Using AI with SQL3 lessons
21.1AI as Your Query Copilotopen →
21.2Text-to-SQL: Schemas & Promptsopen →
21.3Trust, but Verifyopen →
VI

Mastery

Expert → Mentor
0%
22  Under the Hood: How Databases Really Work4 lessons
22.1Storage: Pages, Heaps & B-Treesopen →
22.2The Optimizer: Statistics & Join Algorithmsopen →
22.3WAL, MVCC & Crash Recoveryopen →
22.4Scaling: Replication, Partitioning & Distributed SQLopen →
23  Craftsmanship & the SQL Mindset3 lessons
23.1SQL Style & Code Reviewopen →
23.2Testing SQL & Data Qualityopen →
23.3Becoming the Database Personopen →
Milestone project

Own the Data

Own a messy marketplace dataset end to end: model it, load clean tables, answer analytics questions, tune with indexes, and ship checks.

Completed In progress Upcoming🏆 Project — hands-on build💡 Insight — usually skipped elsewhere⚠️ Trap — classic mistake to learn early