Course Outline
Introduction to Greenplum
- Overview of MPP databases and Greenplum’s architectural design.
- Key distinctions between Greenplum and standard PostgreSQL.
- Real-world use cases and integration scenarios.
Installation Planning and Preparation
- Review of system requirements and prerequisites.
- Defining cluster topology and networking configurations.
- Disk configuration strategies and performance optimization best practices.
Greenplum Installation Process
- Installing the Greenplum Database on Linux systems.
- Configuring master and segment instances.
- Initializing the cluster and verifying successful installation.
Fundamentals of Greenplum Administration
- Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
- Working effectively with the Greenplum Command Center.
- Managing user roles, resource queues, and workloads.
System Updates and Patching Strategies
- Understanding Greenplum versioning mechanisms.
- Implementing safe patching strategies and scheduling maintenance windows.
- Executing rolling upgrades and considering backup requirements.
Library and Extension Management
- Utilizing and managing libraries such as PL/Java and PL/Python.
- Installing extensions using gpkg and the CREATE EXTENSION command.
- Managing library dependencies and applying updates.
Monitoring, Logging, and Troubleshooting
- Employing performance monitoring tools and interpreting key metrics.
- Analyzing logs to diagnose and resolve errors.
- Addressing common issues with effective resolution strategies.
Summary and Future Steps
Requirements
- Solid understanding of database concepts and SQL.
- Practical experience in Linux system administration.
- Familiarity with 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 3900 € + 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.
