Topic coverage
SQL topics we can work through with your actual brief
The page focuses on syntax, program structure, data flow and language-specific behaviour. Each topic below should connect to a deliverable, test or explanation instead of appearing as isolated terminology.
01Joins and subqueries
For joins and subqueries, first define the expected behaviour or result, then apply it to the coursework brief using MySQL. Capture evidence that demonstrates the result and explain how it relates to syntax, program structure, data flow and language-specific behaviour.
02Normalisation
Normalisation often earns marks in more than one place: implementation, testing and explanation. Use PostgreSQL to make the work reproducible, then discuss the important assumptions, edge cases and limitations.
03Views and indexes
When the brief includes views and indexes, identify exactly what the marker expects to inspect. Build or analyse that part with SQL Server, record meaningful evidence, and connect the outcome to working code that can be explained and reproduced.
04Transactions
For transactions, first define the expected behaviour or result, then apply it to the coursework brief using MySQL Workbench. Capture evidence that demonstrates the result and explain how it relates to syntax, program structure, data flow and language-specific behaviour.
05Query optimisation
When the brief includes query optimisation, identify exactly what the marker expects to inspect. Build or analyse that part with pgAdmin, record meaningful evidence, and connect the outcome to working code that can be explained and reproduced.