Course Information

IBM Netezza Training Duration: 30 Hours

IBM Netezza Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

IBM Netezza Training Method: Instructor Led Online/Classroom Training

IBM Netezza Study Material: Soft Copy

Course Content

NPS AMPP Architecture  & Various Netezza appliance models

Netezza High Availability Architecture (Clustering, Mirroring, failover)

Installing Netezza system and client softwares

Installing Netezza Emulator for day-to-day practice

NzAdmin: GUI Admin Tool (Installation & Setup)

Netezza Command Line Interface (CLI)

Manage NPS with CLI commands

Manage User access to Netezza Databases

Monitoring Netezza and Linux logs

Netezza Events (Setup & Monitoring)

Databases & Tables

Data Distribution (Hash, Random), Cluster Base Tables, Table Skew

Generate Statistics, Zone Maps, Materialized Views, Groom Table

Backup & Restore (Host Level, Database Level, Table Level)

Database Refreshes & Migrations

Netezza Appliance migration (For Example: 6.x to 7.x migration)

Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE

Data Loading/Unloading using GUI Tools

Optimizer and query plans

Query history collection & Reporting

Netezza Replication/DR Architecture

Techniques to improve Netezza performance

Frequent DBA activities such as SPU replacements, etc

ODBC/JDBC/OLEDB Client Connectivity

Working with IBM Netezza Support to resolve issues

Request For Demo