Comp 521 Fall 2020
Agenda
08/11 Introduction
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/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/25 No class
Assignment 1 SQL and Relational Algebra released, due 09/08.
08/27 Continuing Chapter 4, then Chapter 5: SQL Queries
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
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.