This course is not scheduled.
Overview
| Course code | 3W510AU | Skill level | Advanced |
|---|---|---|---|
| Duration | 2.0 days | Delivery type | Instructor Led - Online Training
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price |
AUD $1,700.00 ex GST
AUD $1,870.00 inc GST |
PLEASE NOTE: This is a live, instructor-led online course. Please do not make arrangements to travel.
This course teaches you advanced database administration skills for the IBM Netezza 1000 Advanced Concepts System. This course is designed to give you a working knowledge and understanding on IBM Netezza 1000 internals to optimize IBM Netezza 1000 performance and tune system parameters. This course provides an overview of IBM Netezza 1000 administration and analysis.
View this course in other countries
Roadmaps that contain this course are:
Audience
This advanced course is for database administrators, system administrators, application developers, and data warehouse architects.
Prerequisites
Those who have successfully completed the IBM Netezza Appliance Usage course have satisfied the prerequisite requirements to attend this course.
Objectives
- Analyze Plan files
- Perform query analysis and troubleshooting
- Optimize data distributions
- Interact with advanced CLI commands
- Use nzsql and workload management
Course outline
Agenda
Day 1
- Unit 1: High availability architecture
- Unit 2: DBOS internals and system log files
- Exercise 1: DBOS and system logs
- Unit 3: nzsql and scripting
- Exercise 2: nzsql and scripting
- Unit 4: nzevent and event processing
- Exercise 3: nzevent and event processing
- Unit 5: Analyzing plan files
- Exercise 4: Analyzing performance
Day 2
- Unit 6: Analyzing and optimizing query performance
- Unit 7: Workload management
- Unit 8: Authenticating users with LDAP
- Unit 9: Configuring query history
- Exercise 5: Reviewing query history
- Unit 10: Backup and restore
- Exercise 6: Backup and restore
- Unit 11: SSL