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 database technologies and Greenplum’s architectural design.
- Distinguishing features: Greenplum versus PostgreSQL.
- Typical applications and integration pathways.
Planning and Preparing for Deployment
- Reviewing system requirements and prerequisites.
- Designing cluster topology and network configurations.
- Optimizing disk setup and adhering to performance standards.
Installing Greenplum
- Deploying the Greenplum Database on Linux systems.
- Setting up master and segment instances.
- Initializing the cluster and validating the installation.
Fundamentals of Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
- Interacting with the Greenplum Command Center.
- Managing user roles, resource queues, and workload distribution.
Managing System Updates and Patches
- Comprehending Greenplum versioning strategies.
- Implementing safe patching methods and scheduling maintenance windows.
- Executing rolling upgrades and managing backup requirements.
Library and Extension Administration
- Managing libraries including PL/Java, PL/Python, and others.
- Deploying extensions via gpkg and the CREATE EXTENSION command.
- Handling dependencies and updating library components.
Monitoring, Logging, and Troubleshooting
- Leveraging performance monitoring tools and key metrics.
- Analyzing logs to identify and resolve errors.
- Addressing common operational issues and implementing fixes.
Recap and Future Pathways
Requirements
- Solid grasp of database principles and SQL.
- Practical experience in Linux system administration.
- Prior knowledge of 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.