Netezza Education Course Descriptions
Netezza Appliance Usage
Course Description and Objectives
This course will teach students database administration of
NPS. The NPS Appliance Usage course is designed to give the
student an overview of the NPS architecture and provide a
working knowledge and understanding of the NPS database features
and best practices. The NPS Appliance Usage course will provide
an overview of NPS high availability architecture and administration.
Students will be able to administer NPS, configure client
connectivity, create users and groups, create databases and
tables, determine optimal distribution methods, load and unload
tables, generate statistics, analyze query performance and
plans, create materialized views and backup and restore the
NPS system.
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 Performance Server 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
- Chapter 9 Data Types
Day 2
- Chapter 10 SEQUENCES
- Chapter 11 Transactions
- Chapter 12 Loading & Unloading Tables
- Lab Exercise 4: nzload
- Lab Exercise 5: EXTERNAL TABLES
- Chapter 13 GENERATE STATISTICS
- Lab Exercise 6: GENERATE STATISTICS
- Chapter 14 Optimizer & Query Plans
- Lab Exercise 7: Analyzing Query Plans
- Chapter 15 Zone Maps
- Chapter 16 MATERIALIZED VIEWS
- Lab Exercise 8: MATERIALIZED VIEWS
Day 3
- Chapter 17 nzreclaim
- Lab Exercise 9: nzreclaim
- Chapter 18 Backup & Restore
- Lab Exercise 10: Backup & Restore
- Chapter 19 ODBC/JDBC/OLEDB Client Connectivity
- Lab Exercise 11: Installing ODBC / JDBC / OLEDB
Netezza Appliance Advanced Components
Course Description and Objectives
This course will teach students the advanced database administration
skills of NPS. The NPS Appliance Advanced Components course
is designed to give the student a working knowledge and understanding
on NPS internals to optimize NPS performance and tune system
parameters. Students will learn how to analyze Plan files,
perform query analysis and troubleshooting, optimize data
distributions, interact with advance CLI command, 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 Command Line Interface
- Lab Exercise 1: Command Line Interface
- Chapter 3 DBOS Internals & System Log Files
- Lab Exercise 2: DBOS & System Logs
- Chapter 4 Tunable System Parameters
- Lab Exercise 3: Tunable System Parameters
- Chapter 5 nzsql & Scripting
- Lab Exercise 4: nzsql & Scripting
Day 2
- Chapter 6 Cross Database Access
- Chapter 7 nzevents and Event Processing
- Chapter 8 Analyzing Plan Files
- Lab Exercise 5: Reviewing Plan Files
- Chapter 9 Analyzing & Optimizing Query Performance
- Lab Exercise 6: Analyzing Performance
- Lab Exercise 7: Analyzing Execution Plans
- Chapter 10 Workload Management
- Chapter 11 Authenticating Users with LDAP
- Lab Exercise 8: Authenticating Users with LDAP
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