Get in Touch

Course Outline

Greenplum Fundamentals

  • Introduction to MPP databases and the Greenplum architectural design
  • Distinguishing Greenplum from standard PostgreSQL: critical differences
  • Ideal use cases and integration opportunities

Pre-Installation Planning and Preparation

  • Defining system requirements and verifying prerequisites
  • Designing cluster topology and networking configurations
  • Optimizing disk layout and adhering to performance best practices

Deploying Greenplum

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

Core Greenplum Administration

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

Managing System Updates and Patches

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

Library and Extension Governance

  • Leveraging and administering PL/Java, PL/Python, and additional libraries
  • Deploying extensions via gpkg and the CREATE EXTENSION command
  • Resolving dependencies and updating library components

Surveillance, Logging, and Diagnostics

  • Utilizing performance monitoring tools and interpreting key metrics
  • Analyzing logs to identify and resolve errors
  • Addressing common operational challenges and remediation tactics

Course Conclusion and Forward-Looking Actions

Requirements

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