You Came to Solve a Murder, You Left Knowing JOINs
SQL Noir is a detective game where the only tool is a query editor. Each case hands you a crime and a database full of records — witnesses, alibis, access logs — and you write real SQL to find the rows that matter, connect them, and name the culprit.
SELECT name FROM suspects WHERE alibi IS NULL AND seen_at = 'crime scene'; — one match, and that's your killer.
Why It Works Better Than a Tutorial
You're not reciting syntax, you're filtering, sorting, grouping and joining data to answer a question you actually care about. That's the job. The motivation to find the murderer does the work that a tutorial's exercises usually fail to do.
It Teaches You On the Way
No SQL required to start — the first case covers SELECT and WHERE, the middle cases bring in JOINs and real filtering, and later ones move to grouping and harder schemas. Each case has its own database, so the difficulty ramps with genuinely new material rather than more of the same.
Free, open source, MIT licensed, and it runs in the browser — no signup, no install. Useful as a bootcamp alternative or as interview prep.
What's in the Guide
How the cases work, the skills each stage teaches, the difficulty ramp, and the link to play.
The full field guide is in the PDF.
Get the Guide
Drop your email below and we'll send it straight to your inbox.