Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Greenplum
- Overview of MPP databases and Greenplum's architecture.
- Key distinctions between Greenplum and PostgreSQL.
- Typical use cases and integration scenarios.
Installation Planning and Preparation
- System requirements and prerequisites.
- Cluster topology and networking considerations.
- Disk configuration and performance optimization best practices.
Greenplum Installation
- Installing the Greenplum Database on Linux.
- Configuring master and segment instances.
- Cluster initialization and installation verification.
Fundamentals of Greenplum Administration
- Core utilities such as gpstart, gpstop, and gprecoverseg.
- Utilizing the Greenplum Command Center.
- Managing user roles, resource queues, and workloads.
System Updates and Patching
- Understanding Greenplum versioning schemes.
- Strategies for safe patching and defining maintenance windows.
- Rolling upgrades and backup protocols.
Library and Extension Management
- Utilizing and managing libraries such as PL/Java and PL/Python.
- Installing extensions via gpkg and the CREATE EXTENSION command.
- Managing library dependencies and updates.
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and key metrics.
- Log interpretation and error diagnosis.
- Common issues and effective resolution strategies.
Summary and Next Steps
Requirements
- Solid grasp of database concepts and SQL.
- Proficiency in Linux system administration.
- Familiarity with PostgreSQL is advantageous.
Target Audience
- Database administrators.
- System administrators.
- DevOps and platform engineers.
21 Hours
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.