# Lecture Notes - Fall 2025

- Final Review notes {doc}`./lecture_notes/final_review`
- [Final Review notes -2](./lecture_notes/final_review_2.pdf)

- Lecture 26 (Two Phase Locking and Tuning)  {doc}`./lecture_notes/lecture26`
- Lecture 25 (Query Optimization and Serializability in Transactions)  {doc}`./lecture_notes/lecture25`
- Lecture 24 (External Sort, Query Processing and Pipelining)  {doc}`./lecture_notes/lecture24`
- Lecture 23 (Size Estimation, Index Selectivity and Block-nested-loop join)  {doc}`./lecture_notes/lecture23`
- Lecture 22 (Index Scan with B-trees)  {doc}`./lecture_notes/Lecture22`
- Lecture 21 (B-trees)  {doc}`./lecture_notes/lecture21`
- Lecture 20 (Storage Management Introduction)  {doc}`./lecture_notes/lecture20`
- [Lecture 19](./lecture_notes/lecture19.txt)
- Lecture 18 (SQL - Views and Advanced Features)  {doc}`./lecture_notes/lecture18`
- [Lecture 17](./lecture_notes/lecture17_part2.txt)
- Lecture 17 (SQL - Access Control and Triggers)  {doc}`./lecture_notes/lecture17`
- [Lecture 16](./lecture_notes/lecture16.txt)
-  Lecture 15 (SQL - Transactions, Constraints and Procedural SQL)  {doc}`./lecture_notes/lecture15`
-  Lecture 14 (SQL - Anonymous queries, insert/update/delete)  {doc}`./lecture_notes/lecture14`
-  Lecture 13 (SQL - Outer joins, subqueries)  {doc}`./lecture_notes/lecture13`
- Lecture 12 (SQL - group by/having, outer joins)  {doc}`./lecture_notes/lecture12`
-  Lecture 11 (SQL - basic structure)  {doc}`./lecture_notes/lecture11`
-  Lecture 10 (ER Hierarchies and Introduction to SQL)  {doc}`./lecture_notes/lecture10`
-  Lecture 9 (ER Diagrams)  {doc}`./lecture_notes/lecture9`
-  Lecture 8 (ER Diagrams)  {doc}`./lecture_notes/lecture8`
-  Lecture 7 (Normalization: Decomposition properties/3NF and BCNF decompositions)  {doc}`./lecture_notes/lecture7`
-  Lecture 6 (Normalization: BCNF/3NF/Minimal Basis)  {doc}`./lecture_notes/lecture6`
-  Lecture 5 (Normalization)  {doc}`./lecture_notes/lecture5`
-  Lecture 4 (Relational Algebra)  {doc}`./lecture_notes/lecture4`
-  Lecture 4 (Normalization)  {doc}`./lecture_notes/lecture4_2`
- [Lecture 3 Example Database](./lecture_notes/lecture3_Example_Database.pdf)
- [Lecture 3](./lecture_notes/lecture3.pdf)
- [Lecture 2](./lecture_notes/lecture2.txt)
- [Lecture 1](./lecture_notes/lecture1.txt)