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 mechanisms and data movement.
- The underlying Greenplum Data Warehouse architecture.
Greenplum Table Structures
- Comparing distributed tables against randomly assigned tables.
- Contrasting heap tables with append-only tables.
- Choosing between row and columnar storage formats.
- Managing partitioned and clustered tables.
Data Distribution and Hashing
- Hashing logic and the selection of distribution keys.
- Addressing skew and its impact on performance.
- Utilizing hash maps and row placement strategies.
Indexes and Performance Optimization
- Implementing clustered and non-clustered indexes.
- Use cases for B-tree and bitmap indexes.
- Understanding index scans and storage behavior.
Physical Database Design
- Normalization principles and logical model design.
- User access strategies and distribution analysis.
- Data demographics and informed indexing decisions.
Denormalization Techniques
- Leveraging derived data, summary tables, and pre-joins.
- Using columnar tables for vertical partitioning.
- Building data marts and materialized views.
Advanced SQL and Query Execution
- Join strategies and data redistribution.
- Applying OLAP and 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 optimizing plans.
- Managing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM operations.
- Data loading and movement using Nexus.
- Managing security, permissions, and general performance tips.
Summary and Next Steps
Requirements
- Solid knowledge 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 utilizing Greenplum.
Testimonials (1)
the practices