Training

PureData System for Analytics Advanced Concepts

Overview
This course teaches participants advanced database administration skills for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliances. This course is designed to give participants a working knowledge and understanding on IBM PureData System for Analytics (PDA) N1001 and N2001 appliance internals to optimize IBM PDA performance and tune system parameters. This course provides an overview of IBM PDA administration and analysis.

It includes content and labs on the features introduced in NPS 7 including full schema support.

Audience
Database administrators, system administrators, application developers, and data warehouse architects.

Prerequisites
You should have successfully completed the IBM PureData System for Analytics Appliance Usage course.

Objective
 Analyze Plan files
 Perform query analysis and troubleshooting
 Optimize data distributions
 Interact with advanced CLI commands
 Use nzsql and workload management:
 Determine workload management requirements
 Make use of the System Management functionality

For Registration click here

PureData System for Analytics for Developers and Administrators

Overview
This course is the combination of IBM PureData System for Analytics Usage (DW503) and IBM PureData System for Analytics advanced Concepts (DW512)

This course will teach participants database administration for the IBM PureData System for Analytics appliances. This course is designed to give the participant an overview of the IBM PureData System for Analytics architecture and provide a working knowledge and understanding of the Netezza database features and best practices.

This course teaches participants advanced database administration skills for the IBM PureData System for Analytics Advanced Concepts System. This course is designed to give participants a working knowledge and understanding on IBM PureData System for Analytics internals to optimize IBM PureData System for Analytics performance and tune system parameters. This course provides an overview of IBM PureData System for Analytics administration and analysis.

Audience
This course is for database administrators, system administrators, application developers, and data warehouse architects.

Prerequisites
You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL.

Objective
 Administer the IBM PureData System for Analytics
 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

For Registration click here

PureData System for Analytics, NPS 7.0 New Features

Overview
In this course, you will learn the IBM Netezza Platform Software (NPS) Version 7.0 enhancements and new features, as well as how to apply them. These enhancements and new features include:
 Small query performance enhancements to increase concurrency and throughput
 Improved support for ODS workload profiles
 Workload Management enhancements to increase throughput and performance and support for Analytics
 Enhanced Event Manager templates for increased monitoring and notifications
 New capabilities for object maintenance
 New and modified system views for improved system management
In addition, you will get a brief overview of Unicode support, SQL changes and upgrade paths.

Audience
This intermediate course is for application developers, system administrators, data warehouse architects, and database administrators who are familiar with IBM Netezza Platform Software (NPS) Version 6.x.

Prerequisites
You should know:
 Netezza Data Warehouse Appliance Usage 6.0

Objective
 Take advantage of page granular zone maps (PZGM)
 Use Planner Control to eliminate JIT statistics
 Balance appliance workload for differing profiles
 Improve Event Manager notifications
 Utilize new and modified system views for improved diagnostics and fault investigation
 Use enhanced object maintenance for greater flexibility in backups and restores

For Registration click here

Netezza Analytics for Data Scientists - Using R and NZSQL

Overview
IBM Netezza Analytics provides a game-changing experience for Data Scientists by allowing data miners and quantitative analysts to leverage all the data while still achieving high performance throughout the entire modeling cycle - from data prep through exploratory data analysis through to model scoring and deployment. By leveraging the massively parallel processing architecture of an IBM Netezza Appliance, analytics can be performed in-database so that there is no superfluous data movement. This harnesses the full power of IBM Netezza Appliance and allows data miners and quantitative analysts to greatly reduce the time to build and deploy/score a model in a single environment while leveraging increasing massive data sets and shrinking the time from model concept to deployment.

This course will focus on how to effectively leverage the IBM Netezza Analytics platform to build, test and score analytic models in-database. You will learn how to leverage:

 In-Database Analytics fully scalable and parallelized in-database analytics package,
 Enterprise R, the statistical language, that runs on Netezza.
 Matrix Engine, a parallelized, linear algebra package.

Audience
This advanced course is for analytic modelers including: data miners, quantitative analysts and statisticians.

Prerequisites
You should have:
 Basic understanding of using advanced analytics (statistics, data mining, etc.) in business problem solutions
  Working knowledge of R and/or SQL

Objective
 Understand how the Netezza architecture and parallel processing capabilities supports modeling and analysis paradigms on large scale data sets
 Understand data mining methods in the context of use cases to solve common business problems
 Apply new approaches to modeling and analysis made possible by IBM Netezza Analytics
 Invoke Netezza Analytics data mining methods and statistical functions using the R client and/or Netezza SQL (NZSQL)
 Convert existing R statistical modules/functions to leverage the Netezza platform

For Registration click here

Netezza Analytics for Developers

Overview
Netezza allows you to extend SQL by using user-defined extensions (UDXs), as well as User-Defined Analytic Processes (UDAPs). UDXs can be thought of as the user-defined counterparts of built-in SQL Functions. They are called from SQL in the same manner and follow the same guidelines for input and output. UDAPs, although called from SQL similarly to UDXs, are actually applications that run when called. The UDAP concept allows a Netezza developer to implement a freestanding, executable data-processing program, that runs ''out of process'' that is, outside the system, and register it in a database.

This course will teach you how to develop User Defined Extensions including: User Defined Functions (UDFs), User Defined Aggregates (UDAs), User Defined Table Functions (UDTFs), and User Defined Analytic Processes (UDAPs). You will develop these User Defined Extensions using the Netezza command line utilities to compile and register these in-database analytics.

Audience
This advanced course is intended for Developers and Programmers that want to embed in-database analytics on Netezza.

Prerequisites
You should have:
 Working knowledge of Unix or Linux
 Working knowledge of Data Warehousing concepts
 Knowledge of C or C++
 Ability to use the VI Editor
 Knowledge of Java
 Familiarity with Eclipse

Objective
 Write a user defined function (UDF) in C++ to extend the capabilities of SQL
 Write a user defined aggregate (UDA) in C++ to implement the various phases of aggregate evaluation, such as initialization, accumulation, and merging
 Write a user defined table function (UDTF) in C++ enabling you to process one/many rows to return a table shape composed of many rows/columns
 Manage user defined functions, aggregates and table functions and shared libraries (e.g., granting permissions)
 Write a user defined analytic process (UDAP) in Java to extend the capabilities of SQL and run an analytic out-of-process. Additionally, be aware that UDAPs can be developed in other programmatic languages
 Know the features of the Netezza Plug-in for Eclipse

For Registration click here