By completing the following activities you will practise your SQL skills to select, insert, update or delete data in a relational database.
|Activity 1||Simple queries: Selecting and sorting data from one table.|
|Activity 2||Complex queries: Selecting data from one table using a range of filtering criteria.|
|Activity 3||Complex queries: Selecting and combining data from multiple tables.|
|Activity 4||Inserting new data/records into a table.|
|Activity 5||Updating existing data/records.|
|Activity 6||Deleting data/records from a table.|
|Activity 7||Changing the structure of the database by adding, altering or dropping tables of data.|