Piovtal Greenplum Administrator

Live Online & Classroom Certification Training

Get Pivotal Greenplum Administration certification gives you a complete understanding on Installing and Maintaining on Greenplum Database. Get equipped with essential skills required to use the Greenplum Database System. This course explores fundamental concepts using the psql CLI, DDL, DML, and DQL, data loading, backup and restore; data modeling, as well as some performance tuning strategies.

(4.7) 193 Learners
Instructed by SPRINGPEOPLE
INDIA

    No Public/Open-house class on the topic scheduled at the moment!

Course Description

Overview

Gain in-dept knowlege on Greenplum Database Features, Benefits, and Architecture in terms of shared nothing, MPP design and how Greenplum database supports redundancy and high availability. Gain Hands-on experience to Install, Configure and Administer a Greenplum Database, query data, Implement security and access strategies. Be proficient with DDL, DML, and DQL to access, manage.

Learn how to Implement appropriate table storage models, compression, and tablespaces, data distributions, and table partitioning strategies to store data in a Greenplum database. Improve query performance by following a number of performance enhancement tips by understanding the Pivotal Query Optimizer, database tuning, query profiling, tuning and rewriting, and indexing strategies

This course serves as a prerequisite for the Pivotal Greenplum Administrator Certification exam. At the end of this course, you will be able to confidently take the Pivotal Greenplum Administrator Exam and earn one of the highest paying certifications in the industry 

Suggested Audience:

  • Administrators responsible for the installation and maintenance of the Greenplum database, including initial system preparation, installation and configuration as well as the ongoing tuning and troubleshooting 

Duration:

  • Classroom - 4 Days
  • Live Online - 24 Hours

Objective

At the end of the training, you should be able to:

• Describe Greenplum database features, benefits, and architecture in terms of shared nothing, MPP design and how Greenplum database supports redundancy and high availability
• Install, configure, and administer a Greenplum Database
• Be proficient with DDL, DML, and DQL to access, manage, and query data
• Implement appropriate table storage models, compression, and tablespaces, data distributions, and table partitioning strategies to store data in a Greenplum database
• Understand best practices for data loading
• Be proficient in data modeling and physical design decisions
• Improve query performance by following a number of performance enhancement tips by understanding the Pivotal Query Optimizer, database tuning, query profiling, tuning and rewriting, and indexing strategies
• Implement security and access strategies
• Perform backup and restore

 

Prerequisites

  • Basic UNIX or Linux command-line navigation and administration skills
  • Database query language basics, including but not limited to basic SQL knowledge for accessing database objects
  • Fundamental relational database concepts

Course Curriculum

Expand All
  • psql CLI utility
  • Command Cente
  • System preparation and verification
  • Greenplum Database Initializatio
  • DDL, DML, DQL
  • Roles and Privileges
  • Controlling Access
  • Managing Resources
  • GP Workload Manage
  • Implementing table storage models, compression, and tablespaces
  • Data loading
  • Table partitioning
  • Managing the Greenplum Database
  • Backups and Restores
  • Data modeling in Greenplum
  • Physical design decisions
  • Pivotal Query Optimizer
  • DB Tuning
  • Query profiling
  • Query tuning and rewriting
  • Statistics
  • Indexing strategies

Certification

SpringPeople works with top industry experts to identify the leading certification bodies on different technologies - which are well respected in the industry and globally accepted as clear evidence of a professional’s “proven” expertise in the technology. As such, these certification are a high value-add to the CVs and can give a massive boost to professionals in their career/professional growth.

Our certification courses are fully aligned to these high-profile certification exams; at the end of the course, participants will have detailed knowledge, be eligible and be fully ready take up these certification exams and pass with flying colours.

 

SpringPeople is the offiical training partners of Piovtal. This course is aligned to Pivotal Greenplum Administration Certification.The certification fee is not included as part of the training fee. 

The price of the exam is $200. Purchasing the Certification Exam entitles you to one (1) proctored exam attempt with a Pivotal-authorized testing center. You will receive exam scheduling and registration instructions via email after your purchase. Your exam must be scheduled and taken within 90 days of your exam purchase or your exam attempt will be forfeited.

Your exam must be scheduled and taken within 90 days of your exam purchase or your exam attempt will be forfeited.

Click here to purchase Exam

The Pivotal Greenplum Administrator certification exam is designed to test and validate your proficiency with Pivotal Greenplum in the following areas:

  • Describing Greenplum features, benefits, and architecture
  • Database installation and initialization
  • Defining and securing the user database
  • Data loading and distribution
  • Database management and archiving
  • Data modeling and design
  • Performance analysis and tuning 

Recommended Certification Path:

  • Experience with installing and maintaining the Greenplum database, including initial system preparation, installation, and configuration as well as ongoing tuning and troubleshooting
  • Take the proctored Pivotal Greenplum Administrator Certification exam 

Exam Topics:

  • Architecture Design (20%) 
  • Deployment (5%)
  • B & R (5%)
  • Security (5%)
  • Operations (15%)
  • Workload Management (15%)
  • Performance Management (20%)
  • Loading/Unloading (15%) 

Exam Detais:

  • Type - Proctored and Multiple Choice
  • Duration - 90 Minutes
  • Number of Questions - 40
  • Passing Score - 75% 

Upon sucessful completion of exam you will receive an electronic certificate and Pivoatal does not provide Hard Copies of certificates

Resources

SpringPeople Corporate Learning Center

About the Instructor

Founded in 2009, SpringPeople is a global premier eLearning marketplace for Online Live, Instructor-led classes in the region. It is a certified training delivery partner of leading technology creators, namely Pivotal, Elastic, Lightbend, EMC, VMware, MuleSoft, RSA, and... Read More


Course Rating and Reviews

4.7

Average Rating
5 Stars
28
4 Stars
12
3 Stars
1
2 Stars
0
1 Star
0

SPRINGPEOPLE SpringPeople Trainer

Santhosh Karunakaran

Sr Manager
Fidelity Investments
Course:
Instructor:
Course Material:
Class Experience:
Get a trainer who can communicate better

SPRINGPEOPLE SpringPeople Trainer

Santhosh Karunakaran

Sr Manager
Fidelity Investments
Course:
Instructor:
Course Material:
Class Experience:
Get a trainer who can communicate better

SPRINGPEOPLE SpringPeople Trainer

Senthil Kumar

Course:
Instructor:
Course Material:
Class Experience:
The prerequisites should be given for the students before the class will improve the students participation more. And following the course structure is essential .

This class is intended for participants with some prior exposure to the technology and are now looking to build up their expertise on the topic.

On successful completion of the course, participants will be eligible to sit of the related certification exam (see course overview). All participants receive a course completion certificate, demonstrating their expertise on the subject.

Total duration of the online, live instructor led sessions. Sessions are typically delivered as short lectures (2-hrs weekdays/3-hrs weekends) and detailed hands-on guidance.

Expected offline lab work hours that participants will need to complete and submit to the trainer, during and after the instructor-led online sessions.

  1. We are happy to refund full fee paid - no questions asked - should you feel that the training is not up to your expectations.
  2. Our dedicated team of expert training enablement advisors are available on email, phone and chat to assist you with your queries.
  3. All courseware, including session recordings, will always be available to access to you for future reference and rework.

Contact Us

+91-80-6567-9700 (BLR)

training@springpeople.com

Schedule a Call

Related Courses

Recently Viewed