3 arrows

Popular Mirantis On Demand Training Courses Now 50% Off

closeClose

Introduction to IBM Netezza Performance Server eLearning

  • Tuition USD $162
  • Reviews star_rate star_rate star_rate star_rate star_half 2844 Ratings
  • Course Code 6XA101G-WBT
  • Duration 6.5 hours
  • Available Formats Self Paced

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

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

It was a good overview, but I feel like I need a lot more studying to be able to pass the test

Excellent presentation to learn about available features in Microsoft Office Online.

The courses are very in-depth and useful to get a good idea of everything and get going from there.

Excellent I would highly recommend ExitCertified (Tech Data) training courses

Great class, engaging instructor - helpful materials. A week on Zoom went by in a flash, thank you :)

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