When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Data Modeling & Warehousing Fundamentals in Data Engineering

Économisez sur les compétences qui vous font briller avec 40 % de réduction sur 3 mois de Coursera Plus. Économisez maintenant

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues.

Data Modeling & Warehousing Fundamentals in Data Engineering

Ce cours fait partie de Certificat Professionnel Open source Data Engineering with Spark, dbt & Airflow

Instructeur : Professionals from the Industry

Inclus avec

11 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

9 heures à compléter

Planning flexible

Apprenez à votre propre rythme

11 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

niveau Débutant

Expérience recommandée

9 heures à compléter

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

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.

Compétences que vous acquerrez

Catégorie : Star Schema
Catégorie : Data Integration
Catégorie : Database Architecture and Administration
Catégorie : Database Design
Catégorie : Extract, Transform, Load
Catégorie : Database Theory
Catégorie : Business Intelligence
Catégorie : Data Warehousing
Catégorie : Database Development
Catégorie : Data Infrastructure
Catégorie : SQL
Catégorie : Data Modeling
Catégorie : Database Management
Catégorie : Performance Tuning

Outils que vous découvrirez

Catégorie : Relational Databases
Catégorie : PostgreSQL
Catégorie : Database Software

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

mars 2026

Évaluations

20 affectations¹

Noté par l'IA voir l'avis de non-responsabilité

Enseigné en Anglais

91% of learners achieved a positive career outcome

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise en Data Analysis

Ce cours fait partie de la Certificat Professionnel Open source Data Engineering with Spark, dbt & Airflow

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à ce Certificat Professionnel.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable auprès de Coursera

Il y a 11 modules dans ce cours

You'll learn the essential skills needed to design, build, and maintain robust data warehouses that power business intelligence and analytics. Through hands-on practice, you'll learn to create star schema data models that enable self-service reporting, apply database normalization techniques while preserving query performance, and use advanced SQL window functions for complex analytical calculations.

You'll also gain expertise in configuring database replication for high availability and implementing incremental loading strategies to efficiently update large datasets. This comprehensive course integrates fundamental data engineering concepts with practical implementation skills, preparing you to build scalable data infrastructure that supports enterprise analytics. By combining data modeling theory with real-world database administration techniques, you'll develop the versatile skill set that data engineering professionals need to create reliable, performant data systems that drive business insights and decision-making across organizations.

Détails du module

You will explore the foundational concepts of dimensional modeling and understand how star schema design enables self-service business intelligence reporting.

Inclus

2 vidéos2 lectures1 devoir1 laboratoire non noté

2 vidéosTotal 9 minutes

Identifying Business Processes and Defining Model Grain6 minutes
Creating Star Schema Relationships and Surrogate Keys3 minutes

2 lecturesTotal 18 minutes

Dimensional Modeling Principles and Star Schema Components10 minutes
Fact and Dimension Table Design Patterns 8 minutes

1 devoirTotal 3 minutes

Star Schema Design Knowledge Check 3 minutes

1 laboratoire non notéTotal 18 minutes

Star Schema Design for Self-Service Analytics18 minutes

You will apply dimensional modeling concepts to implement complete star schemas and validate their designs for business intelligence effectiveness.

Inclus

1 vidéo1 lecture3 devoirs

You will establish a solid foundation in database normalization principles, understand Third Normal Form requirements, and begin applying these concepts to real-world database scenarios.

Inclus

1 vidéo1 lecture2 devoirs

You will implement normalization techniques while applying strategic performance optimization methods, including indexing, query optimization, and selective denormalization for real-world database scenarios.

Inclus

3 vidéos1 lecture2 devoirs

3 vidéosTotal 23 minutes

Why Performance Matters in Normalized Databases6 minutes
Index Types and Performance Impact in Database Systems12 minutes
Implementing Performance-Optimized Database Normalization6 minutes

1 lectureTotal 10 minutes

Strategic Indexing and Query Optimization for Normalized Databases10 minutes

2 devoirsTotal 16 minutes

Database Normalization Mastery Assessment13 minutes
Performance Optimization Knowledge Check3 minutes

You will establish foundational understanding of SQL window functions, master the OVER() clause syntax, and implement basic window function queries for analytical calculations.

Inclus

3 vidéos1 lecture1 devoir

You will master advanced window function applications including rolling calculations, ranking functions, and comprehensive analytical implementations that mirror production data engineering workflows.

Inclus

2 vidéos1 lecture3 devoirs

2 vidéosTotal 10 minutes

Real-World Impact of Advanced Window Functions3 minutes
Rolling Calculations and Frame Specifications7 minutes

1 lectureTotal 10 minutes

Ranking Functions and Practical Applications10 minutes

3 devoirsTotal 38 minutes

SQL Window Functions Mastery Assessment15 minutes
Advanced Analytics with Window Functions15 minutes
Advanced Window Functions Assessment8 minutes

You will understand the critical importance of database replication for high availability, explore fundamental concepts of streaming replication and physical replication slots, and gain foundational knowledge needed for implementing fault-tolerant database architectures.

Inclus

3 vidéos1 lecture1 devoir

3 vidéosTotal 17 minutes

Why Database Replication Saves Your Business From Disaster5 minutes
Understanding Streaming Replication and Physical Replication Slots 8 minutes
Configuring Physical Replication Slots Step-by-Step4 minutes

1 lectureTotal 10 minutes

PostgreSQL Replication Components and Architecture Deep Dive10 minutes

1 devoirTotal 5 minutes

Database Replication Fundamentals Knowledge Check5 minutes

You will implement complete streaming replica configuration, validate replication health through monitoring, and demonstrate mastery by configuring a production-ready high availability setup with sub-5-second lag performance.

Inclus

1 vidéo1 lecture2 devoirs

You will understand the fundamental concepts of incremental loading and prepare for hands-on implementation.

Inclus

3 vidéos2 lectures2 devoirs

3 vidéosTotal 19 minutes

Why Incremental Loading Transforms Data Engineering4 minutes
Core Concepts of Incremental Loading7 minutes
Business Key Selection and Matching Logic8 minutes

2 lecturesTotal 21 minutes

Staging Table Architecture and Patterns8 minutes
Podcast: MERGE Statement Mastery for Incremental Loading13 minutes

2 devoirsTotal 23 minutes

Incremental Loading Foundation Analysis18 minutes
Incremental Loading Foundation Knowledge Check5 minutes

You will implement complete incremental loading workflows using hands-on practice and demonstrate mastery.

Inclus

2 vidéos2 lectures2 devoirs

2 vidéosTotal 15 minutes

Production Patterns and Advanced MERGE Techniques8 minutes
Complete Incremental Loading Implementation Walkthrough7 minutes

2 lecturesTotal 8 minutes

Professional Implementation Context and Enterprise Patterns3 minutes
Enterprise Workflow Integration and Best Practices5 minutes

2 devoirsTotal 17 minutes

Incremental Loading Mastery Assessment15 minutes
MERGE Implementation Knowledge Check2 minutes

You will design and implement a complete data warehouse solution that integrates dimensional modeling, database optimization, advanced SQL analytics, high availability infrastructure, and efficient data loading processes to support enterprise business intelligence reporting.

Inclus

4 lectures1 devoir

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.