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 processes.
- Greenplum Data Warehouse architecture overview.
Greenplum Table Structures
- Differences between distributed and randomly assigned tables.
- Comparison of heap versus append-only table structures.
- 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 impact on performance.
- Hash maps and strategies for row placement.
Indexes and Performance Optimization
- Clustered and non-clustered index definitions.
- Appropriate use cases for B-tree and bitmap indexes.
- Index scan behaviors and storage characteristics.
Physical Database Design
- Normalization principles and logical model design.
- User access strategies and distribution analysis techniques.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Utilization of derived data, summary tables, and pre-joins.
- 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 methods.
- Application of OLAP and window functions.
- Handling temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively.
- Cost analysis and plan optimization strategies.
- Join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Usage of ANALYZE and VACUUM commands.
- Data loading and movement via Nexus.
- Security protocols, permission management, and performance tips.
Summary and Next Steps
Requirements
- Fundamental understanding 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