SQL-Engineering-Handbook

Practice Tracks

Pre-built sequences by interview length/role.

Coverage status: These tracks were built during the original 48-question pilot and pull only from that range (Q001–Q048) — all still valid, unrenamed IDs, unaffected by the later expansion or by the ID-retirement fix in QUESTION_INDEX.md. They have not been extended to include Q049–Q096 (the two post-pilot expansion rounds). That’s a scoped, tracked gap — a natural post-freeze improvement noted in AUDIT_REPORT.md — not a silent omission.

30-Minute SQL Screen (target 10 — 8 available)

Q001 → Q003 → Q005 → Q006 → Q007 → Q009 → Q011 → Q012

60-Minute Analyst Interview (target 20 — 14 available)

Q001 → Q002 → Q005 → Q006 → Q007 → Q008 → Q010 → Q011 → Q012 → Q013 → Q015 → Q016 → Q017 → Q025

90-Minute Analytics Engineer Interview (target 25 — 18 available)

Q005 → Q006 → Q007 → Q009 → Q010 → Q011 → Q012 → Q013 → Q014 → Q015 → Q016 → Q017 → Q019 → Q022 → Q023 → Q025 → Q029 → Q033

Senior SQL Engineer Interview (target 20 — 21 available — target met)

Q007 → Q013 → Q014 → Q017 → Q018 → Q019 → Q020 → Q021 → Q022 → Q023 → Q024 → Q026 → Q027 → Q030 → Q037 → Q038 → Q039 → Q040 → Q045 → Q046 → Q047

Data Engineer SQL Round (target 25 — 17 available)

Q003 → Q006 → Q007 → Q008 → Q014 → Q016 → Q017 → Q018 → Q019 → Q022 → Q023 → Q024 → Q025 → Q031 → Q033 → Q048

Analytics Engineer Round (target 25 — 18 available)

Q009 → Q010 → Q011 → Q012 → Q013 → Q014 → Q015 → Q016 → Q017 → Q019 → Q022 → Q023 → Q025 → Q028 → Q029 → Q032 → Q034 → Q036

Staff-Level SQL Assessment (target 10 architecture-heavy — 10 available, target met)

Q020 → Q021 → Q024 → Q037 → Q038 → Q039 → Q040 → Q045 → Q046 → Q047

Interviewer Calibration Session (uses Level 8 meta-questions)

Q041 → Q042 → Q043 → Q044 — run this among interviewers themselves before running candidate interviews, to calibrate methodology.

How to Use a Track

Run as a coherent session using INTERVIEWER_GUIDE.md’s pacing guidance — not a checklist to blast through. Adjust based on early performance; move to Senior-Level Extensions when a candidate solves quickly.

This site is open source. Improve this page.