| Date | Description |
|---|---|
| September 27 |
Introduction Slides: large small |
| September 29 |
Data Models (2.1-3) Slides: large small and SQL code |
| October 2 |
SQL Basics (6.1-2) Slides: large small and SQL code and Java code and Web SQL (outside scope): HTML and Javascript and CSS |
| October 4 |
SQL Aggregates (6.3-4) Slides: large small and SQL code: outer joins and aggregates and Data |
| October 6 |
SQL Grouping (6.3-4) Slides: large small and SQL code |
| October 9 |
SQL Subqueries (6.3) Slides: large small |
| October 11 |
SQL wrap-up Slides: large small |
| October 13 |
RA: Relational Algebra (2.4 & 5.1) Slides: large small |
| October 16 |
Datalog (5.3-4) Slides: large small |
| October 18 |
Datalog cont. + NoSQL and JSON Slides: large small |
| October 20 | NoSQL and JSON cont. |
| October 23 |
JSON and SQL++ Slides: large small |
| October 25 | JSON and SQL++ cont. |
| October 27 |
RA cont. & Query Evaluation (5.2 & 16.3, skimming 16.3.2) Slides: large small |
| October 30 |
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) Slides: large small |
| November 1 |
Storage & Indexing cont. + Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) Slides: large small |
| November 3 | Query Optimization Basics cont., by Magdalena Balazinska |
| November 8 |
Parallel Databases (20.1), by Dan Suciu Slides: large small |
| November 13 |
MapReduce (20.2) Slides: large small |
| November 15 |
Spark (23.1-2) Slides: large small |
| November 17 | Spark Cont. |
| November 20 |
E/R Diagrams & Constraints (4.1-6, 7.1-2) Slides: large small |
| November 22 |
Design Theory (3.1, 3.3-4) Slides: large small |
| November 27 | Design Theory cont. |
| November 29 |
Intro to Transactions (18.1) Slides: large small and SQL code |
| December 1 |
More Transactions (18.1-3) Slides: large small |
| December 4 |
Transaction Implementation (18.3) Slides: large small |
| December 6 |
DB techniques for ML Slides: large small |
| December 8 |
Final Review Slides: large small |