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 concepts
- Segment roles and cluster configuration details
- Scalability factors and data movement mechanisms
- Greenplum Data Warehouse architectural components
Greenplum Table Structures
- Distributed versus randomly assigned table types
- Heap versus append-only table implementations
- Row versus columnar storage format options
- Partitioned and clustered table designs
Data Distribution and Hashing
- Hashing logic and the role of distribution keys
- Managing data skew and its performance implications
- Hash maps and strategies for row placement
Indexes and Performance Optimization
- Clustered and non-clustered index types
- Applicable use cases for B-tree and bitmap indexes
- Index scan behaviors and storage interactions
Physical Database Design
- Normalization principles and logical model structuring
- User access strategies and distribution analysis techniques
- Data demographics and informed indexing decisions
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joined structures
- Employing columnar tables as a form of vertical partitioning
- Designing data marts and materialized views
Advanced SQL and Query Execution
- Join strategies and data redistribution methods
- OLAP operations and the use of window functions
- Working with temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output effectively
- Conducting cost analysis and plan optimization
- Optimizing join movement and segment-local operations
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM commands
- Data loading and movement procedures using Nexus
- Security protocols, permissions, and performance tips
Summary and Next Steps
Requirements
- Proficiency in relational databases and SQL
- Practical 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