WK

Class/Date

Topic

Book Chapter

Lecture  Notes

1

Tu 8/30

Introduction

1

Th 9/1

Relational Model

3

2

Tu 9/5

Disks and Files

9

Th 9/7

Indexes

8 & 10

3

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

9

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

13

Tu 11/21

Th 11/23

14

Tu 11/28

Th 11/30

14

Tu 12/5

Th 12/7

Wrapup