Course Outline
Greenplum Architecture
- Parallel processing and symmetric multi-processing concepts.
- Segment roles and cluster configuration details.
- Scalability mechanisms and data movement processes.
- The architecture of the Greenplum Data Warehouse.
Greenplum Table Structures
- Comparison of distributed versus randomly assigned tables.
- Differences between heap and append-only tables.
- Row-based versus columnar storage formats.
- Designing partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and the role of distribution keys.
- Managing skew and its impact on performance.
- Hash maps and strategies for row placement.
Indexes and Performance Optimization
- Utilizing clustered and non-clustered indexes.
- Use cases for B-tree and bitmap indexes.
- Understanding index scans and storage behavior.
Physical Database Design
- Normalization and logical model design principles.
- User access strategies and distribution analysis.
- Data demographics and making informed indexing decisions.
Denormalization Techniques
- Using derived data, summary tables, and pre-joins.
- Treating columnar tables as vertical partitioning.
- Implementing data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- Applying OLAP and window functions.
- Working with temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively.
- Conducting cost analysis and optimizing plans.
- Managing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM operations.
- Data loading and movement using Nexus.
- Tips on security, permissions, and performance.
Summary and Next Steps
Requirements
- Solid foundation in 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 utilizing Greenplum.
Testimonials (5)
the exercises and problem-solving
Mario Humberto Serrano Gutierrez - Hipodromo de Agua Caliente
Course - Greenplum Architecture and Data Modeling
Machine Translated
The theory was the most interesting
Luis Antonio Jimenez Gil - Hipodromo de Agua Caliente
Course - Greenplum Architecture and Data Modeling
Machine Translated
the practical exercises and the willingness to answer questions
Edith Vichua Solis - Hipodromo de Agua Caliente
Course - Greenplum Architecture and Data Modeling
Machine Translated
the explanation, I think I used terms that were too understandable for everyone
Moises Jafet Hernandez Fuentes - Hipodromo de Agua Caliente
Course - Greenplum Architecture and Data Modeling
Machine Translated
the practices