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
Greenplum Fundamentals
- Understanding MPP database concepts and Greenplum’s architectural design
- Distinguishing Greenplum from PostgreSQL: primary architectural differences
- Identifying optimal use cases and integration opportunities
Installation Planning and Preparation
- Defining system requirements and verifying prerequisites
- Designing cluster topology and networking structures
- Configuring disks and applying performance optimization best practices
Deploying Greenplum
- Setting up Greenplum Database on Linux systems
- Configuring master and segment instances for optimal operation
- Initializing the cluster and conducting installation verification
Core Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
- Operating the Greenplum Command Center for management tasks
- Managing user roles, resource queues, and workload distribution
System Updates and Patch Management
- Grasping Greenplum versioning schemes and lifecycles
- Implementing safe patching strategies within defined maintenance windows
- Executing rolling upgrades and managing backup procedures
Library and Extension Governance
- Managing PL/Java, PL/Python, and other associated libraries
- Installing extensions via gpkg and the CREATE EXTENSION command
- Resolving dependencies and handling library updates
Monitoring, Logging, and Diagnostics
- Leveraging performance monitoring tools and key metrics
- Analyzing logs to identify and diagnose errors
- Addressing common operational issues with effective resolution strategies
Recap and Future Learning Paths
Requirements
- A solid grasp of database principles and SQL language
- Proficiency in Linux system administration
- Prior knowledge of PostgreSQL is advantageous
Target Audience
- Database administrators
- System administrators
- DevOps and platform engineers
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.