Manuals / SQL / Guide 12

Reference · beginner · ~15 min · Guide 12 of 12

Timeline, tools & cheat sheet

Return when stuck. Week map, safety ritual, and interview quick hits.

Path progress
94%

Step 1 of 3

Week map

  • Weeks 1–2 — SELECT, WHERE, ORDER BY
  • Weeks 3–4 — JOINs + Checkpoint A
  • Weeks 5–6 — GROUP BY, subqueries, CTEs
  • Weeks 7–8 — mutations, transactions
  • Weeks 9–10 — indexes, EXPLAIN + Checkpoint B
Week mapDrag stickies · tap for tips
Study mapDrag stickies · tap for tipsKeep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Assert the UIdrag · tap →Retry wiselydrag · tap →Seed datadrag · tap →Close the loopdrag · tap →Keep it shortdrag · tap →Name the waitdrag · tap →Scope locatorsdrag · tap →Trace when stuckdrag · tap →One browser firstdrag · tap →Isolate statedrag · tap →Pathwise hackdrag · tap →Week mapdrag · tap →Try thisdrag · tap →Follow the dashed drag · tap →
Was this step clear?
Chapter learning outcomes
  • 10-week map
  • Safety ritual
  • Interview one-liners

Clear these before you leave