|
|
|
Tirgulim (TA Lectures)
-
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 |
|
|
|
|