Course Outline
Greenplum Architecture
- Explore parallel processing mechanisms and symmetric multi-processing capabilities
- Examine segment roles and cluster configuration strategies
- Discuss scalability considerations and data movement workflows
- Overview of the Greenplum Data Warehouse architectural model
Greenplum Table Structures
- Compare distributed tables with randomly assigned tables
- Contrast heap storage with append-only table formats
- Evaluate row-oriented versus columnar storage options
- Implement partitioned and clustered table designs
Data Distribution and Hashing
- Analyze hashing logic and the selection of distribution keys
- Address data skew issues and their impact on system performance
- Review hash maps and strategies for optimal row placement
Indexes and Performance Optimization
- Distinguish between clustered and non-clustered index types
- Identify use cases for B-tree and bitmap indexes
- Understand index scanning behavior and its effect on storage access
Physical Database Design
- Apply normalization principles and logical model design techniques
- Develop user access strategies and conduct distribution analysis
- Make informed indexing decisions based on data demographics
Denormalization Techniques
- Utilize derived data, summary tables, and pre-joined structures
- Implement columnar tables as a form of vertical partitioning
- Create data marts and materialized views for enhanced access
Advanced SQL and Query Execution
- Implement join strategies and manage data redistribution
- Leverage OLAP features and window functions
- Utilize temporary tables, subqueries, and derived tables effectively
EXPLAIN Plans and Query Tuning
- Learn to read and interpret EXPLAIN output efficiently
- Perform cost analysis and optimize execution plans
- Manage join movement and execute segment-local operations
Greenplum Utilities and Best Practices
- Execute ANALYZE and VACUUM maintenance tasks
- Facilitate data loading and movement using Nexus
- Apply security, permission management, and performance tuning tips
Summary and Next Steps
Requirements
- A solid grasp of relational databases and SQL syntax
- Prior experience working with data warehousing or analytical systems
- Proficiency in Linux command-line operations
Target Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists engaged with 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