Module v1.0 · Required
Data Records: Tables, Rows, Columns, and Keys
A visual vocabulary for reading a small relational dataset.
What you will practice
Identify the record grain, describe columns, and recognize a useful key.
0 of 3 sections complete
Not started
Read the table before writing a query
Know what one record represents.
Before asking for a count or total, identify the record grain: one order, one shipment, one customer contact, or another defined unit. A correct calculation at the wrong grain can still mislead.
- Name what one row represents
- List the fields needed for the question
- Identify a stable record identifier
- Note fields that may be missing