Thinking in Data with SQL
Open a coffee chain and get to know it through its data. You learn SQL to find which table holds what, how the tables connect, and when a number looks right but is wrong. No programming needed.
- Beginner
- In Vietnamese or English
- About 6 to 8 hours
- 8 sections
- 31 lessons
Sign in with Google or GitHub and the course opens in the Academy with the same account.
Course outline
Section 1
What does one row record? (SELECT, WHERE)
What this course trains
Lesson · 5 min
Reading the sales notebook
Lesson · 6 min
Ask the notebook
Practice · 30 min
Journal: the first wrong guess
Lesson · 5 min
Section 2
Record once, use everywhere (tables and keys)
When the notebook gets messy
Lesson · 12 min
Sort the columns
Practice · 6 min
Meet the relationship diagram
Lesson · 24 min
Journal: a fact in two places
Lesson · 5 min
Section 3
Trace the link (JOIN)
Following a line on the diagram
Lesson · 24 min
Joining tables
Practice · 24 min
Journal: which side is many?
Lesson · 5 min
Section 4
What is missing (LEFT JOIN, NULL)
Walk-in customers
Lesson · 6 min
What is missing
Practice · 18 min
Bug hunt
Practice · 12 min
Journal: what I assumed was there
Lesson · 5 min
Section 5
Grouped by what? (GROUP BY)
Per what?
Lesson · 12 min
Totals and groups
Practice · 30 min
Milestone: the monthly report
Practice · 6 min
Journal: per what?
Lesson · 5 min
Section 6
Don't trust a number too soon
A number that looks right
Lesson · 6 min
Find what is wrong
Practice · 24 min
Cross-check
Practice · 6 min
Journal: the number I almost believed
Lesson · 5 min
Section 7
The shop grows (design, changing data)
Toppings and coupons
Lesson · 6 min
Design for the new menu
Practice · 6 min
Changing the data
Practice · 24 min
Journal: why is the price stored twice?
Lesson · 5 min
Section 8
The investigation: March revenue
The March drop
Lesson · 5 min
Milestone: the investigation
Practice · 30 min
The six moves
Lesson · 5 min
Journal: my strategy
Lesson · 5 min