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
Greenplum Fundamentals
- Introduction to MPP databases and Greenplum architecture
- Distinguishing Greenplum from PostgreSQL: critical differences
- Relevant use cases and integration scenarios
Installation Planning and Preparation
- System requirements and necessary prerequisites
- Cluster topology design and networking considerations
- Disk configuration strategies and performance optimization best practices
Greenplum Deployment
- Installing the Greenplum Database on Linux systems
- Configuring master and segment instances correctly
- Initializing the cluster and validating the installation
Core Greenplum Administration
- Utilizing gpstart, gpstop, gprecoverseg, and other essential utilities
- Navigating the Greenplum Command Center
- Managing user roles, resource queues, and workload distribution
System Updates and Patch Management
- Understanding Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance windows
- Executing rolling upgrades and managing backup considerations
Library and Extension Oversight
- Working with PL/Java, PL/Python, and other supporting libraries
- Deploying extensions using gpkg and CREATE EXTENSION
- Managing library dependencies and handling updates
Monitoring, Logging, and Diagnostics
- Leveraging performance monitoring tools and key metrics
- Analyzing logs to identify and resolve errors
- Addressing common issues with effective resolution strategies
Conclusion and Future Steps
Requirements
- A solid grasp of database concepts and SQL
- Practical experience in Linux system administration
- Prior knowledge of PostgreSQL is advantageous
Target Audience
- Database administrators
- System administrators
- DevOps and platform engineers
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
