Course Notes - Fall 2025

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