Pivotal Greenplum Developer

Live Online & Classroom Certification Training

Get Pivotal Greenplum Developer certification gives you a essential skills to use the Greenplum database system. Get introduced to fundamental concepts using the psql CLI; DDL, DML, and DQL; data loading strategies; data modeling, OLAP capabilities of the Greenplum database as well as some performance tuning strategies.

(0.0)
Instructed by SPRINGPEOPLE
INDIA

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

Course Description

Overview

Gain in-dept knowledge on Greenplum database features, benefits, and architecture in terms of shared nothing and the MPP design and how Greenplum database supports redundancy and high availability. Be proficient with DDL, DML, and DQL to access, manage, and query data. With our Hands-on gain experience on how to Implement appropriate table storage models, compression, and tablespaces.

Distribute and store data in Greenplum database using a distribution key and partitioning. Learn the best practices for data loading and table partitioning and get in-sights on to improve query performance and perform complex OLAP queries using built-in functions, window functions, user defined types, and user defined functions.

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

Objective

Upon successful completion of this course, you should be able to:

  • Describe Greenplum database features, benefits, and architecture in terms of shared nothing and the MPP design and how Greenplum database supports redundancy and high availability
  • Be proficient with DDL, DML, and DQL to access, manage, and query data
  • Implement appropriate table storage models, compression, and tablespaces
  • Distribute and store data in Greenplum database using a distribution key and partitioning
  • Understand best practices for data loading and table partitioning
  • Be proficient in data modeling and physical design decisions
  • Improve query performance:
    • Understanding the Pivotal Query Optimizer
    • SQL joins 0 Query profiling 
    • Query tuning and rewriting
    • Indexing strategies
  • Perform complex OLAP queries using built-in functions, window functions, user defined types, and user defined functions

Duration:

  • Classroom - 3 Days
  • Live Online - 18 Hours 

Suggested Audience:

  • Application developers responsible for designing and developing the Greenplum database

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
  • Overview
  • psql CLI utility
  • Implementing table storage models, compression, and tablespaces
  • Data loading
  • Table partitioning
  • Data modeling in Greenplum
  • Physical design decisions
  • Pivotal Query Optimizer
  • SQL joins: types and implementation
  • Query profiling
  • Query tuning and rewriting
  • Indexing strategies
  • Window functions
  • Built-in functions
  • User defined functions
  • User defined types

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 official training partners of Pivotal. This course is aligned to Pivotal Greenplum Developer 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

Click here to purchase the exam

Recommended Certification Path

  • Complete the Pivotal Greenplum Administrator course or the Pivotal Greenplum Developer course 
  • Take the proctored Pivotal Greenplum Developer Certification exam

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

  • Describing Greenplum features, benefits, and architecture.
  • DDL, DML, and DQL to access, manage, and query data.
  • Implementing appropriate table storage models, compression, and tablespaces.
  • Distributing and storing data in Greenplum using a distribution key and partitioning.
  • Best practices for data loading and table partitioning.
  • Data modeling and physical design decisions.
  • Improving query performance (understanding the Pivotal Query Optimizer, SQL joins, query profiling, query tuning and rewriting, and indexing strategies).
  • Performing complex OLAP queries using built-in functions, window functions, user defined types, and user defined functions.

 Exam Foramt:

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

Upon successful completion of exam, you will receive an electronic certificate and Pivotal does not provide Hard Copies of certificates.

Resources

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

0.0

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

SPRINGPEOPLE SpringPeople Trainer

Ashok Reddy

Course:
Instructor:
Course Material:
Class Experience:
It goog if we get real time scenarios for automation

SPRINGPEOPLE SpringPeople Trainer

Goutham

Course:
Instructor:
Course Material:
Class Experience:
Maybe you could set Scala as a prerequisite for this course and discuss more technical details of Spark like what happens under the hood

SPRINGPEOPLE SpringPeople Trainer

Vamshi Suram

Software Engineer 2
Intuit
Course:
Instructor:
Course Material:
Class Experience:
Content is good. Could have added additional links to good resources to proceed further.

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

Recently Viewed