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.
Course Outline
Greenplum Architecture
- Parallel processing and symmetric multi-processing.
- Segment roles and cluster configuration.
- Scalability and data movement.
- Greenplum Data Warehouse architecture.
Greenplum Table Structures
- Distributed versus randomly assigned tables.
- Heap versus append-only tables.
- Row versus columnar storage formats.
- Partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and distribution keys.
- Handling skew and its impact on performance.
- Hash maps and row placement strategies.
Indexes and Performance Optimization
- Clustered and non-clustered indexes.
- Use cases for B-tree and bitmap indexes.
- Index scan and storage behavior.
Physical Database Design
- Normalization and logical model design.
- User access strategies and distribution analysis.
- Data demographics and indexing decisions.
Denormalization Techniques
- Derived data, summary tables, and pre-joins.
- Columnar tables as a form of vertical partitioning.
- Data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and redistribution.
- OLAP and window functions.
- Temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output.
- Cost analysis and plan optimization.
- Join movement and segment-local operations.
Greenplum Utilities and Best Practices
- ANALYZE and VACUUM commands.
- Data loading and movement with Nexus.
- Security, permissions, and performance tips.
Summary and Next Steps
Requirements
- A solid understanding 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 working with Greenplum.
21 Hours
Testimonials (1)
the practices