Back to Micro Free Courses

SQL Interview & Case Lab

Intermediate

The SQL course you take AFTER sql-basics. Business-context patterns (LTV, cohort retention, funnels, anomaly detection), the interview classics (gaps & islands, Nth-highest, recursive CTEs), enough query performance to read an EXPLAIN plan — and 6 mock-interview walkthroughs that mirror what FAANG, ola/swiggy, and SaaS shops actually ask. Built for the Topfolio Data Analyst career track W10 and W12.

SQL Interview & Case Lab

Duration

2 weeks

Content

4 modules, 38 lessons

Students

2

Total Time

~8 hours

100% Free Structured Micro Course

All video lessons, coding exercises, and quizzes are completely free with zero gatekeeping. Start learning right away!

Micro Free Course• 100% Free Learning & Quizzes

Start Learning Immediately

Every video, lesson, and practice quiz is completely free. Upgrade to an Official Verified Certificate & AI Review anytime for just ₹99.

Course Curriculum

1

Business SQL PatternsFREE PREVIEW

The six business-context SQL patterns DA interviews hit hardest: LTV, cohort retention, funnels, growth rates, top-N per group, and anomaly detection. Every one is a query you'll write hundreds of times.

130 min12 lessons

Calculating LTV in SQL — Patterns from Real SaaS

Recap — LTV Three Ways

Cohort Retention Analysis in Pure SQL

Recap — Building a Retention Table

Funnel Analysis with Self-Joins and Window Functions

Recap — Funnel SQL Patterns

MoM, YoY, WoW — The SQL Patterns

Recap — Running Totals and Growth Rates

Top-N per Group — The RANK / ROW_NUMBER Trap

Recap — Top-N Without Falling Into the Trap

Anomaly Detection in SQL — Z-Scores and IQR

Recap — Flagging Outliers

2

Interview SQL PatternsFREE PREVIEW

The named interview classics: Nth-highest, gaps-and-islands, pivoting without PIVOT, recursive CTEs, custom date bucketing, and set operations. Memorize the shapes — these recur in every screen.

120 min12 lessons

The Nth Highest Salary Problem

Recap — Why People Get Nth Highest Wrong

Consecutive Days, Sessions — Gaps and Islands

Recap — The Gaps and Islands Pattern

Pivot Using CASE WHEN — Cross-Database Compatibility

Recap — CASE WHEN Pivoting

Recursive CTEs — Org Charts and Hierarchies

Recap — Building Recursive Queries

Custom Date Buckets — Fiscal Weeks and Rolling Windows

Recap — Date Bucketing Recipes

EXCEPT, INTERSECT, UNION — For Diffs and Dedup

Recap — Choosing the Right Set Op

3

Performance & Query ReadingFREE PREVIEW

Just enough EXPLAIN, query performance, and indexing to read your own plans and write index-friendly SQL. You're not a DBA — but you should sound like you've met one.

75 min8 lessons

EXPLAIN for Analysts — Just Enough to Read One

Recap — Five Things to Look For

The 5 Most Common Reasons Your SQL Is Slow

Recap — The Query Performance Checklist

CTE vs Subquery vs Temp Table — When to Use Each

Recap — Choosing the Right Pattern

Indexes for Analysts — What to Know

Recap — Writing Index-Friendly Queries

4

Live Case WalkthroughsFREE PREVIEW

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.

140 min6 lessons

Case 1 — Top 3 Products by Revenue per Region, Last Quarter

Case 2 — Weekly Active Users and 4-Week Retention

Case 3 — Customers Who Churned and Reactivated in the Same Year

Case 4 — Detect Anomalous Days in Daily Signups

Case 5 — Marketing Attribution: First-Touch and Last-Touch

Case 6 — SaaS Metrics: MRR, MRR Growth, Net Revenue Retention

Micro Free Course

Ready to Master SQL Interview & Case Lab?

All videos, lessons, and practice exercises are 100% free with zero gatekeeping. Start learning immediately, or enroll with the ₹99 Verified Certificate Pass.

Reviews & Ratings

No reviews yet

Sign in to leave a review.