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
Introduction to Greenplum
- Examination of MPP database concepts and Greenplum’s architectural design
- Distinguishing Greenplum from PostgreSQL: primary distinctions
- Applicable use cases and integration frameworks
Strategic Planning for Deployment
- Defining system requirements and prerequisite conditions
- Designing cluster topology and networking infrastructure
- Optimizing disk configuration and adhering to performance benchmarks
Greenplum Deployment Process
- Installing the Greenplum Database on a Linux operating system
- Setting up master nodes and segment instances
- Initializing the cluster and validating the installation
Fundamentals of Greenplum Administration
- Utilizing core management tools such as gpstart, gpstop, and gprecoverseg
- Interacting with the Greenplum Command Center interface
- Managing user roles, resource queues, and workload distribution
System Maintenance and Patch Management
- Navigating Greenplum versioning structures
- Implementing secure patching protocols and scheduling maintenance periods
- Executing rolling upgrades and managing backup strategies
Oversight of Libraries and Extensions
- Utilizing and maintaining PL/Java, PL/Python, and other supporting libraries
- Deploying extensions via gpkg and the CREATE EXTENSION command
- Resolving dependencies and keeping libraries up to date
Monitoring, Log Analysis, and Problem Resolution
- Leveraging performance monitoring tools and key metrics
- Analyzing logs to identify and diagnose system errors
- Addressing common operational challenges with effective resolution techniques
Course Recap and Future Directions
Requirements
- A solid grasp of database fundamentals and SQL syntax
- Practical experience in Linux system administration
- Prior exposure to PostgreSQL is advantageous
Target Audience
- Database administrators
- System administrators
- DevOps and platform engineers
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.