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 considerations and data movement mechanics.
- Overview of the Greenplum Data Warehouse architecture.
Greenplum Table Structures
- Comparing distributed versus randomly assigned tables.
- Distinctions between heap and append-only tables.
- Row-oriented versus columnar storage formats.
- Implementation of partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and the role of distribution keys.
- Managing skew and its impact on performance.
- Utilizing hash maps and row placement strategies.
Indexes and Performance Optimization
- Clustered versus non-clustered index types.
- Applicable use cases for B-tree and bitmap indexes.
- Understanding index scans and storage behavior.
Physical Database Design
- Normalization principles and logical model design.
- User access strategies and distribution analysis techniques.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Use of derived data, summary tables, and pre-joins.
- Columnar tables as a form of vertical partitioning.
- Implementing data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution methods.
- Application of OLAP and window functions.
- Utilizing 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
- Using ANALYZE and VACUUM for maintenance.
- Data loading and movement using Nexus.
- Security protocols, permissions, and performance tips.
Summary and Next Steps
Requirements
- A solid foundation in relational databases and SQL.
- Practical experience with data warehousing or analytical systems.
- Proficiency in 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