Course platforms teach SQL as a curriculum. caseSQL teaches SQL as a role. Both valid — pick the one that matches how you retain things.
If you’re comparing caseSQL to SQLHabit or other curriculum-style SQL courses, the split is reading-first vs doing-first. Course platforms are well-structured — read a lesson, try the exercises, move on. caseSQL is a simulator — you’re dropped into an analyst seat on mission 1, you write queries for a “manager” who keeps sending Slack messages, and the curriculum emerges from the work. If you retain best by reading and then practicing, a course platform will feel natural. If you retain best by doing first and reading the debrief after, caseSQL will feel natural.
caseSQL differs from curriculum-style SQL courses in three ways.
There are no chapters on caseSQL. There’s mission 1, where your manager needs a campaign ROI list, and mission 2, where the VP wants the deck by Friday. Concepts — window functions, cohort analysis, CTEs — are introduced by the problems that need them, not by lesson order. This is a higher-activation-energy way to learn SQL and also, in our bias, a higher-retention one.
Every caseSQL database ships with the ugly stuff: NULLs, duplicate customer rows, refunds that settle after the sale, timestamps in inconsistent timezones. Course-style platforms usually use clean reference datasets so the concept under the microscope is the only variable. That’s great for isolating a concept and not great for simulating real analyst work.
caseSQL ships four career paths — Marketing Analyst, BI Analyst, Healthcare Analyst, Finance Analyst — each with its own star-schema database and its own domain vocabulary. Course-style platforms often lean heavily toward a single angle (marketing analytics is a common one). If you want to try SQL through a healthcare lens or a finance lens, caseSQL has a path for that out of the box.
“Not a focus” means it isn't what that platform optimizes for — it's not an assertion that the feature is unavailable.
| Feature | caseSQL | Course platform |
|---|---|---|
| Browser-based SQL editor, no setup | Yes | Yes |
| Simulated analyst role with stakeholder briefs | Yes | Not a focus |
| 5-tier graduated validator | Yes | Not a focus |
| Multiple industry paths (Marketing, BI, Healthcare, Finance) | Yes | Partial |
| Dirty data (NULLs, duplicates, refunds) built in | Yes | Partial |
| Career-path progression (25 missions per path) | Yes | Partial |
| Reading-first curriculum with structured lessons | Partial | Yes |
| Email newsletter / drip-style learning cadence | Not a focus | Yes |
| Free tier with substantive content | Yes | Partial |
Not every reader should pick caseSQL. Honest summary:
They’re adjacent with different optimization targets. SQLHabit and other curriculum-style courses are explicit lessons plus exercises in a clear reading-to-practice loop. caseSQL is a simulator — no chapters, just missions in a simulated analyst seat. Both teach SQL; the right one depends on how you retain new material.
Not in the traditional sense. Each mission has a debrief and a learning objective, and hints explain concepts in context, but there’s no standalone lesson tree to read through. You learn by doing missions.
Yes — Marketing Analytics is one of the four shipped paths, with its own database (customers, campaigns, sends, sessions, purchases), its own stakeholders, and 25 missions covering ROI, attribution, cohorts, and executive scorecards.
Yes. The fundamentals of SQL learning are free forever. Sign up, pick a career path, start mission 1. No credit card, no trial clock.
PostgreSQL, hosted on Supabase — the same stack used by many modern data teams. Each path has its own star-schema database with dimension and fact tables, sized to feel like a small real company.
Pick a path, read the first Slack from your manager, write the query. Free to start.