All seven topics
Browse by decision question. Each topic page has the same structure: what the decision is, why it matters, key concepts, slides, hands-on activities, SQL files, datasets, and optional further resources.
DECISION 1
"How does data live in tables?"
Tables, Keys, Basic SQL
Week 2
DECISION 2
"How do I get the data I need?"
SELECT, JOINs, Subqueries, CTEs
Weeks 3, 9
DECISION 3
"How do I design a DB that won't break?"
ERD/EER, Normalization
Weeks 4–6
DECISION 4
"How do I enforce business rules?"
Constraints, Triggers, Stored Procedures
Week 6
DECISION 5
"Operations or analytics?"
Data Warehouses, ETL, Dimensional Modeling
Week 10
DECISION 6
"How do I put a database online?"
MySQL on Hostinger, PostgreSQL, PHP APIs
Weeks 11, 13–14
DECISION 7
"What's next for databases?"
PWA, Oracle APEX, HTAP, AI-assisted dev
Week 13