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 the underlying Greenplum architecture.
- Distinguishing Greenplum from PostgreSQL: key architectural and functional differences.
- Exploring use cases and potential integration scenarios.
Planning and Preparation for Installation
- Reviewing system requirements and necessary prerequisites.
- Designing cluster topology and networking infrastructure.
- Optimizing disk configuration and adhering to performance best practices.
Greenplum Installation Process
- Deploying the Greenplum Database on a Linux environment.
- Configuring master and segment instances for optimal performance.
- Initializing the cluster and validating the installation integrity.
Foundational Greenplum Administration
- Utilizing core administrative tools such as gpstart, gpstop, and gprecoverseg.
- Operating within the Greenplum Command Center for system oversight.
- Managing user roles, resource queues, and workload distribution.
System Updates and Patching Strategies
- Understanding Greenplum versioning protocols.
- Implementing safe patching strategies and planning maintenance windows.
- Executing rolling upgrades while maintaining backup integrity.
Library and Extension Management
- Deploying and managing libraries such as PL/Java and PL/Python.
- Installing extensions via gpkg and the CREATE EXTENSION command.
- Managing library dependencies and coordinating updates.
Monitoring, Logging, and Troubleshooting
- Leveraging performance monitoring tools and key metrics.
- Analyzing logs and diagnosing system errors effectively.
- Addressing common operational issues with proven resolution strategies.
Summary and Future Directions
Requirements
- A solid grasp of fundamental database concepts and SQL.
- Practical experience in Linux system administration.
- Prior knowledge of PostgreSQL is beneficial.
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.