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 strategies
- Overview of Greenplum Data Warehouse architecture
Greenplum Table Structures
- Distributed versus randomly assigned tables
- Comparison of heap and append-only tables
- Row versus columnar storage formats
- Partitioned and clustered table implementations
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Handling data skew and its performance implications
- Hash maps and strategies for row placement
Indexes and Performance Optimization
- Clustered and non-clustered index structures
- Use cases for B-tree and bitmap indexes
- Index scan behavior and storage characteristics
Physical Database Design
- Normalization principles and logical model design
- User access strategies and distribution analysis
- Data demographics and criteria for indexing decisions
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins
- Columnar tables as a form of vertical partitioning
- Data marts and the application of materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution mechanisms
- OLAP operations and window functions
- Working with temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively
- Cost analysis and plan optimization techniques
- Join movement and segment-local operations
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM operations
- Data loading and movement utilizing Nexus
- Security, permissions, and general performance tips
Summary and Next Steps
Requirements
- A solid grasp of relational databases and SQL fundamentals
- Practical experience with data warehousing or other analytical systems
- Proficiency in using Linux command-line interfaces
Target Audience
- Data architects and software engineers
- Database administrators and technical leads
- BI developers and analytics specialists working within Greenplum environments
Testimonials (1)
the practices