Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • Fundamentals of MPP databases and the Greenplum architectural model.
  • Distinguishing Greenplum from PostgreSQL: key architectural and functional differences.
  • Identifying suitable use cases and integration opportunities.

Installation Planning and Preparation

  • Reviewing system requirements and essential prerequisites.
  • Defining cluster topology and networking configurations.
  • Optimizing disk configuration and adhering to performance best practices.

Installing Greenplum

  • Deploying the Greenplum Database on Linux platforms.
  • Setting up master and segment instances.
  • Initializing the cluster and conducting installation verification checks.

Fundamentals of Greenplum Administration

  • Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
  • Operating the Greenplum Command Center for operational insights.
  • Implementing user roles, resource queues, and workload management policies.

System Updates and Patch Management

  • Navigating Greenplum versioning strategies.
  • Executing safe patching protocols and scheduling maintenance windows.
  • Performing rolling upgrades while ensuring backup integrity.

Managing Libraries and Extensions

  • Leveraging PL/Java, PL/Python, and other scripting libraries.
  • Deploying extensions via gpkg and the CREATE EXTENSION command.
  • Overseeing library dependencies and update cycles.

Monitoring, Logging, and Troubleshooting

  • Employing performance monitoring tools and analyzing key metrics.
  • Analyzing logs to identify and diagnose system errors.
  • Addressing common operational issues with effective resolution strategies.

Summary and Future Steps

Requirements

  • Solid grasp of fundamental database concepts and SQL syntax.
  • Proven experience in Linux system administration.
  • Prior familiarity with PostgreSQL is recommended but not mandatory.

Target Audience

  • Database Administrators.
  • System Administrators.
  • DevOps and Platform Engineers.

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories