Course Brief:
This comprehensive course provides foundational knowledge in database design principles, entity relationships, normalization, and database modeling. Students will learn essential database design skills including entity relationship modeling, normalization techniques, database project creation, and presentation skills. The course is designed for individuals seeking to develop their database design capabilities and prepare for data management roles.
Course Structure:
1. Introduction
2. Entities and Attributes
3. Relationship Basics
4. Super/Sub Types and Business Rules
5. Relationship Fundamentals
6. UIDs and Normalization
7. Arcs, Hierarchies, and Recursive Modeling
8. Changes and Historical Modeling
9. Mapping
10. Creating Database Projects
11. Presenting Database Projects