Course Notes - Fall 2026#
Contents:
- Introduction to Relational Databases
- Example Database
- Relational Model and Algebra
- Normalization
- Entity-Relationship (ER) Models
- SQL - Part 1: Basics
- SQL - Part 2: Advanced Features
- SQL - Part 3: Data Definition and Manipulation
- SQL - Procedural Programming
- SQL - Procedural Programming with PL/PGSQL
- SQL - Database Object-Relational Frameworks (ORMs)
- SQL - Other Procedural Paradigms
- SQL - Other Features
- SQL - Object-Relational Extensions
- Secondary Storage and Indexing
- Index Scan
- Size Estimation for Cost-based Query Optimization
- Query Processing - Sorting and Join
- Query Processing
- Query Optimization
- Transaction Management - Concurrency
- Database Tuning