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 mechanisms and symmetric multi-processing
- Segment roles and cluster configuration details
- Scalability factors and data movement dynamics
- Structure of the Greenplum Data Warehouse
Greenplum Table Structures
- Differences between distributed and randomly assigned tables
- Comparison of heap and append-only table types
- Row-based versus columnar storage formats
- Implementation of partitioned and clustered tables
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing data skew and its impact on performance
- Utilizing hash maps and row placement strategies
Indexes and Performance Optimization
- Characteristics of clustered and non-clustered indexes
- Applying B-tree and bitmap indexes to specific use cases
- Understanding index scans and storage behavior
Physical Database Design
- Normalization processes and logical model construction
- User access strategies and distribution analysis
- Considerations for data demographics and indexing choices
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins
- Using columnar tables for vertical partitioning
- Implementing data marts and materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution methods
- OLAP concepts and window function application
- Use of temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Techniques for reading and interpreting EXPLAIN output
- Cost analysis and optimization of execution plans
- Join movement and segment-local operational efficiency
Greenplum Utilities and Best Practices
- Execution of ANALYZE and VACUUM commands
- Data loading and movement utilizing Nexus
- Security protocols, permission management, and performance advice
Summary and Next Steps
Requirements
- Solid grasp of relational databases and SQL fundamentals
- Practical experience with data warehousing or analytical systems
- Proficiency with Linux command line operations
Intended Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists utilizing Greenplum
Testimonials (1)
the practices