Data Modeling Scheme

É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 Scheme

Instructeur : Steve Hoberman

Inclus avec

13 modules

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

niveau Débutant

Expérience recommandée

1 semaine à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

13 modules

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

niveau Débutant

Expérience recommandée

1 semaine à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Compétences que vous acquerrez

Catégorie : Business Analytics
Catégorie : Business Analysis
Catégorie : Data Architecture
Catégorie : Database Design
Catégorie : Database Development
Catégorie : Database Administration
Catégorie : Graph Theory
Catégorie : Data Modeling
Catégorie : Database Architecture and Administration
Catégorie : Document Management
Catégorie : Data Governance
Catégorie : Data Strategy
Catégorie : Databases
Catégorie : Database Management
Catégorie : Data Engineering
Catégorie : Database Theory

Outils que vous découvrirez

Catégorie : Relational Databases
Catégorie : Database Systems
Catégorie : Database Software
Catégorie : Database Management Systems

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Récemment mis à jour !

mai 2026

Évaluations

13 devoirs

Enseigné en Anglais

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

Il y a 13 modules dans ce cours

Explain the strengths of each and the differences among the 12 types of data models. Create business terms, logical, and physical data models across relational, dimensional, document, and graph approaches. Apply practical techniques such as normalization, dimensional grain and meter design, JSON nested arrays, graph patterns (RDF and Property), denormalization, indexing, views, and partitioning.

This course gives learners a complete journey through the Align (common business vocabulary), Refine (business requirements), and Design (technical solution) approach. Much more than a lecture, you will see lots of examples, compare modeling approaches, and build models step by step. By the end of the course, you will be better prepared to choose the right type of model for the right need and communicate your decisions with confidence. What makes this course unique is its breadth and practicality. Most courses stay in one modeling world. This one brings together relational, dimensional, document, and graph in one clear framework. It also connects business vocabulary, business requirements, and technical design through the powerful Align/Refine/Design approach, so learners can see how modeling works from start to finish. This is a course for people who want to become more competent and versatile data modelers.

Become adept at identifying the characteristics used to distinguish each of the 12 different types of data models. There are three levels of detail (align, refine, and design) and four main modeling mindsets (relational, dimensional, document, and graph), leading to 12 different types of models we can create. Align is where we create the business terms model (conceptual data model) to establish a common business vocabulary. Refine is where we create the logical data model to precisely capture the business requirements. Design is where we create the physical data model to document a technology-optimized version of the business requirements. Relational helps us capture business rules, primarily for operational applications (OLTP) and large integration hubs such as data warehouses. Dimensional helps us capture business questions, primarily for analytical applications (OLAP). Document helps us capture nested structures, used for storing and retrieving highly related content (like documents). Graph helps us capture patterns in the data, used for understanding and predicting connections. We'll cover the 12 types at a high level and provide an example of each.

Inclus

4 vidéos1 devoir

Learn all about the relational BTM and build one too! Explore several examples of the relational BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a relational BTM. Finally, design a relational BTM.

Inclus

12 vidéos1 lecture1 devoir

12 vidéosTotal 46 minutes

Why a Business Terms Model and not a Conceptual Data Model?1 minute
About the Relational BTM2 minutes
Relational BTM Example 1 - University6 minutes
Relational BTM Example 2 - ERP Solution (Vendor Product)4 minutes
Overview on How to Build a BTM3 minutes
Step 1 of 5 on Building a Relational BTM: Ask the Six Strategic Questions5 minutes
Step 2 of 5 on Building a Relational BTM: Identify and Define the Terms3 minutes
Step 3 of 5 on Building a Relational BTM: Capture the Relationships3 minutes
Step 4 of 5 on Building a Relational BTM: Determine the Most Useful Form4 minutes
Step 5 of 5 on Building a Relational BTM: Review and Confirm0 minutes
A Data Modeling Joke0 minutes
Technics Publications Exercise15 minutes

1 lectureTotal 10 minutes

About the Relational BTM10 minutes

1 devoirTotal 15 minutes

Relational BTM15 minutes

Learn all about the dimensional BTM and build one too! Explore several examples of the dimensional BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional BTM. Finally, design a dimensional BTM.

Inclus

10 vidéos1 lecture1 devoir

10 vidéosTotal 34 minutes

