About Trainer

  • 7 years of Netezza experience
  • 2 years of onsite experience
  • Teaching Netezza from 3.5 years
  • IBM Netezza Certified
  • Working as an Architect
  • Excellent in Communication

About IBM Puredata Netezza

 
 
 
 
ONLINE TRAINING IN IBM PureData system for Analytics (a.k.a NETEZZA) DBA BY OUR REALTIME/CERTIFIED PROFESSIONALS

Course Pre-requisites:

Lab setup:

  • Windows 7 64 bit machine that supports Virtualization
  • VMWARE 7 or above
  • Netezza Emulator 7.x
  • Windows ISO image to create Windows VMware

Training Material:

  • Class PPT’s (Soft copy)
  • Netezza 7.x PDF’s (Soft copy)
  • Netezza Emulator softwares

IBM NETEZZA/PureData System For Analytics DBA ONLINE TRAINING Course Outline:

  • NPS AMPP Architecture
  • NPS High availability architecture (Clustering, mirroring, failover)
  • Netezza command line interface (CLI)
  • NZADMIN: GUI Admin tool
  • Creating databases and data objects
  • Data distribution (Random, Hash)
  • Data Loading and Unloading (CLI, GUI)
  • Backup and recovery
  • Database refreshes & migrations
  • Netezza Events
  • Optimizer & Query plans
  • Workload Management
  • Statistics, Zonemaps, CBT, Groom table
  • Views, System Views, Materialized Views
  • Performance Tuning
  • Monitoring logs
  • Query history collection & reporting
  • Netezza Replication/DR Architecture
  • ODBC/JDBC/OLEDB client connectivity

Contents (Unit:1):

  • About Netezza
  • Netezza AMPP Architecture
  • Netezza Architecture fundamental principles
  • Netezza components terminology: FPGA Core, CPU Core, Disk, Host, S-Blade, SPU, SPA, Disk Enclosure
  • Various other Datawarehouse appliances in the market
  • Netezza Host Filesystems (/nz, /export/home, /nzscratch)
  • Host High availability and clustering
  • Controlling DRBD with Heartbeat
  • Netezza HA Administration
  • Netezza disk mirroring (Replication, Failover, Regeneration)
  • S-Blade Failover
  • Netezza Emulator Installation
  • Netezza IP Addresses
  • Standard Log Files (Netezza, Linux)
  • Introduction to Netezza Command Line Interface (CLI)
  • Netezza CLI options
  • Finding Netezza system status (NZSTATE)
  • Netezza SQL Introduction
  • Netezza Environment Variables
  • NZSQL command line options
  • NZSQL Internal slash commands
  • Create Database, Table, Synonym, Sequence
  • Create View, Materialized views, user, groups
  • System tables, views, privileges (object, administrative)
  • SQL Identifiers, Netezza Data types, Internal Datatypes
  • Lab: Emulator installation, NZSQL slash & sql commands

Contents (Unit:2):

  • Data Distribution (Hash, Random)
  • Data Distribution:Collocated Joins
  • Data Distribution: Single/Double Redistribution, Broadcasting
  • Multi Column Distribution
  • Data Distribution: Best Practises
  • Data Loading/Unloading using External Tables
  • Data Loading/Unloading using Compressed External Tables
  • Data Loading using NZLOAD
  • Data Loading usinng NZLOAD fixed format
  • Lab: Database objects creation, Data Loading/unloading (both CLI & GUI)

Contents (Unit:3):

  • Database Level backups/restores (Full, Differential, Cumulative)
  • Schema Level backups/restores
  • Global backups/restores
  • Host level backups/restores
  • Netezza Events (Setup & Monitoring)
  • Query/Audit history collection
  • Work Load Management
  • Concurrent Jobs
  • Resource Sharing Groups
  • Gatekeeper Scheduler
  • GRA Scheduler
  • Snippet Scheduler
  • Resource Scheduler
  • Short Query Bias
  • NZSYSTEM:Change system registry values
  • Introduction to NZSTOP, NZSTART, NZSYSTEM RESTART
  • Lab: Backups & Restores, Netezza restarts

Contents (Unit:4):

  • NZADMIN Installation
  • ODBC Drivers Installation
  • Aginity workbench installation
  • Extents & Zonemaps
  • Clustered Base Tables (CBT)
  • Groom table
  • Skew Table
  • Transactions
  • Statistics(Database, Table, Column, System)
  • NZ* commands
  • Netezza Appliance models
  • Netezza System logs
  • Functions, Operators
  • Table constraints
  • Joins, Stored procedures, SQL Extensions
  • Lab: Groom Table, Skew Table, NZADMIN walk-thru

 
 
 
 

Testimonials

  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal on Netezza Training

  • A great value for time and money. The BEST training I have received so far from India
    - Susan, DBA Lead

  • Really impressive the way most complicated topics in Netezza curriculum explained with examples. I recommend Etraining
    - Mithu Kurian