Data Modeling with Netezza Online Training|Training|Support -3092003878

[edwardcruz]

Best Online Training Providers by Real Time Experts on  Data Modeling with Netezza 

Course Outline:

 

 Need of Data Modeling 

• What is data modeling and its significance?
• What is Data Warehousing

 Data Modeling 

• Conceptual Data modeling
• Physical Data modeling
• Logical Data modeling
• Benefits and scope of data modeling

Multidimensional Data Modeling 

• Basic Conceptual Architecture
• Demonstrate fact and dimension
• Difference between facts and dimensions

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

SCD Implementation methods 

• Type 0 Fixed attributes
• Type 1 Changing attributes
• Type 2 Historical attributes

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

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

SQL Parsing

• SQL Parsing-1
• SQL Parsing-2
• Compilation
• Optimization-1
• Optimization-2
• Execution