Working with Databases
The relational model, and enough SQL to answer your own questions
- About 20 min
- 9 lessons
- Intermediate
Part of Become a data practitioner.
Starts after Data Foundations on Become a data practitioner.
Start with Data Foundations — freeYou’ll learn toContents
- Read a schema diagram and predict what a join will return
- Write SELECT, WHERE, GROUP BY and JOIN without looking them up
- Recognise when a query is answering a different question than you asked
Most data worth having lives in a relational database, and most people are locked out of it by a two-hour gap in their education. This closes the gap: tables and keys, then the handful of SQL that answers ninety per cent of real questions.
- The relational model3 lessonsFree
- A database, end to end
- Why anything is split across tables
- Keys and joins
- Asking questions4 lessons
- The shape of a query
- Check: reading a query
- GROUP BY, and the trap in it
- Aggregates
- Getting it wrong safely2 lessons
- Three checks before you send it
- A public database to practise against
Share