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 the Greenplum architectural design
- Distinguishing Greenplum from standard PostgreSQL: critical differences
- Ideal use cases and integration opportunities
Pre-Installation Planning and Preparation
- Defining system requirements and verifying prerequisites
- Designing cluster topology and networking configurations
- Optimizing disk layout and adhering to performance best practices
Deploying Greenplum
- Installing the Greenplum Database on Linux systems
- Configuring master and segment instances
- Initializing the cluster and validating the installation
Core Greenplum Administration
- Mastering core utilities such as gpstart, gpstop, and gprecoverseg
- Utilizing the Greenplum Command Center for oversight
- Managing user roles, resource queues, and workload control
Managing System Updates and Patches
- Navigating Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance windows
- Executing rolling upgrades and managing backup protocols
Library and Extension Governance
- Leveraging and administering PL/Java, PL/Python, and additional libraries
- Deploying extensions via gpkg and the CREATE EXTENSION command
- Resolving dependencies and updating library components
Surveillance, Logging, and Diagnostics
- Utilizing performance monitoring tools and interpreting key metrics
- Analyzing logs to identify and resolve errors
- Addressing common operational challenges and remediation tactics
Course Conclusion and Forward-Looking Actions
Requirements
- Solid grasp of database fundamentals and SQL syntax
- Proficiency in Linux system administration
- Background knowledge of PostgreSQL is beneficial
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.