Track map
From everyday SQL to senior-level Postgres: query design, modelling, performance, concurrency, operations, and using Postgres correctly from a Node.js app.
Track progress
0/12lessons complete
Unit 1
psql, tables and types, data changes, filtering and pagination, NULL logic, and the logical order of a query.
Finishing a lesson checks it automatically. You can also mark it learned here.
Review key ideas →Test out of this unit →Unit 2
Inner and outer joins, GROUP BY and HAVING, subqueries and EXISTS, set operations, and dates and time zones.
Finishing a lesson checks it automatically. You can also mark it learned here.
Review key ideas →Test out of this unit →Unit 3
CTEs and recursive CTEs, window functions, top-N per group, running totals, DISTINCT ON and LATERAL.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 4
Primary and foreign keys, constraints, normalisation, relationships, enums and money, and evolving a schema.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 5
How indexes work, choosing the right ones, reading query plans, statistics, and finding slow queries.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 6
ACID, row versions and snapshots, isolation levels and anomalies, retries, VACUUM, and long transactions.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 7
Table and row locks, SKIP LOCKED job queues, deadlocks, advisory locks, upserts, and lock-safe DDL.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 8
jsonb and its indexes, full-text search, arrays and ranges, views, generated columns, triggers, and extensions.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 9
Pooling, partitioning, replication and CDC, backups and PITR, zero-downtime migrations, and monitoring.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 10
Roles and least privilege, SQL injection, Row-Level Security, connection security, and encryption.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 11
Pools and serverless drivers, ORMs and query builders, transactions in code, outbox, idempotency, multi-tenancy, and testing.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.
Unit 12
An e-commerce schema, classic interview queries, diagnosing slow queries and incidents, and senior-level trade-offs.
Finishing a lesson checks it automatically. You can also mark it learned here.
Lessons for this unit are coming soon.