Class Schedule

Subject to change

  • 1/5 Introduction and Data Models
  • 1/7 Relational Model, Relational Algebra, and Intro to SQL
  • 1/12 Intro DB Internals, Buffer Pool Management, and Query Processing
  • 1/14 Data Layout and Access Methods
  • 1/19 Schema/Database Design (Lab 1 assigned)
  • 1/21 Indexes
  • 1/26 Indexes Continued (Grad reading 1 assigned)
  • 1/28 Advanced SQL and Joins (Lab 1 due 11:59pm. Lab 2 assigned)
  • 2/2 Query Opimization (Reading 1 due)
  • 2/4 Midterm
  • 2/9 Concurrency Control
  • 2/11 Concurrency Control (Lab 2 Due 2/12)
  • 2/16 Recovery (Lab 3 assigned)
  • 2/18 Distributed and Parallel DBs, Distributed Queries
  • 2/23 Distributed Txns, Replication, CAP
  • 2/25 Eventual Consistency and Dynamo
  • 3/1 Column-oriented databases (Lab 3 due, Lab 4 assigned)
  • 3/3 BigTable and Impala
  • 3/8 Main Memory DBMS
  • 3/10 Reading Day
  • 3/15 Final: Tuesday, March 15th, 1:30-3:30 pm, Ry 276
  • LAB 4 Due Noon 3/17 (Thurs)