Overview
| Course code | DW520AU | Skill level | Advanced |
|---|---|---|---|
| Duration | 5.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price |
AUD $4,250.00 ex GST
AUD $4,675.00 inc GST |
Future price | AUD $4,500.00 ex GST For classes starting on or after: 30 Jun 2013 AUD $4,950.00 inc GST For classes starting on or after: 30 Jun 2013 |
This course is a combination of IBM Netezza Appliance Usage (DW501AU) and IBM Netezza Appliance Advanced Concepts (DW510AU).
This course will teach you database administration for the IBM Netezza 1000. This course is designed to give you an overview of the IBM Netezza 1000 architecture and provide a working knowledge and understanding of the Netezza database features and best practices.
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
You should have:
- Working knowledge of UNIX or Linux
- Eexperience with shell scripting,
- Experience with VI editing
- Basic SQL
Objectives
- Administer the IBM Netezza 1000
- Configure client connectivity
- Create databases and tables
- Determine distribution methods
- Set up Clustered Base Tables
- Load and unload tables
- Generate statistics
- Analyze query plans
- Create materialized views
- Reclaim unused disk space
- Program stored procedures
- 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
- Welcome
- Unit 1: About Netezza
- Unit 2: IBM Netezza data warehouse architecture
- Unit 3: Connecting to the IBM Netezza Data Warehouse Appliance Host
- Exercise 1: Access Training's IBM Netezza 1000
- Unit 4: Managing user access to the IBM Netezza database
- Exercise 2: Managing access to the database
- Unit 5: NzAdminExercise 3: NzAdmin
- Unit 6: Databases and tables
- Unit 7: Distributions
- Exercise 4: Distributions
Day 2
- Unit 8: Loading and unloading tables
- Exercise 5: nzload
- Exercise 6: External tables
- Unit 9: ODBC/JDBC/OLEDB client connectivity
- Exercise 7: ODBC connectivity
- Unit 10: Optimizer and query plans
- Exercise 8: Analyzing query plans
- Unit 11: Zone maps and Clustered Base Tables (CBT)
- Exercise 9: Zone maps and CBT
- Unit 12: Materialized views
- Exercise 10: Materialized views
- Unit 13: Generate statistics
- Exercise 11: Generate statistics
Day 3
- Unit 14: Cross-database access
- Unit 15: Transactions
- Unit 16: Reclaiming disk space using GROOM
- Exercise 12: Reclaiming disk space using GROOM
- Unit 17: Stored procedures
- Exercise 13: Stored procedures
Day 4
- Unit 18: High availability architecture
- Unit 19: DBOS internals and system log files
- Exercise 14: DBOS and system logs
- Unit 20: nzsql and scripting
- Exercise 15: nzsql and scripting
- Unit 21: nzevent and event processing
- Exercise 16: nzevent and event processing
- Unit 22: Analyzing plan files
- Exercise 17: Analyzing performance
Day 5
- Unit 23: Analyzing and optimizing query performance
- Unit 24: Workload management
- Unit 25: Authenticating users with LDAP
- Unit 26: Configuring query history
- Exercise 18: Reviewing query history
- Unit 27: Backup and restore
- Exercise 19: Backup and restore
- Unit 28: SSL