|
|
|
|
This page provides our tentative class schedule (which may be changed as needed). You can also access lecture notes, as they become available.
|
Week |
Date |
Lecture |
Topic |
|
Assignments |
Notes |
|
|
Out |
Due |
||||||
|
1 |
08/24 |
1 |
Introduction |
1 |
|
|
01-intro |
|
2 |
08/29 |
2 |
ER Model |
2 |
|
|
02-ER |
|
08/31 |
3 |
Relational Model |
3.1-3.3 |
|
|
03-rel | |
|
3 |
09/05 |
4 |
Relational Schema Design 1 |
3.4-3.7 |
04-reldesign-1 | ||
|
09/07 |
5 |
Relational Schema Design 2 |
3.4-3.7 |
|
|
04-reldesign-2 | |
|
4 |
09/12 |
6 |
Guest lecture by Marty Payne from State Farm |
|
|
guest-lecture-1 | |
|
09/14 |
7 |
Relational Algebra |
5.1-5.3 |
HW#1 |
Project stage 0 |
05-relalgebra | |
|
5 |
09/19 |
8 |
SQL: Queries |
6.1-6.2 |
|
|
06-sql-1 |
|
09/21 |
9 |
SQL: Subqueries and aggregation |
6.3-6.4 |
|
Project stage 1; |
06-sql-2 | |
|
6 |
09/26 |
10 |
SQL: DB Modification, Definition, Views |
6.5-6.7 |
|
HW#1; |
06-sql-3 |
|
09/28 |
11 |
SQL: Constraints and triggers |
7 |
|
Graduate project |
06-sql-4 | |
|
7 |
10/03 |
12 |
SQL: Systems Aspects |
8.1-8.4 |
HW#2 |
|
07-sqlsys, Beer.java, |
|
10/05 |
13 |
Database security |
8.7 |
|
Project stage 2 |
08-security | |
|
8 |
10/10 |
14 |
Logical query languages |
10.1-10.4 |
|
HW#2 |
09-datalog |
|
10/12 |
15 |
Midterm review |
|
|
10-midterm | ||
|
9 |
10/17 |
|
Midterm Exam: 3:30-4:45.
Bring UIUC PhotoID |
|
|
|
|
|
10/19 |
16 |
Storage and Representation |
11.1-11.4, 11.6-11.8, 12 |
|
|
11-storage | |
|
10 |
10/24 |
17 |
Indexing |
13 |
|
Graduate project |
12-indexing-1 |
|
10/26 |
18 |
Indexing |
13 |
|
|
12-indexing-2 | |
|
11 |
10/31 |
19 |
Guest lecture by Maryam Karimzadehgan |
|
Project stage 3 |
guest-lecture-2 | |
|
11/02 |
20 |
Query Execution |
15.1-15.6 |
|
|
13-queryprocessing-1 | |
|
12 |
11/07 |
21 |
|
HW#3 |
|
13-queryprocessing-2 | |
|
11/09 |
22 |
Query Optimization |
16 |
|
|
13-queryprocessing-3 | |
|
13 |
11/14 |
23 |
|
|
|
HW#3 |
13-queryprocessing-4 |
|
11/16 |
24 |
Transaction Management |
17 |
Project stage 4 |
14-tranmgr-1 | ||
|
14 |
11/21 |
|
Thanksgiving vacation. No class. |
|
|
||
|
11/23 |
|
Thanksgiving vacation. No class. |
|
|
|
||
|
15 |
11/28 |
25 |
|
|
HW#4 |
|
14-tranmgr-2 |
|
11/30 |
26 |
Concurrency Control |
18 |
Project stage 5 |
14-tranmgr-3 | ||
|
16 |
12/05 |
27 |
Distributed Transactions |
19 |
|
HW#4 |
14-tranmgr-4 |
|
12/07 |
28 |
Final review |
|
|
Graduate project |
||
|
17 |
12/12 |
|
Final Exam: 7:00pm-10:00pm, 1320 DCL. Bring UIUC PhotoID |
|
|
|
|