Tirgulim (TA Lectures)

Lectures Schedule

Date Topic PPT Handouts (ps, pdf) 29/10/2003 Entity-Relationship Diagrams ppt (ps), (pdf) 5/11/2003 Creating Tables and Translating ER Diagrams ppt (ps), (pdf) 12/11/2003 DML and SQL ppt - Part 1 ppt - Part 2 (ps - Part 1), (ps - Part 2), (pdf - Part 1), (pdf - Part 2) 19/11/2003 Advanced SQL ppt (ps), (pdf) 26/11/2003 Views, Materialized Views and Null Values ppt (ps), (pdf) 3/12/2003 JDBC ppt (ps), (pdf) 10/12/2003 Review of Homework, Computing Keys (ps), (pdf) 17/12/2003 PL/SQL and Triggers ppt - Part 1 ppt - Part 2 (ps - Part 1), (ps - Part 2), (pdf - Part 1), (pdf - Part 2) 24/12/2003 Triggers (cont.) and Design Theory ppt (ps), (pdf) 31/12/2003 Optimization ppt (ps), (pdf) 7/1/2004 Database Tuning ppt (ps), (pdf) 14/1/2004 More Tuning/Optimization ppt (ps), (pdf), 21/1/2004 Transaction Management ppt (ps), (pdf) 28/1/2004 Review Lesson: Example questions and answers