Welcome to the SQL activities page.

By completing the following activities you will practise your SQL skills to select, insert, update or delete data in a relational database.

Activity 1Simple queries: Selecting and sorting data from one table.
Activity 2Complex queries: Selecting data from one table using a range of filtering criteria.
Activity 3Complex queries: Selecting and combining data from multiple tables.
Activity 4Inserting new data/records into a table.
Activity 5Updating existing data/records.
Activity 6Deleting data/records from a table.
Activity 7Changing the structure of the database by adding, altering or dropping tables of data.