By taking advantage of 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 or score a model in a single environment while using increasing massive data sets and shrinking the time from model concept to deployment.

This course focuses on how to effectively exploit the IBM Netezza Analytics platform to build, test, and score analytic models in-database. Participants in this course learn how to use:

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



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


You should have the following background:

  • Basic understanding of using advanced analytics (statistics, data mining, and so on) in business problem solutions
  • Working knowledge of R, SQL, or both
  • Working knowledge of Unix or Linux
  • Experience with Shell Scripting
  • Experience with VI Editing



  • Understand how the IBM 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
  • Use Netezza Analytics data mining methods and statistical functions using the R client, or IBM Netezza SQL (NZSQL), or both



  • About Netezza
  • Netezza Appliance AMPP Architecture
  • Various Netezza appliance models
  • Netezza Client Installation
  • ODBC/JDBC/OLEDB Client connectivity
  • Netezza SQL (NZSQL) language
  • NZSQL DDL/DML/DCL/TCL statements
  • Netezza Command Line Interface (CLI)
  • Netezza Environment Variables
  • Netezza Internal Slash Commands
  • Managing User Access to the Netezza Database
  • Working with Databases & Tables (both from CLI & GUI interface)
  • Netezza Data Types
  • Users, Groups, Privileges
  • Data Distribution (Hash, Random)
  • Netezza Transactions
  • Netezza External Tables
  • Data Loading/Unloading using CLI tools
  • Data Loading/Unloading using Aginity Workbench
  • Netezza system tables, views, and user tables
  • Netezza stored procedures
  • Generate Statistics
  • Zone Maps
  • Materialized Views
  • Netezza SQL Extensions
  • Functions and Operators
  • Sequences, Synonyms
  • Reclaiming Space with NZRECLAIM, Groom Table
  • Techniques to improve Netezza query performance
  • Working with IBM Netezza support to resolve issues



If you want to know more about IBM NETEZZA DEVELOPER ONLINE TRAINING do not hesitate to call +91-7774892805 or mail us on