Northgate Institute

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.

You’ll learn to
  • 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
About

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.

Contents
  1. The relational model3 lessonsFree
    • A database, end to endVideo
    • Why anything is split across tablesReading
    • Keys and joinsFlashcards
  2. Asking questions4 lessons
    • The shape of a queryReading
    • Check: reading a queryShort assessment
    • GROUP BY, and the trap in itReading
    • AggregatesFlashcards
  3. Getting it wrong safely2 lessons
    • Three checks before you send itReading
    • A public database to practise againstDownload