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 roles and cluster configuration details
- Scalability mechanisms and data movement
- The Greenplum Data Warehouse architectural framework
Greenplum Table Structures
- Differences between distributed and randomly assigned tables
- Comparison of heap versus append-only tables
- Row versus columnar storage format implications
- Characteristics of partitioned and clustered tables
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing data skew and its performance impact
- Hash maps and row placement strategies
Indexes and Performance Optimization
- Functionality of clustered and non-clustered indexes
- Appropriate use cases for B-tree and bitmap indexes
- Index scan behavior and storage interactions
Physical Database Design
- Normalization principles and logical model design
- User access strategies and distribution analysis
- Data demographics and informed indexing decisions
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins
- Employing columnar tables as a form of vertical partitioning
- Implementation of data marts and materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution techniques
- OLAP concepts and the application of window functions
- Usage of temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output accurately
- Conducting cost analysis and plan optimization
- Managing join movement and segment-local operations
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM commands
- Data loading and movement processes using Nexus
- Security considerations, permissions, and performance tips
Summary and Next Steps
Requirements
- A solid grasp of relational databases and SQL
- Practical experience with data warehousing or analytical systems
- Proficiency with Linux command line operations
Target Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists working with Greenplum
Testimonials (1)
the practices