COSC344

Database Theory and Applications

Semester 2, 2017

Lectures

Slides in PDF Date Topic
Lecture 1 print version 11/07/17 Introduction to databases, models
Lecture 2 print version 13/07/17 Database design, ER modelling
Lecture 3 print version 18/07/17 Relational model, relational algebra & operators 1
Lecture 4 print version 20/07/17 Relational algebra & operators 2
Lecture 5 print version 25/07/17 SQL - DDL
Lecture 6 print version 27/07/17 SQL - DML 1
Lecture 7 print version 01/08/17 SQL - DML 2
Lecture 8 print version 03/08/17 Functional dependencies
Lecture 9 print version 08/08/17 Normalisation
Lecture 10 print version 10/08/17 PL/SQL
Lecture 11 print version 15/08/17 Triggers
Lecture 12 print version 17/08/17 Java & SQL
Lecture 13 print version 22/08/17 C & SQL
Lecture 14 print version 24/08/17 PHP & SQL

Mid-semester break - Enjoy your time off
Lecture 15 print version 05/09/17 Views & NULL
Lecture 16 print version 07/09/17 DBMS Architecture & System catalog
Lecture 17 print version 12/09/17 Database files and storage
Lecture 18 print version 14/09/17 Database indexing - part 1
Lecture 19 print version 19/09/17 Database indexing - part 2
Lecture 20 print version 21/09/17 Database security & auditing
Lecture 21 print version 26/09/17 Transactions
Lecture 22 print version 28/10/17 Concurrency control
Lecture 23 print version 03/10/17 Database recovery
Lecture 24 print version 05/10/17 Query optimisation
Lecture 25 print version 10/10/17 NoSQL and Big data
Lecture 26 print version 12/10/17 Revision


Last updated:  2nd Oct 2017   05:09