Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • Overview of MPP database technologies and Greenplum’s architectural design.
  • Distinguishing features: Greenplum versus PostgreSQL.
  • Typical applications and integration pathways.

Planning and Preparing for Deployment

  • Reviewing system requirements and prerequisites.
  • Designing cluster topology and network configurations.
  • Optimizing disk setup and adhering to performance standards.

Installing Greenplum

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

Fundamentals of Greenplum Administration

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

Managing System Updates and Patches

  • Comprehending Greenplum versioning strategies.
  • Implementing safe patching methods and scheduling maintenance windows.
  • Executing rolling upgrades and managing backup requirements.

Library and Extension Administration

  • Managing libraries including PL/Java, PL/Python, and others.
  • Deploying extensions via gpkg and the CREATE EXTENSION command.
  • Handling dependencies and updating library components.

Monitoring, Logging, and Troubleshooting

  • Leveraging performance monitoring tools and key metrics.
  • Analyzing logs to identify and resolve errors.
  • Addressing common operational issues and implementing fixes.

Recap and Future Pathways

Requirements

  • Solid grasp of database principles and SQL.
  • Practical experience in Linux system administration.
  • Prior knowledge of PostgreSQL is advantageous.

Target Audience

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

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories