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 mechanisms
- Segment roles and cluster configuration fundamentals
- Scalability principles and data movement dynamics
- Greenplum Data Warehouse structural overview
Greenplum Table Structures
- Distributed vs. randomly assigned table types
- Heap vs. append-only storage models
- Row vs. columnar storage format considerations
- Implementation of partitioned and clustered tables
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing skew and assessing performance impact
- Hash maps and row placement strategies
Indexes and Performance Optimization
- Clustered and non-clustered index distinctions
- Application scenarios for B-tree and bitmap indexes
- Index scan mechanics and storage behavior
Physical Database Design
- Normalization principles and logical model design
- User access strategies and distribution analysis
- Data demographics and indexing decision-making
Denormalization Techniques
- Use of derived data, summary tables, and pre-joins
- Columnar tables as a form of vertical partitioning
- Data marts and the implementation of materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution
- OLAP operations and window functions
- Temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively
- Cost analysis and plan optimization techniques
- Join movement and segment-local operation optimization
Greenplum Utilities and Best Practices
- Utilizing ANALYZE and VACUUM commands
- Data loading and movement using Nexus
- Security protocols, permissions, and performance tips
Summary and Next Steps
Requirements
- Foundational understanding 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 with Greenplum
Testimonials (1)
the practices