ݺߣ

ݺߣShare a Scribd company logo

Dw503 g formation-ibm-puredata-system-for-analytics-usage

•
•
CERTyou Formation
CERTyou Formation

This 3-day course teaches participants how to administer the IBM PureData System for Analytics (PDA) appliance. The course provides an overview of the PDA architecture and teaches features like creating databases and tables, setting distribution methods, loading and unloading tables, and more. The course is intended for database administrators, system administrators, application developers, and data warehouse architects and requires knowledge of UNIX/Linux, shell scripting, and basic SQL. Dates for sessions in Paris are listed.

1 of 1
Download to read offline
CERTYOU, 37 rue des Mathurins, 75008 PARIS - SAS au capital de 10 000 Euros Tél : 01 42 93 52 72 - Fax : 01 70 72 02 72 - contact@certyou.com - www.certyou.com RCS de Paris n° 804 509 461- TVA intracommunautaire FR03 804509461 - APE 8559A Déclaration d’activité enregistrée sous le N° 11 75 52524 75 auprès du préfet de région d’Ile-de-France IBM PureData System for Analytics Usage Formation Informatique / Systèmes d'exploitation / Serveurs d'Applications 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. OBJECTIFS • 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 PUBLIC This course is for Database administrators, system administrators, application developers, and data warehouse architects. PRE-REQUIS You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL. PROGRAMME 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 A retenir Durée : 3 jours soit 21h. Réf. DW503G Dates des sessions Paris 18/05/2015 28/09/2015 14/12/2015 Cette formation est également proposée en formule INTRA-ENTREPRISE. Inclus dans cette formation Coaching Après-COURS Pendant 30 jours, votre formateur sera disponible pour vous aider. CERTyou s'engage dans la réalisation de vos objectifs. Votre garantie 100% SATISFACTION Notre engagement 100% satisfaction vous garantit la plus grande qualité de formation.

More Related Content

Dw503 g formation-ibm-puredata-system-for-analytics-usage

  • 1. CERTYOU, 37 rue des Mathurins, 75008 PARIS - SAS au capital de 10 000 Euros Tél : 01 42 93 52 72 - Fax : 01 70 72 02 72 - contact@certyou.com - www.certyou.com RCS de Paris n° 804 509 461- TVA intracommunautaire FR03 804509461 - APE 8559A Déclaration d’activité enregistrée sous le N° 11 75 52524 75 auprès du préfet de région d’Ile-de-France IBM PureData System for Analytics Usage Formation Informatique / Systèmes d'exploitation / Serveurs d'Applications 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. OBJECTIFS • 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 PUBLIC This course is for Database administrators, system administrators, application developers, and data warehouse architects. PRE-REQUIS You are required to have a working knowledge of UNIX or Linux, experience with shell scripting, experience with VI editing, and basic SQL. PROGRAMME 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 A retenir Durée : 3 jours soit 21h. Réf. DW503G Dates des sessions Paris 18/05/2015 28/09/2015 14/12/2015 Cette formation est également proposée en formule INTRA-ENTREPRISE. Inclus dans cette formation Coaching Après-COURS Pendant 30 jours, votre formateur sera disponible pour vous aider. CERTyou s'engage dans la réalisation de vos objectifs. Votre garantie 100% SATISFACTION Notre engagement 100% satisfaction vous garantit la plus grande qualité de formation.