Get in Touch

Course Outline

Introduction to Greenplum

  • An overview of MPP databases and the Greenplum architectural design
  • Differentiating Greenplum from PostgreSQL: key distinctions
  • Typical use cases and integration scenarios

Installation Planning and Preparation

  • Defining system requirements and prerequisites
  • Designing cluster topology and networking structures
  • Optimizing disk configuration and performance best practices

Installing Greenplum

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

Fundamental Greenplum Administration

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

System Updates and Patch Management

  • Navigating Greenplum versioning schemes
  • Implementing safe patching strategies and defining maintenance windows
  • Executing rolling upgrades and managing backup considerations

Library and Extension Administration

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

Monitoring, Logging, and Troubleshooting

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

Summary and Future Directions

Requirements

  • A solid grasp of fundamental database concepts and SQL
  • Practical experience in Linux system administration
  • Existing knowledge of PostgreSQL is beneficial

Target Audience

  • Database Administrators
  • System Administrators
  • DevOps and Platform Engineers
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories