SQL for Analysts

From SELECT to window functions, on data that looks like your data

4.6(4,471 reviews)92,600 learners

Created by Priya Raghunathan

Updated April 2026EnglishBeginner10h 30m74 lectures

What you will learn

  • Query, filter and sort with confidence
  • Join several tables and predict how many rows come back
  • Aggregate with GROUP BY and HAVING correctly
  • Use CTEs to make long queries readable
  • Apply window functions for running totals, ranks and period comparisons
  • Debug a query that returns the wrong number of rows

Course content

13 sections · 74 lectures · 10h 30m total length

  • What this course covers, and what it does notPreview03:00
  • How to get the most out of itPreview04:00
  • Setting up and downloading the exercise files06:00

  • SELECT and WHEREPreview05:00
  • SELECT and WHERE in detail09:00
  • A closer look at select and where08:00
  • Worked example: select and where13:00
  • Where select and where goes wrong10:00
  • Exercise: select and where14:00
  • SELECT and WHERE in practice14:00

Topics covered

SELECT and WHERESorting and limitingNULL handlingInner and outer joinsAggregationGROUP BY and HAVINGSubqueriesCommon table expressionsWindow functionsDate handlingQuery debugging

Requirements

  • No prior SQL needed
  • A spreadsheet background is plenty of preparation

Description

SQL is the highest-leverage skill an analyst can have, and it is learnable in a fortnight. This course takes you from a first SELECT to window functions and CTEs, using a realistic multi-table dataset rather than a toy one.

Your instructor

PR
Priya Raghunathan

Data scientist working in health research

4.7 instructor rating2,83,520 learners3 courses

Priya moved from academic statistics into applied health data and has never lost the habit of asking what a number actually measures. Expect a lot of attention to how data is collected before any model appears.

Learner reviews

4.64,471 reviews
  • 5 star64%
  • 4 star28%
  • 3 star5%
  • 2 star2%
  • 1 star1%
  • AG
    Aisha G.3 February 2026

    I came in knowing a bit and still learned plenty. The middle third is the strongest part.

  • QN
    Quentin N.30 November 2025

    Excellent. The examples are realistic rather than the usual toy versions.

  • GA
    Grace A.25 November 2025

    Worth it for the section on common mistakes alone — I recognised two things I have been doing wrong for years.

  • WV
    Wei V.29 September 2025

    Clear explanations without the usual filler. I watched most of it at 1.25x and still followed everything.

  • KG
    Kemi G.26 October 2025

    Genuinely well structured. I have started three courses on this topic and this is the first one I finished.

  • OD
    Olive D.2 March 2026

    Excellent. The examples are realistic rather than the usual toy versions.

  • UA
    Ursula A.2 September 2025

    I have recommended this to two colleagues already. The structure makes it easy to dip back into.

  • UB
    Ursula B.30 December 2025

    Clear explanations without the usual filler. I watched most of it at 1.25x and still followed everything.

  • BG
    Ben G.27 February 2026

    I came in knowing a bit and still learned plenty. The middle third is the strongest part.

Showing 9 of 4,471 reviews.

Learners also looked at

More from Data Science and beyond.

All Data Science

Python for Data Analysis

Priya Raghunathan

4.7(9,315)
24h162 lecturesBeginner
₹2,299₹4,499
Bestseller

Modern JavaScript From the Ground Up

Amara Osei

4.7(8,412)
28h 30m186 lecturesBeginner
₹2,499₹4,499
Bestseller

Photography Foundations

Yusuf Demir

4.8(6,218)
13h88 lecturesBeginner
₹1,499₹3,299
Bestseller

React in Production

Amara Osei

4.8(6,187)
22h148 lecturesIntermediate
₹2,999₹5,999
Bestseller