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
- An overview of MPP databases and the Greenplum architecture
- Greenplum vs. PostgreSQL: Understanding key distinctions
- Relevant use cases and integration scenarios
Planning and Preparation for Installation
- System requirements and essential prerequisites
- Designing cluster topology and networking strategies
- Disk configuration and performance optimisation best practices
Installing Greenplum
- Deploying Greenplum Database on Linux
- Configuring master and segment instances
- Initialising the cluster and validating the installation
Fundamentals of Greenplum Administration
- Utilising core tools such as gpstart, gpstop, gprecoverseg, and others
- Operating the Greenplum Command Center
- Managing user roles, resource queues, and workloads
Managing System Updates and Patches
- Navigating Greenplum versioning structures
- Implementing safe patching strategies and scheduling maintenance windows
- Executing rolling upgrades and managing backup considerations
Library and Extension Management
- Leveraging and administering libraries such as PL/Java, PL/Python, and others
- Installing extensions using gpkg and the CREATE EXTENSION command
- Maintaining library dependencies and applying updates
Monitoring, Logging, and Troubleshooting
- Deploying performance monitoring tools and tracking key metrics
- Analysing logs and diagnosing system errors
- Addressing common issues and implementing resolution strategies
Summary and Future Steps
Requirements
- A solid grasp of fundamental database concepts and SQL.
- Practical experience in Linux system administration.
- Prior familiarity with PostgreSQL is beneficial but not mandatory.
Target Audience
- Database administrators
- System administrators
- DevOps and platform engineers
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
