Undergraduate
University Programme
SQL skills for the real world — the practical query fluency that employers screen for.
Overview
Graduates routinely arrive in their first analyst role able to discuss normalisation theory but unable to write a JOIN under pressure. This programme closes that gap, focusing entirely on hands-on SQL against realistic datasets.
Request this programme
What's Covered
Programme modules
1
SQL foundations
SELECT, WHERE, ORDER BY, and the mental model of how a query executes.
2
Working across tables
Primary and foreign keys, INNER and OUTER JOINs, and reasoning about results.
3
Aggregation and grouping
COUNT, SUM, AVG, GROUP BY and HAVING — answering summary questions.
4
Practical lab work
Students work through a realistic analysis brief end to end and present findings.
Learning Outcomes
By the end, delegates can
- task_alt Write multi-table queries with confidence
- task_alt Choose the correct join type for a given question
- task_alt Aggregate and summarise data accurately
- task_alt Debug a query that returns unexpected results
Practical Detail
How it runs
schedule
DurationFull 3-lesson series, or a single intensive workshop
groups
Group sizeLecture format, or labs of up to 40 students
science
FormatGuest lecture, semester supplement, or block workshop
location_on
DeliveryOn-campus or virtual instructor-led
Looking at a different audience?
Ready to build data capability?
Tell us about your organisation and we'll put together a tailored training proposal.