That Blue Square Thing

Key Guide:

This is all the syntax you need to know.

AQA Computer Science GCSE

This page is up to date for the AQA 8525 syllabus for exams from 2022.

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.

You can get experiment with this database with SQLite online.

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

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

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

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

Multi-table queries - slides from class

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

Here are those SQL syntax rules again:

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