Three interactive labs cover Cambridge 0478 Topic 9: defining a single-table database (fields, records and validation), choosing data types, primary keys, and the SQL in the syllabus. The Foundations Lab builds the structure; the Querying Lab uses SELECT, FROM, WHERE, ORDER BY, AND and OR to pull out the exact records you need; the Aggregating Lab adds SUM and COUNT. Each idea is taught, drilled, then tested — work straight through, or jump to the part you need.
The structural language of databases — fields and records, validation, the six data types, and primary keys as unique identifiers. Plus what SQL is for, so every query in the next two labs has firm ground to stand on.
Ask the database questions with SELECT, FROM, WHERE and ORDER BY (ASCENDING / DESCENDING), joining conditions with AND and OR. Run your queries on sample tables and learn to write the output a query returns.
Turn rows into answers with SUM and COUNT. One rule — “how much?” versus “how many?” — settles which to use. Then work out the single value a query returns, and explain what a query does.