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.
- The role of segments and cluster configuration.
- Strategies for scalability and data movement.
- The architecture of the Greenplum Data Warehouse.
Greenplum Table Structures
- Comparing distributed and randomly assigned tables.
- Differences between heap and append-only tables.
- Row versus columnar storage formats.
- Partitioned and clustered table implementations.
Data Distribution and Hashing
- Hashing logic and the selection 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 types.
- Application scenarios for B-tree and bitmap indexes.
- Understanding index scans and storage behaviour.
Physical Database Design
- Normalisation principles and logical model design.
- User access strategies and distribution analysis.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Utilising 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 processes.
- OLAP capabilities and window functions.
- Working with temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Decoding and interpreting EXPLAIN output.
- Cost analysis and techniques for plan optimisation.
- Join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Utilising ANALYZE and VACUUM commands.
- Data loading and movement using Nexus.
- Security, permissions, and key performance tips.
Summary and Next Steps
Requirements
- A solid grasp of relational databases and SQL fundamentals.
- 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 utilising Greenplum.
Testimonials (1)
the practices