Piovtal Greenplum Administrator

Live Online & Classroom Certification Training

Master the skills to administer the Greenplum database. Internalize and practice using the psql CLI, DDL, DML, and DQL, data loading, backup, restore, data modeling and performance tuning strategies for the Greenplum data warehouse.

(4.7) 193 Learners
Instructed by SPRINGPEOPLE
INDIA
  • 30
    Oct
    12 Days
    Online, 30-Oct to 11-Nov (Monday - Saturday), LVC (08:30 PM Start) ₹89,950.00  Early Bird Offer: ₹84,950.00

Course Description

Overview

This training has been designed to impart an in-depth and hands-on experience to administer the Greenplum database and datawarehouse. Accelerate your learning curve and internalize best practices as you learn and work with our industry expert for this certified training. Practice assignments and projects on our cloudlabs to be Greenplum ready.

This course serves as a prerequisite for the Pivotal Greenplum Administrator Certification exam. The certification fee is not included as part of the training fee. The exam vouchers can be availed through SpringPeople.

 Suggested Audience

Aspiring administrators intending to install and maintain the Greenplum database and data warehouse

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

Duration

Instructor Led Training - 24 hrs

Prerequisites

Exposure to basic UNIX or Linux command-line navigation, database query language basics, fundamental relational database concepts is recommended.

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.

 

Get certified by the Pivotal Academy as a part of this official training. SpringPeople is the official training partner for Pivotal to get professionals and organizations Pivotal ready. Be equipped to take the proctored Pivotal Cloud Foundry Administrator Certification exam. The certification fee is not included as part of the training fee. The exam vouchers can be availed through SpringPeople.

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

Mridhul

Devops
Course:
Instructor:
Course Material:
Class Experience:
The trainer was pretty new to the training and the class was not helpful. Not at all recommended. Failed to satisfy my requirements

SPRINGPEOPLE SpringPeople Trainer

Satheesh Viswanathan

Course:
Instructor:
Course Material:
Class Experience:
As the course focuses more towards the certification, the difficulty level of the labs & exercises could have been increased.

SPRINGPEOPLE SpringPeople Trainer

Deepak Kodigepalli

Course:
Instructor:
Course Material:
Class Experience:
Wifi connectivity was a bit slow and were experiencing intermittent disconnects

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