Tentative Class Schedule - Fall 2024¶
Week 16 - Tuesday (12/10)¶
Before lecture:
- Read: Chapter 16 (Query Compiler) and Chapter 18 (Concurrency Control, 18.1-18.4)
- Course Notes: Query Optimization
- Course Notes: Concurrency Control
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Optional Lecture 22 Exercise on Submitty after class (deadline 11:59:59 pm on 12/10).
Week 15 - Friday (12/06)¶
Before lecture:
- Read: Chapter 15 (Query Execution)
- Course Notes: Query Processing
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 21 Exercise on Submitty after class (deadline in 48 hrs).
Week 15 - Tuesday (12/3)¶
Before lecture:
- Read: Chapter 14 (Index Structures)
- Course Notes: Secondary Storage
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 20 Exercise on Submitty after class (deadline in 48 hrs).
Week 14 - Thursday (11/29) ———————-__–
- No classes, Thanksgiving Break!
Week 14 - Tuesday (11/26)¶
Before lecture:
- Read: Chapter 14 (Index Structures)
- Course Notes: Secondary Storage
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 19 Exercise on Submitty after class (deadline in 48 hrs).
Week 13 - Friday (11/22)¶
- Take Test 2 at 8:00AM in Sage 3303!
Week 13 - Tuesday (11/19)¶
- Attend lecture at 8:00AM in DCC 330 for a test review session (Recording available on Mediasite after lecture)!
Week 12 - Friday (11/15)¶
Before lecture:
- Read: Chapter 14 (Index Structures)
- Course Notes: Secondary Storage
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
No Lecture Exercise for Lecture 18
Week 12 - Tuesday (11/12)¶
Before lecture:
- Read: Chapter 13 (Secondary Storage Management)
- Course Notes: Secondary Storage
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
No Lecture Exercise for Lecture 17
Week 11 - Friday (11/8)¶
Before lecture:
- Read: Views and Indexes (Chapter 8.1-8.2)
- Course Notes: Other SQL Features
- Course Notes: Object-Relational Extensions
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
No Lecture Exercise for Lecture 16.
Week 11 - Tuesday (11/5)¶
Before lecture:
- Read: Views and Indexes (Chapter 8.1-8.2)
- Course Notes: Other SQL Features
- Course Notes: Object-Relational Extensions
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 15 Exercise on Submitty after class (deadline in 48 hrs).
Week 10 - Friday (11/1)¶
Before lecture:
- Read: Constraints and Triggers (Chapter 7)
- Course Notes: Data Definition and Manipulation in SQL
- Course Notes: Procedural SQL
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
No Lecture Exercise for Lecture 14.
Week 9 - Friday (10/25)¶
Before lecture:
- Read: SQL Language (Chapter 6), Constraints and Trigger (Chapter 7)
- Course Notes: Data Definition and Manipulation in SQL
- Course Notes: Procedural SQL
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 13 Exercise on Submitty after class (deadline in 48 hrs).
Week 9 - Tuesday (10/22)¶
Before lecture:
- Read: SQL Language (Chapter 6)
- Course Notes: Advanced SQL
- Course Notes: Data Definition and Manipulation in SQL
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs).
Week 8 - Friday (10/18)¶
- Take Test 1 at 8:00AM in Sage 3303!
Week 8 - Tuesday (10/15)¶
- Attend lecture at 8:00AM in DCC 330 for a test review session (Recording available on Mediasite after lecture)!
Week 7 - Friday (10/11)¶
- Attend lecture at 8:00AM in DCC 330 for a test review session (Recording available on Mediasite after lecture)!
Week 7 - Tuesday (10/8)¶
Before lecture:
- Read: SQL Language (Chapter 6)
- Course Notes: Advanced SQL
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 11 Exercise on Submitty after class (deadline in 48 hrs).
Week 6 - Friday (10/4)¶
Before lecture:
- Read: SQL Language (Chapter 6)
- Course Notes: SQL Basics
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 10 Exercise on Submitty after class (deadline in 48 hrs).
Week 6 - Tuesday (10/1)¶
Before lecture:
- Read: SQL Language (Chapter 6)
- Course Notes: SQL Basics
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 9 Exercise on Submitty after class (deadline in 48 hrs).
Week 5 - Friday (9/27)¶
- Before lecture:
- Read: Entity-Relationship Diagrams (Chapter 4.1-4.5)
- Course Notes: ER Diagram
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 8 Exercise on Submitty after class (deadline in 48 hrs).
Week 5 - Tuesday (9/24)¶
- Before lecture:
- Read: Entity-Relationship Diagrams (Chapter 4.1-4.3)
- Course Notes: ER Diagram
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 7 Exercise on Submitty after class (deadline in 48 hrs).
Week 4 - Friday (9/20)¶
- Before lecture:
- Read: Multivalued dependencies and the Fourth Normal Form (Chapter 3.6-3.7)
- Course Notes: Normalization
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs).
Week 4 - Tuesday (9/17)¶
- Before lecture:
- Read: Normal Forms and Decomposition (Chapter 3.4-3.5)
- Course Notes: Normalization
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs).
Week 3 - Friday (9/13)¶
- Before lecture:
- Read: Design Theory and Normalization (Chapter 3.1-3.3).
- Course Notes: Normalization
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs).
Week 3 - Tuesday (9/10)¶
- Reading: Introduction to Relational Algebra and Normalization (Chapter 2)
- Before lecture:
- Read: Rest of Chapter 2.
- Course Notes: Relational Algebra
- Hand written notes from lectures can be found here.
- Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
- Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs).
Week 2 - Tuesday (9/3)¶
Reading: Introduction to Relational Algebra (Chapter 2)
- Before lecture:
- Read: The rest of Chapter 2.
- Course Notes: Relational Algebra.
Hand written notes from lectures can be found here.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs).
Week 1 - Friday (8/30)¶
Introduction to Databases and Relational Data Model
Before lecture:
- Read: Chapter 1, 2.1-2.2.
- Course Notes: Introduction.
Hand written notes from lectures can be found here.
Course “First Day” presentation is in this PDF.
Attend lecture at 8:00AM in DCC 330 (Recording available on Mediasite after lecture)!
Complete Lecture 1 Exercise 1 on Submitty after the lecture (test exercise, not counted towards the grade!)