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
Greenplum Architecture
- Parallel processing and symmetric multi-processing concepts
- Segment functions and cluster setup
- Scalability mechanisms and data transfer
- Greenplum Data Warehouse structural design
Greenplum Table Configurations
- Distributed tables versus randomly distributed tables
- Heap tables versus append-only tables
- Row-oriented versus columnar storage formats
- Partitioned and clustered table implementations
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing data skew and its effect on performance
- Hash maps and strategies for row placement
Indexing and Performance Enhancement
- Clustered versus non-clustered index types
- Use cases for B-tree and bitmap indexes
- Index scanning behaviour and storage interactions
Physical Database Design
- Normalization and logical model construction
- User access strategies and distribution assessment
- Data demographics and indexing decisions
Denormalization Techniques
- Derived data, summary tables, and pre-joined structures
- Columnar tables as a form of vertical partitioning
- Data marts and the use of materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution
- OLAP features and window functions
- Temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Interpreting and analysing EXPLAIN output
- Cost analysis and plan refinement
- Join mobility and segment-local operations
Greenplum Utilities and Best Practices
- ANALYZE and VACUUM processes
- Data loading and movement using Nexus
- Security, permissions, and performance recommendations
Summary and Next Steps
Requirements
- Solid comprehension of relational databases and SQL fundamentals
- Prior exposure to data warehousing or analytical systems
- Proficiency with Linux command-line interfaces
Target Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists utilising Greenplum
Testimonials (1)
the practices