SQL for Data Science and Analytics Interviews

intermediate1.5 hours3 sections9 lessons

Grain and join fan-out, anti-joins and NULLs, conditional rates, window functions, streaks and sessions, active users, retention, cohorts and funnels, practiced the way live SQL rounds test them.

What you will be able to do

  • State a table's grain, catch join fan-out and NULL traps, and compute rates over the right denominator.
  • Rank within groups, compare periods, keep running totals and find streaks and sessions with window functions.
  • Compute active users, retention cohorts and funnels with time zones and missing days handled.
  • Work a live SQL question out loud: clarify, build in CTEs, check row counts and test edge cases.

Who this course is for

Data scientist, analyst, analytics engineer and data engineer candidates who can write a basic query and need the patterns live SQL rounds test.

Helpful to know first

  • SELECT, WHERE, GROUP BY and a basic join; the course builds everything else.

Course content

3 sections 9 lessons 1.5 hours

Locked sections open with Premium.Upgrade to Premium

Rate this course

Tell us how useful this course was. You can update your rating later.

Loading your rating...

Course rating

No ratings yet. Yours would be the first.