Learnly
All levels

SQL for Everyone

Ask your data questions in an afternoon.

4.82,210 reviews15,760 learners
Created byMei-Lin Ota Updated Oct 2026 English · 6 subtitles 5 hours

What you'll learn

  • Load and clean messy, real-world datasets
  • Ask clear questions and answer them with queries
  • Chart results so the story is obvious at a glance
  • Spot outliers, gaps and misleading averages
  • Automate a weekly report end to end
  • Explain findings to people who hate spreadsheets

Curriculum

4 sections · 13 core lessons · 3h 34m
01First queries3 lessons · 21 min
  • Welcome & the shop databaseFree preview4 min
  • SELECT, WHERE and ORDER BYFree preview12 min
  • Check-in: your first queries5 min
02Summarising data3 lessons · 32 min
  • Counting and grouping13 min
  • HAVING and conditional sums11 min
  • Quiz: aggregates8 min
03Joining tables3 lessons · 1h 1m
  • Inner and left joins15 min
  • Reading: drawing joins on paper6 min
  • Project: answer five business questions40 min
04Beyond the basics4 lessons · 1h 40m
  • Subqueries and CTEs14 min
  • Window functions, gently explained16 min
  • Dates and time zones10 min
  • Final project: a KPI query pack1h 0m

Requirements

  • No experience needed: we start from zero
  • A laptop or phone and about 20 minutes a day
  • Curiosity, and a notebook you don't mind messing up

This course is for

  • Curious beginners who learn by doing
  • Career changers building a first portfolio
  • Teams who want a shared vocabulary

Your instructor

Mei-Lin Ota

Data scientist

  • 4.9 instructor rating
  • 35k students
  • 3 courses

Mei-Lin spent eight years in climate research and teaches data analysis with real, messy datasets.

More from Mei-Lin

What learners say

2,210 reviews
4.8out of 5
  • 5★81%
  • 4★14%
  • 3★3%
  • 2★1%
  • 1★1%
  • Lena Fischer2 weeks ago

    Short lessons, clear tasks and an instructor who answers questions in the community within a day. I finished in five weeks.

  • Daniel Okoro1 month ago

    The projects are the best part. I used the final one in a job interview and it carried the conversation.

  • Hana Sato1 month ago

    Lovely pacing. A couple of lessons could be shorter, but the quick checks kept me honest the whole way.

Learners also took