Slides and Videos | COMP3311 23T1 | WebCMS3

Week 1 12/02/2023 - 18/02/2023

Data Modelling, ER, Relational, ER->Rel

Week 2 19/02/2023 - 25/02/2023

SQL intro, DBMSs, SQL DDL, ER->SQL

Week 3 26/02/2023 - 04/03/2023

SQL: Sample DB, Updating, Queries, Views

Week 4 05/03/2023 - 11/03/2023

More SQL Queries, Stored Procedures, PLpgSQL

Week 5 12/03/2023 - 18/03/2023

PLpgSQL (ii), Constraints, Triggers, Aggregates, DB Programming

Week 6 26/03/2023 - 01/04/2023

There are no accessible resources under here.

Week 7 02/04/2023 - 08/04/2023

Python, Pyscopg2, Relational Design Theory

Week 8 09/04/2023 - 15/04/2023

Relational Design Theory