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

Angular with Firebase and Firestore

 14 hours

Firebase is a web application development platform. Firestore is a NoSQL database for storing, syncing, and querying data at scale. Users can use Firebase and Firestore while leveraging serverless architecture to build Angular applications. This

Firebase Fundamentals

 14 hours

This instructor-led, live training (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application.  By the end of this training, participants will be able to: Understand the

Serverless Cloud Based Mobile and Web Development with Firebase

 28 hours

This instructor-led, live training (online or onsite) is aimed at mobile and web developers who wish to use Firebase to build serverless cloud based Android, iOS or web applications. By the end of this training, participants will be able

ClickHouse Fundamentals

 14 hours

ClickHouse is an open-source columnar database management system (DBMS) for online analytical processing (OLAP). This instructor-led, live training (online or onsite) is aimed at developers and IT professionals who wish to set up, manage, and use

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Change Data Capture (CDC) with Debezium

 14 hours

Debezium is an open source distributed platform for capturing database changes. Debezium operates as a connector service between a database and applications that wish to process changes to the database. This instructor-led, live training (online

Hasura GraphQL Engine

 14 hours

Hasura GraphQL Engine is an open source product built for fast, secure, and scalable data access. It provides real-time GraphQL queries across data sources and efficient data transformations with Postgres. This instructor-led, live training

Distributed Data Processing and Storage with Hazelcast

 14 hours

Hazelcast is an open source in-memory data grid platform for distributed computing and data storage. It provides a scalable cluster for efficient workload handling and integration with data sources and cloud technologies.     This

Mastering LINQ with C#

 14 hours

C# is a multi-paradigm programming language encompassing object-oriented and component-oriented disciplines. LINQ (language integrated query) is a component that adds native data querying capabilities to programming languages. This

Migrating Oracle to Azure SQL or PostgreSQL

 7 hours

On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or

MongoDB Atlas Fundamentals

 14 hours

MongoDB Atlas is a multi-cloud database-as-a-service (DBaaS) platform. It simplifies the setup, operation, and management of MongoDB deployments in the cloud. This instructor-led, live training (online or onsite) is aimed at developers and

Presto for Data Science

 14 hours

Presto is a distributed query engine for big data analytics. Using Presto, users can natively query data, access data from multiple systems, and more. This instructor-led, live training (online or onsite) is aimed at data scientists who wish

Monitoring Kubernetes with Prometheus

 7 hours

This instructor-led, live training (online or onsite) is aimed at system administrators and developers who wish to use Prometheus to monitor Kubernetes clusters. By the end of this training, participants will be able to: Install and

Prometheus Fundamentals

 14 hours

Prometheus is an open source time series database for systems monitoring and alerting. It is decoupled from a larger infrastructure, making it a reliable tool to diagnose problems immediately during an outage. This instructor-led, live training

SQLite Fundamentals

 14 hours

SQLite is an open source serverless database for embedded applications that requires no configuration or administration. It is lightweight, efficient, and reliable, making it suitable for embedded devices and IoT. This instructor-led, live