Data & AI
SQL for Analysts
Select, join and aggregate the tables you already have, then check that the number is real.
9 lessons10 minBeginner
Overview
Select, join and aggregate the tables you already have, then check that the number is real.
- 9 lessons
- 10 min
- Beginner
Curriculum
3 modules
- 1
Asking the table
- Select, where and order9 min
- Aggregates and group by9 min
- Nulls that change the count9 min
- 2
Joining carefully
- Inner and left joins9 min
- Grain: one row means one what9 min
- Checking the join did not explode9 min
- 3
Query lab
Includes hands-on lab- Write the question in a sentence9 min
- Translate it to SQL9 min
- Lab: explain the number to a lead14 min
Open sources & licenses
This curriculum is an original outline informed by these openly-licensed resources.