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 Specialization?

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.

Is financial aid available?

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.

Data Modeling Scheme

Data Modeling Scheme

位教师：Steve Hoberman

包含在中

了解更多

13个模块

深入了解一个主题并学习基础知识。

初级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

13个模块

深入了解一个主题并学习基础知识。

初级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有13个模块

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.

涵盖的内容

4个视频1个作业

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.

涵盖的内容

12个视频1篇阅读材料1个作业

12个视频总计46分钟

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

1篇阅读材料总计10分钟

About the Relational BTM10分钟

1个作业总计15分钟

Relational BTM15分钟

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.

涵盖的内容

10个视频1篇阅读材料1个作业

10个视频总计34分钟

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

1篇阅读材料总计10分钟

About the Dimensional BTM10分钟

1个作业总计15分钟

Dimensional BTM15分钟

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.

涵盖的内容

9个视频1篇阅读材料1个作业

9个视频总计28分钟

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

1篇阅读材料总计10分钟

Value of the Business Terms Model10分钟

1个作业总计15分钟

Document BTM15分钟

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.

涵盖的内容

11个视频1篇阅读材料1个作业

11个视频总计41分钟

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

1篇阅读材料总计10分钟

About Graph Databases Like Neo4j10分钟

1个作业总计30分钟

Graph BTM30分钟

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

涵盖的内容

14个视频1个作业

14个视频总计59分钟

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

1个作业总计30分钟

Relational LDM30分钟

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.

涵盖的内容

13个视频1个作业

13个视频总计57分钟

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

1个作业总计30分钟

Dimensional LDM30分钟

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.

涵盖的内容

3个视频1篇阅读材料1个作业

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.

涵盖的内容

3个视频1篇阅读材料1个作业

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.

涵盖的内容

11个视频1个作业

11个视频总计52分钟

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

1个作业总计30分钟

Relational PDM30分钟

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.

涵盖的内容

9个视频1个作业

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.

涵盖的内容

2个视频1篇阅读材料1个作业

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.