К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Data Modeling Scheme · LearnSpace
Назад в каталог
courseraIT и технологии

Data Modeling Scheme

Курс от Technics Publications
Начальный≈ 15.8 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Data ModelingDatabase DesignRelational DatabasesGraph TheoryDatabase SystemsBusiness AnalysisData GovernanceDatabase Management SystemsDocument ManagementData EngineeringDatabase AdministrationBusiness AnalyticsDatabase TheoryDatabase ManagementDatabase DevelopmentDatabase SoftwareDatabasesDatabase Architecture and AdministrationData ArchitectureData Strategy

Программа курса

13 модулей · 137 учебных материалов

01Data Modeling Scheme Overview5 материалов
About Data Modeling SchemesВидеоBusiness Terms Model (BTM) OverviewВидеоLogical Data Model (LDM) OverviewВидеоPhysical Data Model (PDM) OverviewВидео

Учитесь у экспертов

Steve Hoberman

Преподаватель курса

Data Modeling Scheme
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 15.8 ч

13 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета
Data Modeling SchemeЗадание
02Relational Business Terms Model (Align), also known as Conceptual15 материалов
Why a Business Terms Model and not a Conceptual Data Model?ВидеоAbout the Relational BTMВидеоRelational BTM Example 1 - UniversityВидеоRelational BTM Example 2 - ERP Solution (Vendor Product)ВидеоOpportunities to Create a Relational BTMDIALOGUEOverview on How to Build a BTMВидеоStep 1 of 5 on Building a Relational BTM: Ask the Six Strategic QuestionsВидеоStep 2 of 5 on Building a Relational BTM: Identify and Define the TermsВидеоStep 3 of 5 on Building a Relational BTM: Capture the RelationshipsВидеоStep 4 of 5 on Building a Relational BTM: Determine the Most Useful FormВидеоStep 5 of 5 on Building a Relational BTM: Review and ConfirmВидеоAbout the Relational BTMЧтениеA Data Modeling JokeВидеоTechnics Publications ExerciseВидеоRelational BTMЗадание
03Dimensional Business Terms Model (Align), also known as Conceptual13 материалов
About the Dimensional BTMВидеоDimensional BTM ExampleВидеоOpportunities to Create a Dimensional BTMDIALOGUEOverview on How to Build a BTMВидеоStep 1 of 5 on Building a Dimensional BTM: Ask the Six Strategic QuestionsВидеоStep 2 of 5 on Building a Dimensional BTM: Identify and Define the TermsВидеоStep 3 of 5 on Building a Dimensional BTM: Capture the RelationshipsВидеоStep 4 of 5 on Building a Dimensional BTM: Determine the Most Useful FormВидеоStep 5 of 5 on Building a Dimensional BTM: Review and ConfirmВидеоAbout the Dimensional BTMЧтениеA Data Modeling JokeВидеоCozy Cactus Bed & Breakfast ExerciseВидеоDimensional BTMЗадание
04Document Business Terms Model (Align), also known as Conceptual12 материалов
About the Document BTMВидеоDocument BTM ExampleВидеоOpportunities to Create a Document BTMDIALOGUEValue of the Business Terms ModelЧтениеOverview on How to Build a BTMВидеоStep 1 of 5 on Building a Document BTM: Ask the Six Strategic QuestionsВидеоStep 2 of 5 on Building a Document BTM: Identify and Define the TermsВидеоStep 3 of 5 on Building a Document BTM: Capture the RelationshipsВидеоStep 4 of 5 on Building a Document BTM: Determine the Most Useful FormВидеоStep 5 of 5 on Building a Document BTM: Review and ConfirmВидеоTechnics Publications ExerciseВидеоDocument BTMЗадание
05Graph Business Terms Model (Align), also known as Conceptual14 материалов
About the Graph BTMВидеоGraph BTM ExampleВидеоOpportunities to Create a Graph BTMDIALOGUEGraph ComponentsВидеоHow does a Label Property Graph (LPG) Compare with the Resource Development Framework (RDF)?ВидеоAbout Graph Databases Like Neo4jЧтениеOverview on How to Build a BTMВидеоStep 1 of 5 on Building a Graph BTM: Ask the Six Strategic QuestionsВидеоStep 2 of 5 on Building a Graph BTM: Identify and Define the TermsВидеоStep 3 of 5 on Building a Graph BTM: Capture the RelationshipsВидеоStep 4 of 5 on Building a Graph BTM: Determine the Most Useful FormВидеоStep 5 of 5 on Building a Graph BTM: Review and ConfirmВидеоCozy Cactus Bed & Breakfast ExerciseВидеоGraph BTMЗадание
06Relational Logical Data Model (Refine)16 материалов
About the Relational LDMВидеоNormalization MindsetВидеоNormalization OverviewВидеоOpportunities to Create a Relational LDMDIALOGUEMy Approach to Normalization: The Normalization HikeВидеоThe Normalization Hike OverviewВидеоStarting with ChaosВидеоFirst Normal Form (1NF)ВидеоSecond Normal Form (2NF)ВидеоThird Normal Form (3NF)ВидеоBoyce/Codd Normal Form (BCNF)ВидеоFourth (4NF) and Fifth Normal Form (5NF)ВидеоSummary of Normalization RulesВидеоA Data Modeling JokeВидеоTechnics Publications ExerciseВидеоRelational LDMЗадание
07Dimensional Logical Data Model (Refine)15 материалов
About the Dimensional LDMВидеоMeasure, Meter, and DimensionВидеоThe Importance of Choosing the Right GrainВидеоFun with Measures and GrainВидеоDimensional Models are Built for NavigationВидеоThree Types of Measures: Transaction, Snapshot, and AccumulatingВидеоExamples of Each Type of MeasureВидеоOpportunities to Create a Dimensional LDMDIALOGUEDo's of Dimensional ModelingВидеоDon'ts of Dimensional ModelingВидеоAdditional Dimensional Logical Structures: Conformed DimensionВидеоAdditional Dimensional Logical Structures: Factless FactsВидеоAdditional Dimensional Logical Structures: Behavioral DimensionalВидеоCozy Cactus Bed & Breakfast ExerciseВидеоDimensional LDMЗадание
08Document Logical Data Model (Refine)6 материалов
About the Document LDMВидеоBuilding the Document LDMВидеоThe Document Model of MongoDBЧтениеOpportunities to Create a Document LDMDIALOGUETechnics Publications ExerciseВидеоDocument LDMЗадание
09Graph Logical Data Model (Refine)6 материалов
About the Graph LDMВидеоBuilding the Graph LDMВидеоNuances of Graph Logical Data Modeling in Neo4jЧтениеOpportunities to Create a Graph LDMDIALOGUECozy Cactus Bed & Breakfast ExerciseВидеоGraph LDMЗадание
10Relational Physical Data Model (Design)13 материалов
About the PDMВидеоDenormalization OverviewВидеоDenormalization: Standard and Repeating AttributesВидеоDenormalization: Variation of Repeating Attributes (Nested Arrays)ВидеоDenormalization: SummarizationВидеоDenormalization: AggregationВидеоOpportunities to Create a Relational PDMDIALOGUEIndexingВидеоViewsВидеоPartitioningВидеоA Data Modeling JokeВидеоTechnics Publications ExerciseВидеоRelational PDMЗадание
11Dimensional Physical Data Model (Design)11 материалов
Star SchemaВидеоSnowflakeВидеоOpportunities to Create a Dimensional PDMDIALOGUESlowly Changing Dimension OverviewВидеоSlowly Changing Dimensions Types 0 and 1ВидеоSlowly Changing Dimension Type 2ВидеоSlowly Changing Dimension Type 3ВидеоDegenerate DimensionВидеоJunk DimensionВидеоCozy Cactus Bed & Breakfast ExerciseВидеоDimensional PDMЗадание
12Document Physical Data Model (Design)5 материалов
Building the Document PDMВидеоAn Example of a Document Pattern in MongoDB: The Approximation PatternЧтениеOpportunities to Create a Document PDMDIALOGUE Technics Publications ExerciseВидеоDocument PDMЗадание
13Graph Physical Data Model (Design)6 материалов
About the Graph PDMВидеоBuilding the Graph PDMВидеоAbout Design and Neo4jЧтениеOpportunities to Create a Graph PDMDIALOGUECozy Cactus Bed & Breakfast ExerciseВидеоGraph PDMЗадание