Class Notes and Reading Guide
(Note: please visit this page frequently as it will be updated constantly during the term)

Lectures Zoom Details

Dates
Topic
Reading
Slides/Handouts
11 Jan 2022
Class Logistics & Introduction to Database Systems Chapter 1 from the textbook Set #1
4 slides per page
13 Jan 2022
Design of Query Languages Chapter 2.0-2.3, 6.0-6.5, 8.1-8.2.2, 8.5 & 10.1 from the textbook Set #1
4 slides per page
14 Jan 2022
(Optional)
Tutorial: PostgreSQL & DataGrip Setup and Introduction [1pm-1:50pm]: Zoom Link (pass: DBrec22)
[2pm-2:50pm]: Zoom Link (pass: DBrec22)
PostgreSQL & DataGrip Setup
Interfaces Quick Guide
18 Jan 2022
Design of Query Languages Chapter 2.0-2.3, 6.0-6.5, 8.1-8.2.2, 8.5 & 10.1 from the textbook Set #2
4 slides per page
20 Jan 2022
SQL Transactions & Specifying C of ACID (Integrity Constraints) Chapter 7 from the textbook Set #1
4 slides per page
Theory of Recovery Chapters 1.1-1.2, 2.1 & 2.4 from BHG book from extra material Set #1
4 slides per page
24 Jan 2022
Theory of Recovery Chapters 1.1-1.2, 2.1 & 2.4 from BHG book from extra material Set #2
4 slides per page
Theory of Serializability Chapters 1.3, 2.1-2.3 & 2.5-2.6 from BHG book from extra material Set #1
4 slides per page
27 Jan 2022
Theory of Serializability Chapters 1.3, 2.1-2.3 & 2.5-2.6from BHG book from extra material Set #2
4 slides per page
27 Jan 2022
Theory of Serializability Chapters 1.3-1.4, 2.1-2.3 & 2.5-2.6 from BHG book from extra material Set #3
4 slides per page
3 Feb 2022
Data Storage Chapter 13 from textbook Set #1
4 slides per page
8 Feb 2022
Data Storage Chapter 13 from textbook Set #2
4 slides per page
10 Feb 2022
Data Storage Chapter 13 from textbook & UC Caching from extra material Set #3
4 slides per page
15 Feb 2022
Data Storage Chapter 13 from textbook & SSDs, QMD, and TraQIOS from extra material Set #4
4 slides per page
17 Feb 2022
File Organization Chapter 13 from textbook Set #1
4 slides per page
22 Feb 2022
File Organization Chapter 13 from textbook Set #2
4 slides per page
Access Methods & Index Structures Chapter 14 from textbook Set #1
4 slides per page
24 Feb 2022
Access Methods & Index Structures Chapter 14 from textbook Set #2
4 slides per page
2 Mar 2022
Access Methods & Index Structures Chapter 14 from textbook Set #3
4 slides per page
2 Mar 2022
Query Processing (Relational Algebra review) Chapter 5.1-5.2 from textbook Set #1
4 slides per page
17 Mar 2022
Query Processing Chapters 15 & 16 from textbook Set #2
4 slides per page
22 Mar 2022
Query Processing Chapters 15 & 16 from textbook Set #3
4 slides per page
24 Mar 2022
Query Processing Chapters 15 & 16 from textbook Set #4
4 slides per page
29 Mar 2022
Recovery Tecnhiques Chapter 17 & 19.1 from textbook Set #1
4 slides per page
31 Mar 2022
Recovery Techniques Chapter 17 & 19.1 from textbook Set #2
4 slides per page
5 Apr 2022
Locking Techniques Chapter 18 & 19.2 from textbook Set #1
4 slides per page
7 Apr 2022
Locking Techniques Chapters 18 & 19.2 from textbook Set #2
4 slides per page
12 Apr 2022
Timestamp Ordering Techniques Chapter 18 & 19.2 from textbook Set #1
4 slides per page
14 Apr 2022
Optimistic CC Techniques Chapter 18 & 19.2 from textbook Set #1
4 slides per page
Multi-Version CC Techniques Chapter 18 & 19.2 from textbook Set #1
4 slides per page
19 Apr 2022
Distributed DBMSs Chapter 20.2-20.6 from textbook Set #1
4 slides per page
21 Apr 2022
Distributed DBMSs Chapter 20.2-20.6 from textbook Set #2, Set #3
4 slides per page