SQL Fundamentals
Start from zero. Write your first real queries and build the habits the rest of the platform assumes.
About this course
No prior SQL needed. You'll go from SELECT * to confidently filtering, sorting, aggregating, and joining tables — every concept runnable in your browser. By the end you'll be ready for 'SQL for Data Analysts' and the business cases.
Topics covered
Lessons
- 1.
SELECT … FROM: The Two Words This Site Is Named After
12 min
- 2.
WHERE: Keep Only the Rows You Mean
12 min
- 3.
ORDER BY: Put the Result in Order
10 min
- 4.
LIMIT and Top-N: Just the First Few Rows
10 min
- 5.
DISTINCT: Each Value Once
10 min
- 6.
Filtering Deeper: AND, OR, IN, BETWEEN, LIKE, NULL
25 min
- 7.
Counting and Summing: GROUP BY and the Aggregate Functions
25 min
- 8.
HAVING and the Order SQL Actually Runs In
20 min
- 9.
JOINs: Combining Two Tables
25 min
- 10.
Readable SQL: Style That Survives a Code Review
15 min
- 11.
UNION: Stacking Result Sets on Top of Each Other
20 min
- 12.
CASE: If/Then/Else Inside a Query
25 min
- 13.
Subqueries: A Query Inside a Query
25 min
- 14.
SQL Dialects: Why the Same Query Behaves Differently
12 min