| 1 |
Jan. 16 |
0. Introduction |
No Section |
|
Setup |
|
| |
Jan. 18 |
1. SQL I (Slides) + 2. SQL II (Slides) |
|
SQL |
|
|
| 2 |
Jan. 23 |
3. Disk, Buffers, Files I (Slides) |
SQL Slides WS Sol Exam Prep WS Exam Prep Sol |
|
SQL
(Due 2/2) |
|
| |
Jan. 25 |
4. Disks, Buffers, Files II (Slides) |
|
Disks, Buffers,
Files |
|
|
| 3 |
Jan. 30 |
5. B+ Trees (Slides) |
Disks, Buffers, Files Slides WS Sol Exam Prep WS Exam Prep Sol |
|
|
|
| |
Feb. 1 |
6. Indices & B+ Tree
Refinements (Slides) |
|
B+ Trees
(Due 2/12) |
B+ Trees
(Due 2/23) |
|
| 4 |
Feb. 6 |
7. Buffer Management (Slides) |
B+ Trees Slides WS Sol Exam Prep WS Exam Prep Sol |
|
|
|
| |
Feb. 8 |
8. Relational Algebra (Slides) |
|
Buffer Management
and
Relational Algebra
(Due 2/19) |
|
|
| 5 |
Feb. 13 |
9. Sorting & Hashing (Slides) |
Buffer Management and Relational Algebra Slides WS Sol Exam Prep WS Exam Prep Sol |
|
|
|
| |
Feb. 15 |
Extra time for Sorting & Hashing |
|
Sorting and Hashing
(Due 2/26) |
|
|
| 6 |
Feb. 20 |
10. Iterators & Joins (Slides) |
Sorting & Hashing Slides WS Sol Exam Prep WS Exam Prep Sol |
|
Joins + QO
(Part 1 Due 3/6)
(Part 2 Due 3/13) |
|
| |
Feb 21 |
Midterm 1 (7-9 PM), alternate TBD |
|
Iterators and Joins
(Due 3/4) |
|
|
| |
Feb. 22 |
No Lecture |
|
|
|
|
| 7 |
Feb. 27 |
11. Query Optimization I (Slides) |
Iterators & Joins Slides WS Sol Exam Prep WS Exam Prep Sol |
Query Optimization
(Due 3/11) |
|
|
| |
Feb. 29 |
12. Query Optimization II (Slides) |
|
|
|
|
| 8 |
Mar. 5 |
13. Transactions &
Concurrency I (Slides) |
Query Optimization Slides WS Sol Exam Prep WS Exam Prep Sol |
Transactions
(Due 3/18) |
|
|
| |
Mar. 7 |
14. Transactions &
Concurrency II (Slides) |
|
|
|
|
| 9 |
Mar. 12 |
15. DB Design:
ER Models (Slides) |
Transactions Slides WS Sol Exam Prep WS Exam Prep Sol |
DB Design
(Due 3/25) |
Locking
Part 1 Due 3/24
Part 2 Due 4/10 |
|
| |
Mar. 14 |
16. DB Design:
FDs (Slides) |
|
|
|
|
| 10 |
Mar. 19 |
17. Recovery I (Slides) |
DB Design Slides WS Sol Exam Prep WS Exam Prep Sol |
Recovery
(Due 4/8) |
|
|
| |
Mar. 21 |
18. Recovery II (Slides) |
|
|
|
|
| |
Mar. 26 |
Spring Break |
No Section |
|
|
|
| |
Mar. 28 |
Spring Break |
|
|
|
|
| 11 |
Apr. 2 |
19. PQP (Slides) |
Recovery Slides WS Sol Exam Prep WS Exam Prep Sol |
PQP
(Due 4/15) |
|
|
| |
Apr. 4 |
No Lecture |
|
|
Recovery
Due 4/23 |
|
| |
April 4 |
Midterm 2 (7-9 PM), alternate TBD |
|
|
|
|
| 12 |
Apr. 9 |
20. Distributed Xacts (Slides) |
Parallel Query Processing Slides WS Sol Exam Prep WS Exam Prep Sol |
Distributed Xacts
(Due 4/22) |
|
|
| |
Apr. 11 |
No Lecture |
|
|
|
|
| 13 |
Apr. 16 |
21. NoSQL (Slides) |
Distributed Transactions Slides WS Sol Exam Prep WS Exam Prep Sol |
NoSQL
(Due 4/29) |
|
|
| |
Apr. 18 |
No Lecture |
|
|
|
|
| 14 |
Apr. 23 |
22. Cluster Computing (Slides) |
NoSQL Slides WS Sol |
|
NoSQL
Due 5/1 |
|
| |
Apr. 25 |
23. Window Functions (Slides) |
|
|
|
|
| 15 |
Apr. 30 |
RRR Week |
RRR Week - Review Sections |
|
|
|
| |
May. 2 |
RRR Week |
|
|
|
|
| |
May. 7 |
May. 14 |
|
|
|
|
