Databases and Data Management

How data is stored, related and queried at scale. The relational model and SQL, entity-relationship design and normalisation, the guarantees of transactions, and the NoSQL alternatives built for a different kind of scale.

This subject course follows the topic vertically, across the years it spans. Some lessons are already written; the rest are shown as placeholders.

Year 2 — Databases

  1. Data vs Information
  2. Tables, Records and Fields
  3. Primary and Foreign Keys
  4. Flat-File vs Relational Databases
  5. Entity-Relationship Modelling
  6. Database Normalisation
  7. SQL SELECT Queries
  8. SQL INSERT, UPDATE, DELETE
  9. SQL Joins and Aggregate Queries
  10. Transactions and ACID
  11. NoSQL Databases