Data Modeling Scheme

Sparen Sie mit 40% Rabatt auf 3 Monate Coursera Plus bei den Fähigkeiten, die Sie zum Strahlen bringen. Jetzt sparen

kurs ist nicht verfügbar in Deutsch (Deutschland)

Wir übersetzen es in weitere Sprachen.

Data Modeling Scheme

Dozent: Steve Hoberman

Bei enthalten

Mehr erfahren

13 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

13 Module

Verschaffen Sie sich einen Einblick in ein Thema und lernen Sie die Grundlagen.

Stufe Anfänger

Empfohlene Erfahrung

1 Woche zu vervollständigen

unter 10 Stunden pro Woche

Flexibler Zeitplan

In Ihrem eigenen Lerntempo lernen

Kompetenzen, die Sie erwerben

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

Werkzeuge, die Sie lernen werden

Kategorie: Relational Databases
Kategorie: Database Software
Kategorie: Database Systems
Kategorie: Database Management Systems

Wichtige Details

Zertifikat zur Vorlage

Zu Ihrem LinkedIn-Profil hinzufügen

Kürzlich aktualisiert!

Mai 2026

Bewertungen

13 Aufgaben

Unterrichtet in Englisch

Erfahren Sie, wie Mitarbeiter führender Unternehmen gefragte Kompetenzen erwerben.

Weitere Informationen zu Coursera für Unternehmen

Logos von Petrobras, TATA, Danone, Capgemini, P&G und L'Oreal

In diesem Kurs gibt es 13 Module

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.

Das ist alles enthalten

4 Videos1 Aufgabe

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.

Das ist alles enthalten

12 Videos1 Lektüre1 Aufgabe

12 VideosInsgesamt 46 Minuten

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

1 LektüreInsgesamt 10 Minuten

About the Relational BTM10 Minuten

1 AufgabeInsgesamt 15 Minuten

Relational BTM15 Minuten

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.

Das ist alles enthalten

10 Videos1 Lektüre1 Aufgabe

10 VideosInsgesamt 34 Minuten

About the Dimensional BTM2 Minuten
Dimensional BTM Example2 Minuten
Overview on How to Build a BTM3 Minuten
Step 1 of 5 on Building a Dimensional BTM: Ask the Six Strategic Questions6 Minuten
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 Minuten
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 Minuten
A Data Modeling Joke0 Minuten
Cozy Cactus Bed & Breakfast Exercise12 Minuten

1 LektüreInsgesamt 10 Minuten

About the Dimensional BTM10 Minuten

1 AufgabeInsgesamt 15 Minuten

Dimensional BTM15 Minuten

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.

Das ist alles enthalten

9 Videos1 Lektüre1 Aufgabe

9 VideosInsgesamt 28 Minuten

About the Document BTM2 Minuten
Document BTM Example1 Minute
Overview on How to Build a BTM3 Minuten
Step 1 of 5 on Building a Document BTM: Ask the Six Strategic Questions5 Minuten
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 Minuten
Step 5 of 5 on Building a Document BTM: Review and Confirm0 Minuten
Technics Publications Exercise13 Minuten

1 LektüreInsgesamt 10 Minuten

Value of the Business Terms Model10 Minuten

1 AufgabeInsgesamt 15 Minuten

Document BTM15 Minuten

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.

Das ist alles enthalten

11 Videos1 Lektüre1 Aufgabe

11 VideosInsgesamt 41 Minuten

About the Graph BTM2 Minuten
Graph BTM Example1 Minute
Graph Components7 Minuten
How does a Label Property Graph (LPG) Compare with the Resource Development Framework (RDF)?8 Minuten
Overview on How to Build a BTM3 Minuten
Step 1 of 5 on Building a Graph BTM: Ask the Six Strategic Questions8 Minuten
Step 2 of 5 on Building a Graph BTM: Identify and Define the Terms2 Minuten
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 Minuten
Cozy Cactus Bed & Breakfast Exercise9 Minuten

1 LektüreInsgesamt 10 Minuten

About Graph Databases Like Neo4j10 Minuten

1 AufgabeInsgesamt 30 Minuten

Graph BTM30 Minuten

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)!

Das ist alles enthalten

14 Videos1 Aufgabe

14 VideosInsgesamt 59 Minuten

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

1 AufgabeInsgesamt 30 Minuten

Relational LDM30 Minuten

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.

Das ist alles enthalten

13 Videos1 Aufgabe

13 VideosInsgesamt 57 Minuten

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

1 AufgabeInsgesamt 30 Minuten

Dimensional LDM30 Minuten

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.

Das ist alles enthalten

3 Videos1 Lektüre1 Aufgabe

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.

Das ist alles enthalten

3 Videos1 Lektüre1 Aufgabe

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.

Das ist alles enthalten

11 Videos1 Aufgabe

11 VideosInsgesamt 52 Minuten

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

1 AufgabeInsgesamt 30 Minuten

Relational PDM30 Minuten

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.

Das ist alles enthalten

9 Videos1 Aufgabe

9 VideosInsgesamt 33 Minuten

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

1 AufgabeInsgesamt 30 Minuten

Dimensional PDM30 Minuten

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.

Das ist alles enthalten

2 Videos1 Lektüre1 Aufgabe

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.

Das ist alles enthalten

3 Videos1 Lektüre1 Aufgabe

Dozent

Steve Hoberman

Technics Publications

2 Kurse16 Lernende

von

Technics Publications

Warum entscheiden sich Menschen für Coursera für ihre Karriere?

Felipe M.

Lernender seit 2018

„Es ist eine großartige Erfahrung, in meinem eigenen Tempo zu lernen. Ich kann lernen, wenn ich Zeit und Nerven dazu habe.“

Jennifer J.

Lernender seit 2020

„Bei einem spannenden neuen Projekt konnte ich die neuen Kenntnisse und Kompetenzen aus den Kursen direkt bei der Arbeit anwenden.“

Larry W.

Lernender seit 2021

„Wenn mir Kurse zu Themen fehlen, die meine Universität nicht anbietet, ist Coursera mit die beste Alternative.“

Chaitanya A.

„Man lernt nicht nur, um bei der Arbeit besser zu werden. Es geht noch um viel mehr. Bei Coursera kann ich ohne Grenzen lernen.“

Häufig gestellte Fragen

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.

Weitere Fragen

Besuchen Sie die das Hilfe-Center für Kursteilnehmer.

Finanzielle Unterstützung verfügbar,