Links to the instructor's lecture notes are posted here as we cover them in class.
- Course Introduction and Fundamental Concepts
- The Relational Model; Relational Algebra
Simple Library Database: Schema Diagram and Relations, Example Queries - SQL
Simple Library Database: Database Creation SQL, With Constraints - The Entity Relationship Model
- Databae Design Principles
Library Database Canonical Cover - Database Normalization
- Database Application Development
- File Structures and Indexes
- Query Processing Strategies and Optimization
- Transactions and Crash Recovery
- Concurrency
- Database Architectures
- NoSQL Databases
- Data Analysis and Data Science
- Course Review