Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • An overview of MPP databases and Greenplum's architectural design
  • Key distinctions between Greenplum and PostgreSQL
  • Use cases and potential integration scenarios

Installation Planning and Preparation

  • System requirements and necessary prerequisites
  • Cluster topology and network configurations
  • Disk setup and performance optimization best practices

Greenplum Installation

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

Fundamental Greenplum Administration

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

System Updates and Patching

  • Understanding Greenplum versioning schemes
  • Safe patching strategies and defining maintenance windows
  • Rolling upgrades and backup considerations

Library and Extension Management

  • Managing libraries such as PL/Java, PL/Python, and others
  • Installing extensions using gpkg and the CREATE EXTENSION command
  • Handling library dependencies and updates

Monitoring, Logging, and Troubleshooting

  • Performance monitoring tools and key metrics
  • Interpreting logs and diagnosing errors
  • Common issues and strategies for resolution

Summary and Next Steps

Requirements

  • A solid grasp of database fundamentals and SQL
  • Practical experience in Linux system administration
  • Knowledge of PostgreSQL is beneficial

Target Audience

  • Database administrators
  • System administrators
  • DevOps and platform engineers

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories