Note: Many
slides copied and modified from Amol Deshpande, Nick Roussopoulos,
and www.db-book.org.
Many thanks to all of them!
Date |
Topic |
Book |
Lecture Notes |
---|---|---|---|
Jan 27 |
Introduction |
|
|
Jan 29 |
Relational Model |
Chapter 1 |
|
Feb 4 |
SQL |
Chapter 2 |
|
Feb 6 |
SQL |
|
|
Feb 11 |
SQL |
|
Advanced SQL |
Feb 13 |
SQL |
Chapter 3 |
|
Feb 18 |
SQL; Relational Algebra |
Chapter 5, 6 |
Relational algebra |
Feb 20 |
ER Model |
Chapter 7 |
|
Feb 25 |
ER Model...cont, Conversion to relational |
Chapter 7 |
|
Feb 27 |
Functional
dependencies |
Chapter 8 |
|
Mar 4 |
Midterm 1 |
|
Everything including ER model but not functional dependencies |
Mar 6 |
Normalization |
Chapter 8 |
|
Mar 11 |
Normalization
|
|
|
Mar 13 |
Storage/Files |
Chapter 10 |
|
Mar 18 |
Spring Break |
|
|
Mar 20 |
Spring Break |
|
|
Mar 25 |
Indexing/Hashing |
|
Prof. Pop out |
Mar 27 |
Storage: Indexing/Hashing |
Chapter 11 |
Mid 2 |
Apr 1 |
Midterm 2 |
|
Prof. Pop out/ ER model, functional dependencies/normalization, storage/files. |
Apr 3 |
Storage: Indexing/Hashing |
|
|
Apr 8 |
Query processing: Join/Sorting |
Chapter 12 |
|
Apr 10 |
Query processing: Join/Sorting |
|
|
Apr 15 |
Query optimization |
Chapter 13 |
|
Apr 17 |
Query optimization |
|
|
Apr 22 |
Transactions |
Chapter 14 |
|
Apr 24 |
Catch-up/quiz (mini-midterm 3) |
|
|
Apr 29 |
Concurrency |
Chapter 15 |
|
May 1 |
Recovery |
Chapter 16 |
|
May 6 |
Recovery |
|
|
May 8 |
Parallel Databases |
Chapters 18,19 |
|
May 13 |
Wrap-up |
|
|
May 20 |
FINAL |
1:30-3:30pm CSIC 1121 |
EVERYTHING |