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. |