Data Modeling & Warehousing Fundamentals in Data Engineering
Completed by Enock Agoi
May 21, 2026
9 hours (approximately)
Enock Agoi's account is verified. Coursera certifies their successful completion of Data Modeling & Warehousing Fundamentals in Data Engineering
What you will learn
Design star schema data models with fact and dimension tables that enable intuitive self-service business intelligence reporting.
Apply third normal form normalization to optimize database structure while maintaining query performance through indexing strategies.
Use advanced SQL window functions to calculate rolling metrics, rankings, and time-series analytics for complex data analysis.
Implement database replication and incremental loading techniques to ensure high availability and efficient data warehouse updates.
Skills you will gain
- Category: Data Warehousing
- Category: Performance Tuning
- Category: Business Intelligence
- Category: Database Development
- Category: SQL
- Category: Data Integration
- Category: Database Architecture and Administration
- Category: Data Infrastructure
- Category: Data Modeling
- Category: Extract, Transform, Load
- Category: Data Architecture
- Category: Relational Databases
