Databases
Slides and lecture notes
There are brand new teaching materials for this course in 2026/27. As of the latest update (2026-10-11), these materials are incomplete. The rest of the materials will appear here as the course progresses.
- Lecture notes
- Slides without step-by-step builds
- Slides with step-by-step builds
- Practical exercises and supervision problems are embedded within the lecture notes.
SQL database practicals
It is important that you try out queries on a real database so that you can get a feel for how it works. We provide you with an example database of movies that is also used as running example in the lectures. For the SQL exercises we will use DuckDB. There are two options for running DuckDB:
- Install the DuckDB command line interface
on your computer, download the example database, and then open that
database by running
duckdb movies.duckdb - Use DuckDB in your browser, where the movies database is already preloaded
Feel free to modify the database as you like; your changes will not be saved and nobody else will be affected. If you break the database, you can just re-download it.