Month 4: Principles of Relational Database Design
Week 1: Basics of Database Design
- Day 1: Introduction to Database Design
- Day 2: Entities and Attributes
- Day 3: Relationships and Cardinality
- Day 4: Normalization
- Day 5: Database Keys
Week 2: Advanced Database Design Concepts
- Day 1: Database Integrity Constraints
- Day 2: Indexes and Performance
- Day 3: Views and Security
- Day 4: Stored Procedures and Triggers
- Day 5: Transaction Management
Week 3: Data Modeling
- Day 1: Introduction to Data Modeling
- Day 2: Conceptual Data Modeling
- Day 3: Logical Data Modeling
- Day 4: Physical Data Modeling
- Day 5: ER Diagrams
Week 4: Database Design Tools and Techniques
- Day 1: Introduction to Database Design Tools
- Day 2: Using SQL Server Management Studio
- Day 3: Using Oracle SQL Developer
- Day 4: Using MySQL Workbench
- Day 5: Other Database Design Tools
dowhatkennydoes.com 