MSc Advanced Databases

BrightSpace : This module is available on BrightSpace. Each student needs to self-enrol in the module. Search for ‘Advanced Databases DATA9810: 2020-2021‘, and for my name. The module description will have my name. This Brightspace module will be used for TU59 and TU60.  Look in sub-sections for links for online classes.  Online classes for TU59 will be listed in module sub-section called TU59 Online Classes. Similar for TU60.

Students are reminded that notes provided on this site are intended to form summary material only and are not intended to be a substitute for attending lectures or further reading on the subject.

My slides are not Lecture Notes

Students should download the notes to your own device. The notes are a living artifact and will evolve from semester to semester. It cannot be guaranteed that the notes will be available after the end of a semester.

Important: You will need to perform additional reading and research (outside of class time) on each topic. A number of lab exercises will be given and it is expected that these will be completed. You may need to complete additional research to complete these.

*** Module Introduction & Admin – Notes

FAQ for module – Please check regularly

Week of/begin
 Lecture Topic
21st Sept
wk1
Introduction class & module overview

Review of Database & Database Management, and their role in Enterprises

Assignment A – Handout

28th Sept
wk2
Alternative and NoSQL Databases

Full-time Students : All students to notify me if they are completing Assignment A in pairs (and the other person name) or individually. Sent me an email confirming individual or group (with names and student numbers) members by Monday 5th October @13:00.

Part-time Students : Assignment A is an individual assessment.

5th Oct
wk3
Distributed Databases

Assignment A – Lottery of research topics

12th Oct
wk4
Query Optimization – Part 1
19th Oct
wk5
Query Optimization – Part 2
26th Oct
wk6
Bank Holiday

Work on Completing Assignment A

2nd Nov
wk7
Guest Lecture – Advanced SQL Functionality

Assignment B – Handout

9th Nov
wk8
Database Security

Assignment A – Due Friday 13th November

16th Nov
wk9
Assignment A – Student Presentation

Part-time Student Schedule
Full-time Student Schedule

23rd Nov
wk10
Assignment A – Student Presentation
30th Nov
wk11
Assignment A – Student Presentation

Complete work on Assignment B

7th Dec
wk12
Assignment A – Student Presentation or No Class if presentation schedule is complete

Work on Assignment B

Assignment B – Due Monday 21st December

14th Dec
wk13
Study & Revision

Assignment marking. I will endeavor to have assignment A marked before Christmas.
Due to the short turn around time, this may not be possible, and results will be available in early January.

Assignment feedback sessions can be arranged in January.

Would you interested in writing your own Database. Here is sample code for creating a basic database engine using Go Lang. And here is the blog post to step you through the code.