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 mechanisms and symmetric multi-processing
- Segment responsibilities and cluster setup
- Scalability considerations and data migration flows
- Greenplum Data Warehouse architectural overview
Greenplum Table Structures
- Comparison of distributed tables versus randomly assigned tables
- Heap-based versus append-only table implementations
- Row-oriented versus columnar storage methodologies
- Partitioned and clustered table configurations
Data Distribution and Hashing
- Hashing algorithms and selection of distribution keys
- Managing data skew and assessing performance implications
- Hash mapping and row placement tactics
Indexes and Performance Optimization
- Clustered versus non-clustered index structures
- Appropriate use cases for B-tree and bitmap indexes
- Index scanning behaviors and storage interactions
Physical Database Design
- Normalization principles and logical modeling strategies
- User access patterns and distribution analysis
- Data demographics and criteria for indexing decisions
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joined structures
- Columnar tables as a form of vertical partitioning
- Data marts and the use of materialized views
Advanced SQL and Query Execution
- Join methodologies and data redistribution
- OLAP capabilities and window functions
- Management of temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Tuning
- Analyzing and interpreting EXPLAIN command output
- Cost evaluation and execution plan refinement
- Join mobility and segment-local processing
Greenplum Utilities and Best Practices
- Execution of ANALYZE and VACUUM commands
- Data ingestion and transfer using Nexus
- Security protocols, permission management, and performance optimization tips
Summary and Next Steps
Requirements
- Foundational knowledge of relational databases and SQL
- Prior exposure to data warehousing or analytical platforms
- Proficiency with Linux command-line interface operations
Intended Audience
- Data architects and engineers
- Database administrators and technical leads
- BI developers and analytics specialists utilizing Greenplum
Testimonials (1)
the practices