
GCSE Computer Science SQL and relational databases unit: six editable 60-minute lessons for AQA 8525 (3.7 and 3.2.11) with OCR J277 mapping, led by the SQL Practice Tool, an offline interactive where pupils write real queries and get instant, auto-checked feedback.
What is it? A complete databases unit for Years 10 and 11: what a database is; tables, records, fields and data types; data redundancy and inconsistency; primary and foreign keys; SELECT, FROM and WHERE with AND and OR; ORDER BY and queries on two tables; INSERT, UPDATE and DELETE; and simple validation and authentication routines. SQL (structured query language) is how programs ask a relational database for data and change it.
SQL Practice Tool (one offline HTML file): pupils type SQL and run it against a fictional School Clubs database, with clear error messages (missing quote marks, ambiguous fields, = versus ==) and a Reset button. Twenty challenges in five levels (SELECT, WHERE, ORDER BY, two tables, changing data) are checked automatically, with hints and model answers. A Keys & Tables tab shows a foreign key in action and a flat file versus relational demo of redundancy. Whiteboard, laptop or phone; no installation, no logins; nothing is saved or sent.
Engagement in every lesson: a term and definition card sort, a split-the-flat-file design task, predict-then-run queries on mini-whiteboards, an SQL clause jigsaw and tool challenges.
What’s included
- Lessons 1–6 (60 min each), from database basics to validation and authentication
- 12 PowerPoint decks (Teacher with notes and answers; Student) and 18 Word worksheets at 3 levels
- End-of-unit assessment (13 questions, 36 marks, our own wording) with answers and marking guidance
- Knowledge organiser, SQL quick reference card and card pack
- Teacher guide with a coverage table for AQA and OCR, answer key, START HERE page and PDF copies
Time and materials: six hours; no textbook or database software needed.
Formats: PowerPoint, Word and PDF; the tool opens in any modern browser. UK spelling. Every query answer was checked by running it in SQLite.
Specification: AQA GCSE Computer Science 8525 (current specification for teaching from September 2025) 3.7 Relational databases and SQL, plus 3.2.11 validation and authentication; OCR J277 2.2.3 (SELECT, FROM, WHERE), 2.3.1 and 1.4.1 (SQL injection). Not endorsed by AQA or OCR.
Free taster: GCSE Computer Science SQL Free Lesson: SELECT, FROM and WHERE.
Licence: Supplied under the Tes licence you choose at checkout. Please don’t share these files beyond what that licence allows (for example, by posting them on a public website).
Last updated: 19/11/2026 (first release).
If this helped your class, an honest review on Tes helps other teachers find it. Thank you!
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.