Creator Center
← All courses
Data Science

SQL for Everyday Questions

Answer your own data questions with SELECT, WHERE, GROUP BY and JOIN.

28 learners

Created by Daniel Okafor · Updated October 22, 2026

  • Beginner
  • 38 min total
  • 9 lessons
  • Self-paced

What you’ll learn

  • Select, filter and sort data with confidence
  • Summarise data with GROUP BY and aggregate functions
  • Combine tables with INNER and LEFT JOIN
  • Write readable queries that colleagues can understand

Course content

3 sections · 9 lessons · 38 min

Asking questions3 lessons · 10 min
  • Your first SELECTVideo · 8 min
  • Filtering with WHEREReading · 1 min
  • Sorting and limitingReading · 1 min
Summarising3 lessons · 12 min
  • COUNT, SUM and AVGVideo · 10 min
  • GROUP BYReading · 1 min
  • Cheat sheetReading · 1 min
Combining tables3 lessons · 16 min
  • JOINs without the fearVideo · 14 min
  • INNER and LEFT JOINReading · 1 min
  • Writing readable queriesReading · 1 min

Requirements

  • No experience needed
  • A modern browser

Description

SQL is the most useful data skill you can learn in a weekend. This course teaches the queries that answer real business questions, using a small shop's database of customers, orders and products. You'll write every query yourself in your browser; no setup or installation is needed.

Instructor

Daniel Okafor

Data scientist · Analytics lead

  • 4.5 instructor rating
  • 28 reviews
  • 64 learners
  • 2 courses

I work with data every day, from messy spreadsheets to production analytics. Before that I taught statistics. I focus on the techniques that answer real business questions, practised on realistic datasets.

4.6 course rating · 11 reviews

5 ★64%
4 ★36%
3 ★0%
2 ★0%
1 ★0%
  • Nikhil Dubois · Oct 22, 2026

    Solid fundamentals, well paced.

  • Lucia Hassan · Oct 22, 2026

    Good course overall. A couple of lessons could go deeper.

  • Chidi Garcia · Oct 22, 2026

    One of the best short courses I've taken.

  • Priyanka Müller · Oct 22, 2026

    Well structured and easy to follow. Exactly what I needed.

  • Rohan Menon · Oct 22, 2026

    Clear and friendly teaching style.

  • Kavya Khan · Oct 22, 2026

    Much better than the free videos I tried before.

  • Aditya Clarke · Oct 22, 2026

    Clear explanations and practical examples throughout.

  • Sneha Smith · Oct 22, 2026

    Clear and fast. Would love an advanced follow-up on window functions.

  • Alex Ahmed · Oct 22, 2026

    I can finally pull my own reports instead of waiting for the data team.

  • Hannah Nair · Oct 22, 2026

    The LEFT JOIN trick for finding missing customers was gold.

  • Ishaan Wang · Oct 22, 2026

    Perfect beginner course. Everything runs in the browser.

SQL for Everyday Questions · Creator Center