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 class room for this module. This means you will need to use your own laptop to do all the lab work. Make sure you download and unzip Oracle SQL Developer and Oracle Data Modeller.  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 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

In-Database Data Mining

Assignment Handout

26th Nov
wk11
Data Manipulation using SQL

In-Database Data Mining

Assignment Handout

R and Databases (RJDBC)  (install JRE on your Laptop)

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) (install JRE on your laptop)

Running R in the Database

Work on Assignment
17th Dec
wk14
Submit Assignment Submit Assignment
Results will be available in the New Year.