English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 38m | 257 MB
To model data is to know data. In this course, you will learn how to create a relational data model, incorporate entities from a decomposed JSON document, create a dimensional model, and build a database from a script generated from your data model.
How can you get value from your data if you don’t know your data? How many data projects have you started only to go through the same process of hunting down someone who knows something about the data you need to work with? Do they still work with the company? This is why we model data. In this introductory course, Enterprise Data Modeling: Getting Started, you will learn about the relational data model and normalization techniques. First, you will explore the NoSQL data stores and the JSON data format. Next, you will learn about OLAP and the dimensional model. Finally, you will take what you have learned and put into practice with a few demonstrations including creating a physical data model from a logical model to generate a script to build a database. By the end of the course, you will have a firm understanding of what a data model is, different types of data models, how to apply normalization, the JSON data format, and how to create both a relational and dimensional data model.
Table of Contents
Course Overview
1 Course Overview
Course Introduction
2 Course Introduction
Understanding Data Modeling Concepts
3 Module Introduction
4 Data Modeling Terminology – Part 1
5 Data Modeling Terminology – Part 2
6 Data Modeling Concepts
Beginning Relational Data Modeling
7 Module Introduction
8 The Relational Model Basics
9 Normal Form Notation
10 Why Normalize Part 1
11 Why Normalize Part 2
12 Demo – Data Governance Compliance and Data Domains
13 Demo – Modeling to the 1NF 2NF and 3NF
14 Module Summary
Beginning NoSQL Modeling
15 Module Introduction
16 The JSON Document
17 Demo – JSON to a Relational Data Model
18 Module Summary
Beginning Dimensional Modeling
19 Module Introduction
20 OLAP vs. OLTP
21 Dimensional Terms and Concepts – Part 1
22 Dimensional Terms and Concepts – Part 2
23 Key Performance Indicators
24 Demo – The Dimensional Model
25 Module Summary
Building a Database from DDL
26 Module Introduction
27 Demo – The Physical Model DDL and Deploying to a Database Server
28 Course Summary
Resolve the captcha to access the links!