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
28th Oct.
wk7
Bank Holiday Monday – No Class

Classes Start Next Week for full-time students

Introduction to Databases and SQL
4th Nov
wk8
 Introduction to Databases and SQL Database Design Principals & Practice
11th Nov
wk9
Database Design Principals & Practice Loading Data, Analytical SQL and PL/SQL
18th Nov
wk10
Loading Data and Analytical SQL PL/SQL and Data Manipulation

Assignment Handout

25th Nov
wk11
PL/SQL and Data Manipulation

Assignment Handout

In-Database Data Mining

R & Python for Databases  (install JRE on your Laptop)    (Optional)

How to run R and Python to access and process data in a Database

Work on Assignment

2nd Dec
wk12
In-Database Data Mining

R & Python for Databases  (install JRE on your Laptop)    (Optional)

How to run R and Python to access and process data in a Database

Work on Assignment

Work on Assignment
9th Dec
wk13
Work on Assignment Work on Assignment
16th Dec
wk14
Assignment Due Monday 23rd December @23:00 Assignment Due Monday 23rd December @23:00