Pivotal Certified Greenplum Administrator Training

Live Online & Classroom Certification Training

This course provides administrators with the necessary background to install and maintain the Greenplum database. Students will learn the essential skills required to use the Greenplum database system. The 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
  • 11
    Sep
    12 Days
    Online, 11-Sep to 23-Sep (Monday - Saturday), LVC (08:30 PM Start) ₹89,950.00  Early Bird Offer: ₹84,950.00

Course Description

Overview

This course provides administrators with the necessary background to install and maintain the Greenplum database. Students will learn the essential skills required to use the Greenplum database system. The 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.

Objective

At the end of the training, students will 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

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 - 4 Days

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.

 

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

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

 

Purchase Exam

Resources

SpringPeople Corporate Learning Center

Job Trends

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

Debashish Maity

Program Architect
Mindtree
Course:
Instructor:
Course Material:
Class Experience:
Provide the latest exercise, classroom guides as current hands outs are old ones and not matching / consistent with class session.

SPRINGPEOPLE SpringPeople Trainer

Ritabrata Chakraborty

Application Development Team Lead
Accenture
Course:
Instructor:
Course Material:
Class Experience:
Kindly include some part of Anypoint-MQ this course.

SPRINGPEOPLE SpringPeople Trainer

Bidyut

Course:
Instructor:
Course Material:
Class Experience:
No comments as of now

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

Request Call Back

Related Courses

Recently Viewed