IBM NETEZZA Online Training

 >>  IBM NETEZZA Online Training

IBM NETEZZA Online Training


 (5) | 1500 Ratings


Introduction


IBM NETEZZA Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

NETEZZA Training Modules

The objective of this course is to enrich an associate with end-to-end knowledge on IBM Netezza development to handle day-to-day and any complex business needs.

Below are various topics that will be covered as part of this detailed practical training:

  • About Netezza Performance Server (NPS)
  • NPS AMPP Architecture & Various Netezza appliance models
  • Installing Netezza GUI client Interfaces
  • ODBC/JDBC/OLEDB Client connectivity
  • Installing Netezza Emulator for day-to-day practice
  • Netezza Command Line Interface (CLI)
  • Netezza SQL (NZSQL) language
  • NZSQL DDL/DML/DCL/TCL statements
  • NZSQL command line options & Internal slash commands
  • Netezza Environment & System Variables
  • Managing User Access to the Netezza Database
  • Working with Databases & Tables (both from NZSQL & GUI interfaces)
  • Netezza Data Types, Schemas, Users, Groups, Privileges
  • Functions, Operators, Constraints, Sequences & Synonyms
  • Data Distribution (Hash, Random) & Best practices
  • Transactions, Generate Statistics, Zone Maps, Materialized Views
  • Groom Table, CBT, Table Skew
  • SQL Identifiers, Reserved Words & keywords, Table Constraints
  • Data Loading/Unloading using External Tables, NZLOAD (CLI & GUI tools)
  • Netezza system tables, views, user tables, Materialized views
  • Netezza Joins, Sub queries, stored procedures, Aggregates, UDFs
  • Netezza SQL Extensions & Analytic functions
  • Techniques to improve Netezza query performance
  • Working with IBM Netezza support to resolve issues

Exam & Certification

0

Course Review

(5)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

NETEZZA Training Modules

The objective of this course is to enrich an associate with end-to-end knowledge on IBM Netezza development to handle day-to-day and any complex business needs.

Below are various topics that will be covered as part of this detailed practical training:

  • About Netezza Performance Server (NPS)
  • NPS AMPP Architecture & Various Netezza appliance models
  • Installing Netezza GUI client Interfaces
  • ODBC/JDBC/OLEDB Client connectivity
  • Installing Netezza Emulator for day-to-day practice
  • Netezza Command Line Interface (CLI)
  • Netezza SQL (NZSQL) language
  • NZSQL DDL/DML/DCL/TCL statements
  • NZSQL command line options & Internal slash commands
  • Netezza Environment & System Variables
  • Managing User Access to the Netezza Database
  • Working with Databases & Tables (both from NZSQL & GUI interfaces)
  • Netezza Data Types, Schemas, Users, Groups, Privileges
  • Functions, Operators, Constraints, Sequences & Synonyms
  • Data Distribution (Hash, Random) & Best practices
  • Transactions, Generate Statistics, Zone Maps, Materialized Views
  • Groom Table, CBT, Table Skew
  • SQL Identifiers, Reserved Words & keywords, Table Constraints
  • Data Loading/Unloading using External Tables, NZLOAD (CLI & GUI tools)
  • Netezza system tables, views, user tables, Materialized views
  • Netezza Joins, Sub queries, stored procedures, Aggregates, UDFs
  • Netezza SQL Extensions & Analytic functions
  • Techniques to improve Netezza query performance
  • Working with IBM Netezza support to resolve issues

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry