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 Greenplum’s architectural design
- Key distinctions between Greenplum and PostgreSQL
- Applicable use cases and integration scenarios
Planning and Installation Preparation
- System requirements and essential prerequisites
- Cluster topology and network configurations
- Disk setup and performance optimization best practices
Installing Greenplum
- Deploying Greenplum Database on Linux systems
- Configuring master nodes and segment instances
- Initializing the cluster and validating the installation
Fundamentals of Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
- Operating the Greenplum Command Center
- Managing user roles, resource queues, and workload control
System Updates and Patching
- Comprehending Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance windows
- Performing rolling upgrades and considering backup protocols
Managing Libraries and Extensions
- Utilizing and managing libraries such as PL/Java and PL/Python
- Installing extensions via gpkg and the CREATE EXTENSION command
- Maintaining library dependencies and applying updates
Monitoring, Logging, and Troubleshooting
- Employing performance monitoring tools and tracking key metrics
- Analyzing logs to diagnose errors effectively
- Addressing common issues and applying resolution strategies
Conclusion and Future Steps
Requirements
- A solid grasp of fundamental database concepts and SQL
- Proficiency in Linux system administration
- Prior knowledge of PostgreSQL is advantageous
Target Audience
- Database administrators
- 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.