Course Outline
Greenplum Fundamentals
- Overview of MPP databases and Greenplum's architectural design
- Key distinctions between Greenplum and standard PostgreSQL
- Typical use cases and integration patterns
Pre-Installation Planning
- Review of system requirements and necessary prerequisites
- Defining cluster topology and network configurations
- Disk layout optimization and performance best practices
Installing Greenplum
- Deploying the Greenplum Database on Linux systems
- Configuring master and segment roles
- Cluster initialization and installation validation
Core Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg
- Managing operations via the Greenplum Command Center
- Defining user roles, resource queues, and workload controls
Updates and Patch Management
- Understanding Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance windows
- Executing rolling upgrades and planning backups
Library and Extension Oversight
- Managing programming libraries including PL/Java and PL/Python
- Installing extensions using gpkg and the CREATE EXTENSION command
- Handling library dependencies and version updates
Monitoring and Troubleshooting
- Leveraging performance monitoring tools and key metrics
- Analyzing logs to diagnose system errors
- Addressing common operational issues and resolution techniques
Summary and Future Directions
Requirements
- Solid grasp of database principles and SQL.
- Practical experience in Linux system administration.
- Prior knowledge of PostgreSQL is advantageous.
Target Audience
- Database Administrators.
- System Administrators.
- DevOps and Platform Engineers.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
