This course introduces modern database systems, covering database architecture, entity-relationship and relational database models, SQL, data normalization, and relational algebra. The course aims to teach students the fundamentals of database systems, including designing and querying databases. The teaching method includes lectures, readings, and practical exercises. This course is intended for students or professionals interested in gaining a foundational understanding of modern database systems.
Overview
Syllabus
- Course Introduction
- Unit 1: Introduction to Modern Database Systems
- Unit 2: Database Architecture and Date Languages
- Unit 3: The History of Databases
- Unit 4: The Entity-Relationship Model
- Unit 5: The Relational Database Model
- Unit 6: Relational Algebra
- Unit 7: Introduction to Data Normalization
- Unit 8: Introduction to SQL
- Unit 9: Basic Select Statements
- Unit 10: The Join Statement
- Study Guide
- Course Feedback Survey
- Certificate Final Exam