IBM PureData System for Analytics Programming and Usage (DW585G) Training

Live Online & Classroom Enterprise Certification Training

This course will teach participants how to develop applications for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliance.

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is IBM PureData System for Analytics Programming and Usage (DW585G) Certification Training about?

This course 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 development best practices.

It includes content and labs on the features introduced in NPS 7 including full schema support. The lab environment is an N2002-005 physical appliance.

It will give the intended audience an overview of the IBM PureData System for Analytics (PDA) architecture and provide a working knowledge and understanding of the PDA database features and development best practices.

What are the objectives of IBM PureData System for Analytics Programming and Usage (DW585G) Certification Training ?

After completing this course, you should be able to:

Develop SQL applications
Know how to use various ETL/ELT tools
Create databases, tables and schemas
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

Who is IBM PureData System for Analytics Programming and Usage (DW585G) Certification Training for?

This intermediate course is for application developers, and data warehouse analysts who want to develop applications for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliance.

What are the prerequisites for IBM PureData System for Analytics Programming and Usage (DW585G) Certification Training?

Prerequisites

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

Available Training Modes

Live Online Training

24 Hours

Classroom Training

4 Days

Course Outline Expand All

Expand All

Unit 1: PureData System for Analytics Overview

Unit 2: IBM PDA Architecture

Unit 3: Admin, NzPortal and Aginity Workbench

Unit 4: Database and tables and schemas

Unit 5: Data Distribution

Unit 6: Loading and Unloading Tables with external tables

Unit 7: load

Unit 8: Statistics

Unit 9: Optimizer and Query Plans

Unit 10: Zone maps and Clustered Base Tables (CBT)

Unit 11: Materialized Views

Unit 12: Transactions

Unit 13: Groom

Unit 14: Stored Procedures

Who is the instructor for this training?

The Trainer is IBM certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

IBM PureData System for Analytics Programming and Usage (DW585G) Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of IBM through Tech Data
For any queries, feel free to reach us at ibm@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree