Lecture Notes - Fall 2025#
Lecture 23 (Size Estimation, Index Selectivity and Block-nested-loop join) Announcements
Lecture 22 (Index Scan with B-trees) Lecture 22
Lecture 21 (B-trees) Lecture 21 - B-tree indices
Lecture 20 (Storage Management Introduction) Lecture 20 - Secondary Storage Management
Lecture 18 (SQL - Views and Advanced Features) Lecture 18
Lecture 17 (SQL - Access Control and Triggers) Lecture 17
Lecture 15 (SQL - Transactions, Constraints and Procedural SQL) Lecture 15 - Procedural SQL
Lecture 14 (SQL - Anonymous queries, insert/update/delete) Lecture 13ish - Anonymous Queries and DDL
Lecture 13 (SQL - Outer joins, subqueries) Lecture 13 - Advanced SQL
Lecture 12 (SQL - group by/having, outer joins) Lecture 12 - SQL and moreSQL
Lecture 11 (SQL - basic structure) Lecture 11 - SQL Basics
Lecture 10 (ER Hierarchies and Introduction to SQL) Lecture 10: ER wrap up and SQL
Lecture 9 (ER Diagrams) Announcements
Lecture 8 (ER Diagrams) Announcements
Lecture 7 (Normalization: Decomposition properties/3NF and BCNF decompositions) Announcements
Lecture 6 (Normalization: BCNF/3NF/Minimal Basis) Announcements
Lecture 5 (Normalization) Lecture 5 Announcements
Lecture 4 (Relational Algebra) Announcements
Lecture 4 (Normalization) Normalization