Greenplum Certification Training

The Greenplum Certification Training offers a unique opportunity for the student to introduce the fundamental concepts of the Greenplum database and EMC DCA appliance. The training will cover postgre SQL essentials including basic SQL structures, user maintenance, Roles and privileges, data types and functions. The certification training helps to learn the key elements of the unique Greenplum architecture and become familiar with terminology, data distribution and high level optimization methods. The students will gain the hands-on exposure to the installation, configuration upgrade and ongoing maintenance of the Greenplum database system, including all critical administration and monitoring tasks. Even the system can also be configured to call home to EMC support for automatic event notification and advanced support capabilities.

• The Greenplum Certification Training helps the person to install, initialize, validate and configure Greenplum Database.
• The user can manage the database objects and workload management processes by defining and managing roles, privileges and resource queues. 
• The training helps to use table partitioning as a design methodology for handling large tables.
• The person can load the data into a Greenplum database instance using external tables, SQL copy, insert commands and parallel load utilities. 
• It helps the user to perform the backup and restoration of Greenplum data.
• The Greenplum users can gain immediate benefit from deploying the latest commodity hardware innovations.   
• The Greenplum Database provides integrated email and SNMP notification in the case of any event needing IT attention.

After successfully completing the Certification Training, the person should be able to:

• Initialize and validate a Greenplum install.
• Column oriented storage techniques
• Loading Techniques and Backup Techniques.
• Tuning Techniques for GP SQL and Utilize the explain plan to tune SQL.
• Greenplum scripting via Python or Perl.

The course is designed for the individuals who have previously attended the General Greenplum training or are actively using Greenplum. It is also designed for the persons who are presently or plans to install Greenplum Database, Design and develop Greenplum Database implementation, those who administer and manage the Greenplum Database.

The different components of Certification Training are: The Greenplum Master, The Greenplum Segments, Redundancy and Failover in Greenplum Database, The Greenplum Interconnect, Parallel Data Loading and Management and Monitoring.

Generally there are 80 questions and the time limit is 3 hours. The no of question and their level of difficulty depends upon the stage of advancement. The examination is carried out in a standard procedure worldwide.