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
- Insights into MPP databases and the Greenplum architecture.
- Distinguishing between Greenplum and PostgreSQL: key architectural differences.
- Exploring primary use cases and integration scenarios.
Planning and Preparation for Installation
- Reviewing system requirements and prerequisites.
- Defining cluster topology and networking requirements.
- Best practices for disk configuration and performance optimisation.
Installing Greenplum
- Deploying Greenplum Database on Linux systems.
- Configuring master and segment instances.
- Initialising the cluster and validating the installation.
Core Greenplum Administration
- Utilising core utilities such as gpstart, gpstop, and gprecoverseg.
- Navigating the Greenplum Command Center.
- Managing user roles, resource queues, and workload distribution.
System Updates and Patching
- Understanding Greenplum versioning and release cycles.
- Implementing safe patching strategies and scheduling maintenance windows.
- Executing rolling upgrades while managing backup requirements.
Library and Extension Management
- Leveraging and managing libraries like PL/Java and PL/Python.
- Installing extensions using gpkg and the CREATE EXTENSION command.
- Managing library dependencies and applying updates.
Monitoring, Logging, and Troubleshooting
- Utilising performance monitoring tools and key metrics.
- Analysing logs to diagnose and resolve errors.
- Addressing common issues with effective resolution strategies.
Recap and Further Learning
Requirements
- A solid grasp of database fundamentals and SQL.
- Practical experience in Linux system administration.
- Prior knowledge of 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.
