Level 13 of 13 · about 2 weeks
Practical performance, operations and interviews
Measuring load and reasoning about scalability, tuning a genuinely slow query end to end, a decision framework for choosing a database for a workload, a full worked database system-design interview case study, and a capstone designing this very platform's own database.
Modules
Core: everyone needs it. Common: most jobs use it. Specialist: optional depth, safe to skip on a first read.
1
Load, performance and scalability
describing how busy a system is, measuring how fast it responds, and reasoning about what happens as both grow
Core 6 parts · about 2 hours
2
Tuning a real slow query
reading an execution plan step by step to find out why an indexed query is still slow
Core 6 parts · about 2 hours
3
Choosing a database for a workload
a decision framework built from consistency needs, scale, query patterns, and team cost, not from which database is newest
Core 6 parts · about 2 hours
4
Database system-design interview practice
a full worked case study, designing the database behind a concert-ticket booking system, using the five-step habit
Core 7 parts · about 3 hours
5
"Capstone: design this roadmap's own database"
schema, indexes, and a scaling plan for a free study-notes platform like this one
Specialist 6 parts · about 3 hours