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 databases and Greenplum architecture.
- Key differences between Greenplum and PostgreSQL.
- Application scenarios and integration use cases.
Pre-Installation Planning and Preparation
- System requirements and prerequisites.
- Cluster topology and networking considerations.
- Disk configuration and performance best practices.
Installing Greenplum
- Deploying Greenplum Database on Linux.
- Configuring master and segment instances.
- Initializing the cluster and verifying the installation.
Fundamentals of Greenplum Administration
- Core utilities such as gpstart, gpstop, and gprecoverseg.
- Utilizing the Greenplum Command Center.
- Managing user roles, resource queues, and workloads.
System Updates and Patching
- Understanding Greenplum versioning strategies.
- Safe patching methods and maintenance window planning.
- Rolling upgrades and backup considerations.
Library and Extension Management
- Utilizing and managing PL/Java, PL/Python, and other libraries.
- Installing extensions via gpkg and CREATE EXTENSION.
- Managing library dependencies and updates.
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and key metrics.
- Log interpretation and error diagnosis.
- Common issues and effective resolution strategies.
Summary and Future Steps
Requirements
- A solid grasp of database concepts and SQL.
- Experience in Linux system administration.
- Prior familiarity with PostgreSQL is advantageous.
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.
