MSc Working with Data

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) to complete the various lab exercises and to explore the topics covered in more detail.

*** Module Introduction & Admin – Notes

IMPORTANT:  We will be using a database hosted on the cloud. This means you will be able to access it from anywhere. Details of how to connect to it will be given during the first week, along with your login details. This will be an Oracle Database, and if you want you can go create your own cloud database using their Oracle Free Tier.

To access the database you will need to use Oracle SQL Developer. You will need to download this onto your own laptop/PC. Make sure you download and unzip Oracle SQL Developer.  If possible download the version that includes JDK (the first one in the list).  There is no install required. Just download the software, unzip it and it is ready to use.  This needs to be completed before the first class.

Week of/begin
 Full-time & Part-time Students
Module Introduction & Admin
26th Oct.
wk6
Bank Holiday Monday – Review Week – No Class

Classes Start Next Week

2nd Nov
wk7
 Introduction to Databases and SQL
9th Nov
wk8
More SQL, Loading Data, Transforming Data
16th Nov
wk9
Analytical SQL Functions
23rd Nov
wk10
Procedural SQL using PL/SQL

Assignment Handout

30th Nov
wk11
In-Database Data Mining

Work on Assignment

7th Dec
wk12
Work on Assignment

Online support session during first hour of scheduled class time. Assignment is due next week.

14th Dec
wk13
Work on Assignment

Assignment due Friday 18th December @23:00