Online Training |Training data modeling Netezza -3092003878

[Davidjhon]

We Provide Online Training |Training| on   data modeling Netezza with Real Time Experts

Course Outline:

 

• 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 1 – 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

 

Module2  – SQL Parsing

 

• SQL Parsing-1

• SQL Parsing-2

• Compilation

• Optimization-1

• Optimization-2

• Execution

 

Module  – 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

 

Module3  – 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]