AQA GCSE Computer Science 8525 – AQ2.47 SQL: INSERT, UPDATE and DELETE – Lesson & Worksheet

Bespoke, fully editable lesson for AQA GCSE Computer Science (8525): AQ2.47 SQL: INSERT, UPDATE and DELETE. Slides, worksheet and full answers.

Written for Paper 2 Computing concepts, section 3.7 Relational databases and SQL (spec 3.7.2.2, 3.7.2.3). Everything is editable, so you can adapt it to your class.

What’s included

• PowerPoint lesson (12 slides) with teacher notes on every slide
• Student worksheet (Word), ready to print or edit
• Answer sheet (Word) with mark-scheme style answers for every question

AQ2.47 SQL: INSERT, UPDATE and DELETE

By the end of the lesson students can:

• Add a record to a table with INSERT INTO … VALUES
• Change data with UPDATE … SET … WHERE
• Remove records with DELETE FROM … WHERE, and explain why the WHERE clause matters

Worksheet sections: A. Which statement?; B. What happens?; C. Write the statements; D. Exam-style questions; E. Challenge

Every lesson includes

• Learning goals and a starter question
• Clear explanations, diagrams and worked examples (Python 3 throughout, with AQA pseudo-code alongside so students can read exam algorithms)
• A quick check and a “your turn” task linked to the worksheet
• Exam-style questions with marks, and an exit ticket

Format

• PowerPoint (.pptx) and Word (.docx), fully editable
• Works in PowerPoint and Google Slides
• Bright, clear GCSE design, consistent across the whole course

These are independent resources written for the AQA GCSE Computer Science specification (8525, version 1.3), for exams from 2027. They are not produced or endorsed by AQA. Spec point numbers are our own numbering of the specification statements.