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.
Duration 21 hours
Course Outline
Introduction to Greenplum
- An overview of MPP databases and Greenplum's architectural design
- Key distinctions between Greenplum and PostgreSQL
- Use cases and potential integration scenarios
Installation Planning and Preparation
- System requirements and necessary prerequisites
- Cluster topology and network configurations
- Disk setup and performance optimization best practices
Greenplum Installation
- Installing the Greenplum Database on a Linux system
- Configuring master and segment instances
- Cluster initialization and installation verification
Fundamental Greenplum Administration
- Core utilities including gpstart, gpstop, and gprecoverseg
- Utilizing the Greenplum Command Center
- Managing user roles, resource queues, and workloads
System Updates and Patching
- Understanding Greenplum versioning schemes
- Safe patching strategies and defining maintenance windows
- Rolling upgrades and backup considerations
Library and Extension Management
- Managing libraries such as PL/Java, PL/Python, and others
- Installing extensions using gpkg and the CREATE EXTENSION command
- Handling library dependencies and updates
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and key metrics
- Interpreting logs and diagnosing errors
- Common issues and strategies for resolution
Summary and Next Steps
Requirements
- A solid grasp of database fundamentals and SQL
- Practical experience in Linux system administration
- Knowledge of PostgreSQL is beneficial
Target Audience
- Database administrators
- System administrators
- DevOps and platform engineers
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.