COSC344

Database Theory and Applications

Semester 2, 2018

Lectures

Slides in PDF Date Topic
Lecture 1 print version 10/07/18 Introduction to databases, models
Lecture 2 print version 12/07/18 Database design, ER modelling
Lecture 3 print version 17/07/18 Relational model, relational algebra & operators 1
Lecture 4 print version 19/07/18 Relational algebra & operators 2
Lecture 5 print version 24/07/18 SQL - DDL
Lecture 6 print version 26/07/18 SQL - DML 1
Lecture 7 print version 31/07/18 SQL - DML 2
Lecture 8 print version 02/08/18 Functional dependencies
Lecture 9 print version 07/08/18 Normalisation
Lecture 10 print version 09/08/18 PL/SQL
Lecture 11 print version 14/08/18 Triggers
Lecture 12 print version 16/08/18 Java & SQL
Lecture 13 print version 21/08/18 C & SQL
Lecture 14 print version 23/08/18 PHP & SQL

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


Last updated:  12th Oct 2018   08:41