| September 28 |
Introduction
|
| September 30 |
Data Models (2.1-2.3)
Example queries
|
| October 3 |
SQL Basics (6.1-6.2)
Example queries
|
| October 5 |
SQL Joins and Aggregates (6.3-6.4)
|
| October 7 |
Grouping and Query Evaluation (6.3-6.4)
|
| October 10 |
SQL Subqueries (6.3)
|
| October 12 |
SQL Wrapup and relational algebra (no reading)
|
| October 14 |
Relational Algebra (2.4)
|
| October 17 |
Relational Algebra and Query Evaluation (no reading)
|
| October 19 |
Data Storage and Indexing (14.1)
|
| October 21 |
Query Optimization and Cost Estimation (15.1-3, 15.6)
|
| October 24 |
More Cost Estimation
|
| October 26 |
Relational calculus (query language primer)
|
| October 28 |
Datalog (5.3-5.4, query language primer)
|
| October 31 |
NoSQL and JSon (skim 11.1-3, 12.1)
|
| November 2 |
CouchBase and N1QL (no reading)
|
| November 4 |
Midterm Review
|
| November 9 |
E/R Diagrams and Constraints (4.1-4.6)
|
| November 14 |
Design Theory (3.1-3.4)
|
| November 16 |
BCNF (3.1-3.4)
|
| November 18 |
Introduction to Transactions (18.1)
|
| November 21 |
More Transactions (18.1-3)
|
| November 23 |
Transaction Implementations (18.1-3)
|
| November 28 |
Parallel Databases (20.1)
|
| November 30 |
More Parallel Databases and MapReduce (20.1-2)
|
| December 2 |
Spark (no reading)
|
| December 5 |
More Spark (no reading)
|
| December 7 |
Finale (no reading)
|