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 the specific architecture of Greenplum
- Distinguishing Greenplum from standard PostgreSQL: key architectural differences
- Exploring typical use cases and integration scenarios
Planning and Preparation for Installation
- Identifying system requirements and meeting prerequisites
- Designing cluster topology and networking structures
- Optimizing disk configuration and adhering to performance best practices
Installing Greenplum
- Deploying the Greenplum Database on Linux systems
- Setting up master and segment instances
- Initializing the cluster and validating the successful installation
Fundamentals of Greenplum Administration
- Utilizing core administrative tools such as gpstart, gpstop, and gprecoverseg
- Interacting with the Greenplum Command Center for administrative tasks
- Managing user roles, resource queues, and overall workload distribution
Managing System Updates and Patches
- Grasping Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance windows
- Executing rolling upgrades while considering backup requirements
Library and Extension Oversight
- Utilizing and administering libraries such as PL/Java and PL/Python
- Installing extensions using gpkg and the CREATE EXTENSION command
- Handling library dependencies and managing their updates
Monitoring, Logging, and Problem Resolution
- Employing performance monitoring tools and tracking key metrics
- Analyzing logs to identify and diagnose errors effectively
- Addressing common operational issues and applying resolution strategies
Conclusion and Future Directions
Requirements
- A solid grasp of fundamental database concepts and SQL syntax
- Practical experience in Linux system administration
- Prior familiarity with PostgreSQL is advantageous
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.