Exercises for Tutorial 4 are on the tutorial page. These involve writing and executing SQL queries using the LibreOffice Base desktop application. This is installed on all DICE machines, and the tutorial includes detailed usage notes: using DICE is probably the simplest way to complete the tutorial. It is also possible to do the exercises on university open-access machines or your own computer, and there are some instructions to help with that.
This tutorial includes more substantial starred extension exercises to try out other ways to access the same database.
- Setting up queries using the LibreOffice Base graphical query designer.
- Connecting on the command-line to a remote PostgreSQL database server.
- Linking LibreOffice Base to the remote database server.