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 and symmetric multi-processing
- Segment roles and cluster configuration
- Scalability mechanisms 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 table design
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing skew and its impact on performance
- Hash maps and row placement strategies
Indexes and Performance Optimization
- Clustered and non-clustered index types
- B-tree and bitmap index application scenarios
- Index scan behaviors and storage interactions
Physical Database Design
- Normalization principles and logical model design
- User access strategies and distribution analysis
- Data demographics and informed indexing decisions
Denormalization Techniques
- Derived data, summary tables, and pre-joined structures
- Using columnar tables for vertical partitioning
- Data marts and materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution
- OLAP capabilities and window functions
- Temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output
- Cost analysis and execution plan optimization
- Join movement and segment-local operations
Greenplum Utilities and Best Practices
- ANALYZE and VACUUM maintenance tasks
- Data loading and movement using Nexus
- Security, permissions, and performance optimization tips
Summary and Next Steps
Requirements
- Solid knowledge of relational databases and SQL.
- Practical experience with data warehousing or analytical systems.
- Proficiency with Linux command-line operations.
Target Audience
- Data architects and engineers.
- Database administrators and technical leads.
- BI developers and analytics specialists working within Greenplum environments.
Testimonials (1)
the practices