| March 26 |
Introduction (large) (small)
|
| March 28 |
Relational Data Model (large) (small) (2.1-3)
Sqlite Demo
|
| March 30 |
SQL Basics (large) (small) (6.1-2)
Sqlite Demo
|
| April 2 |
SQL Aggregates (large) (small) (6.3-4)
|
| April 4 |
SQL Aggregates (large) (small) (6.3-4)
Sqlite Demo
Sqlite Demo Data
|
| April 6 |
SQL Subqueries (large) (small) (6.4)
|
| April 9 |
SQL wrap-up (large) (small)
|
| April 11 |
Datalog (large) (small) (5.3-5.4)
|
| April 13 |
More Datalog (large) (small) (5.3-5.4)
Souffle Demo 1
Souffle Demo 2
Souffle Demo 3
Souffle Demo 4
|
| April 16 |
Relational algebra (large) (small) (2.4 & 5.1)
|
| April 18 |
More relational algebra (large) (small)
|
| April 20 |
Introduction to NoSQL (large) (small)
|
| April 23 |
JSon and SQL++ (large) (small)
(SQL++ tutorial, Pages 6-25, 28-35 (skip SELECT VALUE), 41-65)
|
| April 25 |
SQL++ (large) (small)
|
| April 27 |
SQL++ Wrapup (large) (small)
|
| April 30 |
From RA to Query Evaluation, Parallel Databases (large) (small) (5.2 & 16.3, skim 16.3.2, 20.1)
|
| May 2 |
MapReduce and Spark (large) (small) (no reading)
|
| May 7 |
Spark (large) (small) (no reading)
|
| May 9 |
E/R Diagrams (large) (small) (4.1-4.6)
|
| May 11 |
Design Theory (large) (small) (3.1-3.4)
|
| May 14 |
BCNF (large) (small) (3.1-3.4)
|
| May 16 |
Introduction to Transactions (small) (18.1)
|
| May 18 |
More Transactions (small) (18.1-3)
|
| May 21 |
Transaction Implementations (small) (18.1-3)
|
| May 23 |
Storage & Indexing Basics (small) (8.3-4 & 14.1-1.7, skim 14.2-3)
|
| May 25 |
More Storage & Indexing (small) (15.{1,3,4.6,6} and 16.4-5)
|
| May 30 |
More Operator Costs (small) (15.{1,3,4.6,6} and 16.4-5)
|
| June 1 |
Intro to Query Optimization (small)
|