Get trained to think big and think fast

Become productive and indispensable by getting the hands-on training you need to realize the promise of the Greenplum Database and the shared-nothing, massively parallel architecture that makes it the industry's fastest and most affordable high-end data warehousing solution.

Greenplum offers comprehensive education services to equip customers and partners with the knowledge and exposure to deliver maximum results in developing, administering, and optimizing Greenplum Database to suit a wide range of implementations. Each custom and catalog course enables customers and partners to spend time working with Greenplum Database deployed on a variety of hardware, and learn directly from experienced Greenplum technical resources.

Download course descriptions, schedule and pricing >

Or, for more information, Contact Greenplum Training >

Courses

Greenplum Fundamentals

This class is an introduction to Greenplum. Covered topics are Greenplum architecture and the MPP environment, data warehousing fundamentals, introduction to PostgreSQL, and an introduction to Greenplum and Unix. Students will be introduced to the UNIX interface (psql) and the Greenplum Data Dictionary.

Duration: 1 Day (8 hours)

Audience: Developers, Database Administrators, End Users

Prerequisites: SQL Experience (any RDBMS, PostgreSQL is helpful), Some UNIX Experience

Greenplum Advanced SQL and Tuning

This class is an advanced session that will take the student through a typical Greenplum implementation. The students will start with creating a Greenplum database on an already installed system, create databases, schemas and other database objects. Students will learn how to select load methodologies, optimize and tune queries through a connected series of hands-on labs. The end result of the class will be a highly tuned operational data mart.

• Review Greenplum “Shared Nothing” Architecture & Concepts
• By implementing a Greenplum Data Mart students will:
  • Create a Greenplum Database and Schemas
  • Evaluate Logical and Physical Data Models
  • Determine appropriate Distribution Keys and create tables
  • Determine and implement partitioning and indexing strategies
  • Determine and implement optimal load methodologies
• By fulfilling reporting requirements students will:
  • Be able to “Explain the Explain Plan”
  • Create and use statistics
  • Create detail and summary reports using OLAP functions
  • Create and use temporary tables
  • Write basic Postgres functions and create data types
  • Identify and optimize problem queries
    

Duration: 2 Days (16 hours)

Audience: Developers and Database Administrators

Format: Combination lecture and hands-on labs

Prerequisites:

• Greenplum Fundamentals Training Course
• Experience with Unix or Linux
• Experience with SQL (PostgreSQL is preferred)
• Experience with VI or EMACS
• Experience with Shell Scripting

Greenplum Administration

This class is centered around the installation, upgrade and maintenance of the Greenplum database system. The students will create a Greenplum instance, database and schemas. The class covers configuration settings at the database and operating system levels. Students will perform all essential database administration and monitoring tasks through hands-on labs for each class module. Database backup and recovery, workload management and access control are also taught.

• Hardware Considerations
• Installation and System Initialization
• PostgreSQL Client Programs (PSQL)
• Server Configuration
• Data Definition Language (DDL)
• Table Partitioning
• Roles, Privileges and Role-Based Resource Queues
• Data Loading
• Data Manipulation Language (DML) and Data Query Language (DQL)
• Performance Tuning
• System Administration
• Redundancy and High-Availability
• Backups and Restores
• Database Internals
• Greenplum Support

Audience: Database and System Administrators

Format: Lecture and Hands-on Labs

Pre-Requisites: Greenplum Fundamental

More Information

To get more information about Greenplum training in your area and to inquire about custom or on-site training at your facility in North America and EMEA, contact your

• Greenplum Sales representative, or
• contact Greenplum Training
  

The Fine Print

Greenplum training is available to individuals and companies in open-enrollment, public offerings, and custom or private offerings. In general tuition for open-enrollment courses is on a per student basis, with students responsible for their own travel and lodging. Custom and private offerings are offered on either a flat-rate or per-student basis, with additional charges for instructor travel, lodging and expenses.