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.

What it covers

At GCSE (F7.3 and F7.4) you wrote SELECT, FROM, WHERE and ORDER BY, joined two tables with a WHERE condition, and changed data. At A level SQL does the whole job: it defines the tables from your normalised design, and it answers questions that need several tables, counts, totals and queries inside queries.

  • CREATE TABLE
  • ALTER TABLE and DROP TABLE
  • The club database
  • Searching: LIKE, BETWEEN and IN
  • INNER JOIN
  • Aggregates and GROUP BY
  • Nested SELECT
Read the free lesson (60 min)

Or do it in the simulator, with tasks that mark themselves

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.