IBM-training-courses

Introduction to IBM Netezza Performance Server eLearning

This IBM Web-Based Training (WBT) is Self-Paced and includes: - Instructional content available online for duration of course - Visuals without hands-on lab exercises This course takes the learner...

Read More
$249 USD GSA  $138.48
Course Code 6XA101G-WBT
Duration 6.5 hours
Available Formats Self Paced
5812 Reviews star_rate star_rate star_rate star_rate star_half
Course Image

This IBM Web-Based Training (WBT) is Self-Paced and includes:
- Instructional content available online for duration of course
- Visuals without hands-on lab exercises

This course takes the learner through the purpose and value of IBM Netezza Performance Server to knowing how to use the database system. It covers at a high level the NPS architecture and then dives into how to use NPS. The learner will be able to describe the data distribution model used in Netezza systems and be able to create and manage databases and tables. The learner 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, the learner will be able to perform backup and restore operations, monitoring, and troubleshooting.

 

 

Skills Gained

- Overview of IBM Netezza Performance Server 
- 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

Who Can Benefit

Database Administrators

Prerequisites

None

Course Details

Course Outline

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

Contact Us 1-800-803-3948
Contact Us
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward