Date | Description |
---|---|
June 19 | Introduction |
June 21 |
Data Models (2.1-3) Slides: PDF SQL: code |
June 23 |
SQL Basics (6.1-6.2) Slides: PDF SQL: sql-basics |
June 26 |
SQL Joins and Aggregates (6.3-6.4) Slides: PDF SQL: outer joins and aggregates and Data: Data |
June 28 |
Grouping and Query Evaluation (6.3-6.4) Slides: PDF |
June 30 |
SQL Subqueries (6.3) Slides: PDF SQL: subqueries |
July 3 | SQL Wrapup (no reading) Materials Slides: PDF SQL: subqueries |
July 5 | Relational Algebra (2.4, 5.1) Materials Slides: PDF |
July 7 | Relational Algebra and Query Evaluation (5.2) Materials Slides: PDF |
July 10 |
Data Storage and Indexing (14.1) Slides: PDF |
July 12 |
Query Optimization and Cost Estimation (15.1-3, 15.6, 16.3-5) Slides: PDF |
July 14 |
Relational Calculus query language primer (optional reference) Slides: PDF |
July 17 | Datalog (Ch 5.3–5.4) query language primer Materials Slides: PDF |
July 19 |
Datalong and Review Slides: PDF |
July 24 |
E/R Diagrams and Constraints (4.1-4.6, 7.1-7.2) Slides: PDF |
July 26 |
Design Theory (3.1, 3.3-4) Slides: PDF |
July 28 |
BCNF (3.5-3.7) Slides: PDF (large) PDF (small-annotations) |
July 31 |
Introduction to Transactions (18.1) Slides: PDF |
August 2 |
More Transaction (18.1-3) Slides: PDF |
August 4 |
Transaction Implementations (6.6, 18.4-6) Slides: PDF |
August 7 |
Parrallel Databases (20.1) Slides: PDF |
August 9 |
NoSQL (skim 11.1-3, 12.1) SQL vs NoSQL blog post (optional) Slides: PDF |
August 11 |
MapReduce (20.2) Original research paper (optional) Slides: PDF |
August 14 |
Spark Why Spark (quick overview) Slides: PDF |
August 16 |
ORMs and Review Slides: PDF |