GREENPLUM 101
Get Greenplum Started With These Resources
Introduction to Greenplum

What is Greenplum?
1.5 minutes
Greenplum Fundamentals
Marshall Presser, 15 minutes
Hello Greenplum
Bradford Boyle, 40 minutes
The Origin of Greenplum Database
Ivan Novick, Scott Yara, Luke Lonergan, 15 minutes
Greenplum Tutorial for Beginners
Ivan Novick, 100 minutes

About the Greenplum Architecture
greenplum.org, Doc
Greenplum 5: Proven, Open-Source, Multi-Cloud Data Analytics Platform
Jacque Istok, 20 minutes
Introducing Greenplum 5
Ivan Novick, 35 minutes
Greenplum Roadmap Update 2019,
Ivan Novick, 1 hour

Data Warehousing With Greenplum,
Marshall Presser, e-Book
What is a Data Warehouse?
Scaling Postgres For Analytics
Jacque and Ivan Interview about Greenplum 1 hr
Greenplum Usage and DBA Skills

What It Means to be a Massively Parallel PostgreSQL DBA
Pravin Rao and Randy Willard, 30 minutes

About Redundancy and Failover in Greenplum Database
greenplum.org, Doc

Starting and Stopping Greenplum Database
greenplum.org, Doc
Greenplum psql Client
Michael Goddard, 20 minutes
Greenplum Data Definition Language
Michael Goddard, 30 minutes
Greenplum Storage Consideration
Michael Goddard, 30 minutes
Understanding Data Distribution with Pivotal Greenplum
Dr. Venkatesh Raghavan, 12 minutes

Distribution and Skew
greenplum.org, Doc
Greenplum Polymorphic Storage: Row and Columnar Orientation
Keaton Adams, 4 minutes

Default Storage Options
Pivotal Guru, Blog
Greenplum Table Compression: On-premises or in the Cloud
Keaton Adams, 10 minutes
Greenplum Database SQL Joins: Overview and Demo
Michael Goddard 20 minutes
Greenplum Database, mixed local data and remote hdfs data as a single table
Scott Kahler, 7 minutes

Going Beyond Structured Data with Pivotal Greenplum
Derek Comingore, Blog

Using Resource Groups
greenplum.org
Optimizing Performance of Greenplum
Yon Lew, 1 hour

Backup and Restore Overview
greenplum.org

Configuring Client Authentication, greenplum.org
greenplum.org

Creating and Managing Databases
greenplum.org

Creating and Managing Schemas
greenplum.org
How to Integrate Greenplum with Hadoop, Spark, and GemFire
Kong Chan, 40 minutes

Introduction to PXF
greenplum.org

Accessing Hadoop with PXF
greenplum.org

Accessing Azure, Google Cloud Storage, Minio, and S3 Object Stores with PXF
greenplum.org, Doc

Accessing an SQL Database with PXF (JDBC)
greenplum.org, Doc

Loading Data with gpload
greenplum.org

Altered States: Greenplum Alter Table Command
Howard Goldberg, Blog
Greenplum SQL ANALYST


Using Indexes in Greenplum Database
greenplum.org, Doc

About GPORCA
greenplum.org, Doc

WITH Queries
greenplum.org, Doc

Working with JSON data
greenplum.org, Doc

High Concurrency, Low Latency Index Lookups with Pivotal Greenplum Database
Gianluca Rossetti, Blog
Greenplum Advanced Analytics

Machine Learning, Graph, Text, Geospatial Analytics on Greenplum
Frank McQuillan and Bharath Sitaraman, 40 minutes
Geospatial Analytics at Massive Scale
Ivan Novick, 1 hour
Introducing Pivotal Greenplum GPText 3.0
Bharath Sitaraman, 15 minutes
Analytics for Synthetic Fraud
Bob Glithero, 10 minutes
Greenplum for Insider Threats – Lateral Movement Detection
Bob Glithero, 3 minutes
Running R Data Science Workloads in Greenplum
Woo Jung, 1 hour
Neural Networks on Greenplum with Apache MADlib
Frank McQuillan, 3 minutes
Deep Learning with Greenplum
Frank McQuillan, 35 minutes
Pivotal Greenplum PL/Container
Jack Wu, 35 minutes

The MADlib Analytics Library or MAD Skills, the SQL
Joe Hellerstein, Article

Greenplum Advanced Analytics Course, 200 slides on Graph, Geo, Python, Time Series, and Text
greenplum.org, ppt

Github for Greenplum Advanced Analytics Course, sample queries for course above
Github
Greenplum Deployment Considerations

So you want to build a Greenplum?
Scott Kahler, 1 hour
Greenplum Deployment In The Wild
Jacque Istok, 1 hour
Introduction to Greenplum Building Blocks (Dell Technologies)
Jacque Istok, 10 minutes
Greenplum for Kubernetes: Bringing Cloud Databases On-Prem
Oz Basarir, 5 minutes
Pivotal Greenplum in Action on AWS, Azure, and Google Cloud Platform
Jon Roberts, 20 minutes
Greenplum on Azure Marketplace: Deployment
Jon Roberts, 2 minutes
Greenplum on AWS Marketplace: Deployment
Jon Roberts, 4 minutes
Netezza to Greenplum: The Easiest, Quickest and Best Migration
Jacque Istok, 20 minutes

Install Greenplum OSS on Ubuntu
Ivan Novick, Web
Greenplum Internals


About Greenplum Query Processing
greenplum.org
Understanding the internals of GPORCA Optimizer
Xin Zhang, 1 hour

Orca: A Modular Query Optimizer Architecture for Big Data
Mohamed A. Soliman, pdf
Getting Your Greenplum Environment

Cloud Marketplaces Versions
AWS Deployment
AWS
Self healing
AWS
Snapshots for HA / DR
AWS

Open Source Version
Google Cloud Platform

gpsnap create (coming soon)
Google Cloud Platform

gpsnap restore (coming soon)
Google Cloud Platform
Azure Deployment
Azure
gpsnap create
Azure
gpsnap restore
Azure
gpoptional
Utilities for All Cloud Marketplaces
gprelease
Utilities for All Cloud Marketplaces
Copyright © 2023 VMware, Inc. or its affiliates. All Rights Reserved.
Your California Privacy Rights
Cookie Settings
Code of Conduct Trademark Guidelines
Terms of Use Privacy Policy
Log In