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
Foundations of Greenplum
- Examination of Massively Parallel Processing (MPP) databases and Greenplum’s architectural design.
- Distinct advantages and differences between Greenplum and standard PostgreSQL.
- Identification of key use cases and potential integration scenarios.
Pre-Installation Planning and Preparation
- Review of hardware requirements and necessary prerequisites.
- Designing cluster topologies and networking structures.
- Optimizing disk configurations and applying performance best practices.
Installing Greenplum
- Deploying the Greenplum Database on Linux systems.
- Setting up master nodes and segment instances.
- Cluster initialization and verifying the integrity of the installation.
Core Greenplum Administration
- Utilizing essential command-line tools such as gpstart, gpstop, and gprecoverseg.
- Interacting with the Greenplum Command Center for administrative tasks.
- Managing user roles, resource queues, and workload distribution.
Managing System Updates and Patches
- Navigating Greenplum versioning structures.
- Developing safe patching strategies and defining maintenance windows.
- Executing rolling upgrades while considering backup requirements.
Oversight of Libraries and Extensions
- Leveraging and maintaining PL/Java, PL/Python, and other procedural languages.
- Deploying extensions using gpkg and the CREATE EXTENSION command.
- Managing library dependencies and ensuring timely updates.
Monitoring, Log Analysis, and Diagnostics
- Employing performance monitoring tools and interpreting key metrics.
- Analyzing log files to identify and diagnose errors.
- Addressing common operational issues and implementing resolution strategies.
Conclusion and Future Recommendations
Requirements
- A solid grasp of fundamental database concepts and SQL language.
- Prior experience in Linux system administration.
- Proficiency with PostgreSQL is advantageous.
Intended Participants
- 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.
