SQL · Product-Company Interviews
Scenario-Based SQL Masterclass Crack SQL at Top Product Companies
Not 100 random questions. The handful of patterns every product-company SQL round is built on — solved live, end to end.
Product-company SQL rounds are not a hundred random questions. They are built on a handful of patterns, and once you can see the pattern in the first thirty seconds the query writes itself. Two hours, six live scenarios: window functions in anger (RANK, LAG/LEAD, running totals), retention and cohorts (D1/D7/D30, churn, repeat rate), funnels and sessionisation (event order, drop-off, gaps and islands), tricky joins and duplicates (fan-out, anti-joins, dedupe patterns), top-N and ratio problems (per-group ranking, % of total), and optimisation and narration — query plans, indexes, and how to explain your answer the way interviewers actually score it. Ends with live Q&A on SQL rounds and case interviews.
Agenda
What we'll cover
- Window functions in anger — RANK, LAG/LEAD, running totals
- Retention & cohorts — D1/D7/D30, churn, repeat rate
- Funnels & sessionisation — event order, drop-off, gaps & islands
- Tricky joins & duplicates — fan-out, anti-joins, dedupe patterns
- Top-N & ratio problems — per-group ranking, % of total
- Optimisation & narration — query plans, indexes, how to explain your answer
- Live Q&A on SQL rounds and case interviews
Perfect for
Who it's for
Every attendee
What you get
- Live, hands-on session on Zoom
- Live Q&A with the instructor
- Session notes & key resources — emailed after
- Optional: that session's recording + resources — add for ₹99

Your host
Pragya Rathi
Co-Founder, PrepNPlaced · Data Engineer @ 7-Eleven · SQL, PySpark, Power BI & Excel Instructor
Reserve your free seat
One quick step: sign in with Google, then reserve your free seat — your Zoom link lands in your email instantly.
Free forever · Sunday 13 September · 12:00 PM IST
Free live seat
Sunday · 12:00 PM IST