9.1–9.2
Foundations
The structural language of databases — fields and records, the 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.
The Learning Hub/Topic 9
🗄️ Topic 9
Databases
Three interactive labs fold the whole of Topic 9 into the Learning Hub. The first lays the foundations — database structure, fields and records, the data types, and primary keys as unique identifiers, plus what SQL is for (9.1–9.2). The second is querying — SELECT, FROM, WHERE and ORDER BY, the four clauses that pull the exact data you need (9.3–9.5). The third is aggregating — SUM and COUNT, the “how much?” versus “how many?” rule that unlocks Cambridge's data questions (9.6–9.7). Each idea is taught, drilled, then tested — work straight through, or jump to the part you need.
9.3–9.5
Querying
Ask the database questions with SELECT, FROM, WHERE and ORDER BY — the four clauses that carry every Cambridge database question. Build a query clause by clause and see the exact rows it returns.
9.6–9.7
Aggregating
Turn rows into answers with SUM and COUNT. One rule — “how much?” versus “how many?” — settles which to use, and that single idea unlocks most of Cambridge's aggregation marks.
📚 Want the written theory too? Read the Topic 9 lessons in the Knowledge Library, then come back to train.