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

Week of/begin
 Full-time Students Part-time Students
29th Oct.
wk7
Bank Holiday Monday – No Class

Classes Start Next Week for full-time students

Introduction to Databases and SQL
5th Nov
wk8
 Introduction to Databases and SQL Database Design Principals & Practice
12th Nov
wk9
Database Design Principals & Practice Loading Data, Analytical SQL and PL/SQL
19th Nov
wk10
Loading Data, Analytical SQL and PL/SQL Data Manipulation using SQL

Query Performance and In-Database Data Mining

26th Nov
wk11
Data Manipulation using SQL

Query Performance and In-Database Data Mining

R and Databases (RJDBC) and Running R in the Database
3rd Dec
wk12
No Class – Work on Assignment No Class – Work on Assignment
10th Dec
wk13
R and Databases (RJDBC) and Running R in the Database Work on Assignment
17th Dec
wk14
Submit Assignment Submit Assignment
Results will be available in the New Year.