← All courses
🗄️Beginner
SQL & Databases Essentials
Store and query data like a pro. Tables, SELECT, filtering, relationships and joins — the foundation of every app.
7 modules · 26 lessons · runnable · 26 lessons
Share
Free
What you'll learn
- Tables
- SELECT & filtering
- Aggregates
- Joins
Curriculum
7 modules · 26 lessonsModule 1Getting started5 lessons
What SQL isPreviewThe sample database
Choosing columns
SELECT DISTINCT
LIMIT
Module 2Filtering4 lessons
Filtering with WHEREPreviewComparison operators
AND, OR, NOT
IN, BETWEEN, LIKE
Module 3Sorting & shaping3 lessons
Sorting with ORDER BY
Column aliases (AS)
Calculated columns
Module 4Aggregates4 lessons
Counting rows
SUM, AVG, MIN, MAX
GROUP BY
HAVING
Module 5Joining tables3 lessons
Relating tables
INNER JOIN
Joins with aggregates
Module 6Changing data4 lessons
Inserting rows
Updating rows
Deleting rows
Creating a table
Module 7Putting it together3 lessons
A real reporting query
Common mistakes
Where to go next
Reviews
No reviews yet.
