CSE 414 Spring 2019
Lecture Topics

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

DateDescription
April 1 Unit 1 Intro
April 3 Unit 2 Relational Data Model (2.1-3) Sqlite (data model)
April 5 SQL Basics (6.1-2) Sqlite (joins)
April 8 Joins
April 10 Aggregates (6.3-4)
April 12 SQL Subqueries (6.3)
April 15 [RESCHEDULED ON 4/18] SQL wrap-up. Relational algebra (2.4 & 5.1)
April 17 More relational algebra (2.4 & 5.1)
April 19 Datalog (5.3-5.4)
April 22 Datalog (5.3-5.4)
April 24 Unit 3
April 26 JSon and SQL++
April 29 JSon and SQL++
May 1 JSon and SQL++
May 6 Unit 4 From RA to Query Evaluation (5.2 & 16.3, skim 16.3.2)
May 8 Storage & Indexing Basics (8.3-4 & 14.1-1.7 & skim 14.2-3)
May 10 Query Optimization Basics (15.{1,3,4.6,6} and 16.4-5)
May 13 Query Optimization wrapup
May 15 Unit 5
May 17 Parallel Databases (20.1)
May 20 Unit 6 E/R Diagrams and Constraints (4.1-4.6)
May 22 Integrity Constraints (4.1-4.6)
May 24 BCNF (3.1-3.4)
May 29 Unit 7 Introduction to Transactions (18.1) Sqlite demo
May 31 More Transactions (18.1-3)
June 3 Transaction Implementations (18.1-3)
June 5 Transaction Implementations (18.1-3)
June 7 Final Review