Course catalog

Advanced Databases

Own the data layer.

Advanced
16 lessons
2 projects
About 2.5h
EN · UZ · KO

Take the SQL you know and push it to mastery: multi-table JOINs, aggregations, subqueries, and CTEs that read like prose. Then learn what separates a working database from a reliable one — normalization, transactions, ACID, and indexes — before touring the NoSQL landscape of document, key-value, wide-column, and graph stores. Finally, go to production: injection-proof queries, ORMs, migrations, replication, and caching. You'll finish by choosing and defending a complete data stack for a food-delivery app.

Start with a preview lesson Compare all plans

Curriculum

Section 1
Advanced SQL
Answer real product questions in one query with joins, grouping, subqueries, and CTEs.
1. Inner vs Left Join
2. Joining Three Tables
3. GROUP BY & HAVING
4. Subqueries & CTEs
Section 2
Reliable by Design
Design schemas that stay correct and fast with normalization, transactions, ACID, and indexes.
1. Normalization, Pragmatically
2. Transactions & ACID
3. Indexes

Learning paths

Python & Data Developer

Analyze real data and build tested tools that talk to outside APIs safely and search your own content, using Python, Git, SQL, and vector search.

10 course sequence

Try one lesson. Then build the habit.

Eligible first-time members can get 7 free days · Cancel anytime

Get started

Back to courses

Advanced Databases

Curriculum

Advanced SQL

Reliable by Design

Learning paths

Python & Data Developer

Try one lesson. Then build the habit.

The NoSQL Landscape

Databases in Production