Tables, Rows, Columns, Schemas, and Relational Thinking

About 70-90 minutes of guided work.

By the end of this module you can look at an unfamiliar database and say, out loud and correctly, what one row means in each table, how the tables connect, and which join will silently double your numbers.

Units

1. Unit 01.00: What one row means: finding the grain
2. Unit 01.01: Keys, and how tables actually connect
3. Unit 01.02: The fan-out trap: when a join doubles your money
4. Unit 01.03: NULL is not zero, and not empty
5. Unit 01.04: Writing the evidence note

Module work

• Activity
• Knowledge check
• Summary