Online Classes Zoom link for all lectures.
Monday  Wednesday  

Introduction (slides)

Introduction Continued Read chapters 1 (skim), 2, 3.13.7 for Quiz 1, due by Friday Midnight Assignment 1 should be completed by Friday Midnight. (slides)


Modeling and Querying SQL Read chapter 4 for Quiz 2 due at noon (slides) 
Modeling and Querying More SQL, Relational Algebra (slides) 

Modeling and Querying Relational Algebra Quiz 3 due at noon (slides) 
Modeling and Querying ER Diagrams (slides) 

Modeling and Querying ER Diagrams, reduction (slides) 
Modeling and Querying FDs, BCNF normal form, Normalization Chapter 5 for Quiz 4 due at noon (note different day just for this week) Assign 4 due Saturday, midnight (slides) 

Modeling and Querying FDs, BCNF normal form, Normalization Chapters 7,8 for Quiz 5 due Wednesday at noon(long, start early) (slides) 
Functional Dependencies Chapters 7,8 for Quiz 5 due at noon (slides) (Example midterms: mid1s17.pdf, mid1f17.pdf, midf19.pdf) 

Functional Dependencies (slides) 
Exam 1  
Storage / Implementation / Optimization Query Processing Quiz 6 due at noon (slides) 
Storage / Implementation / Optimization Query processing (slides) 

Spring Break  Spring Break  
Storage / Implementation / Optimization Indexes, B+trees Quiz 7 due at noon (slides) 
Storage / Implementation / Optimization Query processing (updated slides folded into slides in last class) 

Storage / Implementation / Optimization Query processing (slides) 
Storage / Implementation / Optimization Query optimization (slides) 

Storage / Implementation / Optimization Query optimization Quiz 8 due at noon (slides) 
Storage / Implementation / Optimization Query optimization (slides) 

Isolation and Serializability (slides) 
Exam 2  
Isolation and Serializability Quiz 9 due at noon (slides) 
Isolation and Serializability (slides) 

Isolation and Serializability Quiz 10 due at noon 
Isolation and Serializability Assign 10 due Friday, midnight Late deadline for Quiz 10 

Isolation and Serializability Quiz 11 due at noon 
Isolation and Serializability Distributed Systems Assign 11 due Friday, midnight Late deadline for Quiz 11 

The End Exam 3 