Databases & SQL|Cambridge IGCSE Computer Science 0478 / 0984|PPT|Worksheet|Activity|MCQ Quiz|Answers.

SQL doesn’t have to be intimidating — this pack makes it click. Covers database fundamentals (records, fields, primary keys), validation, and SQL SELECT statements with WHERE, AND/OR and ORDER BY — exactly as examined in Cambridge IGCSE 0478/0984 Topic 9. Includes a clear step-by-step PPT, 10 progressively challenging SQL-writing exercises, a database design activity, a 15-question MCQ quiz, and a marking scheme showing correct SQL syntax for every question. Perfect for students who’ve never written a query before.

1 Lecture Slides (PPTX, 30 slides)

Title, objectives, table/record/field, primary keys, data types, validation recap, intro to SQL, WHERE + operators, AND/OR, ORDER BY, COUNT, practice + recap slides — all built around one consistent Students table

2 Worksheet (DOCX)
Database design task (ClubMembers scenario) + 10 graded SQL-writing questions (simple WHERE → AND/OR → ORDER BY → combined), 56 marks total, full answer space

3 Activity (DOCX)
“SQL Snap!” card-matching game — full teacher instructions, timing, materials, differentiation ideas, and printable cut-out cards (10 English Request cards + 10 SQL Statement cards) with answer key

4 MCQ Quiz (DOCX)
15 questions (easy→hard), including 6 “what would this SQL return?” questions using the same Students table, with an answer grid

5 Answers & Marking Scheme (DOCX)
Model table design with justification, exact correct SQL for all 10 worksheet questions with mark breakdowns, full MCQ answer key with one-line justifications, plus grade boundary guidance

All worksheets are print-ready

Fully editable resources.

Great for: classroom teaching, revision lessons, flipped learning, homework tasks.

If you found this useful, please leave a review. it really helps!

Check out my other resources and bundles in my TES shop.