Netezza Education Course Descriptions
Netezza Datawarehouse Appliance Usage
Course Description and Objectives
This course will teach participants database administration for the Netezza appliance. The Netezza Appliance Usage course is designed to give the participant an overview of the Netezza appliance architecture and provide a working knowledge and understanding of the Netezza database features and best practices. Participants will be able to administer the Netezza appliance, understand High Availability Systems, configure client connectivity, create databases and tables, determine distribution methods, load and unload tables, GENERATE STATISTICS, analyze query plans, create materialized views and backup and restore the Netezza appliance.
Format
Classroom Lecture, Lab Exercises or Self-paced web format
Audience
Database Administrators, System Administrators, Application Developers and Data Warehouse Architects
Course Length
3.0 days
Delivery
Customer On Site or Netezza Corporate or Self-paced web format
Student Prerequisites
- Working knowledge of Unix or Linux
- Experience with Shell Scripting
- Experience with VI or EMACS Editing
- Basic SQL experience
Course Content
Day 1
- Chapter 1 About Netezza . . .
- Chapter 2 Netezza Data Warehouse Architecture
- Chapter 3 High Availability Architecture
- Chapter 4 Getting Started
- Chapter 5 Permissions, Users & Groups
- Lab Exercise 1: Getting Started
- Chapter 6 NzAdmin
- Lab Exercise 2: NzAdmin
- Chapter 7 Databases & Tables
- Chapter 8 Distributions
- Lab Exercise 3: Distributions
Day 2
- Chapter 9 Data Types
- Chapter 10 Transactions
- Chapter 11 Loading and Unloading Tables
- Lab Exercise 4: nzload
- Lab Exercise 5: External Tables
- Chapter 12 Generate Statistics
- Lab Exercise 6: Generate Statistics
- Chapter 13 Optimizer and Query Plans
- Lab Exercise 7: Analyzing Query Plans
Day 3
- Chapter 14 Zone Maps
- Chapter 15 Materialized Views
- Lab Exercise 8: Materialized Views
- Chapter 16 nzreclaim
- Lab Exercise 9: nzreclaim
- Chapter 17 Backup and Restore
- Lab Exercise 10: Backup and Restore
- Chapter 18 ODBC/JDBC/OLEDB Client Connectivity
- Lab Exercise 11: Installing ODBC / JDBC / OLEDB
Netezza Data Warehouse Appliance Advanced Concepts
Course Description and Objectives
This course will teach participants advanced database administration skills for the Netezza Appliance® .The Netezza Appliance Advanced Concepts course is designed to give the participant a working knowledge and understanding on Netezza appliance internals to optimize Netezza appliance performance and tune system parameters. This course will provide an overview of Netezza appliance administration and analysis. Participants will learn how to analyze Plan files, perform query analysis and troubleshooting, optimize data distributions, interact with advanced CLI commands, use nzsql and workload management.
Format
Classroom Lecture, Lab Exercises or Self-paced web format
Audience
Database Administrators, Application Developers, System Administrators and Data Warehouse Architects
Course Length
2.0 days
Delivery
Customer On Site or Netezza Corporate or Self-paced web format
Student Prerequisites
- Netezza Performance Server Appliance Usage training course (required)
- Experience with Unix or Linux
- Experience with Shell Scripting
- Experience with VI
- Experience with SQL
Course Content
Day 1
- Chapter 1 About Netezza . . .
- Chapter 2 DBOS Internals & System Log Files
- Lab Exercise 1: DBOS & System Logs
- Chapter 3 Tunable System Parameters
- Lab Exercise 2: Tunable System Parameters
- Chapter 4 nzsql & Scripting
- Lab Exercise 3: nzsql & Scripting
- Chapter 5 Cross Database Access
- Chapter 6 nzevent and Event Processing
- Lab Exercise 4: nzevent and Event Processing
- Chapter 7 Analyzing Plan Files
- Lab Exercise 5: Reviewing Plan Files
Day 2
- Chapter 8 Analyzing & Optimizing Query Performance
- Lab Exercise 6: Analyzing Performance
- Lab Exercise 7: Analyzing Execution Plans
- Chapter 9: Workload Management
- Chapter 10: Authenticating Users with LDAP
- Lab Exercise 8: Authenticating Users with LDAP
- Chapter 11: Processing Data using Stored Procedures
- Lab Exercise 9: Creating a Stored Procedure
- Chapter 12: Configuring Query History
- Lab Exercise 10: Reviewing Query History
Netezza Appliance Servicing
Course Objectives
This course will teach students basic Netezza Performance
Server system support and operational skills. The course is
designed to give the student an overview of the Netezza Performance
Server architecture. Students will learn how to perform basic
system monitoring, troubleshooting and diagnostics. Students
will learn how to manage SPUs in the Netezza Performance Server,
use the Netezza Ticket System and NPS KnowledgeBase.
Format
Classroom Lecture, Lab Exercises or Self-paced web format
Audience
Operations, Administrators, and Database Administrators
Course Length
1.0 day
Delivery
Customer On Site or Netezza Corporate or Self-paced web format
Student Prerequisites
Basic Unix or Linux administration skills are required.
Table of Contents
- Chapter 1 Introducing Netezza
- Chapter 2 NPS Architecture Overview
- Chapter 3 System States and Troubleshooting
- Chapter 4 DBOS Processes and System Log Files
- Chapter 5 Monitoring and Troubleshooting with the CLI
- Chapter 6 SPU Management
- Chapter 7 NzAdmin
- Chapter 8 NPS Diagnostics
- Chapter 9 Netezza Support Model
- Chapter 10 Netezza Ticket System and KnowledgeBase
- Appendix A: Spare Parts Kit and Component Replacement
- Appendix B: Basic Linux and vi Commands
Netezza OnStream 4.5
Web Based Course
This web based class contains all the slides, notes, lectures and labs as the instructor led class. If you wish to receive a class manual, please email education@netezza.com. You need access to an NPS server to conduct the labs.
Labs
The labs can be downloaded and run on your NPS server, or you can login to the Netezza training server and conduct the labs online.
Course Description and Objectives
This course will introduce participants to Netezza and the Netezza Developer Network, describe how OnStream works within the NPS architecture, familiarize the participants with the concepts of User Defined Functions, User Defined Aggregates and the SPUPad functionality in the NPS environment.
The participants in this course will gain experience using the Decanter Integrated Development Environment to create user defined functions, user defined aggregates and SPUPad functionality.
Participants will also learn to compile and register a UDF or UDA from the command line as well as learn to manage permissions for UDF’s and UDA’s.
Format
Web, Lab Exercises
Audience
Application Developers and Database Administrators
Student Prerequisites
Participants who have successfully completed the Netezza Performance Server System Appliance Usage course have satisfied the prerequisite requirements to attend this course.
Course Content
- Chapter 1 About Netezza . . .
- Chapter 2 How OnStream Works
- Chapter 3 The Decanter Integrated Development Environment
- Lab Exercise 1: Creating a database using Decanter
- Chapter 4 User Defined Functions
- Lab Exercise 2: Developing User Defined Functions
- Chapter 5 User Defined Aggregates
- Lab Exercise 3: Developing User Defined Aggregates
- Chapter 6 Grant & Revoke Permissions
- Chapter 7 Allocating Memory using SPUPAD
- Chapter 8 Applying OnStream Analytics to your Environment
- Chapter 9 Compiling & Registering a UDX
- Lab Exercise 4: Compiling & Registering a UDX
