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 concepts and symmetric multi-processing.
- Segment functions and cluster setup.
- Scalability mechanisms and data transfer processes.
- Architectural specifics of the Greenplum Data Warehouse.
Greenplum Table Structures
- Comparing distributed and randomly assigned tables.
- Distinguishing between Heap and append-only tables.
- Row-based versus columnar storage formats.
- Partitioned and clustered table designs.
Data Distribution and Hashing
- Hashing logic and the selection of distribution keys.
- Managing data skew and its effects on performance.
- Hash maps and strategies for row placement.
Indexes and Performance Optimization
- Clustered versus non-clustered indexes.
- Appropriate use cases for B-tree and bitmap indexes.
- Index scanning behavior and storage interactions.
Physical Database Design
- Normalization principles and logical model creation.
- User access patterns and distribution analysis.
- Data characteristics and rationale for indexing decisions.
Denormalization Techniques
- Utilizing 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.
- OLAP operations and window functions.
- Handling temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- How to read and interpret EXPLAIN output.
- Cost analysis and optimizing execution plans.
- Join movement and segment-local processing.
Greenplum Utilities and Best Practices
- Running ANALYZE and VACUUM commands.
- Data loading and movement utilizing Nexus.
- Security measures, permissions, and performance enhancement tips.
Summary and Next Steps
Requirements
- Knowledge of relational databases and SQL.
- Experience with data warehousing or analytical systems.
- Familiarity with Linux command line operations.
Target Audience
- Data architects and engineers.
- Database administrators and technical leads.
- BI developers and analytics specialists utilizing Greenplum.
Testimonials (1)
the practices