| Date | Description |
|---|---|
| March 27 |
Introduction Slides: large small |
| March 29 |
Data Models (2.1-3) Slides: large small and SQL code |
| March 31 |
SQL Basics (6.1-2) Slides: large small and SQL code and Java code and Web SQL (outside scope): HTML and Javascript and CSS |
| April 3 |
SQL Aggregates (6.3-4) Slides: large small and SQL code: outer joins and aggregates and Data |
| April 5 |
SQL Grouping (6.3-4) Slides: large small and SQL code |
| April 7 |
SQL Subqueries (6.3) Slides: large small |
| April 10 |
SQL wrap-up Slides: large small |
| April 12 |
RA: Relational Algebra (2.4 & 5.1) Slides: large small |
| April 14 |
RA cont. & Query Evaluation (5.2 & 16.3, skimming 16.3.2) Slides: large small |
| April 17 |
Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) Slides: large small |
| April 19 | Storage & Indexing cont. |
| April 21 |
Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) Slides: large small |
| April 24 |
Datalog (5.3-4) Slides: large small |
| April 26 | Datalog cont. |
| May 1 |
NoSQL and JSON Slides: large small |
| May 3 |
JSON and SQL++ Slides: large small |
| May 5 | JSON and SQL++ cont. |
| May 8 |
E/R Diagrams & Constraints (4.1-6, 7.1-2) Slides: large small |
| May 10 |
Design Theory (3.1, 3.3-4) Slides: large small |
| May 12 | Design Theory cont. |
| May 15 |
Intro to Transactions (18.1) Slides: large small and SQL code |
| May 17 |
More Transactions (18.1-3) Slides: large small |
| May 19 |
Transaction Implementation (18.3) Slides: large small |
| May 22 |
Parallel Databases Slides: large small |
| May 24 |
MapReduce Slides: large small |
| May 26 |
Spark Slides: large small |
| May 31 |
Streaming Data slides |
| June 2 |
Final Review Slides: large small |