Course Outline
Greenplum Architecture
- Parallel processing and symmetric multi-processing concepts.
- Segment roles and cluster configuration details.
- Scalability mechanisms and data movement processes.
- The Greenplum Data Warehouse architectural model.
Greenplum Table Structures
- Comparing distributed and randomly assigned tables.
- Evaluating heap versus append-only tables.
- Analyzing row versus columnar storage formats.
- Designing partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and the role of distribution keys.
- Addressing data 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
- Normalizing and designing logical data models.
- Strategies for user access and distribution analysis.
- Data demographics and making informed indexing decisions.
Denormalization Techniques
- Employing derived data, summary tables, and pre-joins.
- Using columnar tables as a form of vertical partitioning.
- Implementing data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- OLAP capabilities and window functions.
- Working with temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Interpreting EXPLAIN output for insights.
- Conducting cost analysis and optimizing execution plans.
- Managing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Running ANALYZE and VACUUM commands.
- Data loading and movement using Nexus.
- Security, permission management, and 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 leaders.
- 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