AI can write your SQL, suggest indexes, and sketch architectures. But when the query is slow in production, the pipeline silently drops data, or an architecture decision locks you into years of tech debt — AI can't own that. You can — but only once you understand how these systems actually work underneath, not just how to call them. That mechanistic understanding is what Data System School builds.

The core program

Build the mechanistic understanding that production judgment depends on.

Learn how data systems actually work — measure them, build their core mechanisms, and dissect ones you've never seen. It's a hands-on lab course: nine phases plus a final project, from measurement and query plans through storage, transactions, OLAP, distributed systems, streaming, and the lakehouse. Every phase runs the same loop — Predict → Observe → Isolate → Build → Compare → Transfer. Intuition first, rigor second.

• Start from concepts and intuition. Each phase opens with notes that build the mental model first — the mechanisms and trade-offs, not a tools tour.
• Learn by playing, not just reading. Every phase ships an interactive playground that makes its core trade-off measurable — poke it, run the guided experiments, watch the numbers move.
• Run experiments on real systems. DuckDB, Postgres, SQLite, Kafka, CockroachDB — compared within their category, because the deltas are where the learning lives.
• Build toy versions to internalize. A query engine, storage engine, transaction manager, distributed KV, stream processor, table format, and RAG pipeline — each grown one concept at a time.
• See it in the wild. Every phase ends with a real-world case study — Discord's messages table crossing three storage engines, GitHub's 43-second partition, the Databricks–Snowflake benchmark war — a named company hitting the phase's trade-off, with every claim sourced.
• Finish with a system autopsy. Dissect a data system you've never used, and back every claim with an experiment.

Foundations runs in a one-click dev container with automated grading and a personal course site for every learner.

Free and interactive, no signup: