The following schedule of class lectures is subject to change. I will let you know about any changes as far in advance as possible. You are responsible for reading the appropriate chapter in the course textbook before each class. The reading assignment is indicated in the column labeled Lecture#. For example, for the lectures on Principles of Database Systems (Classes 1-3) you should read Chapters 1 and 2 of the text. The lectures are ordered in such a way as to expose you to material you will need for the programming project (e.g. relational model, SQL) as early in the course as possible.
Classes will be taught online using zoom during normal class time and recorded for viewing offline. The zoom links will be posted on the course homepage.
Class# Date Lecture# Topic
------ ---- -------- -----
1 8/24 1 Principles of Database Systems
2 8/26 1 cont.
3 8/31 2 Relational Databases & Transaction Processing
4 9/2 2 cont.
9/7 Labor Day (no class)
5 9/9 3 The Relational Model & SQL DDL
6 9/14 3 cont.
7 9/16 3 cont.
8 9/21 4 Conceptual Design Using the ER Model
9 9/23 4 cont.
10 9/28 4 cont.
11 9/30 5 Relational Algebra & SQL DML
12 10/5 5 cont.
13 10/7 5 cont.
10/12 Fall Break
14 10/14 Midterm Exam
15 10/19 6 Schema Refinement and Normalization
16 10/21 6 cont.
17 10/26 6 cont.
18 10/28 6 cont.
19 11/2 8 Using SQL in an Application
20 11/4 8 cont.
21 11/9 9 File Organization and Indexing
22 11/11 9 cont.
23 11/16 10 Query Optimization: The Basics
24 11/18 10 cont.
25 11/23 11 Query Optimization
11/25 Thanksgiving Break
26 11/30 7 Triggers
27 12/2 NoSQL
28 12/7 Review for Final
12/14 Final Exam (5:30--8:00pm)