India-flagINDIA : +91-8099902123   usa-flagUSA : 201-710-8393
Call Me Back

training courses

ibm netezza Admin online Training

IBM NETEZZA Course Content

The objective of this course is to enrich an associate with end-to-end knowledge on IBM Netezza Database Administration to handle day-to-day and any complex business needs.

Below are the various topics that will be covered as part of this detailed training:

  • About Netezza & Various Netezza Appliances
  • Netezza Data warehouse Architecture
  • Netezza High Availability Architecture
  • Netezza Command Line Interface (CLI)
  • Managing User Access to the Netezza Database
  • NzAdmin: GUI Admin Tool
  • Databases & Tables
  • Data Distribution
  • Data Types
  • Netezza Transactions
  • Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
  • Data Loading/Unloading using ETL tools
  • Netezza system tables, views, and user tables
  • Netezza stored procedures
  • Generate Statistics
  • Optimizer and Query Plans
  • Zone Maps
  • Materialized Views
  • Reclaiming Space with NZRECLAIM, Groom Table
  • Backup and Restore (Host, Database, Table)
  • Client Installations
  • ODBC/JDBC/OLEDB Client connectivity
  • Database Refreshes, Data Migrations
  • Techniques to improve Netezza performance
  • Netezza Replication/DR architecture
  • Working with IBM Netezza support to resolve issues

If you want to know more about IBM Netezza Admin Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com