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.
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.
||Full-time & Part-time Students|
|Module Introduction & Admin|
|Bank Holiday Monday – Review Week – No Class
Classes Start Next Week
|Introduction to Databases and SQL|
|More SQL, Loading Data, Transforming Data|
|Analytical SQL Functions|
|Procedural SQL using PL/SQL
|In-Database Data Mining
Work on Assignment
|No Class – Work on Assignment|
|Work on Assignment
Updated/Changed: Assignment due 3rd January @23:00