The course will be taught by Holger Pirk and Peter McBrien, and comprise of four hours per week of combined lectures and tutorials. Lectures for the course will run in weeks 2-9. The exam for the course will be held in week 11 of the same term.
The syllabus and book list are held in DSS and on the departmental course page
To gain access to Panopto Lecture Recordings, Piazza Discussion Forums, and to receive course emails, please register at least to level 2 for this course.
The slides are placed here at the time of the lecture. Slides with grey links are provisional versions of the slides. Note that the course content is what is presented verbally during the lectures: you are expected to attend all lectures. Worksheets will be provided during lectures, and answers to those worksheets provided also during lectures.
Further examples to download into your own database are found at databases tools and data mini site.
To connect to the databases hosted on SQL Server, issue commands in the following form on a CSG Linux machine (and using password 'lab'):
sqsh -S sqlserver -D bank_branch -U lab
Once connected, queries may be entered, terminated by \go. Help on the environment may be found using \help.
The sqshrc file may be copied as .sqshrc in
your home directory, and altered to change the default behaviour of
sqsh. This file should by default be also present as
/etc/sqshrc on CSG Linux machines, but may be absent from
recent Ubuntu installations.
Note that this version of SQL Server does not support the various three valued logic tests IF UNKNOWN,
IF NOT FALSE, etc. It has been set to use ANSI
handling of NULL equality tests.
To connect to the databases hosted on Postgres, issue commands in the following form on a CSG Linux machine (and using password 'lab'):
psql -h db -U lab -d bank_branch -W
Once connected, queries may be entered, terminated with a semicolon.
Online help may be accessed with \help, and \exit used to exit the psql tool.
Note that this version of Postgres does not support
CUBE or ROLLUP.