SQL
Course
SQL
Learn to read and change real databases in 20 lessons: SELECT, filtering, joins, grouping, indexes and transactions, ending with a small library database you design yourself.
- 20 lessons
- 4 modules
- Beginner
- 2 h 35 min
-
Module 1
Reading Data
What a relational database is, SELECT, WHERE, ORDER BY and LIMIT u2014 the four clauses that answer most questions.
-
Module 2
Summarising
DISTINCT, COUNT, SUM, AVG, GROUP BY and HAVING: turning rows into answers.
-
Module 3
Joining and Changing Data
INNER and LEFT JOIN, subqueries, INSERT, UPDATE, DELETE, and creating your own tables.
-
Module 4
Design and Safety
Constraints, indexes, transactions, views, and a capstone library database with real queries.
Check what stuck
One quiz per module, with an explanation after every answer.
