Day 1 (Relational Database Design and SQL)
| Topics | Resources |
|---|---|
| Database Design with the E/R Model | slides |
| Relational Model | slides |
| SQL | slides |
| In-class Exercises | download postgres |
| initialize enrollment db | |
| queries (all but last three) |
Day 2 (SQL wrap-up, Query Processing)
| Topics | Resources |
|---|---|
| More SQL (aggregation and universal quantification) | slides (starting slide 87) |
| Query Processing | slides (introduction, slides 1-20) |
| In-class Exercises | queries (last three in list) |
| In-class Exercises | queries |
Day 3 (Performance Tuning: Indexing)
| Topics | Resources |
|---|---|
| Query Processing | slides (2-phase sort and indexing, slides 21 - 134) |
| In-class Exercises | querying the drinkers, bars and beers schema |
Day 4 (More Performance Tuning)
| Topics | Resources |
|---|---|
| Query Processing | slides (2-phase sort and indexing, slides 135 – end) |
| Index Selection | slides |
Day 5 (Materialized Views and Triggers; Column Stores; Datalog)
| Topics | Resources |
|---|---|
| Views | slides |
| Triggers | slides(last two slides), textbook chapter |
| Column Stores | slides |
| Datalog | slides courtesy of Jeff Ullman |