Last Year's Notes (Hellerstein/Garofalakis)
WK
Class/Date
Topic
Book Chapter
Lecture Notes
1
Tu 8/30
Introduction
Th 9/1
Relational Model
3
2
Tu 9/5
Disks and Files
9
Th 9/7
Indexes
8 & 10
Tu 9/12
Sorting
13
Th 9/14
Relational Algebra
4 - 4.2
4
Tu 9/19
catch-up
Th 9/21
Relational Calculus
4.3
5
Tu 9/26
SQL 1
5-5.4
Th 9/28
Query Processing I
6
Tu 10/3
Query Processing II
Th 10/5
Boolean Text Search
7
Tu 10/10
Query Optimization I
Th 10/12
Query Optimization II
8
Tu 10/17
Physical Design, GroupBy/Aggregation
Th 10/19
ER Modeling
Tu 10/24
Functional Dependencies
Th 10/26
Midterm
10
Tu 10/31
Th 11/2
SQL Revisited
11
Tu 11/07
Th 11/9
Concurrency Control I
12
Tu 11/14
Th 11/16
Concurrency Control III
Tu 11/21
Th 11/23
14
Tu 11/28
Th 11/30
Tu 12/5
Th 12/7
Wrapup