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