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
Key Features
  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

  • 100% Money Back Guarantee

PDP BG 1
SpringPeople Logo

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
Available Training Modes

Live Online Training

18 Hours

Classroom Training

 

3 Days
PDP BG 2

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

Course Outline

  • INTRODUCTION
    • Overview
    • psql CLI utility
  • DEFINING AND SECURING THE DATABASE
    • DDL, DML, DQL
  • DATA LOADING AND DISTRIBUTION
    • Implementing table storage models, compression, and tablespaces
    • Data loading
    • Table partitioning
  • DATA MODELING & DESIGN
    • Data modeling in Greenplum
    • Physical design decisions
  • PERFORMANCE ANALYSIS & TUNING
    • Pivotal Query Optimizer
    • SQL joins: types and implementation
    • Query profiling
    • Query tuning and rewriting
    • Indexing strategies
  • ONLINE ANALYTICAL PROCESSING, WINDOW FUNCTIONS
    • Window functions
    • Built-in functions
    • User defined functions
    • User defined types

Who is the instructor for this training?

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

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

... Read More

Reviews