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 fundamentals.
- Defining segment roles and configuring clusters.
- Managing scalability and data movement.
- Overview of the Greenplum Data Warehouse architecture.
Greenplum Table Structures
- Comparing distributed tables with randomly assigned tables.
- Evaluating Heap versus append-only table formats.
- Selecting between row and columnar storage formats.
- Implementing partitioned and clustered tables.
Data Distribution and Hashing
- Understanding hashing logic and selecting distribution keys.
- Managing skew and its impact on performance.
- Utilizing hash maps and row placement strategies.
Indexes and Performance Optimization
- Differentiating between clustered and non-clustered indexes.
- Applying B-tree and bitmap indexes in appropriate scenarios.
- Understanding index scans and storage behaviors.
Physical Database Design
- Balancing normalization with logical model design.
- Defining user access strategies and analyzing distribution.
- Making indexing decisions based on data demographics.
Denormalization Techniques
- Utilizing derived data, summary tables, and pre-joins.
- Leveraging columnar tables as a form of vertical partitioning.
- Implementing data marts and materialized views.
Advanced SQL and Query Execution
- Optimizing join strategies and data redistribution.
- Working with OLAP and window functions.
- Using temporary tables, subqueries, and derived tables effectively.
EXPLAIN Plans and Query Tuning
- Reading and interpreting EXPLAIN output accurately.
- Performing cost analysis and optimizing execution plans.
- Managing join movement and segment-local operations.
Greenplum Utilities and Best Practices
- Executing ANALYZE and VACUUM operations.
- Facilitating data loading and movement using Nexus.
- Enforcing security, permissions, and performance tips.
Summary and Next Steps
Requirements
- A solid grasp of relational database concepts and SQL syntax.
- 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