About the Dimensional BTM2 minutes
Dimensional BTM Example2 minutes
Overview on How to Build a BTM3 minutes
Step 1 of 5 on Building a Dimensional BTM: Ask the Six Strategic Questions6 minutes
Step 2 of 5 on Building a Dimensional BTM: Identify and Define the Terms1 minute
Step 3 of 5 on Building a Dimensional BTM: Capture the Relationships7 minutes
Step 4 of 5 on Building a Dimensional BTM: Determine the Most Useful Form1 minute
Step 5 of 5 on Building a Dimensional BTM: Review and Confirm0 minutes
A Data Modeling Joke0 minutes
Cozy Cactus Bed & Breakfast Exercise12 minutes

1 lectureTotal 10 minutes

About the Dimensional BTM10 minutes

1 devoirTotal 15 minutes

Dimensional BTM15 minutes

Learn all about the document BTM and build one too! Explore several examples of the document BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document BTM. Finally, design a document BTM.

Inclus

9 vidéos1 lecture1 devoir

9 vidéosTotal 28 minutes

About the Document BTM2 minutes
Document BTM Example1 minute
Overview on How to Build a BTM3 minutes
Step 1 of 5 on Building a Document BTM: Ask the Six Strategic Questions5 minutes
Step 2 of 5 on Building a Document BTM: Identify and Define the Terms1 minute
Step 3 of 5 on Building a Document BTM: Capture the Relationships1 minute
Step 4 of 5 on Building a Document BTM: Determine the Most Useful Form0 minutes
Step 5 of 5 on Building a Document BTM: Review and Confirm0 minutes
Technics Publications Exercise13 minutes

1 lectureTotal 10 minutes

Value of the Business Terms Model10 minutes

1 devoirTotal 15 minutes

Document BTM15 minutes

Learn all about the graph BTM and build one too! Explore several examples of the graph BTM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph BTM. Finally, design a graph BTM.

Inclus

11 vidéos1 lecture1 devoir

11 vidéosTotal 41 minutes

About the Graph BTM2 minutes
Graph BTM Example1 minute
Graph Components7 minutes
How does a Label Property Graph (LPG) Compare with the Resource Development Framework (RDF)?8 minutes
Overview on How to Build a BTM3 minutes
Step 1 of 5 on Building a Graph BTM: Ask the Six Strategic Questions8 minutes
Step 2 of 5 on Building a Graph BTM: Identify and Define the Terms2 minutes
Step 3 of 5 on Building a Graph BTM: Capture the Relationships1 minute
Step 4 of 5 on Building a Graph BTM: Determine the Most Useful Form1 minute
Step 5 of 5 on Building a Graph BTM: Review and Confirm0 minutes
Cozy Cactus Bed & Breakfast Exercise9 minutes

1 lectureTotal 10 minutes

About Graph Databases Like Neo4j10 minutes

1 devoirTotal 30 minutes

Graph BTM30 minutes

Learn all about the relational LDM and build one too! Explore several examples of the relational LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a relational LDM. Finally, design a relational LDM. Apply all of the levels of normalization, from First Normal Form (1NF) all the way through Fifth Normal Form (5NF)!

Inclus

14 vidéos1 devoir

14 vidéosTotal 59 minutes

About the Relational LDM4 minutes
Normalization Mindset1 minute
Normalization Overview10 minutes
My Approach to Normalization: The Normalization Hike2 minutes
The Normalization Hike Overview6 minutes
Starting with Chaos6 minutes
First Normal Form (1NF)7 minutes
Second Normal Form (2NF)3 minutes
Third Normal Form (3NF)1 minute
Boyce/Codd Normal Form (BCNF)4 minutes
Fourth (4NF) and Fifth Normal Form (5NF)4 minutes
Summary of Normalization Rules1 minute
A Data Modeling Joke0 minutes
Technics Publications Exercise9 minutes

1 devoirTotal 30 minutes

Relational LDM30 minutes

Learn all about the dimensional LDM and build one too! Explore several examples of the dimensional LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional LDM. Finally, design a dimensional LDM.Compare and contrast the dimensional modeling components of measure, meter, dimension, and grain. Apply the best practices of dimensional modeling through a series of what-to-do and what-not-to-do guidelines for your modeling in analytics applications.Become competent in incorporating different types of measures and dimensions into your models.

Inclus

13 vidéos1 devoir

13 vidéosTotal 57 minutes

About the Dimensional LDM3 minutes
Measure, Meter, and Dimension4 minutes
The Importance of Choosing the Right Grain3 minutes
Fun with Measures and Grain4 minutes
Dimensional Models are Built for Navigation6 minutes
Three Types of Measures: Transaction, Snapshot, and Accumulating6 minutes
Examples of Each Type of Measure4 minutes
Do's of Dimensional Modeling7 minutes
Don'ts of Dimensional Modeling6 minutes
Additional Dimensional Logical Structures: Conformed Dimension4 minutes
Additional Dimensional Logical Structures: Factless Facts1 minute
Additional Dimensional Logical Structures: Behavioral Dimensional2 minutes
Cozy Cactus Bed & Breakfast Exercise7 minutes

