Data Modeling Training

Data Modeling Training lays scope on all aspects that is required to illustrate the relationships between data which explores data-oriented structures and identifies entity types. Data modeling involves a progression from conceptual model to logical model to physical schema which is taught thoroughly by our trainers.

Data Modeling Training Curriculum

Data Warehouse Basics

In this module, we will discuss about the basic concepts of a Data Warehouse and why it is needed. Difference between an operational system and an analytical system, Data marts and approaches to build a data warehouse.

An introduction to Data Warehousing
Purpose of Data Warehouse
Data Warehouse Architecture
Operational Data Store
OLTP Vs Warehouse Applications
Data Marts
Data marts Vs Data Warehouses
Data Warehouse Life cycle

Data Modeling

Data modeling is the analysis of data objects that are used in a business or other context and the identification of the relationships among these data objects. It is a first step in doing object-oriented programming. In this module, you will also learn different phases in Data Modeling.

Introduction of Data Modeling
Different Phases of Data Modelling
Multi-Dimensional Modeling

Learn Data Modelling, what a dimension and a fact is, the different types of dimensions and facts. Reporting concept of Hierarchy

What Is a Dimension in Data Modeling
What are Facts?
Multi Dimensional Model
Hierarchies, Data Modeling – OLAP
Data Modeling – MOLAP
Data Modeling – ROLAP
Data Modeling – HOLAP
Cubes and its Functions
Star Schema
Fact Table
Dimensional Tables
Snow flake Schema
Fact less Fact Table
Confirmed Dimensions
Data Modelling Tools

This module gives you an brief description about the different types of Engineering and Concept of Alter database.

Introduction to Erwin
Forward Engineering
Reverse Engineering
Update Model
Alter database
Complete compare.

  • PRIVATE
  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query
[contact-form-7 id="5639" title="Drop Us A Query"]
© 2016, ALL RIGHTS RESERVED.
Create an Account