The entire course will be taught by Peter McBrien. In Week 11 there will be an exam for all students on the course.
The syllabus outlines the main topics covered in the course.
Books gives guidance about text books that help you with material presented on the course.
Links takes you to external sites that have addition software or information related to the course
The slides used by Peter McBrien are placed here at the time of the lecture. The slides do not form notes for the course, and do not cover all the material in the course. The course content is what is presented verbally during the lectures. Students are expected to attend all lectures.
Further examples to download into your own database are found in my 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.