Lectures

The lectures (except for Lecture 1) are available as audio-only-recordings through the Lectopia system - our particular lecture theatres are not yet enabled for the screen-capture option: Lectopia recordings for CITS3240 Databases

1. Unit Details (4-up PDF) and Introduction to Databases (4-up PDF)
2. The Relational Data Model (4-up PDF)
3. Sets and Relations (4-up PDF)
4. The Entity-Relationship Model I (4-up PDF)
5. The Entity-Relationship Model II (4-up PDF)
6. Database Definition I (4-up PDF)
7. Database Definition II (4-up PDF) plus correction to Slide 11
8. SQL I (4-up PDF)
9. SQL II (4-up PDF)
10. SQL Types (4-up PDF)
11. SQL III (4-up PDF)
12. JDBC 1 (4-up PDF) and Relational Algebra (4-up PDF)
13. Mid Semester Test
14. Relational Algebra II (4-up PDF)
15. PHP I (4-up PDF)
16. HTML & PHP I (4-up PDF)
17. HTML & PHP II (4-up PDF)
18. HTML & PHP III (4-up PDF)
19. Normalization I (4-up PDF)
20. Normalization II (4-up PDF)
21. Transactions I (4-up PDF)
22. Transactions II (4-up PDF)
23. Data Mining I (4-up PDF)
24. SQL IV (4-up PDF) - during tutorial session, 12noon Monday 2nd June, CSSE Rm 1.24
25. Wrap Up and Exam Preparation

Required knowledge

1. HTML I (4-up PDF)