Data Modeling & Netteza Online Training|Training|Support -3092003878

[Davidjhon]

Best Online Training Providers by Real Time Experts on Data Modeling & Netteza

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

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

Forward Engineering & Reverse Engineering

• An introduction to Forward Engineering (SQL Generation)
• An introduction to Reverse Engineering
• An introduction to Complete Compare

Netezza 

• NPS AMPP Architecture & Various Netezza appliance models
• Netezza High Availability Architecture (Clustering, Mirroring, failover)
• Installing Netezza system and client software’s
• NzAdmin: GUI Admin Tool (Installation & Setup)
• Netezza Command Line Interface (CLI)
• Manage NPS with CLI commands
• Manage User access to Netezza Databases
• Databases & Tables
• Data Distribution (Hash, Random), Cluster Base Tables, Table Skew
• Generate Statistics, Zone Maps, Materialized Views, Groom Table
• Database Refreshes & Migrations
• Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
• Data Loading/Unloading using GUI Tools
• Query history collection & Reporting
• Techniques to improve Netezza performance
• ODBC/JDBC/OLEDB Client Connectivity

 

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