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.
|Introduction class & module overview
Assignment A – Handout
|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.
Assignment A – Lottery of research topics
|Query Optimization – Part 1|
|Query Optimization – Part 2|
Work on Completing Assignment A
|Guest Lecture – Advanced SQL Functionality – by Chris Saxon (AskTOM)
Assignment B – Handout
Assignment A – Due Friday 13th November
|Assignment A – Student Presentation – Presentations will be on Teams – See BrightSpace for link
Please test your microphone, video and connection in advance of the scheduled presentations.Part-time Student Schedule
Full-time Student Schedule
|Assignment A – Student Presentation– Presentations will be on Teams – See BrightSpace for link|
|Assignment A – Student Presentation– Presentations will be on Teams – See BrightSpace for link
Complete work on Assignment B
|No Class – Work on Assignment B
Updated/Changed Assignment B – Due Wednesday 23rd December @23:00
|Study & Revision
Assignment marking. I will endeavor to have assignment A marked before Christmas.
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.