|
Assignment |
Topic |
Due Date |
Answers |
|
Homework 1/Programming |
SQL |
||
|
Programming Assignment on SQL |
Due January 24 |
||
|
Transactions |
Due February 14 |
||
|
Locking, Recovery and Storage |
Due February 22 |
||
|
Query Processing and Optimization |
Due March 7 |
|
DATE |
LECTURE |
PDF |
|
01/03 |
Introduction and Overview |
|
|
01/08 |
SQL |
|
|
01/10 |
SQL |
|
|
01/17 |
SQL |
|
|
01/19 |
Building SQL Applications (Sieg 134) |
|
|
01/22 |
SQL |
|
|
01/24 |
Schema Design |
|
|
01/29 |
Schema Design |
|
|
01/31 |
Schema Design |
|
|
02/07 |
Transactions |
|
|
02/12 |
Transactions |
|
|
02/14 |
Transaction Recovery and Storage |
|
|
02/21 |
Storage and Indexing |
|
|
02/26 |
Storage and Indexing |
|
|
02/28 |
Query Processing |
|
|
03/05 |
Query Optimization |
|
|
03/07 |
Query Optimization |
Winter 2001 midterm with solution
Fall 2000 midterm
and its solution
Fall 1999 midterm and its solution
Fall 1998 midterm and its solution