IBM PureData System for Analytics Usage Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu



Tarih ve lokasyonlar


Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:


info@bilginc.com

+90 212 282 7700

Talep Formu
Eğitim Tipi ve Süresi

2 Days ILT    

IBM PureData System for Analytics Usage (1W503G�)

IBM Course Code: 1W503G

This course will teach participants database administration for the IBM PureData System for Analytics (PDA) N1001 and N2001 appliance. 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 best practices. It includes content and labs on the features introduced in NPS 7 including full schema support.

What You'll Learn

  • 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

Who Needs to Attend

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

Prerequisites

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

Follow-On Courses

There are no follow-ons for this course.

Course 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



Eğitim içeriğini PDF olarak indir

Eğitim Sağlayıcı ve Kategori

IBM  » New & Popular Eğitimler
IBM  » PureData Systems (Netezza) Eğitimler
IBM  » Database Management & Development Eğitimler
IBM  » New and Popular Eğitimler