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.
Go from your first step to master level. Three simple steps, all about Database Internals.
Get the basics of Database Internals right, and everything after gets easier.
Most people stop at the basics. Keep going — this step takes you higher.
This is the shortcut: Semgrep AI helps you catch security bugs before they ship — and master Database Internals faster.