AQA A-level Computer Science (7517)Specification point 4.10.4

AQA 7517 4.10.4: Structured Query Language (SQL)

The free BugBot lessons that teach this point, a robot to try it on, and the past-paper questions that test it.

Lessons that teach it

1. A11.4 SQL: defining tables and joining them Databases and big data
   CREATE TABLE with types and keys, ALTER and DROP, then SELECT with INNER JOIN, wildcards, aggregates, GROUP BY and nested queries.
2. A11.5 SQL: changing data and referential integrity Databases and big data
   INSERT, UPDATE and DELETE at A level, and how a database refuses orphan records. The robot logs its own moves.
3. A11.10 Project: the run database Databases and big data
   Design, normalise, build and fill a database of robot runs, log live runs in transactions, report with one joined query and export the…

Try it on a robot

The task from A11.4 SQL: defining tables and joining them, running here. Change the program and press Run.

The specification is AQA's own document; this page says which of our lessons teach point 4.10.4 and is not endorsed by the board.