CSE Roadmap

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. 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. 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. 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. 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. 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