COSC344
Semester 2, 2022
Lectures
| Slides in PDF | Date | Topic | |
|---|---|---|---|
| Lecture 1 | 28/02/22 | Introduction to databases, models | |
| Lecture 2 | 02/03/22 | Database design, ER modelling | |
| Lecture 3 | 07/03/22 | Relational model, relational algebra & operators 1 | |
| Lecture 4 | 09/03/22 | Relational algebra & operators 2 | |
| Lecture 5 | 14/03/22 | SQL - DDL | |
| Lecture 6 | 16/03/22 | SQL - DML 1 | |
| Lecture 7 | 21/03/22 | SQL - DML 2 | |
| Lecture 8 | 23/03/22 | Functional dependencies | |
| Lecture 9 | 28/03/22 | Normalisation | |
| Lecture 10 | 30/03/22 | PL/SQL | |
| Lecture 11 | 04/04/22 | Triggers | |
| Lecture 12 | 06/04/22 | Java & SQL | |
| Lecture 13 | 11/04/22 | C & SQL | |
| Lecture 14 | 13/04/22 | PHP & SQL | |
| Mid-semester break - Enjoy your time off | |||
| ANZAC Day | 25/04/22 | No Lecture | |
| Lecture 16 | 27/04/22 | Views & NULL | |
| Lecture 17 | 02/05/22 | Database files and storage | |
| Lecture 18 | 04/05/22 | Database indexing - part 1 | |
| Lecture 19 | 09/05/22 | Database indexing - part 2 | |
| Lecture 20 | 11/05/22 | Database security & auditing | |
| Lecture 21 | 16/05/22 | Transactions | |
| Lecture 22 | 18/05/22 | Concurrency control | |
| Lecture 23 | 23/05/22 | Database recovery | |
| Lecture 24 | 25/05/22 | Query optimisation | |
| Lecture 25 | 30/05/22 | NoSQL | |
| Lecture 26 | 01/06/22 | Revision | |
Last updated: 29th Mar 2022 04:10
