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
- Fundamentals of MPP databases and the architecture of Greenplum.
- Comparing Greenplum and PostgreSQL: understanding the critical distinctions.
- Real-world use cases and integration pathways.
Strategic Planning and Installation Preparation
- Review of system requirements and necessary prerequisites.
- Designing cluster topology and network configurations.
- Optimizing disk setup and adhering to performance best practices.
Deploying Greenplum
- Step-by-step installation of the Greenplum Database on Linux.
- Configuration of master nodes and segment instances.
- Cluster initialization and installation verification procedures.
Core Greenplum Administration
- Utilization of core utilities such as gpstart, gpstop, and gprecoverseg.
- Interaction with the Greenplum Command Center for management tasks.
- Administration of user roles, resource queues, and workload control.
Managing System Updates and Patches
- Navigation of Greenplum versioning structures.
- Implementation of secure patching strategies and maintenance scheduling.
- Execution of rolling upgrades with due consideration for data backups.
Library and Extension Administration
- Management of PL/Java, PL/Python, and other procedural libraries.
- Deployment of extensions utilizing gpkg and the CREATE EXTENSION command.
- Oversight of dependencies and library updates.
Monitoring, Logging, and Diagnostics
- Application of performance monitoring tools and key metrics.
- Analysis of logs and systematic diagnosis of errors.
- Identification of common issues and application of resolution strategies.
Recap and Future Development
Requirements
- A solid grasp of fundamental database concepts and SQL syntax.
- Practical experience in Linux system administration.
- Prior knowledge of PostgreSQL is advantageous.
Target Audience
- Database Administrators (DBAs).
- 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.