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 management.
- Scalability mechanisms and data movement principles.
- The underlying architecture of Greenplum Data Warehouse.
Greenplum Table Structures
- Differences between distributed and randomly assigned tables.
- Comparing heap and append-only table implementations.
- Selection between row and columnar storage formats.
- Utilizing partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and the selection of distribution keys.
- Managing data skew and its performance implications.
- Hash maps and row placement strategies.
Indexes and Performance Optimization
- Application of clustered and non-clustered indexes.
- Use cases for B-tree and bitmap indexes.
- Understanding index scans and storage behavior.
Physical Database Design
- Normalization and the design of logical models.
- User access strategies and distribution analysis.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins.
- Implementing columnar tables as a form of vertical partitioning.
- Working with data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution techniques.
- Applying OLAP and window functions.
- Working with temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively.
- Performing cost analysis and optimizing execution plans.
- Managing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM operations.
- Data loading and movement using Nexus.
- Enhancing security, permissions, and overall performance.
Summary and Next Steps
Requirements
- Solid knowledge of relational databases and SQL standards.
- Practical experience with data warehousing or analytic systems.
- Proficiency with Linux command-line operations.
Target Audience
- Data architects and engineers.
- Database administrators and technical leads.
- BI developers and analytics specialists operating Greenplum environments.
Testimonials (1)
the practices