How this course works

The chapters and lessons below are the fixed course structure. When you start, LearnLive teaches each lesson interactively and adapts examples, pacing, and questions to you.

Complete syllabus

Every chapter and lesson

01
Chapter 1 · 3 lessons
Your First Real Queries
1. 1.1
  How relational data is laid out
  8 min · Quick check
2. 1.2
  SELECT, FROM & column aliases
  9 min · Quick check
3. 1.3
  Computed columns & expressions
  9 min · Quick check
02
Chapter 2 · 3 lessons
Filtering & Sorting
1. 2.1
  WHERE, AND/OR & comparison
  9 min · Quick check
2. 2.2
  IN, BETWEEN, LIKE & NULLs
  9 min · Quick check
3. 2.3
  ORDER BY & LIMIT
  8 min · Quick check
03
Chapter 3 · 3 lessons
Aggregation & Grouping
1. 3.1
  COUNT, SUM, AVG & friends
  9 min · Quick check
2. 3.2
  GROUP BY for breakdowns
  10 min · Quick check
3. 3.3
  HAVING & filtering groups
  8 min · Quick check
04
Chapter 4 · 3 lessons
Joining Across Tables
1. 4.1
  Keys & how joins work
  9 min · Quick check
2. 4.2
  INNER vs. LEFT joins
  10 min · Quick check
3. 4.3
  Joining several tables
  9 min · Quick check
05
Chapter 5 · 3 lessons
Analyst-Grade Queries
1. 5.1
  Subqueries & CTEs
  10 min · Quick check
2. 5.2
  Window functions
  11 min · Quick check
3. 5.3
  A real analysis, end to end
  10 min · Quick check

SQL for Data Analysis at Work

How this course works

Every chapter and lesson

Your First Real Queries

How relational data is laid out

SELECT, FROM & column aliases

Computed columns & expressions

Filtering & Sorting

WHERE, AND/OR & comparison

IN, BETWEEN, LIKE & NULLs

ORDER BY & LIMIT

Aggregation & Grouping

COUNT, SUM, AVG & friends

GROUP BY for breakdowns

HAVING & filtering groups

Joining Across Tables

Keys & how joins work

INNER vs. LEFT joins

Joining several tables

Analyst-Grade Queries

Subqueries & CTEs

Window functions

A real analysis, end to end

Ready to begin?