DateDescription
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)