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!) .. Week 13 - Thursday (8/17) --------------------------- - Take the Final Exam at 8:00AM in Walker 5113! Week 13 - Monday (8/14) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) and Chapter 16 (Query Compiler) - `Course Notes: Query Processing `_ - `Course Notes: Query Optimization `_ - Hand written notes from lectures can be found `here `_. - Attend lecture at 8:00AM in Walker 5113! - Solve Lecture 21 Exercise on Submitty after class (deadline in 48 hrs). Week 12 - Thursday (8/10) --------------------------- - 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 Walker 5113! - Solve Lecture 20 Exercise on Submitty after class (deadline in 48 hrs). Week 12 - Monday (8/7) --------------------------- - 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 Walker 5113! - Solve Lecture 19 Exercise on Submitty after class (deadline in 48 hrs). Week 11 - Thursday (8/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 Walker 5113! - Solve Lecture 18 Exercise on Submitty after class (deadline in 48 hrs). Week 11 - Monday (7/31) --------------------------- - 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 Walker 5113! - No Lecture Exercise for Lecture 17 Week 10 - Thursday (7/27) --------------------------- - 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 Walker 5113! - No Lecture Exercise for Lecture 16 Week 10 - Monday (7/24) --------------------------- - 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 Walker 5113! - Solve Lecture 15 Exercise on Submitty after class (deadline in 48 hrs). Week 9 - Thursday (7/20) --------------------------- - 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 Walker 5113! - No Lecture Exercise for Lecture 14. Week 8 - Thursday (7/13) --------------------------- - 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 Walker 5113! - Solve Lecture 13 Exercise on Submitty after class (deadline in 48 hrs). Week 8 - Monday (7/10) ------------------------- - 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 Walker 5113! - Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs). Week 7 - Thursday (7/6) ------------------------ - No classes, Summer Break! Week 7 - Monday (7/3) ---------------------- - No classes, Summer Break! Week 6 - Thursday (6/29) ------------------------ - 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 Walker 5113! - Solve Lecture 11 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Monday (6/26) ------------------------ - 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 Walker 5113! - Solve Lecture 10 Exercise on Submitty after class (deadline in 48 hrs). Week 5 - Thursday (6/22) ------------------------ - 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 Walker 5113! - No Lecture Exercise for Lecture 9. Week 5 - Monday (6/19) ----------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4) - `Course Notes: ER Diagram `_ - Hand written notes from lectures can be found `here `_. - Attend lecture at 8:00AM in Walker 5113! - Solve Lecture 8 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Thursday (6/15) ------------------------ - 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 Walker 5113! - Solve Lecture 7 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Monday (6/12) ------------------------ - Before lecture: - Read: Multivalued dependencies (Chapter 3.6-3.7), 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 Walker 5113! - Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Thursday (6/8) ------------------------ - 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 Walker 5113! - Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Monday (6/5) ------------------------ - 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 Walker 5113! - Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs). Week 2 - Thursday (6/1) ------------------------ - 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 Walker 5113! - Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs). Week 2 - Wednesday (5/31) ------------------------- - Monday, May 29, 2023 is Memorial Day. No Classes. Wednesday, May 31, 2023 classes follow a Monday schedule. - 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 Walker 5113! - Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Thursday (5/25) ------------------------ - 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 Walker 5113! - Complete Lecture 1 Exercise 1 on Submitty after the lecture (test exercise, not counted towards a grade!) .. Week 16 - Monday (4/24) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) and Chapter 16 (Query Compiler) - `Course Notes: Query Processing `_ - `Course Notes: Query Optimization `_ - Hand written notes from lectures can be found `here `_. - Attend lecture at 8:00AM in Academy Auditorium. - Solve Lecture 24 Exercise on Submitty after class (deadline in 48 hrs). Week 15 - Thursday (4/20) --------------------------- - 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 Academy Auditorium. - Solve Lecture 23 Exercise on Submitty after class (deadline in 48 hrs). Week 15 - Monday (4/17) --------------------------- - 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 Academy Auditorium. - Solve Lecture 22 Exercise on Submitty after class (deadline in 48 hrs). Week 14 - Thursday (4/13) ------------------------- - Take Test 2 at 8:00AM in Academy Auditorium! Week 14 - Monday (4/10) ----------------------- - Attend lecture at 8:00AM in Academy Auditorium for a test review session! Week 13 - Thursday (4/6) --------------------------- - 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 Academy Auditorium. - Solve Lecture 20 Exercise on Submitty after class (deadline in 48 hrs). Week 13 - Monday (4/3) --------------------------- - 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 Academy Auditorium. - No Lecture Exercise for Lecture 19 Week 12 - Thursday (3/30) --------------------------- - 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 Academy Auditorium. - No Lecture Exercise for Lecture 18 Week 12 - Monday (3/27) --------------------------- - Before lecture: - `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 Academy Auditorium. - Solve Lecture 17 Exercise on Submitty after class (deadline in 48 hrs). Week 11 - Thursday (3/23) --------------------------- - Before lecture: - Read: Views and Indexes (Chapter 8.1-8.2) - `Course Notes: Other SQL Features `_ - Hand written notes from lectures can be found `here `_. - Attend lecture at 8:00AM in Academy Auditorium. - No Lecture Exercise for Lecture 16. Week 11 - Monday (3/20) --------------------------- - 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 Academy Auditorium. - No Lecture Exercise for Lecture 15. Week 10 - Thursday (3/16) --------------------------- - 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 Academy Auditorium. - Solve Lecture 14 Exercise on Submitty after class (deadline in 48 hrs). Week 10 - Monday (3/13) ----------------------- - 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 Academy Auditorium. - Solve Lecture 13 Exercise on Submitty after class (deadline in 48 hrs). Week 9 - Thursday (3/9) ------------------------ - No classes, Spring Break! Week 9 - Monday (3/6) ---------------------- - No classes, Spring Break! Week 8 - Thursday (3/2) ------------------------- - Take Test 1 at 8:00AM in Academy Auditorium! Week 8 - Monday (2/27) ---------------------- - Attend lecture at 8:00AM in Academy Auditorium for a test review session! Week 7 - Thursday (2/23) ------------------------ - 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 Academy Auditorium. - Solve Lecture 11 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Thursday (2/16) ------------------------ - 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 Academy Auditorium. - Solve Lecture 10 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Monday (2/13) ------------------------ - 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 Academy Auditorium. - No Lecture Exercise for Lecture 9. Week 5 - Thursday (2/9) ----------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4) - `Course Notes: ER Diagram `_ - Hand written notes from lectures can be found `here `_. - Attend lecture at 8:00AM in Academy Auditorium. - Solve Lecture 8 Exercise on Submitty after class (deadline in 48 hrs). Week 5 - Monday (2/6) ----------------------- - 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 Academy Auditorium. - Solve Lecture 7 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Thursday (2/2) ------------------------ - Before lecture: - Read: Multivalued dependencies (Chapter 3.6-3.7), 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 Academy Auditorium. - Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Monday (1/30) ------------------------ - 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 Academy Auditorium. - Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Thursday (1/26) ------------------------ - 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 Academy Auditorium. - Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Monday (1/23) ---------------------- No class due to inclement weather. Week 2 - Thursday (1/19) ------------------------ - 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 Academy Auditorium. - Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Thursday (1/12) ------------------------ - 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 Academy Auditorium. - Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Monday (1/9) ----------------------- - 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 Academy Auditorium! - Complete Lecture 1 Exercise 1 on Submitty after the lecture (test exercise, not counted towards a grade!) .. Week 16 - Monday (4/25) ----------------------- - Attend lecture at 4:00PM in DCC 318 for the final exam review session! Week 15 - Thursday (4/21) --------------------------- - Before lecture: - Read: Chapter 18 (Concurrency Control, 18.1-18.6) and Chapter 17 (Durability) - `Course Notes: Concurrency Control `_ - `Course Notes: Durability `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 27 Exercise on Submitty after class (deadline in 48 hrs). Week 15 - Monday (04/18) --------------------------- - Before lecture: - Read: Chapter 16 (Query Compiler) and Chapter 18 (Concurrency Control, 18.1-18.4) - `Course Notes: Query Optimization `_ - `Course Notes: Concurrency Control `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 26 Exercise on Submitty after class (deadline in 48 hrs). Week 14 - Thursday (4/14) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) and Chapter 16 (Query Compiler) - `Course Notes: Query Processing `_ - `Course Notes: Query Optimization `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 25 Exercise on Submitty after class (deadline in 48 hrs). Week 14 - Monday (4/11) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) - `Course Notes: Query Processing `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 24 Exercise on Submitty after class (deadline in 48 hrs). Week 13 - Thursday (4/7) --------------------------- - Before lecture: - Read: Chapter 14 (Index Structures) - `Course Notes: Secondary Storage `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 23 Exercise on Submitty after class (deadline in 48 hrs). Week 13 - Monday (4/4) ---------------------- - Attend lecture at 4:00PM in DCC 318 for a test review session! Week 12 - Thursday (3/31) --------------------------- - Before lecture: - Read: Chapter 14 (Index Structures) - `Course Notes: Secondary Storage `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - No Lecture Exercise for Lecture 21 Week 12 - Monday (3/28) --------------------------- - Before lecture: - Read: Chapter 14 (Index Structures) - `Course Notes: Secondary Storage `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 20 Exercise on Submitty after class (deadline in 48 hrs). Week 11 - Thursday (3/24) --------------------------- - Before lecture: - Read: Chapter 13 (Secondary Storage Management) - `Course Notes: Secondary Storage `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - No Lecture Exercise for Lecture 19 Week 11 - Monday (3/21) --------------------------- - Before lecture: - `Course Notes: Other SQL Features `_ - `Course Notes: Object-Relational Extensions `_ - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 18 Exercise on Submitty after class (deadline in 48 hrs). Week 10 - Thursday (3/17) --------------------------- - Before lecture: - Read: Views and Indexes (Chapter 8.1-8.2) - `Course Notes: Other SQL Features `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - No Lecture Exercise for Lecture 17. Week 10 - Monday (3/14) --------------------------- - Before lecture: - Read: Constraints and Triggers (Chapter 7) - `Course Notes: Data Definition and Manipulation in SQL `_ - `Course Notes: Procedural SQL `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - No Lecture Exercise for Lecture 16. Week 9 - Thursday (3/10) ------------------------ - No classes, Spring Break! Week 9 - Monday (3/7) ---------------------- - No classes, Spring Break! Week 8 - Thursday (3/3) --------------------------- - Before lecture: - Read: SQL Language (Chapter 6), Constraints and Trigger (Chapter 7) - `Course Notes: Data Definition and Manipulation in SQL `_ - `Course Notes: Procedural SQL `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 15 Exercise on Submitty after class (deadline in 48 hrs). Week 8 - Monday (2/28) ---------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: Advanced SQL `_ - `Course Notes: Data Definition and Manipulation in SQL `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 14 Exercise on Submitty after class (deadline in 48 hrs). Week 7 - Thursday (2/24) ------------------------ - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: Advanced SQL `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 13 Exercise on Submitty after class (deadline in 48 hrs). Week 7 - Tuesday (2/22) ----------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: SQL Basics `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Thursday (2/17) ------------------------ - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: SQL Basics `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - No Lecture Exercise for Lecture 11. Week 6 - Monday (2/14) ---------------------- - Attend lecture at 4:00PM in DCC 318 for a test review session! Week 5 - Thursday (2/10) ------------------------ - Attend lecture at 4:00PM in DCC 318 for a test review session! Week 5 - Monday (2/7) --------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4) - `Course Notes: ER Diagram `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 8 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Thursday (2/3) ----------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4.1-4.5) - `Course Notes: ER Diagram `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 7 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Monday (1/31) ------------------------ - Before lecture: - Read: Multivalued dependencies (Chapter 3.6-3.7), Entity-Relationship Diagrams (Chapter 4.1-4.3) - `Course Notes: ER Diagram `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Thursday (1/27) ------------------------ - Before lecture: - Read: Normal Forms and Decomposition (Chapter 3.4-3.5) - `Course Notes: Normalization `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Monday (1/24) ------------------------ - Before lecture: - Read: Design Theory and Normalization (Chapter 3.1-3.3). - `Course Notes: Normalization `_ - Attend lecture at 4:00PM in DCC 318! - Hand written notes from the lecture can be found `here `_. - Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs). Week 2 - Thursday (1/20) ------------------------ - Reading: Introduction to Relational Algebra and Normalization (Chapter 2) - Before lecture: - Read: Rest of Chapter 2. - `Course Notes: Relational Algebra `_ - Hand written notes from videos can be found `here `_. - Join lecture at 5:00PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Thursday (1/13) ------------------------ - Reading: Introduction to Relational Algebra (Chapter 2) - Before lecture: - Read: The rest of Chapter 2. - `Course Notes: Relational Algebra `_. - Hand written notes from videos can be found `here `_. - Join lecture at 5:00PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Monday (1/10) ----------------------- - Introduction to Databases and Relational Data Model - Before lecture: - Read: Chapter 1, 2.1-2.2. - `Course Notes: Introduction `_. - Hand written notes from videos can be found `here `_. - Course "First Day" presentation reviewed during the live session is in this `PDF `_. - Join lecture at 4:00PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Update your personal info, especially Time Zone on Submitty! - Complete Lecture 1 Exercise 1 on Submitty after the lecture (test exercise, not counted towards a grade!) .. Week 14 - Friday (4/30) --------------------------- - Before lecture: - Read: Chapter 18 (Concurrency Control, 18.1-18.6) and Chapter 17 (Durability) - `Course Notes: Concurrency Control `_ - `Course Notes: Durability `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 27 Week 14 - Tuesday (04/27) --------------------------- - 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 videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 26 Week 13 - Friday (4/23) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) and Chapter 16 (Query Compiler) - `Course Notes: Query Processing `_ - `Course Notes: Query Optimization `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 25 Week 13 - Tuesday (4/20) --------------------------- - Before lecture: - Read: Chapter 15 (Query Execution) - `Course Notes: Query Processing `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 24 Week 12 - Friday (4/16) --------------------------- - Before lecture: - Read: Chapter 14 (Index Structures) - `Course Notes: Secondary Storage `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 23 Week 12 - Tuesday (4/13) --------------------------- - Before lecture: - Read: Chapter 14 (Index Structures) - `Course Notes: Secondary Storage `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 22 Week 11 - Friday (4/9) --------------------------- - Before lecture: - Read: Chapter 13 (Secondary Storage Management) - `Course Notes: Secondary Storage `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - No Lecture Exercise for Lecture 21 Week 11 - Tuesday (4/5) ----------------------- - Wellness Day - no lecture Week 10 - Friday (4/2) ---------------------- - Join test review session at 2:30PM on Webex Meetings! (Recording on Mediasite after the session.) Week 10 - Tuesday (3/30) ------------------------ - Join test review session at 2:30PM on Webex Meetings! (Recording on Mediasite after the session.) Week 9 - Friday (3/26) --------------------------- - Before lecture: - `Course Notes: Other SQL Features `_ - `Course Notes: Object-Relational Extensions `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - No Lecture Exercise for Lecture 18 Week 9 - Tuesday (3/23) --------------------------- - Before lecture: - Read: Views and Indexes (Chapter 8.1-8.2) - `Course Notes: Other SQL Features `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture Exercise for Lecture 17 Week 8 - Friday (3/19) --------------------------- - Before lecture: - Read: Constraints and Trigger (Chapter 7) - `Course Notes: Data Definition and Manipulation in SQL `_ - `Course Notes: Procedural SQL `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - No Lecture Exercise for Lecture 16 Week 8 - Tuesday (3/16) --------------------------- - 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 videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 15 Exercise on Submitty after class (deadline in 48 hrs). Week 7 - Friday (3/12) ------------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: Advanced SQL `_ - `Course Notes: Data Definition and Manipulation in SQL `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 14 Exercise on Submitty after class (deadline in 48 hrs). Week 7 - Tuesday (3/9) ------------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: Advanced SQL `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 13 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Friday (3/5) ------------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: SQL Basics `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 12 Exercise on Submitty after class (deadline in 48 hrs). Week 6 - Tuesday (3/2) ---------------------- - Before lecture: - Read: SQL Language (Chapter 6) - `Course Notes: SQL Basics `_ - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) Week 5 - Friday (2/26) ---------------------- - Join test review session at 2:30PM on Webex Meetings! (Recording on Mediasite after the session.) Week 5 - Tuesday (2/23) ----------------------- - Join test review session at 2:30PM on Webex Meetings! (Recording on Mediasite after the session.) Week 4 - Friday (2/19) ---------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4) - `Course Notes: ER Diagram `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 8 Exercise on Submitty after class (deadline in 48 hrs). Week 4 - Tuesday (2/16) ----------------------- - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4.1-4.5) - `Course Notes: ER Diagram `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - No Lecture Exercise for Lecture 7 Week 3 - Friday (2/12) ------------------------ - Before lecture: - Read: Entity-Relationship Diagrams (Chapter 4.1-4.3) - `Course Notes: ER Diagram `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 6 Exercise on Submitty after class (deadline in 48 hrs). Week 3 - Tuesday (2/9) ------------------------ - Before lecture: - Read: Normalization (Chapter 3) - `Course Notes: Normalization `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 5 Exercise on Submitty after class (deadline in 48 hrs). Week 2 - Friday (2/5) ------------------------ - Before lecture: - Read: Introduction to Relational Algebra and Normalization (Chapter 2 & 3) - `Course Notes: Normalization `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 4 Exercise on Submitty after class (deadline in 48 hrs). Week 2 - Tuesday (2/2) ------------------------ - Reading: Introduction to Relational Algebra and Normalization (Chapter 2) - Before lecture: - Read: Rest of Chapter 2 and start reading Chapter 3 - `Course Notes: Relational Algebra `_ - `Course Notes: Normalization `_ - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 3 Exercise on Submitty after class (deadline in 48 hrs). Week 1 - Friday (1/29) ---------------------- - Reading: Introduction to Relational Algebra (Chapter 2) - Before lecture: - Read: Rest of Chapter 2. - `Course Notes: Relational Algebra `_. - Hand written notes from videos can be found `here `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Solve Lecture 2 Exercise on Submitty after class (deadline in 48 hrs). - Make sure your time zone is set correctly on Submitty! Week 1 - Tuesday (1/26) ----------------------- - Introduction to Databases and Relational Data Model - Before lecture: - Read: Chapter 1, 2.1-2.2. - `Course Notes: Introduction `_. - Hand written notes from videos can be found `here `_. - Course "First Day" presentation reviewed during the live session is in this `PDF `_. - Join lecture at 3:20PM on Webex Meetings! (Recording on Mediasite after the lecture.) - Update your personal info, especially Time Zone on Submitty! - Complete Lecture 1 Exercise 1 on Submitty after the lecture (test exercise, not counted towards a grade!) .. Week 15 - Monday (12/7) --------------------------- - Before lecture: - Read: Chapter 17 (Durability) - `Course Notes: Durability `_ - Watch (Vimeo Links): - `Lecture 25 1: Durability: Logging `_ - `Lecture 25 2: Durability: Force/Steal `_ - `Lecture 25 3: Durability: Recovery: Aries Algorithm `_ - Join lecture at 3:20PM on Webex Teams! (Recording on Mediasite after lecture) - Solve Lecture Exercise for Lecture 25