Topics

12 domains, 110 topics — distilled from curated books. Pick a domain to start.

Relational Foundations

The mathematical model beneath relational databases, and the places where SQL deliberately differs from it.

Turning requirements into durable schemas through dependencies, normalization, deliberate trade-offs, and proven modeling patterns.

The core language for deriving and changing relational data, from logical evaluation through joins, aggregation, and writes.

Composable techniques for recursion, analytics, per-row derivation, multidimensional aggregation, and temporal questions.

Making meaning and integrity explicit with data types, constraints, views, generated values, and database-side behavior.

Reasoning about correctness when work overlaps: isolation, locking, MVCC, deadlocks, retries, and application boundaries.

How access paths, statistics, query shape, algorithms, and measurement combine to make database work fast and predictable.

The machinery beneath SQL: pages, buffers, logging, recovery, execution pipelines, physical layouts, and reclamation.

Designing safe, efficient database interactions across connections, queries, transactions, abstractions, and production schema changes.

Protecting data and keeping it available through access control, recovery, observability, lifecycle management, replication, and failover.

Separating the portable SQL core from consequential product differences in names, types, expressions, DML, and transactions.

A concrete PostgreSQL case study spanning architecture, types, MVCC, maintenance, indexes, planning, recovery, and diagnostics.