Course · 8 to 10 hours
SQL from Zero
Start with plain-words intuition for how a database engine works. Then build an online bookshop's database yourself: design its tables, fill them, ask them questions, keep changes safe and control who can do what.
Complete beginners, from students to working professionals. No coding needed.
Module 1
How a database thinks
Intuition first, with everyday comparisons and no code.
Module 2
DDL: building the structure
Create the bookshop's tables, with keys and rules.
Module 3
DML: filling and changing data
Add, change and remove rows safely.
Module 4
DQL: asking questions
SELECT, filtering, sorting and summarising.
Module 5
Combining tables
Joins and subqueries.
Module 6
TCL: keeping changes safe
BEGIN, COMMIT, ROLLBACK and SAVEPOINT in practice.
Module 7
DCL: who can do what
Users, roles and permissions.
Module 8
Final project
Build the bookshop end to end and write a business report.