Practice the SQL patterns hospital hiring managers actually recognize: ICD-10 ↔ CCSR terminology joins, principal vs. secondary diagnosis logic, POA gotchas, HCC risk tiering, and the LEFT-JOIN-vs-INNER-JOIN trap that silently breaks production healthcare dashboards. Curriculum modeled on the patterns named in CMS-HCC, AHRQ CCSR, and the Tuva Project.
25 missions · 7 tables · authentic ICD-10 + CCSR terminology
Read the briefing
A Slack message from your manager
Explore the schema
5 tables in a star schema
Write your query
Full SQL editor with autocomplete
Get expert feedback
Graduated hints, not just pass/fail
Practice ICD-10 → CCSR → HCC the way Cogito and Caboodle analysts do — the foundational pattern absent from every other SQL learning platform.
Cohort patients by principal diagnosis, aggregate comorbidities on those encounters — the HCC-recapture pattern run quarterly at every ACO and Medicare Advantage plan.
POA NULL handling, ICD-9 legacy detection, and the LEFT-JOIN-vs-INNER-JOIN trap that’s the #1 silent bug in healthcare reporting.
Multi-CTE patient-level HCC chronic-burden score with risk tiering. “Built a multi-CTE chronic-disease burden score with HCC risk tiering” lands cleanly with every health-system, ACO, payer, and HealthTech hiring manager.
Each mission is a real request from someone at the company. Difficulty increases as you go.
Hospital operations star schema (shared with Provider Analytics path) plus authentic ICD-10 terminology and per-encounter diagnosis tables. ~5,800+ rows including ~5 legacy ICD-9 codes that survived the 2015 cutover (LEFT JOIN audit target), POA documentation gaps on ~9% of principal diagnoses, and a hidden coding shift on encounter 42 where the admit dx differs from the principal.
●dimension tables ● fact tables
Five Master-tier missions, all the patterns hiring managers actually recognize.
Looking for something different?