Data Modeling with Netezza Training

Netezza copy

 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