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

• Chapter 1 Introduction
• Chapter 2 Netezza Performance Server System Architecture
• Chapter 3 High Availability Architecture and Administration
• Chapter 4 Getting Started
• Chapter 5 Privileges, Users and Groups
• Lab Exercise 1: Getting Started
• Chapter 6 NzAdmin
• Lab Exercise 2: NzAdmin
• Chapter 7 Databases and Tables
• Chapter 8 Distributions
• Lab Exercise 3: Distributions
• Chapter 9 Data Types
• Chapter 10 Sequences
• Chapter 11 Transactions
• Chapter 12 Loading and Unloading Tables
• Lab Exercise 4: Nzload
• Lab Exercise 5: External Tables
• Chapter 13 nzreclaim
• Lab Exercise 6: nzreclaim
• Chapter 14 Backup and Restore
• Lab Exercise 7: Backup and Restore
• Chapter 15 ODBC/JDBC Client Connectivity
• Lab Exercise 8: Installing ODBC
• Chapter 16 Generate Statistics
• Lab Exercise 9: Generate Statistics
• Chapter 17 Optimizer and Query Plans
• Lab Exercise 10: Analyzing Query Plans
• Chapter 18 Zone Maps
• Chapter 19 Materialized Views
• Lab Exercise 11: Materialized Views
• Basic Linux Commands for Lab Exercises
• Netezza Quick Look Up

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

• Chapter 1 Introduction
• Chapter 2 Command Line Interface
• Chapter 3 nzsql
• Chapter 4 DBOS Internals
• Chapter 5 Tunable System Parameters
• Chapter 6 Cross Database Access
• Chapter 7 Analyzing Plan Files
• Chapter 8 Analyzing and Troubleshooting Query Performance
• Chapter 9 Workload Management

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 days

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