TRAINING

Enroll Now

IBM Netezza Training  

IBM 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.

Audience

This intermediate course is for application developers, and data warehouse analysts who want to develop applications for the IBM

End of this course you should be able to:

• know how to develop User Defined Extensions
• know about User Defined Functions (UDFs)
• know about User Defined Aggregates (UDAs)
• know about User Defined Table Functions (UDTFs)
• know about User Defined Analytic Processes (UDAPs)
• learn how to develop these User Defined Extensions using the Netezza command line utilities to compile and register these in-database analytics.

Prerequisites

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

Course outline

• NPS AMPP Architecture  & Various Netezza appliance models
• Netezza High Availability Architecture (Clustering, Mirroring, failover)
• Installing Netezza system and client softwares
• Installing Netezza Emulator for day-to-day practice
• NzAdmin: GUI Admin Tool (Installation & Setup)
• Netezza Command Line Interface (CLI)
• Manage NPS with CLI commands
• Manage User access to Netezza Databases
• Monitoring Netezza and Linux logs
• Netezza Events (Setup & Monitoring)
• Databases & Tables
• Data Distribution (Hash, Random), Cluster Base Tables, Table Skew
• Generate Statistics, Zone Maps, Materialized Views, Groom Table
• Backup & Restore (Host Level, Database Level, Table Level)
• Database Refreshes & Migrations
• Netezza Appliance migration (For Example: 6.x to 7.x migration)
• Data Loading/Unloading using External Tables, NZLOAD, NZ_MIGRATE
• Data Loading/Unloading using GUI Tools
• Optimizer and query plans
• Query history collection & Reporting
• Netezza Replication/DR Architecture
• Techniques to improve Netezza performance
• Frequent DBA activities such as SPU replacements, etc
• ODBC/JDBC/OLEDB Client Connectivity
• Working with IBM Netezza Support to resolve issues