Comp 521 Fall 2020

Agenda

08/11 Introduction

Recording

Today we will introduce the course and discuss logistics.

During class we'll take a little poll.

Read chapter 1 and skim chapter 2 for concepts before next class.

08/13 Chapter 1: Overview of Database Systems

Recording Slides

A worksheet for today.

Read chapter 3

08/18 Chapters 2 and 3: Database Design and the Relational Model

Recording Slides Slides Online SQL REPL

A worksheet for chapters 2 and 3.

Read 4.1 to 4.3 for next class.

08/20 Chapters 3 and 4: Relational Model and Algebra

Recording Slides Slides

A worksheet to practice SQL.

Read 5.1-5.4

08/25 No class

Assignment 1 SQL and Relational Algebra released, due 09/08.

08/27 Continuing Chapter 4, then Chapter 5: SQL Queries

Recording

Slides

You should download the notebook for today and play through it yourself.

A worksheet to practice relational algebra.

Read 5.5-5.10.

09/01 Chapter 5: SQL Aggregates and Null

Join on Zoom Slides

Download the notebook for today and play through it yourself.

A worksheet for more SQL practice.

Skim 6, read 6.1.2. Also skim the Python Database API.

09/03 Continued

09/08 Chapter 6: Database Application Development

Assignment 1 Due before midnight

Read chapter 7.

09/10 Chapter 7: Internet Applications

Assignment 2 SQL Queries released.

09/15 Exam Review

09/17 Midterm 1

09/22 Chapter 7: Internet Applications REST

Assignment 3 REST released.

Read chapter 8.

09/24 Chapter 8: Overview of Storage and Indexing

Read chapter 9.

09/29 Chapter 9: Storing Data

Read 10 and 11.1.

10/01 Chapter 10 + 11.1: Indexing

Assignment 4 Storage + SQL released.

Read chapter 12.

10/06 Chapter 12: Query Evaluation

Read 13.

10/08 Chapter 13: External Sorting.

Perhaps the most widely relevant topic in this class!

Read 14.

10/13 Chapter 14: Evaluating Relational Operators

Assignment 5 Database design released.

10/15 Chapter 16: Overview of Transaction Management

10/20 Exam review.

10/22 Midterm 2

10/27 Chapter 17: Concurrency Control

Next

10/29 Chapter 18: Crash Recovery

11/03 Chapter 19: Database Design

11/05 tbd

11/10 tbd

11/12 tbd

11/17 Exam Review