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.
- Defining segment roles and configuring clusters.
- Managing scalability and data movement.
- The architecture of the Greenplum Data Warehouse.
Greenplum Table Structures
- Distinguishing between distributed and randomly assigned tables.
- Comparing heap and append-only table types.
- Selecting row versus columnar storage formats.
- Utilizing partitioned and clustered tables.
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.
- Application of B-tree and bitmap indexes.
- Understanding index scans and storage behavior.
Physical Database Design
- Normalization and logical model design.
- Strategies for user access and distribution analysis.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Leveraging derived data, summary tables, and pre-joins.
- Viewing columnar tables as a form of vertical partitioning.
- Implementing data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- OLAP capabilities and window functions.
- Working with temporary tables, subqueries, and derived tables.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output.
- Conducting cost analysis and plan optimization.
- Optimizing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Utilizing ANALYZE and VACUUM commands.
- Data loading and movement using Nexus.
- Security, permission management, and performance tips.
Summary and Next Steps
Requirements
- Foundational knowledge of relational databases and SQL.
- Practical experience with data warehousing or analytical systems.
- Proficiency in 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