Course Notes - Fall 2020

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 - Embedded SQL Programming
• SQL - Object-Relational Frameworks
• SQL - Other Features
• SQL - Object-Relational Extensions
• Secondary Storage and Indexing
• Query Processing
• Query Optimization
• Transaction Management - Concurrency
• Transaction Management - Durability
• Database Tuning