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
- Concepts of parallel processing and symmetric multi-processing
- Roles of segments and cluster configuration details
- Mechanisms of scalability and data movement
- Structural overview of the Greenplum Data Warehouse
Greenplum Table Structures
- Comparison between distributed and randomly assigned tables
- Differences between heap and append-only tables
- Advantages of row versus columnar storage formats
- Implementation of partitioned and clustered tables
Data Distribution and Hashing
- Logic behind hashing and selection of distribution keys
- Managing skew and its effect on performance
- Utilization of hash maps and row placement tactics
Indexes and Performance Optimization
- Application of clustered and non-clustered indexes
- Use cases for B-tree and bitmap indexes
- Behavior of index scans and storage interactions
Physical Database Design
- Normalization principles and logical model design
- Strategies for user access and distribution analysis
- Considering data demographics for indexing choices
Denormalization Techniques
- Use of derived data, summary tables, and pre-joins
- Columnar tables as a form of vertical partitioning
- Construction of data marts and materialized views
Advanced SQL and Query Execution
- Techniques for join strategies and data redistribution
- Application of OLAP and window functions
- Management of temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Interpreting and analyzing EXPLAIN output
- Conducting cost analysis and optimizing execution plans
- Optimizing join movement and segment-local operations
Greenplum Utilities and Best Practices
- Utilizing ANALYZE and VACUUM commands
- Data loading and movement using Nexus
- Enhancing security, permissions, and performance
Summary and Next Steps
Requirements
- Solid comprehension of relational databases and SQL
- Practical experience with data warehousing or analytical systems
- Proficiency with Linux command line operations
Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists working with Greenplum
Testimonials (1)
the practices