| COMP3311 09s1 | Lectures | Database Systems |
| Weekly | Notices |
| Week 01 | Course Intro ... Data Modelling ... ER Model |
| Week 02 | Ass 1 ... Relational Model ... ER-Rel Mapping |
| Week 03 | DBMSs ... SQL ... Schemas ... Building Databases |
| Week 04 | SQL ... Changing the Database ... Queries and Views |
| Week 05 | Ass1 ... SQL ... Ass2 ... More SQL ... Views |
| Week 06 | Extending SQL ... Stored Procedures ... PLpgSQL ... Constraints ... Triggers |
| Week 07 | Aggregates ... Catalogs ... DB Programming ... PHP Language/Libraries |
| Week 08 | Ass2 Review ... Ass3 Preview ... PL/DB Interfaces ... Web/DB Interfaces |
| Week 09 | Ass 3 ... Relational Design Theory ... Relational Algebra |
| Week 10 | Ass 3 ... Rel.Algebra ... DBMS Internals |
| Week 11 | Ass 3 ... DBMS Internals ... Query Processing ... Transaction Processing |
| Week 12 | Ass 3 ... Concurrency Control ... Database Trends ... Course Review |
| Manuals | PostgreSQL ... PHP |