New · Cohort 4AI-Powered Data Engineering Cohort 4 goes live 26 September · only 40 seatsRegister Now
← All webinars
Live Webinar Sunday, 13 September 12:00 PM IST 2 hours · Free on Zoom

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

Anyone grinding SQL questions with no structure — learn to recognise the pattern in the first 30 secondsCandidates who write correct SQL but lose the round on explaining it — narration is how interviewers actually score youBeginners welcome — free and live; joins and GROUP BY are enough to follow along

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
Pragya Rathi

Your host

Pragya Rathi

Co-Founder, PrepNPlaced · Data Engineer @ 7-Eleven · SQL, PySpark, Power BI & Excel Instructor

Free seat No spam

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