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
- Fundamentals of MPP databases and the Greenplum architectural model.
- Distinguishing Greenplum from PostgreSQL: key architectural and functional differences.
- Identifying suitable use cases and integration opportunities.
Installation Planning and Preparation
- Reviewing system requirements and essential prerequisites.
- Defining cluster topology and networking configurations.
- Optimizing disk configuration and adhering to performance best practices.
Installing Greenplum
- Deploying the Greenplum Database on Linux platforms.
- Setting up master and segment instances.
- Initializing the cluster and conducting installation verification checks.
Fundamentals of Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
- Operating the Greenplum Command Center for operational insights.
- Implementing user roles, resource queues, and workload management policies.
System Updates and Patch Management
- Navigating Greenplum versioning strategies.
- Executing safe patching protocols and scheduling maintenance windows.
- Performing rolling upgrades while ensuring backup integrity.
Managing Libraries and Extensions
- Leveraging PL/Java, PL/Python, and other scripting libraries.
- Deploying extensions via gpkg and the CREATE EXTENSION command.
- Overseeing library dependencies and update cycles.
Monitoring, Logging, and Troubleshooting
- Employing performance monitoring tools and analyzing key metrics.
- Analyzing logs to identify and diagnose system errors.
- Addressing common operational issues with effective resolution strategies.
Summary and Future Steps
Requirements
- Solid grasp of fundamental database concepts and SQL syntax.
- Proven experience in Linux system administration.
- Prior familiarity with PostgreSQL is recommended but not mandatory.
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.