Kurs informasjon: IBM Netezza Analytics for Developers (ILO)

This is the Instructor-led Online version of Classroom course IBM Netezza Analytics for Developers (DW551).

This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course material.

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

View this course in other countries

Roadmaps:

• PureData System for Analytics, powered by Netezza
• Netezza Appliance

Til top

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

Til top

You should have the following background:

• 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

Til top

• 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

Til top

Please refer to Course Overview.

Til top