Greenplum Developer Training Logo

Greenplum Developer Training

Live Online & Classroom Enterprise 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.

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Greenplum Developer Training about?

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.

What are the objectives of Greenplum Developer Training ?

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

Who is Greenplum Developer Training for?

Application developers responsible for designing and developing the Greenplum database.

What are the prerequisites for Greenplum Developer 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

  • Overview
  • psql CLI utility
  • DDL, DML, DQL
  • 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

Who is the instructor for this training?

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

Course Logo

Greenplum Developer Training - Certification & Exam

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.

Reviews