| September 27 |
Unit 1Intro
|
| September 29 |
Unit 2 Relational Data Model (2.1-3)
|
| October 2 |
SQL Basics (6.1-2) demo in sqllite
|
| October 4 |
Aggregates (6.3-4)
|
| October 6 |
Aggregates (6.3-4)
|
| October 9 |
SQL Subqueries (6.3)
|
| October 11 |
SQL wrap-up, Relational algebra (2.4 & 5.1)
|
| October 13 |
More relational algebra (2.4 & 5.1)
|
| October 16 |
Datalog (5.3-5.4)
|
| October 18 |
Datalog (5.3-5.4)
|
| October 20 |
Unit 3 NoSQL, JSON, SQL++
|
| October 23 |
JSon and SQL++)
|
| October 25 |
SQL++
|
| October 27 |
Unit 4 From RA to Query Evaluation (5.2 & 16.3, skimming 16.3.2)
|
| October 30 |
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
|
| November 3 |
Storage & Indexing cont.
|
| November 6 |
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
|
| November 8 |
Unit 5 Parallel Databases (20.1) From RA to Query Evaluation (5.2 & 16.3, skimming 16.3.2)
|
| November 13 |
More Parallel Databases
|
| November 15 |
Introduction to Spark (no reading)
|
| November 17 |
More Spark (no reading)
|
| November 20 |
Unit 6 E/R Diagrams and Constraints (4.1-4.6)
|
| November 22 |
Design Theory (3.1-3.4)
|
| November 27 |
BCNF (3.1-3.4)
|
| November 29 |
Unit 5 Introduction to Transactions (18.1)
|
| December 1 |
More Transactions (18.1-3)
|
| December 4 |
Transaction Implementations (18.1-3)
|
| December 6 |
Transactions Wrapup demo in sqllite
|
| December 8 |
Final Review
|