COSC344

Semester 2, 2020

Lectures

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

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


Last updated:  13th Aug 2020   02:23