ENROLL NOW
Course Name
Course Code : SAV43
Venue Details
Postal Code : 30-644
Session Dates
Duration: 4 days (28 hours)
This course provides a comprehensive introduction to Greenplum Database (GPDB), a massively parallel processing (MPP) data warehouse platform based on PostgreSQL. Participants will learn how to design, query, manage, and optimize data in Greenplum for large-scale analytics. The course blends concepts of SQL development, data modeling, and system administration to prepare learners for real-world enterprise deployments.
Greenplum Overview
MPP vs SMP databases
Use cases in analytics, BI, and data science
Greenplum Architecture
Master, segments, standby, interconnect
Database Setup & Access
Connecting with psql and tools
User roles and authentication basics
SQL Basics in Greenplum
DDL, DML, and query execution in MPP environment
Data Distribution Strategies
Hash, random, replicated distributions
Choosing distribution keys
Partitioning & Storage Management
Range, list, and composite partitioning
Tablespaces and storage options
Data Loading & Unloading
gpload, external tables, COPY command
Parallel data loading best practices
Transaction Management in Greenplum
Query Execution & Optimization
EXPLAIN plans and query tuning
Parallelism in query execution
Advanced SQL Features
Window functions, CTEs, OLAP queries
Array and JSON data handling
In-Database Analytics
MADlib introduction (machine learning in Greenplum)
Using Greenplum for statistical and predictive analysis
User-defined Functions (UDFs) and Procedural Languages (PL/pgSQL, Python)
Installation & Configuration
Cluster setup, gpconfigs, system requirements
Monitoring & Maintenance
gpstate, gp_toolkit views, gpconfig
Vacuum, analyze, reindex operations
Backup & Recovery
gpcrondump, gp_restore, incremental strategies
Performance Tuning
Resource groups, workload management
Common tuning scenarios
High Availability & Fault Tolerance
Standby master, segment mirroring
Failover and recovery
Security & User Management
Role-based access, SSL, encryption
Hands-on Exercises
Summary and Conclusion
Mode of Delivery : The event can be attended both online and at nearby ProgNXT classroom by Individual Professionals and Corporate Employees as per the seat availability. Please Contact Us at [email protected] for checking the seat availability
Audience : We have a global audience that logs in to using their own computers to work hand in hand with our world-class instructors.
Assessment : Each training course will have ProgNXT Assessment at the end.
Certification : After successful passing of ProgNXT Assessment, ProgNXT Certification will be provided, which has got acceptance in 55+ Countries.
| Global Region | Location | Start Date | End Date | Action |
|---|---|---|---|---|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | |