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 architecture
- Greenplum vs. PostgreSQL: significant distinctions
- Typical use cases and integration scenarios
Planning and Preparing for Installation
- System requirements and preconditions
- Cluster topology and network design
- Disk setup and performance optimization best practices
Installing Greenplum
- Deploying 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
- Secure patching strategies and maintenance scheduling
- Rolling upgrades and backup strategies
Managing Libraries and Extensions
- Working with PL/Java, PL/Python, and other libraries
- Installing extensions via gpkg and CREATE EXTENSION
- Handling library dependencies and updates
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and key metrics
- Log analysis and error diagnosis
- Common pitfalls and resolution approaches
Wrap-up and Future Directions
Requirements
- Solid grasp of database fundamentals and SQL
- Proficiency in Linux system administration
- Prior experience 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.