Understand how databases work under the hood. Master B-Trees, Write-Ahead Logging (WAL), locking, and query execution engines.
Don't just use databases; understand them. This course dives into the internal architecture of relational database systems (like PostgreSQL/MySQL). You will learn how storage engines organize data on disk using Pages and B-Trees. Master the ACID properties through Write-Ahead Logging (WAL) and Concurrency Control (Locking/MVCC). We explore how the Query Optimizer parses SQL and selects execution plans. Essential for engineers optimizing high-load systems.
Estimated completion time: 21 lessons • Self-paced learning • Lifetime access
Yes, we build a simple clone to learn.
Concepts apply broadly; we use Postgres as reference.
Yes, most database kernels are written in C/C++.
Helps you debug complex production performance issues.