Computer Science — Databases Complete Pack

Computer Science — Databases Complete Pack

Build confident, exam-ready database skills. This complete Databases pack covers every concept you need — from understanding how relational databases are structured, through writing and refining SQL queries, to using aggregate functions to analyse data. Clear explanations, exam-focused practice, and real SQL examples throughout.

What's inside:

📘 9.1 Database Structure

Understand how relational databases are organised — tables, fields, records, primary keys and foreign keys — and why relational design eliminates data redundancy and keeps data consistent.

📘 9.2 SQL

Get to grips with the full SQL toolkit — SELECT, FROM, WHERE, ORDER BY, LIKE, INSERT INTO, UPDATE and DELETE — with applied questions and error correction throughout.

📘 9.3 SELECT … FROM

Learn how to retrieve exactly the data you need — selecting all fields with *, choosing specific fields, controlling column order, using aliases with AS, and removing duplicates with DISTINCT.

📘 9.4 SELECT … FROM … WHERE

Filter database records precisely using comparison operators (=, <>, <, >, <=, >=), combine conditions with AND and OR, use BETWEEN for ranges, and predict the output of multi-condition queries.

📘 9.5 ORDER BY

Sort query results in ascending or descending order — for both text and numeric fields — including multi-column sorting and combining ORDER BY with WHERE for filtered, sorted output.

📘 9.6 SUM

Use SQL aggregate functions to analyse data — SUM, COUNT, AVG, MIN and MAX — with applied questions using SUM with WHERE conditions, aliases, and multiple aggregates in a single query.

📘 9.7 COUNT

Master the COUNT function in depth — understanding the critical difference between COUNT(*) and COUNT(field), handling NULL values correctly, using COUNT DISTINCT, and applying conditional counting with WHERE.

🍎 Teacher Sheets Included

Every section comes with a full teacher copy complete with mark scheme answers, acceptable alternatives, SQL model answers, and classroom discussion guidance — ready to use straight in the classroom.

✅ Student-friendly and exam-focused

✅ Teacher answer sheets with full explanations included

✅ Aligned to Cambridge IGCSE Computer Science (0478)

✅ Instant PDF download

✅ Perfect for classroom use, homework, and independent revision