Following is a tentative schedule of the topics, and the details *will* change as the semester progresses.
Date Lecture Topics and Materials Notes Assignments
Introduction
  • Why study databases, and key principles underlying the field of data management.
  • Overview of the current data management systems + Industry perspective
  • High-level overview of a relational database system
  • Intro to relational data model + SQL
  • Logistics
[pdf slides] Setting up computing environment (No deliverable)
No class. Self-study using video (Part 1, Part 2) and posted material for
Reading Homework 1.
  • Relational model and relational algebra
  • Different types of keys
  • Basic SQL
[pdf slides]
No class (Labor Day)
Relational model/SQL continued.
[pdf slides] Assigned reading: Chapters 2, 3.1-3.7
(this should be done in conjunction
with the videos above).
Reading Homework 1 (Due 9/9 noon)
Relational Algebra.
[pdf slides] Assigned reading: Chapters 5.1.1 (JDBC), 5.2 (SQL Procedures/Functions), 6.1.1 (Fundamental Operations),
A Short Video (Slides for the video)
Reading Homework 2 (Due 11:59am 9/14)
More SQL: Views, Triggers, NULLs, Embedded SQL
[pdf slides]
[class activity]
Project 1 (Due 9/18)
More SQL. Entity-relationship Model.
[pdf slides] Assigned reading: Chapters 7.1-7.3, 7.5
Reading Homework 3 (Due 11:59am 9/21)
Entity-relationship Model. Ruby-on-Rails.
[pdf slides]
[class activity]
Database Design; Normalization
[pdf slides] Assigned reading: Chapters 8.1, 8.2, 8.3.1, 8.3.2
A Short Video
Reading Homework 4 (Due 11:59am 9/28)
Database Design; Normalization
(cntd above)
[class activity]
Project 2 (Due 10/2)
Storage Hierarchy: Disks, SSD, Caches, etc.
[pdf slides]
Assigned reading: Chapters 10.1, 10.2.1, 10.2.2, 10.2.4
Reading Homework 5 (Due 11:59am 10/5)
Midterm 1.
File organization, Buffer Management, Indexes.
[pdf slides]
Assigned reading: Chapters 10.3.1-3, 10.5, 10.8, 11.1
Reading Homework 6 (Due 11:59am 10/12)
File organization, Buffer Management.
(cntd above)
Project 3 (Due 10/16)
Indexes.
[pdf slides]
Assigned reading: Chapters 11.3
Reading Homework 7 (Due 11:59am 10/19)
Indexes.
[pdf slides]
Query Processing.
[pdf slides] Assigned reading: Chapters 12.1, 12.2, 12.3.1
Reading Homework 8 (Due 11:59am 10/26)
Query Processing. [class activity]
[pdf slides] Project 4 (Due 10/30)
Parallel Databases; MapReduce; Spark
[pdf slides] Assigned reading: Chapters 17.3, 18.1, 18.2, 18.4
Reading Homework 9 (Due 11:59am 11/2)
Parallel Databases; MapReduce; Spark
(cntd from above)
Parallel Databases; MapReduce; Spark
(cntd from above)
Assigned reading: Spark Programming Guide
Reading Homework 10 (Due 11:59am 11/9)
Midterm.
TBP.
Query Optimization.
[pdf slides]
Assigned reading: Chapters 13.1, 13.2.1, 13.3.1
Reading Homework 11 (Due 11:59am 11/16)
Transactions: ACID Properties, Concurrency.
[pdf slides] [class activity] Project 5 (Due 11/20)
Transactions: Recovery.
(cntd) Assigned reading: Chapters 14.1, 14.2, 14.3, 14.4 (some of this was already covered in class, and should be quick reading)
Reading Homework 12 (Due 11:59am 11/23)
Buffer/misc topics. (No class: Self-stufy using posted video and materials).
(cntd)
Transactions: Concurrency, Recovery.
(cntd) Assigned reading: Chapters 14.8, 15.3, 15.4
Reading Homework 13 (Due 11:59am 11/30)
Transactions: Recovery
(cntd) Project 6 (Due 12/7)
Distributed Databases; Distributed Transactions; CAP Theorem; Cloud Computing.
[pdf slides] Assigned reading: Chapters 19.2.1, 19.2.2, 19.3, 20.1, 20.2
Reading Homework 14 (Due 11:59am 12/7)
Object-relational Models; OLAP; Data Warehouses.
(cntd)

Web Accessibility