Get in Touch

Course Outline

Introduction to Greenplum

  • Concepts of MPP databases and the Greenplum architecture
  • Distinct differences between Greenplum and PostgreSQL
  • Typical use cases and integration patterns

Preparation and Planning for Deployment

  • Hardware requirements and pre-installation checks
  • Cluster topology design and network configuration
  • Disk setup strategies and performance optimization tips

Installing Greenplum

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

Fundamentals of Greenplum Administration

  • Utilizing core commands such as gpstart, gpstop, and gprecoverseg
  • Leveraging the Greenplum Command Center for management
  • Managing user roles, resource queues, and workload distribution

Managing System Updates and Patches

  • Comprehending Greenplum versioning schemes
  • Implementing safe patching strategies and scheduling maintenance
  • Executing rolling upgrades and managing backups

Managing Libraries and Extensions

  • Utilizing and administering PL/Java, PL/Python, and similar libraries
  • Deploying extensions via gpkg and the CREATE EXTENSION command
  • Overseeing library dependencies and applying updates

Monitoring, Log Analysis, and Problem Solving

  • Applying performance monitoring tools and interpreting metrics
  • Analyzing logs to identify and diagnose errors
  • Addressing common operational issues and resolution techniques

Recap and Recommended Next Steps

Requirements

  • Solid grasp of database fundamentals and SQL
  • Background in Linux system administration
  • Proficiency with PostgreSQL is recommended

Target Audience

  • Database Administrators (DBAs)
  • System Administrators
  • DevOps and Platform Engineers
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories