Phase 2 · Data and persistence

Week 6: SQL

Friday deliverable: Ledger schema and queries

  1. Day 1Relational model; SQLite shell; SELECT, WHERE, ORDER BYOutline only
  2. Day 2INSERT, UPDATE, DELETE; joinsOutline only
  3. Day 3Aggregates, GROUP BY, subqueriesOutline only
  4. Day 4Keys, constraints, normalisation; ledger schemaOutline only
  5. Day 5database/sql with SQLite; SQL injection demo and parameterised queriesOutline only