1 devoirTotal 30 minutes

Dimensional LDM30 minutes

Learn all about the document LDM and build one too! Explore several examples of the document LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document LDM. Finally, design a document LDM.

Inclus

3 vidéos1 lecture1 devoir

Learn all about the graph LDM and build one too! Explore several examples of the graph LDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph LDM. Finally, design a graph LDM.

Inclus

3 vidéos1 lecture1 devoir

Learn all about the relational PDM and build one too! Explore several examples of the relational PDM to fully experience the characteristics of this type of model. There are four main techniques used as building blocks in the physical: denormalization, indexing, views, and partitioning. Explain the different ways to denormalize and know the pros and cons of each technique. Contrast the different types of indexes and know the default translations from logical to physical. Define views and know the pros and cons of traditional versus materialized views. Describe horizontal and vertical partitioning, and know when to use each.

Inclus

11 vidéos1 devoir

11 vidéosTotal 52 minutes

About the PDM6 minutes
Denormalization Overview5 minutes
Denormalization: Standard and Repeating Attributes7 minutes
Denormalization: Variation of Repeating Attributes (Nested Arrays)3 minutes
Denormalization: Summarization1 minute
Denormalization: Aggregation6 minutes
Indexing6 minutes
Views6 minutes
Partitioning5 minutes
A Data Modeling Joke0 minutes
Technics Publications Exercise7 minutes

1 devoirTotal 30 minutes

Relational PDM30 minutes

Learn all about the dimensional PDM and build one too! Explore several examples of the dimensional PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a dimensional PDM. Finally, design a dimensional PDM. Apply several modeling techniques specific to dimensional physical modeling, including the use of junk and degenerate dimensions.

Inclus

9 vidéos1 devoir

9 vidéosTotal 33 minutes

Star Schema2 minutes
Snowflake5 minutes
Slowly Changing Dimension Overview4 minutes
Slowly Changing Dimensions Types 0 and 14 minutes
Slowly Changing Dimension Type 26 minutes
Slowly Changing Dimension Type 33 minutes
Degenerate Dimension2 minutes
Junk Dimension3 minutes
Cozy Cactus Bed & Breakfast Exercise4 minutes

1 devoirTotal 30 minutes

Dimensional PDM30 minutes

Learn all about the document PDM and build one too! Explore several examples of the document PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a document PDM. Finally, design a document PDM.

Inclus

2 vidéos1 lecture1 devoir

Learn all about the graph PDM and build one too! Explore several examples of the graph PDM to fully experience the characteristics of this type of model. Next, journey through the steps in building a graph PDM. Finally, design a graph PDM.

Inclus

3 vidéos1 lecture1 devoir

Instructeur

Steve Hoberman

Technics Publications

2 Cours16 apprenants

Offert par

Technics Publications

En savoir plus sur Data Management

Technics Publications
Data Modeling Fundamentals
Cours
Statut : Essai gratuit
Packt
Data Modelling Essentials
Cours
Statut : Essai gratuit
Coursera
Data Modeling & Warehousing Fundamentals in Data Engineering
Cours
Statut : Essai gratuit
Microsoft
Data Modeling and Architecture
Cours

Pour quelles raisons les étudiants sur Coursera nous choisissent-ils pour leur carrière ?

Felipe M.

Étudiant(e) depuis 2018

’Pouvoir suivre des cours à mon rythme à été une expérience extraordinaire. Je peux apprendre chaque fois que mon emploi du temps me le permet et en fonction de mon humeur.’

Jennifer J.

Étudiant(e) depuis 2020

’J'ai directement appliqué les concepts et les compétences que j'ai appris de mes cours à un nouveau projet passionnant au travail.’

Larry W.

Étudiant(e) depuis 2021

’Lorsque j'ai besoin de cours sur des sujets que mon université ne propose pas, Coursera est l'un des meilleurs endroits où se rendre.’

Chaitanya A.

’Apprendre, ce n'est pas seulement s'améliorer dans son travail : c'est bien plus que cela. Coursera me permet d'apprendre sans limites.’

Foire Aux Questions

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.

When you enroll in the course, you get access to all of the courses in the Specialization, 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.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Plus de questions

Visitez le Centre d'Aide pour les Étudiants

Aide financière disponible,