Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • Overview of MPP databases and Greenplum's architectural design
  • Key distinctions between Greenplum and PostgreSQL
  • Applicable use cases and integration scenarios

Installation Planning and Preparation

  • Defining system requirements and prerequisites
  • Designing cluster topology and networking
  • Disk configuration strategies and performance best practices

Installing Greenplum

  • Deploying Greenplum Database on Linux systems
  • Configuring master and segment instances
  • Initializing the cluster and validating the installation

Greenplum Administration Fundamentals

  • Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
  • Operating 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 backup requirements

Library and Extension Management

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

Monitoring, Logging, and Troubleshooting

  • Leveraging performance monitoring tools and metrics
  • Analyzing logs and diagnosing system errors
  • Addressing common issues and applying resolution strategies

Summary and Next Steps

Requirements

  • A solid grasp of database concepts and SQL
  • Hands-on experience with Linux system administration
  • Prior familiarity with PostgreSQL is advantageous

Target Audience

  • Database administrators
  • System administrators
  • DevOps and platform engineers

Number of participants


Price per participant (excl. VAT)

Testimonials (3)

Upcoming Courses

Related Categories