advancedSystem Design
Database Internals & Query Tuning
B-trees, MVCC and reading an execution plan like a pro
Database Internals & Query Tuning: B-trees, MVCC and reading an execution plan like a pro.
What you'll be able to do
- Choose the right index
- Read and fix a bad plan
- Reason about isolation levels
Curriculum
Getting started
How this course workspreview
Setting up your environmentpreview11m
Starter repo & setup checklist
Core concepts
The mental model18m
Working through the happy path16m
What breaks in production (and why)
Interactive walkthrough
Applied practice
Building the reference implementation25m
Guided exercise: build it yourself
Cheat sheet, templates & further reading
Build & assess
Knowledge check
Database Internals & Query Tuning: final assignment
Where to go next
Reviews
Farhan Sheikh★★★★★
Went from guessing at indexes to reasoning about them.