This course is not scheduled.
Overview
| Course code | DW501AU | Skill level | Advanced |
|---|---|---|---|
| Duration | 3.0 days | Delivery type | Classroom
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price |
AUD $2,700.00 ex GST
AUD $2,970.00 inc GST |
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.
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:
- a working knowledge of UNIX or Linux
- experience with shell scripting
- experience with VI editing, and 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
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: NzAdmin
- Exercise 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