Learn Full Course: Netezza

• IBM Netezza Overview
• Netezza Architecture
• Connecting to Netezza
• Databases, Tables and Database Objects
• Data Distribution
• Loading and Unloading Tables
• Statistics
• Zone Maps and Materialized Views
• Groom Table

NPS AMPP Architecture & Various Netezza 7.2 Appliance Models

• High Availability Architecture (Clustering, Mirroring, failover)
• Installing the Netezza system and client software
• Installing Netezza Emulator for day-to-day practice
• Nz Admin: 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

• Performance improvement techniques
• Common DBA activities such as SPU replacements, etc.
• ODBC/JDBC/OLEDB Client Connectivity
• Working with IBM Netezza Support to resolve issues

What's Next?