Slides will be available before the lecture; Video and Data several hours after the lecture.
The Video links all go to YouTube; in addition, videos of all lectures are on Echo360 .

Week 1 Monday Data Modelling, ER Model Slides , Video , Data
Week 1 Wednesday ER, Relational Model, ER->Rel Mapping Slides , Video , Data
Week 2 Monday SQL DDL, ER->SQL Mapping Slides , Video , Data
Week 2 Wednesday ER->SQL Mapping, Building Databases Slides , Video , Data
Week 3 Monday Ass1, Modifying a DB, Simple BeerDB, SQL Slides , Video , Data
Week 3 Wednesday More SQL Slides , Video , Data
Week 4 Monday Stored Procedures, PLpgSQL Slides , Video , Data
Week 4 Wednesday More PLpgSQL Slides , Video , Data
Week 5 Monday Aggregates, Constraints, Triggers Slides , Video , Data
Week 5 Wednesday PL/DBMS, Python/Psycopg2 Slides , Video , Data
Week 6 no lectures -
Week 7 Monday Assignment 2, More Python/Psycopg2 Slides , Video , Data
Week 7 Wednesday Relational Design Theory: FDs, Closures Slides , Video , Data
Week 8 Monday Normalisation (BCNF, 3NF) Slides , Video , Data
Week 8 Wednesday Relational Algebra, DBMS Architecture Slides , Video , Data
Week 9 Monday Query Evaluation, Transactions Slides , Video , Data
Week 9 Wednesday Serializability, Locking Slides , Video , Data
Week 10 Monday Database Futures, Course Review, Exam Preview Slides , Video
Week 10 Wednesday -

Resource created Wednesday 07 June 2023, 08:02:41 AM, last modified Monday 28 October 2024, 04:14:50 PM.


Back to top

COMP3311 23T3 (Database Systems) is powered by WebCMS3
CRICOS Provider No. 00098G