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
- Overview of MPP databases and Greenplum's architectural design
- Key distinctions between Greenplum and PostgreSQL
- Applicable use cases and integration scenarios
Installation Planning and Preparation
- Defining system requirements and prerequisites
- Designing cluster topology and networking
- Disk configuration strategies and performance best practices
Installing Greenplum
- Deploying Greenplum Database on Linux systems
- Configuring master and segment instances
- Initializing the cluster and validating the installation
Greenplum Administration Fundamentals
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
- Operating the Greenplum Command Center
- Managing user roles, resource queues, and workloads
System Updates and Patching
- Understanding Greenplum versioning schemes
- Implementing safe patching strategies and maintenance windows
- Executing rolling upgrades and considering backup requirements
Library and Extension Management
- Managing PL/Java, PL/Python, and other libraries
- Installing extensions using gpkg and the CREATE EXTENSION command
- Handling dependencies and library updates
Monitoring, Logging, and Troubleshooting
- Leveraging performance monitoring tools and metrics
- Analyzing logs and diagnosing system errors
- Addressing common issues and applying resolution strategies
Summary and Next Steps
Requirements
- A solid grasp of database concepts and SQL
- Hands-on experience with Linux system administration
- Prior familiarity with 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.