02 9482 8200 info@datasync.com.au

DW50: IBM PureData System for Analytics Usage

Code: DW50
Duration: 3 days

Description

This course will teach participants database administration for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliance.  It is designed to give the participant an overview of the  IBM PureData System for Analytics (PDA) architecture and provide a working knowledge and understanding of the PDA database features and best practices. It includes content and labs on the features introduced in NPS 7 including full schema support.

Outcomes

  • Administer the IBM PureData System for Analytics appliance
  • 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

Audience

Database administrators, system administrators, application developers, and data warehouse architects.

Prerequisites

You should have:

  • Working knowledge of UNIX or Linux
  • Experience with shell scripting,
  • Experience with VI editing
  • Basic SQL

Format

Classroom and hands on lab exercises.

This course is also offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.