|
|
|
Comp2400/Comp6240 Lectures
|
course home page
| title |
date |
pdf for printing |
pdf slides |
mp3 recording |
| Lecture 1: Course Overview |
Tuesday, 17 July 2007 |
printLecture01.pdf |
slidesLecture01.pdf |
sorry |
Lecture 2: The Relational Data Model |
Thursday, 19 July 2007 |
printLecture02.pdf |
slidesLecture02.pdf |
lecture02.mp3 |
Lecture 3: Updates, a DBMS, SQL |
Tuesday, 24 July 2007 |
printLecture03.pdf |
slidesLecture03.pdf |
lecture03.mp3 |
Lecture 4: Mum, where do schemas come from? |
Thursday, 26 July 2007 |
printLecture04.pdf |
slidesLecture04.pdf |
lecture04.mp3 |
Lecture 5: Schemas from Models |
Friday, 27 July 2007 |
printLecture05.pdf |
slidesLecture05.pdf |
lecture05.mp3 |
Lecture 6: Files, Indexes and Query Processing |
Tuesday, 31 July 2007 |
printLecture06.pdf |
slidesLecture06.pdf |
lecture06.mp3 |
Lecture 8 code examples create
schema populate questions drop schema
Lecture 9 code examples create
schema populate questions (use drop schema from
lecture 8).
|
The Relational Model and SQL
|
| title |
date |
pdf for printing |
pdf slides |
mp3 recording |
Lecture 12: Sets, Products, Relations, Functions |
Tuesday, 14 August 2007 |
printLecture12.pdf |
slidesLecture12.pdf |
lecture12.mp3 |
| Lecture 13: Relational Algebra |
Thursday, 16 August 2007 |
printLecture13.pdf |
slidesLecture13.pdf |
lecture13.mp3 |
| Lecture 14: More Relational Algebra |
Friday, 17 August 2007 |
printLecture14.pdf |
slidesLecture14.pdf |
lecture14.mp3 |
| Lecture 15: Logic |
Tuesday, 21 August 2007 |
printLecture15.pdf |
slidesLecture15.pdf |
lecture15.mp3 |
| Lecture 16: Tuple Calculus, Domain Calculus |
Thursday, 23 August 2007 |
printLecture16.pdf |
slidesLecture16.pdf |
sorry |
| Lecture 17: Ontologies and Deductive Databases |
Friday, 24 August 2007 |
printLecture17.pdf |
slidesLecture17.pdf |
lecture17.mp3 |
| Lecture 18: "Logical" Database Design |
Tuesday, 28 August 2007 |
printLecture18.pdf |
slidesLecture18.pdf |
lecture18.mp3 |
| Lecture 19: Normal Forms |
Thursday, 30 August 2007 |
printLecture19.pdf |
slidesLecture19.pdf |
lecture19.mp3 |
Mid-Semester Test |
Friday, 31 August 2007 |
| Lecture 20: Second and Third Normal Forms |
Tuesday, 18 September 2007 |
printLecture20.pdf |
slidesLecture20.pdf |
lecture20.mp3 |
| Lecture 21: Mid-Test Feedback |
Thursday, 20 September 2007 |
printLecture21.pdf |
slidesLecture21.pdf |
sorry |
| no lecture |
Friday, 21 September 2007 |
| Lecture 22: BCNF |
Tuesday, 25 September 2007 |
printLecture22.pdf |
slidesLecture22.pdf |
sorry |
| Lecture 24: A BCNF Example |
Thursday, 27 September 2007 |
printLecture23.pdf |
slidesLecture23.pdf |
lecture23.mp3 |
| Lecture 24: Decomposition Properties |
Friday, 28 September 2007 |
printLecture24.pdf |
slidesLecture24.pdf |
lecture24.mp3 |
| Lecture 25: Normalisation Wrap-Up |
Tuesday, 2 October 2007 |
printLecture25.pdf |
slidesLecture25.pdf |
lecture25.mp3 |
|
Physical Database Design and Implementation
|
| title |
date |
pdf for printing |
pdf slides |
mp3 recording |
| Lecture 26: Query Processing |
Thursday, 4 October 2007 |
printLecture26.pdf |
slidesLecture26.pdf |
lecture26.mp3 |
| Lecture 27: More Query Processing |
Friday, 5 October 2007 |
printLecture27.pdf |
slidesLecture27.pdf |
lecture27.mp3 |
| Lecture 28: JDBC (guest lecturer Robin Garner) |
Tuesday, 9 October 2007 |
printLecture28.pdf |
slidesLecture28.pdf |
lecture28.mp3 |
| Lecture 29: Query Optimisation |
Thursday, 11 October 2007 |
printLecture29.pdf |
slidesLecture29.pdf |
sorry |
| Lecture 30: Transactions |
Friday, 12 October 2007 |
printLecture30.pdf |
slidesLecture30.pdf |
lecture30.mp3 |
| Lecture 31: (guest Lecturer Bob Edwards) |
Tuesday, 16 October 2007 |
|
lecture notes |
|
| Lecture 32: Transaction Schedules |
Thursday, 18 October 2007 |
printLecture32.pdf |
slidesLecture32.pdf |
lecture32.mp3 |
| Lecture 33: Recovery |
Friday, 19 October 2007 |
printLecture33.pdf |
slidesLecture33.pdf |
lecture33.mp3 |
| No Lecture 34 |
Tuesday, 23 October 2007 |
| Lecture 35: Security, Privacy and Ethics |
Thursday, 25 October 2007 |
printLecture35.pdf |
slidesLecture35.pdf |
lecture35.mp3 |
| Lecture 36: Revision and Exam Discussion |
Friday, 26 October 2007 |
printLecture36.pdf |
slidesLecture36.pdf |
lecture36.mp3 |
|
