| January 4 |
Introduction
|
| January 5 |
Data Models (2.1-2.3)
Example queries
|
| January 9 |
SQL Basics (6.1-6.2)
Example queries
|
| January 11 |
SQL Joins and Aggregates (6.3-6.4)
|
| January 12 |
Grouping and Query Evaluation (6.3-6.4)
|
| January 18 |
SQL Subqueries (6.3)
|
| January 19 |
SQL Wrapup and relational algebra (no reading)
|
| January 23 |
Relational Algebra (2.4, 5.1)
|
| January 25 |
Relational Algebra and Query Evaluation (5.2)
|
| January 26 |
Data Storage and Indexing (14.1)
|
| January 30 |
Query Optimization and Cost Estimation (15.1-3, 15.6)
|
| February 1 |
More Cost Estimation (16.3-5)
additional reference: Ch 14 from Ramakrishnan and Gehrke (optional, available in library)
|
| February 2 |
Relational calculus (query language primer)
more reference 1 (optional)
more reference 2 (optional)
|
| February 8 |
Datalog (5.3-5.4, query language primer)
|
| February 9 |
NoSQL (skim 11.1-3, 12.1)
|
| February 15 |
E/R Diagrams and Constraints (4.1-4.6)
|
| February 16 |
Design Theory (3.1-3.4)
|
| February 22 |
BCNF (3.5-3.7)
|
| February 23 |
Introduction to Transactions (18.1)
|
| February 27 |
More Transactions (18.1-3)
|
| March 1 |
Transaction Implementations (18.1-3)
|
| March 2 |
More Transaction Implementations (6.6, 18.4-6)
|
| March 6 |
Parallel Databases (20.1)
|
| March 8 |
MapReduce (20.2)
Original research paper (optional)
Comparison with parallel DBs (optional)
Mining of Massive Datasets (Ch 2.1-2.3) (optional)
|
| March 9 |
Spark (no reading)
|