Greenplum 101: Getting Started

In the Greenplum community, we really believe in the power of education. Below you will find a number of resources that will increase your knowledge and understanding of the Greenplum Database. Enjoy!

INTRODUCTION TO GREENPLUM

  1. What is Greenplum, Scott Kahler, 10 minutes
  2. Greenplum Fundamentals Video, Marshall Presser, 15 minutes
  3. Hello Greenplum, Bradford Boyle, 40 minutes
  4. The Origin of Greenplum Database, Ivan Novick, Scott Yara, Luke Lonergan, 15 minutes
  5. About the Greenplum Architecture, greenplum.org
  6. Greenplum 5: Proven, Open-Source, Multi-Cloud Data Analytics Platform, Jacque Istok, 20 minutes
  7. Introducing Greenplum 5, Ivan Novick, 35 minutes
  8. Greenplum Roadmap Update 2019, Ivan Novick, 1 hour
  9. Data Warehousing With Greenplum, Marshall Presser, e-Book

GREENPLUM USAGE AND DBA SKILLS

  1. What It Means to be a Massively Parallel PostgreSQL DBA, Pravin Rao and Randy Willard, 30 minutes
  2. About Redundancy and Failover in Greenplum Database, greenplum.org
  3. Starting and Stopping Greenplum Database, greenplum.org
  4. Greenplum psql Client, Michael Goddard, 20 minutes
  5. Greenplum Data Definition Language, Michael Goddard, 30 minutes
  6. Greenplum Data Manipulation Language (DML), Michael Goddard, 30 minutes
  7. Greenplum Storage Consideration, Michael Goddard, 30 minutes
  8. Understanding Data Distribution with Pivotal Greenplum, Dr. Venkatesh Raghavan, 12 minutes
  9. Distribution and Skew, greenplum.org
  10. Greenplum Polymorphic Storage: Row and Columnar Orientation, Keaton Adams, 4 minutes
  11. Default Storage Options, Pivotal Guru
  12. Greenplum Table Compression: On-premises or in the Cloud, Keaton Adams, 10 minutes
  13. Greenplum Database SQL Joins: Overview and Demo, Michael Goddard 20 minutes
  14. Greenplum Database, mixed local data and remote hdfs data as a single table, Scott Kahler, 7 minutes
  15. Going Beyond Structured Data with Pivotal Greenplum, Derek Comingore
  16. Using Resource Groups, greenplum.org
  17. Optimizing Performance of Greenplum, Yon Lew, 1 hour
  18. Backup and Restore Overview, greenplum.org
  19. Configuring Client Authentication, greenplum.org
  20. Creating and Managing Databases, greenplum.org
  21. Creating and Managing Schemas, greenplum.org
  22. How to Integrate Greenplum with Hadoop, Spark, and GemFire, Kong Chan, 40 minutes
  23. Introduction to PXF, greenplum.org
  24. Accessing Hadoop with PXF, greenplum.org
  25. Accessing Azure, Google Cloud Storage, Minio, and S3 Object Stores with PXF, greenplum.org
  26. Accessing an SQL Database with PXF (JDBC), greenplum.org
  27. Loading Data with gpload, greenplum.org
  28. Altered States: Greenplum Alter Table Command, Howard Goldberg

GREENPLUM SQL ANALYST

  1. Using Indexes in Greenplum Database, greenplum.org
  2. About GPORCA, greenplum.org
  3. WITH Queries, greenplum.org
  4. Working with JSON data, greenplum.org
  5. High Concurrency, Low Latency Index Lookups with Pivotal Greenplum Database, Gianluca Rossetti

GREENPLUM ADVANCED ANALYTICS

  1. Machine Learning, Graph, Text, Geospatial Analytics on Greenplum, Frank McQuillan and Bharath Sitaraman, 40 minutes
  2. Geospatial Analytics at Massive Scale, Ivan Novick, 1 hour
  3. Introducing Pivotal Greenplum GPText 3.0, Bharath Sitaraman, 15 minutes
  4. Analytics for Synthetic Fraud, Bob Glithero, 10 minutes
  5. Greenplum for Insider Threats – Lateral Movement Detection, Bob Glithero, 3 minutes
  6. Running R Data Science Workloads in Greenplum, Woo Jung, 1 hour
  7. Neural Networks on Greenplum with Apache MADlib, Frank McQuillan, 3 minutes
  8. Deep Learning with Greenplum, Frank McQuillan, 35 minutes
  9. Pivotal Greenplum PL/Container, Jack Wu, 35 minutes
  10. The MADlib Analytics Library or MAD Skills, the SQ, Joe Hellerstein

GREENPLUM DEPLOYMENT CONSIDERATIONS

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

GREENPLUM INTERNALS

  1. About Greenplum Query Processing, greenplum.org
  2. Understanding the internals of GPORCA Optimizer, Xin Zhang, 1 hour
  3. Orca: A Modular Query Optimizer Architecture for Big Data, Mohamed A. Soliman

GETTING YOUR GREEPLUM ENVIRONMENT

Open Source Version

Cloud Marketplaces Versions

  • Google Cloud Platform