IBM Netezza

IBM Netezza

Course Curriculum

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
Search Course
Quick Contact
Top