Data Modeling with Netteza Online Training|Training

[Davidjhon]

We Provide Online Training |Training|  Data Modeling with Netteza  with Real Time Experts

Course Outline :

Module 1 – Need of Data Modeling

 

• What is data modeling and its significance?

• What is Data Warehousing

 

Module 2 – Data Modeling

 

• Conceptual Data modeling

• Physical Data modeling

• Logical Data modeling

• Benefits and scope of data modeling

 

Module 3 – Multidimensional Data Modeling

 

• Basic Conceptual Architecture

• Demonstrate fact and dimension

• Difference between facts and dimensions

 

Module 4 – Concepts/Schema of Data Modeling

 

• Dimensional Model Keys

• Types of facts

• Conformed dimensions

• Star schema

• Snow flake schema

• Difference between Star schema and Snow flake Schema

• Limitations of data warehousing

 

Module 5 – SCD Implementation methods

 

• Type 0 Fixed attributes

• Type 1 Changing attributes

• Type 2 Historical attributes

 

Module 6 – Introduction to RDBMS

 

• Evolution of RDBMS

• 12 Rules of Codd

• RDMS providers

• Parts of database

• Relational concepts – 1

• Relational concepts – 2

• Relational concepts – 3

• Relational concepts – 4

 

Module 7 – RDBMS Vs Data warehouse and ETL Process

 

• OLTP vs. OLAP

• What is ETL Process

• Where ETL Process is used

• Scope of ETL in Data warehouse

 

Module 8 – SQL Parsing

 

• SQL Parsing-1

• SQL Parsing-2

• Compilation

• Optimization-1

• Optimization-2

• Execution

 

Module 9 – Erwin-Design Layer Architecture

 

• What is ERwin Model?

• Design Layer Architecture

• Data Warehouse modeling

• Creating and using ‘User Defined Domains’

• Managing naming standards

• Managing Data type standards

 

Module 11 – Forward Engineering & Reverse Engineering

 

• An introduction to Forward Engineering (SQL Generation)

• An introduction to Reverse Engineering

• An introduction to Complete Compare

You can reach us @   3092003878 or Email us: [email protected]