Course Outline
Introduction to Greenplum
- Overview of MPP databases and Greenplum architecture
- Greenplum vs. PostgreSQL: key differences
- Use cases and integration scenarios
Planning and Preparing for Installation
- System requirements and prerequisites
- Cluster topology and networking
- Disk configuration and performance best practices
Greenplum Installation
- Installing Greenplum Database on Linux
- Configuring master and segment instances
- Initializing the cluster and verifying installation
Greenplum Administration Basics
- gpstart, gpstop, gprecoverseg and other core utilities
- Working with the Greenplum Command Center
- User roles, resource queues, and workload management
System Updates and Patching
- Understanding Greenplum versioning
- Safe patching strategies and maintenance windows
- Rolling upgrades and backup considerations
Library and Extension Management
- Using and managing PL/Java, PL/Python, and other libraries
- Installing extensions with gpkg and CREATE EXTENSION
- Managing dependencies and updates to libraries
Monitoring, Logging, and Troubleshooting
- Performance monitoring tools and metrics
- Interpreting logs and diagnosing errors
- Common issues and resolution strategies
Summary and Next Steps
Requirements
- An understanding of database concepts and SQL
- Experience with Linux system administration
- Familiarity with PostgreSQL is helpful
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 (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
