Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • Overview of MPP databases and Greenplum architecture.
  • Key differences between Greenplum and PostgreSQL.
  • Exploring use cases and integration scenarios.

Planning and Installation Preparation

  • Reviewing system requirements and prerequisites.
  • Designing cluster topology and networking.
  • Optimizing disk configuration and performance practices.

Installing Greenplum

  • Installing the Greenplum Database on Linux.
  • Configuring master and segment instances.
  • Initializing the cluster and verifying the installation.

Fundamentals of Greenplum Administration

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

System Updates and Patching

  • Understanding Greenplum versioning schemes.
  • Implementing safe patching strategies and maintenance windows.
  • Executing rolling upgrades and considering backups.

Library and Extension Management

  • Using and managing PL/Java, PL/Python, and other libraries.
  • Installing extensions using gpkg and CREATE EXTENSION.
  • Managing library dependencies and updates.

Monitoring, Logging, and Troubleshooting

  • Employing performance monitoring tools and metrics.
  • Interpreting logs and diagnosing errors.
  • Addressing common issues and applying resolution strategies.

Summary and Future Steps

Requirements

  • Solid understanding 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.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories