Course Outline

Introduction

Setting up Pivotal Greenplum

Overview of Pivotal Greenplum Features and Architecture

Accessing Data

  • DDL, DML, and DQL

Implementing a Table Storage Model

  • Understanding tablespaces
  • Compressing table data

Distributing the Data

  • Distribution keys and partitioning
  • Managing joins and indexing

Loading Data

  • Table partitioning

OLAP Querying

  • Implementing Greenplum functions

Modeling the Data

  • Physical design considerations

Expanding the System

  • Adding nodes
  • Migrating data

Monitoring a Greenplum system

  • Database activity and performance

Performance Tuning

  • Optimizing queries
  • Optimizing SQL joins
  • Indexing optimization

Greenplum Best Practices

Troubleshooting

Summary and Conclusiond

Requirements

  • An understanding of database concepts.

Audience

  • Developers
  21 Hours
 

Testimonials

Related Courses

Data Vault: Building a Scalable Data Warehouse

  28 hours

ClickHouse Fundamentals

  14 hours

SQLite Fundamentals

  14 hours

MongoDB Atlas Fundamentals

  14 hours

Monitoring Kubernetes with Prometheus

  7 hours

Prometheus Fundamentals

  14 hours

Distributed Data Processing and Storage with Hazelcast

  14 hours

Change Data Capture (CDC) with Debezium

  14 hours

Migrating Oracle to Azure SQL or PostgreSQL

  7 hours

Presto for Data Science

  14 hours

Cost Analysis with Presto COST IT Module

  14 hours

Mastering LINQ with C#

  14 hours

Firebase Fundamentals

  14 hours

Angular with Firebase and Firestore

  14 hours

Serverless Cloud Based Mobile and Web Development with Firebase

  28 hours