Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

IBM PureData System for Analytics for Developers and Administrators - WBT

IBM Course Code: 1W522G

GK# 720518 Vendor# 1W522G

Course Overview

TOP

This course is the combination of IBM PureData System for Analytics Usage (1W503) and IBM PureData System for Analytics advanced Concepts (1W512).

This course will teach you database administration for the IBM PureData System for Analytics appliances. This course is designed to give you 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 you advanced database administration skills for the IBM PureData System for Analytics Advanced Concepts System. This course is designed to give you 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.

What You'll Learn

TOP
  • 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

Outline

TOP
Viewing outline for:

Self-Paced Outline

  • Data warehouse overview
  • Architecture  
  • Connecting to the IBM PureData System for Analytics host
  • Managing user access to the IBM PureData System for Analytics database  
  • Administration tools
  • Databases and tables and schemas
  • Distributions  
  • Loading and unloading tables    
  • ODBC, JDBC, OLEDB client connectivity
  • Optimizer and query plans    
  • Zone maps and Clustered Base Tables (CBT)
  • Materialized views     
  • Generate statistics
  • Cross-database access
  • Transactions
  • GROOM   
  • Stored procedures
  • High availability architecture
  • DBOS internals and system log files
  • nzsql and scripting
  • nzevents and event processing
  • Analyzing plan files
  • Analyzing and optimizing query performance
  • Workload management
  • System management
  • Configuring query history
  • Backup and restore
  • Security including authenticating users with LDAP, SSL

Who Should Attend

TOP

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

Course Delivery

This course is available in the following formats:

Self-Paced

On-demand content enables you to train on your own schedule.



Request this course in a different delivery format.
Enroll