IBM Netezza Performance Server Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

This IBM Netezza Performance Server training course covers the purpose and value of IBM Netezza Performance Server and the use of the database system. It covers at a high level the NPS architecture and then dives into how to use NPS. You will be able to describe the data distribution model used in Netezza systems and be able to create and manage databases and tables. You will also be able to perform load and unload operations as well as understand how the query plans and performance tuning operations are done. Finally, you will be able to perform backup and restore operations, monitoring, and troubleshooting.

By attending IBM Netezza Performance Server workshop, delegates will learn to:

Describe the Netezza Performance Server architecture
Describe data distribution and create distribution keys in Netezza systems
Manage Netezza Performance Server database user access
Load and unload data from Netezza Performance Server database tables
Describe query plans and performance tuning methods for Netezza Performance Server
Backup and restore operations on Netezza Performance Server
Monitoring and troubleshooting Netezza Performance Server

The IBM Netezza Performance Server class is ideal for:

Database Administrators

Overview of IBM Netezza Performance Server

Describe the Netezza Performance Server
List and describe the different deployment factors for Netezza Performance Server
Explain the new features of the Netezza Performance Server

Describe the Netezza Performance Server architecture

Describe the infrastructure and the components
Describe the database architecture
List and describe the storage options for Cloud Pak for Data System with NPS

Describe data distribution and create distribution keys in Netezza systems

Use nzsql to create and manage database and tables
Create and manage databases
Create and manage tables
Describe data types and the best practices for choosing the right data type
Describe table constraints and how they are used

Manage Netezza Performance Server database user access

Create and manage users
Create and manage groups
Describe and manage roles
Compare and contrast administrator and object privileges
Grant and revoke privileges

Load and unload data from Netezza Performance Server database tables

Describe the data movement process, options, and support file types and formats
Describe the data encoding options and use nzconvert
Create and load external tables and remote client systems
Use nzload for high performance bulk load
Describe the use cases of SQL and nzload, including common errors and output
Load and unload of fixed format files

Describe query plans and performance tuning methods for Netezza Performance Server

Active monitoring of queries to isolate the high run-time and high queue-time queries
Optimizing query performance through aligning the distribution key, zone map, system statistics, and groom maintenance job
System tuning guidelines
Workflow management best practices

Backup and restore operations on Netezza Performance Server

Full backup & incremental backup and restore approach for recovery
DR and recovery plan alignment to RPO/RTO (with or without separate DR system)
Backup/Restore sequencing to handle dependency and handling idle or stuck process

Monitoring and troubleshooting Netezza Performance Server

Explain the different web console metrics
Describe the auto alerts and PMR generation
Describe specific action plans for different categories
Create log collections
Use nz_* commands for maintenance and performance tuning

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

IBM Netezza Performance Server

COURSE AGENDA