Class Schedule - Fall 2022#
Week 15 - Thursday (12/7)#
Before lecture:
Read: Database Tuning
Week 14 - Thursday (12/2)#
Before lecture:
Read: Chapter 18 (Concurrency Control, 18.1-18.6)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 24
Week 14 - Monday (11/28)#
Before lecture:
Read: Chapter 16 (Query Compiler)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 23
Week 13 - Monday (11/21)#
Before lecture:
Read: Chapter 15 (Query Execution) and Chapter 16 (Query Compiler)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 22
Week 12 - Thursday (11/17)#
Before lecture:
Read: Chapter 15 (Query Execution)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 21
Week 12 - Monday (11/14)#
Before lecture:
Read: Chapter 14 (Index Structures)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 20
Week 12- Thursday (11/10)#
Before lecture:
Read: Chapter 14 (Index Structures)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 19
Week 11 - Monday (11/8)#
Before lecture:
Read: Chapter 13 (Secondary Storage Management)
Week 10 - Monday (10/31)#
Before lecture:
No new lecture exercise, solve Lecture 16 exercise from last thursday.
Week 9 - Thursday (10/27)#
Before lecture:
Read: Views and Indexes (Chapter 8.1-8.2)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 16
Week 9 - Monday (10/24)#
Before lecture:
Read: Constraints and Trigger (Chapter 7)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 15 (deadline 48 hours)
Week 8 - Thursday (10/20)#
Before lecture:
Read: SQL Language (Chapter 6), Constraints and Trigger (Chapter 7)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 14 (deadline 48 hours)
Week 8 - Monday (10/17)#
Before lecture:
Read: SQL Language (Chapter 6)
Watch (Vimeo Links):
Solve Lecture Exercise for Lecture 13 (deadline 48 hours)
Week 7 - Thursday (10/14)#
Before lecture:
Read: SQL Language (Chapter 6)
Watch (Vimeo Links):
Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs).
Week 7 - Thursday (10/13)#
Before lecture:
Read: SQL Language (Chapter 6)
Watch (Vimeo Links):
Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs).
Week 5 - Thursday (10/6)#
This class will be completely online, on your own time due to the inauguration of RPI’s new president!
Before lecture:
Read: SQL Language (Chapter 6)
Watch either the Vimeo videos below:
Alternatively, you can watch the class recording from a past year class on this topic (or watch both):
Solve Lecture 11 Exercise on Submitty (deadline in 96 hrs after thursday 4pm).
Week 5 - Monday (10/3)#
Before lecture:
Read: SQL Language (Chapter 6)
Watch Vimeo videos below (or in lecture videos posted on Mediasite)
Week 4 - Thursday (9/22)#
Before lecture:
Read: Entity-Relationaship Diagrams (Chapter 4)
Watch (Vimeo Links):
Solve Lecture 7 Exercise on Submitty after class (deadline in 48 hrs).
Week 4 - Monday (9/19)#
Before lecture:
Read: Entity-Relationaship Diagrams (Chapter 4.1-4.5)
Watch (Vimeo Links):
Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs).
Week 3 - Thursday (9/15)#
Before lecture:
Read: Normalization (Chapter 3)
Watch (Vimeo Links):
Lecture 5:3: Normalization (3NF Decomposition) Errata: in the example in this video, one of the keys is missing for R, BCD should also be a key!
Lecture 5:Bonus: Normalization (BCNF Decomposition, Second example)
Join lecture at 2PM.
Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs).
Week 3 - Monday (9/12)#
Before lecture:
Read: Normalization (Chapter 3)
Watch (Vimeo Links):
Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs).
Week 2 - Thursday (9/8)#
Before lecture:
Read: Normalization (Chapter 3)
Watch (Vimeo Links):
Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs).
Week 2 - Tuesday (9/6)#
Reading: Introduction to Relational Algebra and Normalization (Chapter 2)
Before lecture:
Read: Rest of Chapter 2 and Start reading Chapter 3
Watch (Vimeo Links - optional):
Lecture 3.1: Relational Algebra (Join)
(Errata: Note a mistake at 10 minute mark: hid=hid1 should be hid<>hid1, like in the first solution to the same query.
This is why, due to inequality, we cannot use natural join for this query easily.)
Lecture 3.2: Normalization (Functional dependencies, inference, keys), infomercial style!
Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs).
Week 1 - Thursday (9/1)#
Reading: Introduction to Relational Algebra (Chapter 2)
Before lecture:
Read: Rest of Chapter 2 from textbook
Watch (Vimeo Links - optional):
Join lecture in class at 2pm
Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs).
Week 1 - Monday (8/30)#
Introduction to Databases and Relational Data Model
Before lecture:
Read: Chapter 1, 2.1-2.2
(Optional) Watch videos:
Attend lecture at 2PM