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 System Architecture
- Parallel processing mechanisms and symmetric multi-processing models
- Definition of segment responsibilities and cluster structural configuration
- Scaling capabilities and methodologies for inter-node data transfer
- Architectural framework of the Greenplum Data Warehouse
Greenplum Tabular Construction
- Distinction between distributed and randomly allocated table structures
- Comparative analysis of heap-based versus append-only storage
- Selection of row-oriented versus columnar storage formats
- Implementation of partitioned and clustered table designs
Data Dispersion and Hashing Mechanisms
- Logical hashing processes and selection of distribution keys
- Management of data skew and its effect on operational performance
- Utilization of hash maps and strategies for row placement
Indexing and Performance Enhancement
- Application of clustered and non-clustered index types
- Use cases for B-tree and bitmap indexing within analytics
- Behavioral analysis of index scans and underlying storage interactions
Physical Database Architecture
- Normalization principles and logical model structuring
- Strategies for user access control and distribution pattern analysis
- Analysis of data demographics to inform indexing decisions
Denormalization Methodologies
- Creation of derived datasets, summary tables, and pre-joined structures
- Application of columnar tables as a form of vertical partitioning
- Deployment of data marts and materialized views for efficiency
Advanced SQL Application and Query Execution
- Join processing strategies and data redistribution techniques
- Implementation of OLAP capabilities and window functions
- Management of temporary tables, subqueries, and derived tables
EXPLAIN Plans and Query Refinement
- Interpretation and analysis of EXPLAIN execution output
- Cost-based analysis and optimization of query plans
- Optimization of join placement and segment-local processing
Greenplum Toolset and Operational Best Practices
- Execution of ANALYZE and VACUUM maintenance tasks
- Data ingestion and movement using Nexus utilities
- Security protocols, permission management, and performance recommendations
Conclusion and Subsequent Actions
Requirements
- Foundational understanding of relational databases and SQL syntax
- 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 working with Greenplum
Testimonials (1)
the practices