That Blue Square Thing

AQA Computer Science GCSE

This page is up to date for the new AQA 8525 syllabus for the 2022 exam. Make sure you check the revision pages to see which topics will be on the 2022 exam.

More Complex SQL

SQL becomes a little more complex when you want to get data from multiple tables.

The key is to remember how the tables are joined together.

Airport database - a relational database with two tables

You can get experiment with this database with SQLite online.

> SQLite online

Here's the database creation code so that you can try it out in SQLite.

Text file iconAirports database code - copy and paste the code. Don't forget to use DROP TABLE demo; to remove the demo table

Part 1: Some simple queries

The database contents and some simple queries to think about first:

PDF iconAirports database tasks

Part 2: Introducing multi-table queries

The slides from class introduce the idea of using queries across multiple tables:

PDF iconMulti-table queries - slides from class

PDF iconA single slide summary

And some exercises to try using a mix of single table and multi-table queries:

PDF iconAirport database questions - questions from class

PDF iconSlides with the questions on from class (but not the answers...)

Here are those SQL syntax rules again:

PDF iconSQL syntax rules

A data problem

This is an idea I want to think about at the end of the unit:

PDF iconA data management problem