COSC344

Semester 2, 2021

Lectures

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

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


Last updated:  12th Aug 2021   02:45