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
- Conceptual overview of MPP databases and Greenplum's architectural design.
- Differentiating features: Greenplum versus PostgreSQL.
- Identifying key use cases and integration scenarios.
Pre-Installation Planning and Preparation
- Defining system requirements and verifying prerequisites.
- Designing cluster topology and networking strategies.
- Optimizing disk configuration and adhering to performance best practices.
Installing Greenplum
- Deploying Greenplum Database on Linux systems.
- Configuring master and segment instances effectively.
- Initializing the cluster and validating the installation process.
Core Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
- Navigating the Greenplum Command Center interface.
- Managing user roles, resource queues, and workload allocation.
System Updates and Patch Management
- Navigating Greenplum versioning structures.
- Implementing safe patching strategies and scheduling maintenance windows.
- Executing rolling upgrades while considering backup integrity.
Managing Libraries and Extensions
- Utilizing and administering PL/Java, PL/Python, and other procedural languages.
- Installing extensions using gpkg and the CREATE EXTENSION command.
- Tracking dependencies and managing library updates.
Monitoring, Logging, and Troubleshooting
- Leveraging performance monitoring tools and interpreting key metrics.
- Analyzing logs to diagnose and resolve errors.
- Addressing common operational issues with effective resolution strategies.
Course Summary and Future Learning Paths
Requirements
- A solid grasp of fundamental database concepts and SQL language.
- Practical experience in Linux system administration.
- Prior familiarity with PostgreSQL, while beneficial, is not strictly mandatory.
Target Audience
- Database administrators.
- System administrators.
- DevOps and platform engineers.
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.