Greenplum Administrator Training

Live Online & Classroom Enterprise Certification Training

Our 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.

Looking for a private batch ?

REQUEST A CALLBACK

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

What is Greenplum Administrator Training about?

Gain in-depth knowledge 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

Greenplum administrator 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

What are the objectives of Greenplum Administrator Training ?

At the end of the greenplum administrator 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

What are the prerequisites for Greenplum Administrator Training?

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

Available Training Modes

Live Online Training

18 Hours

Classroom Training

3 Days

Course Outline Expand All

Expand All

1. INTRODUCTION

Overview

2. PSQL AND UTILITIES

psql CLI utility

Command Cente

3. DATABASE INSTALLATION AND INITIALIZATION

System preparation and verification

Greenplum Database Initializatio

4. DEFINING AND SECURING THE DATABASE

DDL, DML, DQL

Roles and Privileges

Controlling Access

Managing Resources

GP Workload Manage

5. DATA LOADING AND DISTRIBUTION

Implementing table storage models, compression, and tablespaces

Data loading

Table partitioning

6. DATABASE MANAGEMENT AND ARCHIVING

Managing the Greenplum Database

Backups and Restores

7. DATA MODELING & DESIGN

Data modeling in Greenplum

Physical design decisions

8. PERFORMANCE ANALYSIS & TUNING

Pivotal Query Optimizer

DB Tuning

Query profiling

Query tuning and rewriting

Statistics

Indexing strategies

Lab - 9

Lab - 9

Who is the instructor for this training?

The trainer for this Greenplum Administrator Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Greenplum Administrator Training - Certification & Exam

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

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