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.
Your First Query: SELECT, FROM, WHERE
20 min
- 2.
Shaping Results: ORDER BY, LIMIT, DISTINCT
20 min
- 3.
Filtering Deeper: AND, OR, IN, BETWEEN, LIKE, NULL
25 min
- 4.
Counting and Summing: GROUP BY and the Aggregate Functions
25 min
- 5.
HAVING and the Order SQL Actually Runs In
20 min
- 6.
JOINs: Combining Two Tables
25 min
- 7.
UNION: Stacking Result Sets on Top of Each Other
20 min
- 8.
CASE: If/Then/Else Inside a Query
25 min
- 9.
Subqueries: A Query Inside a Query
25 min