CSE 344 Autumn 2018
Lecture Topics

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

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