Data Modeling related topics
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
This this course will help you learn how to design a relational data model, dimensional model, incorporate entities from a decomposed JSON document, NoSQL data stores, and more. Also, you’ll understand how Data Modeling determines and interprets data from experts through step-by-step methods and examples. By the end of this certification course, you will have a firm understanding of what a data model is, data model types, how to apply normalization, how to create both a dimensional and relational data model, and much more.
-
COURSE OBJECTIVES
By the end of the course, you‘ll be able to:
- know The Enterprise Data Modeling Getting Started
- Learn about the relational data model and normalization techniques.
- Explore the NoSQL data stores and the JSON data format
- Learn about OLAP and the dimensional model.
- 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.
- Have a firm understanding of what a data model is,
- Different types of data models,
- How to apply normalization,
- The JSON data format
- How to create both a relational and dimensional data model.
-
COURSE AUDIENCE
This course is made for:
- Anyone who has an interest in understanding how data is managed within an organisation and how it flows through business processes.
-
COURSE OUTLINE
Day One:
- Basics of Data Modeling
- Data Model Overall Process
- Notations
Day Two:
- Schema Types
- Data Modeling Types
- Dimension Types
Day Three:
- Fact Types
- Fact Table Types
- Relationships
Day Four:
- Data Modeling Standards
- Dealing with Hierarchy Information
- Data modeling more info
Day Five:
- Data Model Reports
- Practice Test and Interview Questions
Keyword
Training Subject
Training Location