Module 0 – About the Course (2 min)

Module 1 – Introduction to Database Engineering (25 min)

• What is Data Engineering?
• Data Engineer Types

Module 2 – Database Engineering Lifecycle (78 min)

• Data Modeling as Related to Database Engineering
• Tools
• System Requirements
• Technical Requirements & Physical Modeling
• Physical Implementation
• Security Implementation and Management
• Managing Growth
• Performance Monitoring and Tuning

Module 3 – Components of Database Engineering (52 min)

• Relational Database Models
• Multi-Dimensional Database Models
• NoSQL Data Models
• Object Models
• Graph Models
• Relational Database
• Key-Value Database
• Wide Column Database
• Document Store
• Graph Database
• Object Store

Module 4 – Data Engineering Projects (40 min)

• What are the components of a Data Engineering Project
• What roles are needed for Data Engineering Projects
• Database Engineering Project Examples

Module 5 – Database Design Process (73 min)

• Business Requirements
• Technical Requirements
• Performance & Scalability Requirements
• Security & Compliance Requirements
• Read & Write Patterns & Frequency
• Technical Specifications
• Cost Estimation & ROI Analysis
• Physical Database Design
• Platform Selection

Module 6 – Database Implementation (22 min)

• On-Premises Implementation
• Off-Premises Implementation

Module 7 – Case Study Data Mart Project (32 min)

Module 8 – Conclusions & Next Steps (11 min)

• Conclusions
• Opportunities
• Next Steps