Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts.
  • Segment roles and cluster configuration management.
  • Scalability mechanisms and data movement principles.
  • The underlying architecture of Greenplum Data Warehouse.

Greenplum Table Structures

  • Differences between distributed and randomly assigned tables.
  • Comparing heap and append-only table implementations.
  • Selection between row and columnar storage formats.
  • Utilizing partitioned and clustered tables.

Data Distribution and Hashing

  • Hashing logic and the selection of distribution keys.
  • Managing data skew and its performance implications.
  • Hash maps and row placement strategies.

Indexes and Performance Optimization

  • Application of clustered and non-clustered indexes.
  • Use cases for B-tree and bitmap indexes.
  • Understanding index scans and storage behavior.

Physical Database Design

  • Normalization and the design of logical models.
  • User access strategies and distribution analysis.
  • Data demographics and informed indexing decisions.

Denormalization Techniques

  • Utilizing derived data, summary tables, and pre-joins.
  • Implementing columnar tables as a form of vertical partitioning.
  • Working with data marts and materialized views.

Advanced SQL and Query Execution

  • Join strategies and data redistribution techniques.
  • Applying OLAP and window functions.
  • Working with temporary tables, subqueries, and derived tables.

EXPLAIN Plans and Query Tuning

  • Reading and interpreting EXPLAIN output effectively.
  • Performing cost analysis and optimizing execution plans.
  • Managing join movement and segment-local operations.

Greenplum Utilities and Best Practices

  • Executing ANALYZE and VACUUM operations.
  • Data loading and movement using Nexus.
  • Enhancing security, permissions, and overall performance.

Summary and Next Steps

Requirements

  • Solid knowledge of relational databases and SQL standards.
  • Practical experience with data warehousing or analytic systems.
  • Proficiency with Linux command-line operations.

Target Audience

  • Data architects and engineers.
  • Database administrators and technical leads.
  • BI developers and analytics specialists operating Greenplum environments.

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories