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.
- Scalability principles and data movement.
- The underlying architecture of the Greenplum Data Warehouse.
Greenplum Table Structures
- Distinctions between distributed and randomly assigned tables.
- Comparison of heap versus append-only tables.
- Row-based versus columnar storage formats.
- Partitioned and clustered table designs.
Data Distribution and Hashing
- Hashing logic and the role of distribution keys.
- Managing data skew and its performance implications.
- Hash maps and strategies for row placement.
Indexing and Performance Optimization
- Clustered and non-clustered index types.
- Application scenarios for B-tree and bitmap indexes.
- Index scanning and storage behavior.
Physical Database Design
- Normalization and logical model structuring.
- User access strategies and distribution analysis.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins.
- Columnar tables as a form of vertical partitioning.
- Data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- OLAP concepts and window functions.
- Temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Interpreting EXPLAIN output effectively.
- Cost analysis and plan optimization techniques.
- Join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Use of ANALYZE and VACUUM commands.
- Data loading and movement using Nexus.
- Security protocols, permissions, and performance enhancements.
Summary and Next Steps
Requirements
- Foundational knowledge of relational databases and SQL.
- Practical experience with data warehousing or analytical systems.
- Comfort with Linux command-line operations.
Target Audience
- Data architects and engineers.
- Database administrators and technical leads.
- BI developers and analytics specialists utilizing Greenplum.
Testimonials (1)
the practices