NETEZZA Training
Netezza Training makes you familiar with IBM NETEZZA and teaches all the topics required to develop and administer within the IBM NETEZZA system environment.
IBM Netezza Training Curriculum
NPS AMPP Architecture & Various Netezza appliance models
Netezza High Availability Architecture (Clustering, Mirroring, fail over)
Installing Netezza system and client softwares
Installing Netezza Emulator for day-to-day practice
Nz Admin: GUI Admin Tool (Installation & Set-up)
Netezza Command Line Interface (CLI)
Manage NPS with CLI commands
Manage User access to Netezza Databases
Monitoring Netezza and Linux logs
Netezza Events (Set-up & 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.