Welcome to the Advanced Databases module. This is a core module on the MSc in Computing (Advanced Software Development).

During this module we will cover a number of core concepts for enterprise use of databases. This module will not teach you SQL or or SQL/Database programming. It is assumed you have learned this in your undergraduate degree. If you don’t have an IT undergraduate degree or you didn’t have a Databases modules, then you may need to do some additional learning around SQL.

For each topic, a reading list will be provided covering some basic and advanced discussions on the topics. I’ve listed some recommended text books on Databases.

The module is divided into 3 main components.

1. Review of Databases, their role and how to design,

2. Advanced topics for Databases, including Alternative Database architectures, Database & Query optimisation, Database Security and Distributed Databases.

3. Advanced Database solutions including cloud database services and alternative databases

Classes will be a mixture of lecture, in-class exercises, research, independent learning, and for the later part of the module we will be using the flipped class room, where each student will present a short lecture on a database topic.

Module Overview & Admin Notes

Read and understand these notes.

Click here to download these notes.

L0-AdvDB-Overview AdvDB Subject

CORRECTION: Assignment A = 60% and Assignment B = 40% (this is subject to change. Any change will be notified in class)

Books

Preparation for Lab work

I will be asking you to follow some tutorials and exercises on an Oracle Database. The easiest way to do this is to use a virtual machine.

Step 1: Install VirtualBox. This is software to allow you to run virtual machines.

Step 2: Download and import a pre-built virtual machine. Oracle provides several virtual machines that are pre-built with lots of software. Download this pre-built virtual machine. It contains an installed Oracle Database Enterprise Edition (it has all the database features), contains some additionally installed software, and also some tutorials. Follow the installation instructions.

You will need a PC/Laptop that is 64bit and capable of running Virtualisation.

You will need to change some of the configuration settings for this machine. Change RAM to 4G, and number of CPUs to 2.