DSA Factory
Curriculum
DBMS

Indexes, queries and scale

About 9 steps, from the first idea to a mastery test.

  1. Stage 0Where the data livesFree
    1. 1Rows, pages and the cost of a scan12 min
    2. 2The buffer pool11 min
  2. Stage 1IndexesFree
    1. 1B+ tree indexes14 min
    2. 2Composite, covering and selective indexes14 min
  3. Stage 2Executing queriesFree
    1. 1Query plans and join algorithms15 min
    2. 2N+1 queries and finding what's slow12 min
  4. Stage 3Scaling outFree
    1. 1Replication and sharding15 min
    2. 2Caching and the CAP trade-off14 min
    3. 3Choosing a data store12 min
  5. Stage 4MasteryComing soon
Start freeTry a step first