Tabellab
Data & Analytics Intermediate

Relational Data Design by Hand: Flat Tables to Normal Forms, Keys, Functional Dependencies, Update Anomalies, Lookup & Junction Tables, Referential Checks and Reporting Views

Turn a fictional language school's flat booking sheet into clean related tables in 20 hands-on labs: redundancy counts, keys, dependencies, normal forms, anomalies, junction tables, orphan checks, rebuilt reports and migration checks, with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on labs you redesign a fictional language school's flat booking sheet in a spreadsheet. You count redundant cells and conflicting copies, sort attributes into entities, test candidate keys and functional dependencies with COUNTIFS, and split tables into first, second and third normal form. You count update, insert and delete anomalies, build surrogate keys and junction tables, find orphan foreign keys, classify cardinality and rebuild a reporting view with joins that reconcile to the old sheet. Then you handle dated prices, code tables and validation, score when a flattened view pays off, and finish with migration checks and a schema scorecard.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy