SQL Foundations

Declaring what you want, across tables that model something real.

3 concepts · 140 minutes

• SQL BasicsSELECT, WHERE, GROUP BY — declaring what you want and letting the planner find it.
• Joins & RelationshipsInner, left, and the one that silently duplicates all your rows.
• Data ModellingNormalise until it hurts, denormalise until it works — and know which one you're doing.