- Home
- Courses
- SQL Interview & Case Lab
- Live Case Walkthroughs
Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
Live Case Walkthroughs
Six mock-interview problems with full think-aloud, solution, and 3 follow-ups each. Modelled on real screens at e-commerce and SaaS shops in India and the US.
Module Content
Case 1 — Top 3 Products by Revenue per Region, Last Quarter
A 25-min mock interview problem. Prompt → think-aloud → solution → 3 follow-ups the interviewer might add.
Case 2 — Weekly Active Users and 4-Week Retention
A two-part mock. Build WAU from raw events, then compute the 4-week retention curve.
Case 3 — Customers Who Churned and Reactivated in the Same Year
A gaps-and-islands problem disguised as a churn question. The interviewer is testing whether you recognize the pattern.
Case 4 — Detect Anomalous Days in Daily Signups
A live anomaly-detection problem. Build a rolling z-score in SQL, flag the anomalies, defend your threshold.
Case 5 — Marketing Attribution: First-Touch and Last-Touch
Build first-touch and last-touch attribution from raw events. Then defend why neither is right.
Case 6 — SaaS Metrics: MRR, MRR Growth, Net Revenue Retention
The capstone case. Compute the three SaaS metrics every interview asks about — from a raw subscriptions table.