Query optimization
If you like applying Query optimization, every challenge here gives you a chance to practice it on a real industry brief.
- AnalysisBeginnerNew
Index a Slow 90-Million-Row FinTech Reporting Database
Your analysis task is to read the engineering ticket and the six reporting queries in the case file (M1), study the transactions table definition, column statistics, and write w…
- Indexing
- Query Optimization
- Explain Analyze
Open coursework - AnalysisSeniorNew
Diagnose and Fix Query-Planner Misestimates in a FinTech Warehouse
For each of the 6 queries, capture EXPLAIN (ANALYZE, BUFFERS) and compare estimated vs actual rows at each node. Identify the misestimate source per query (single-column stats s…
- Query Optimization
- Postgresql Planner
- Extended Statistics
Advanced Database Systems
How it works
From brief to credential, in six steps.
Step 01
Browse challenges aligned to your studies.
Step 02
Accept the one that fits your goals.
Step 03
Work through it with AI Copilot guidance.
Step 04
Submit for structured evaluation.
Step 05
Earn a verified credential.
Step 06
Add it to LinkedIn with one click.
Industry teams behind a decade of practitioner briefs
Hiring from this pool?
Sponsor a challenge and meet candidates through actual work.
Industry teams can shape briefs around the skills they hire for, then evaluate students on rubric-scored deliverables — not resumes.