The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

Pivotal Greenplum Developer

  • Tuition USD $2,400
  • Reviews star_rate star_rate star_rate star_rate star_half 519 Ratings
  • Course Code GP-DEV
  • Duration 3 days
  • Available Formats Classroom

This course provides students with the necessary background to take advantage of Pivotal Greenplum. Participants will learn the essential skills to use the Greenplum database system. Students are introduced to fundamental concepts using the psql CLI; DDL, DML, and DQL; data loading strategies; data modeling, as well as some performance tuning strategies. Students will also learn details of the OLAP capabilities of the Greenplum database.

Skills Gained

  • 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 - 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 Can Benefit

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 Details

Course Modules

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, USER DEFINED FUNCTIONS

  • Window functions
  • Built-in functions
  • User defined functions
  • User defined types

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

Great experience with using the online training with Webcam and Zoom. It is as if I was there in the same classroom but in the comfort of my own setting.

I had a good and comfortable remote training experience. Look forward to more such trainings.

Michael was amazing! Answered all our questions and went above and beyond when we need it, definitively really nice and friendly course. I'm pleased with the knowledge he had. Finally, I have finished the course having learned new stuff. Thanks, Michael!

Great first experience with ExitCertified. I look forward to many more trainings.

Had great paid experiences, the free experience was not a waste of time, it provided the overview AWS that I needed to get started.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward