Get in Touch

Course Outline

Introduction to Greenplum

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

Planning and Installation Preparation

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

Installing Greenplum

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

Fundamentals of Greenplum Administration

  • Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
  • Operating the Greenplum Command Center
  • Managing user roles, resource queues, and workload control

System Updates and Patching

  • Comprehending Greenplum versioning schemes
  • Implementing safe patching strategies and scheduling maintenance windows
  • Performing rolling upgrades and considering backup protocols

Managing Libraries and Extensions

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

Monitoring, Logging, and Troubleshooting

  • Employing performance monitoring tools and tracking key metrics
  • Analyzing logs to diagnose errors effectively
  • Addressing common issues and applying resolution strategies

Conclusion and Future Steps

Requirements

  • A solid grasp of fundamental database concepts and SQL
  • Proficiency in Linux system administration
  • Prior knowledge of 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