IBM Netezza Training

IBM Netezza Training

Consider that you have few MB's of tables to joined. You can process the data on your normal desktop. However let say that we need to process the data in Terabytes OR Petabytes. This level of huge data cannot be processed on Desktop and One might end up aborting the query. This can be done with the help of Netezza Appliance. 

Netezza is a Datawarehousing appliance which can process your terabytes of data in glimpse. 

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

Key Features

Instructor Led Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request for demo