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
Introduction to Greenplum
- Concepts of MPP databases and the Greenplum architecture
- Distinct differences between Greenplum and PostgreSQL
- Typical use cases and integration patterns
Preparation and Planning for Deployment
- Hardware requirements and pre-installation checks
- Cluster topology design and network configuration
- Disk setup strategies and performance optimization tips
Installing Greenplum
- Deploying Greenplum Database on Linux systems
- Configuring master and segment nodes
- Initializing the cluster and validating the installation
Fundamentals of Greenplum Administration
- Utilizing core commands such as gpstart, gpstop, and gprecoverseg
- Leveraging the Greenplum Command Center for management
- Managing user roles, resource queues, and workload distribution
Managing System Updates and Patches
- Comprehending Greenplum versioning schemes
- Implementing safe patching strategies and scheduling maintenance
- Executing rolling upgrades and managing backups
Managing Libraries and Extensions
- Utilizing and administering PL/Java, PL/Python, and similar libraries
- Deploying extensions via gpkg and the CREATE EXTENSION command
- Overseeing library dependencies and applying updates
Monitoring, Log Analysis, and Problem Solving
- Applying performance monitoring tools and interpreting metrics
- Analyzing logs to identify and diagnose errors
- Addressing common operational issues and resolution techniques
Recap and Recommended Next Steps
Requirements
- Solid grasp of database fundamentals and SQL
- Background in Linux system administration
- Proficiency with PostgreSQL is recommended
Target Audience
- Database Administrators (DBAs)
- 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.