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: key differences
- Use cases and integration scenarios
Planning and Preparing for Installation
- System requirements and prerequisites
- Cluster topology and networking
- Disk configuration and performance best practices
Greenplum Installation
- Installing Greenplum Database on Linux
- Configuring master and segment instances
- Initializing the cluster and verifying installation
Greenplum Administration Basics
- gpstart, gpstop, gprecoverseg and other core utilities
- Working with the Greenplum Command Center
- User roles, resource queues, and workload management
System Updates and Patching
- Understanding Greenplum versioning
- Safe patching strategies and maintenance windows
- Rolling upgrades and backup considerations
Library and Extension Management
- Using and managing PL/Java, PL/Python, and other libraries
- Installing extensions with gpkg and CREATE EXTENSION
- Managing dependencies and updates to libraries
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and metrics
- Interpreting logs and diagnosing errors
- Common issues and resolution strategies
Summary and Next Steps
Requirements
- An understanding of database concepts and SQL
- Experience with Linux system administration
- Familiarity with PostgreSQL is helpful
Audience
- Database administrators
- System administrators
- DevOps and platform engineers
21 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
It was quite hands-on, not too much theory.
David Lambaerts - Estee Lauder BV
Course - ORACLE PL/SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
