Subscribe to this calendar (Google, iCal, etc.)

Date	Description
September 26	Introduction (large)(small)
September 28	Unit 2 Relational Data Model (Textbook sections 2.1-3) (large)(small) demo in sqlite
October 1	SQL Basics (6.1-2) (large)(small) demo in sqlite
October 3	Aggregates (6.3-4) (large)(small) demo in sqlite
October 5	Aggregates (6.3-4) (large)(small) demo in sqlite
October 8	SQL Subqueries (6.3) (large)(small) demo in sqlite
October 10	SQL wrap-up, Relational algebra (2.4 & 5.1) (large)(small)
October 12	More relational algebra (2.4 & 5.1) (large)(small)
October 15	Datalog (5.3-5.4) (large)(small)
October 17	Datalog (5.3-5.4) (large)(small)
October 19	Unit 3 NoSQL, JSON, SQL++ (large)(small)
October 22	JSon and SQL++ (large)(small)
October 24	SQL++ (large)(small)
October 26	SQL++ Wrapup (large)(small)
October 29	Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) (large)(small)
November 2	Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3) (large)(small)
November 5	Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5) (large)(small)
November 7	Unit 5 Parallel Databases (20.1) From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2) (large)(small)
November 9	More Parallel Databases (large)(small)
November 14	Introduction to Spark (no reading) (large)(small)
November 16	More Spark (no reading) (large)(small)
November 19	Unit 6 E/R Diagrams and Constraints (4.1-4.6) (large)(small)
November 21	Design Theory (3.1-3.4) (large)(small)
November 26	BCNF (3.1-3.4) (large)(small)
November 28	Unit 7 Introduction to Transactions (18.1) Description BCNF (3.1-3.4) (large)(small)
November 30	More Transactions (18.1-3) (large)(small)
December 3	Transaction Implementations (18.1-3) (large)(small)
December 5	Transactions Wrapup (large)(small)
December 7	Final Review (large)(small)