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

• Sequences
• Transactions
• Query and System Optimization
• nz commands
• Backup and Restore
• Creating User and User Management
• Query History
• Managing Workloads
• Managing Events
• Createxid, Deletexid

Netezza – Full Course

NPS AMPP Architecture & Various Netezza 7.2 appliance models

• Netezza 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 & 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

• Netezza 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 to read next?