Tabellab

Lessons in this course

  1. The Flat-Sheet Problem: Counting Copies & ConflictsLabFree
  2. Entities & Attributes: Sorting Columns into TablesLab Locked
  3. Candidate Keys: Which Columns Identify a Row?Lab Locked
  4. Functional Dependencies: Does A Determine B?Lab Locked
  5. First Normal Form: One Value per CellLab Locked
  6. Second Normal Form: Facts That Depend on Part of the KeyLab Locked
  7. Third Normal Form: Course → Level → PriceLab Locked
  8. Update, Insert & Delete Anomalies in a Flat SheetLab Locked
  9. Surrogate vs Natural Keys: Ids and a Mapping TableLab Locked
  10. Junction Tables: Students × CoursesLab Locked
  11. Referential Checks: Orphan Keys and Money at StakeLab Locked
  12. Cardinality: One-to-Many or Many-to-Many?Lab Locked
  13. Rebuilding the Report: Joins That ReconcileLab Locked
  14. Redundancy Compared: Stored Cells Before and AfterLab Locked
  15. Effective Dates: The Right Price on the Booking DateLab Locked
  16. Code Tables & Validation: Allowed Values OnlyLab Locked
  17. When to Flatten Again: A Reporting View by NumbersLab Locked
  18. Data Quality After the Redesign: Duplicates & Blank KeysLab Locked
  19. Migration Checks: Row Counts & Control TotalsLab Locked
  20. Final Project: The Schema ScorecardLab Locked