KT-DW522G IBM PureData System for Analytics for Developers and Administrators Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


IBM PureData System for Analytics for Developers and Administrators


Description: 

This course is the combination of IBM PureData System for Analytics Usage (DW503) and IBM PureData System for Analytics advanced Concepts (DW512)

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

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

Skills Taught:

  • 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

 
Click here to view the Course Outline
     
Prerequisite: 

You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL.

 
   
     
Duration: 
5 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.