A-Level Computer Science: Advanced SQL Teaching Pack — JOIN, INSERT, UPDATE, DELETE & DDL

A complete, exam-ready A-Level Computer Science teaching pack on Advanced SQL — covering everything beyond basic queries.

Designed for A-Level students and teachers, this pack builds on GCSE SQL knowledge and covers the full range of SQL skills required at A-Level, including querying across multiple related tables using `JOIN`, manipulating data with `INSERT`, `UPDATE`, and `DELETE`, and defining database structures using DDL commands.

**What's included:**

- **Lesson Presentation Notes** — 11 structured slides covering `INSERT`, `UPDATE`, `DELETE`, `INNER JOIN` across multiple tables, `CREATE TABLE`, aggregate functions (`COUNT`, `SUM`), and key exam tips

- **Student Worksheet** — 7 questions using a realistic College Enrollments database, progressing from DDL and DML through to multi-table JOIN queries

- **Homework Task** — 5 questions using an Online Retailer database, including a 4-mark exam-style question on DDL vs DML

- **Teacher Answer Scheme** — Full model answers with mark allocations for all homework questions

**Topics covered:**

`INSERT` • `UPDATE` • `DELETE` • `INNER JOIN` (across 2 and 3 tables) • `CREATE TABLE` • `ALTER TABLE` • DDL vs DML • `COUNT` • `SUM` • Aggregate functions • Primary Keys & Foreign Keys in queries

**Suitable for:** AQA, OCR, and Eduqas A-Level Computer Science specifications.

**Delivered as:** A single ZIP file containing all four documents. Download instantly and use in your classroom tomorrow.