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 architecture.
- Key differences between Greenplum and PostgreSQL.
- Exploring use cases and integration scenarios.
Planning and Installation Preparation
- Reviewing system requirements and prerequisites.
- Designing cluster topology and networking.
- Optimizing disk configuration and performance practices.
Installing Greenplum
- Installing the Greenplum Database on Linux.
- Configuring master and segment instances.
- Initializing the cluster and verifying the installation.
Fundamentals of Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
- Working with 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 backups.
Library and Extension Management
- Using and managing PL/Java, PL/Python, and other libraries.
- Installing extensions using gpkg and CREATE EXTENSION.
- Managing library dependencies and updates.
Monitoring, Logging, and Troubleshooting
- Employing performance monitoring tools and metrics.
- Interpreting logs and diagnosing errors.
- Addressing common issues and applying resolution strategies.
Summary and Future Steps
Requirements
- Solid understanding of database concepts and SQL.
- Proficiency in Linux system administration.
- 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.