Get in Touch

Course Outline

Introduction to Greenplum

  • Overview of MPP databases and Greenplum architecture
  • Greenplum vs. PostgreSQL: significant distinctions
  • Typical use cases and integration scenarios

Planning and Preparing for Installation

  • System requirements and preconditions
  • Cluster topology and network design
  • Disk setup and performance optimization best practices

Installing Greenplum

  • Deploying 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
  • Secure patching strategies and maintenance scheduling
  • Rolling upgrades and backup strategies

Managing Libraries and Extensions

  • Working with PL/Java, PL/Python, and other libraries
  • Installing extensions via gpkg and CREATE EXTENSION
  • Handling library dependencies and updates

Monitoring, Logging, and Troubleshooting

  • Performance monitoring tools and key metrics
  • Log analysis and error diagnosis
  • Common pitfalls and resolution approaches

Wrap-up and Future Directions

Requirements

  • Solid grasp of database fundamentals and SQL
  • Proficiency in Linux system administration
  • Prior experience 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