Davidjhon Posted September 2, 2016 Report Posted September 2, 2016 (edited) 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] Edited September 2, 2016 by Davidjhon Add a image Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.