Get in Touch

Course Outline

Introduction to Greenplum

  • Overview of MPP databases and Greenplum's architecture.
  • Key distinctions between Greenplum and PostgreSQL.
  • Typical use cases and integration scenarios.

Installation Planning and Preparation

  • System requirements and prerequisites.
  • Cluster topology and networking considerations.
  • Disk configuration and performance optimization best practices.

Greenplum Installation

  • Installing the Greenplum Database on Linux.
  • Configuring master and segment instances.
  • Cluster initialization and installation verification.

Fundamentals of Greenplum Administration

  • Core utilities such as gpstart, gpstop, and gprecoverseg.
  • Utilizing the Greenplum Command Center.
  • Managing user roles, resource queues, and workloads.

System Updates and Patching

  • Understanding Greenplum versioning schemes.
  • Strategies for safe patching and defining maintenance windows.
  • Rolling upgrades and backup protocols.

Library and Extension Management

  • Utilizing and managing libraries such as PL/Java and PL/Python.
  • Installing extensions via gpkg and the CREATE EXTENSION command.
  • Managing library dependencies and updates.

Monitoring, Logging, and Troubleshooting

  • Performance monitoring tools and key metrics.
  • Log interpretation and error diagnosis.
  • Common issues and effective resolution strategies.

Summary and Next Steps

Requirements

  • Solid grasp of database concepts and SQL.
  • Proficiency in Linux system administration.
  • Familiarity with PostgreSQL is advantageous.

Target Audience

  • Database administrators.
  • System administrators.
  • DevOps and platform engineers.
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories