Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing concepts and symmetric multi-processing.
  • Segment functions and cluster setup.
  • Scalability mechanisms and data transfer processes.
  • Architectural specifics of the Greenplum Data Warehouse.

Greenplum Table Structures

  • Comparing distributed and randomly assigned tables.
  • Distinguishing between Heap and append-only tables.
  • Row-based versus columnar storage formats.
  • Partitioned and clustered table designs.

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Clustered versus non-clustered indexes.
  • Appropriate use cases for B-tree and bitmap indexes.
  • Index scanning behavior and storage interactions.

Physical Database Design

  • Normalization principles and logical model creation.
  • User access patterns and distribution analysis.
  • Data characteristics and rationale for indexing decisions.

Denormalization Techniques

  • Utilizing derived data, summary tables, and pre-joins.
  • Columnar tables as a form of vertical partitioning.
  • Data marts and the use of materialized views.

Advanced SQL and Query Execution

  • Join strategies and data redistribution.
  • OLAP operations and window functions.
  • Handling temporary tables, subqueries, and derived tables.

EXPLAIN Plans and Query Tuning

  • How to read and interpret EXPLAIN output.
  • Cost analysis and optimizing execution plans.
  • Join movement and segment-local processing.

Greenplum Utilities and Best Practices

  • Running ANALYZE and VACUUM commands.
  • Data loading and movement utilizing Nexus.
  • Security measures, permissions, and performance enhancement tips.

Summary and Next Steps

Requirements

  • Knowledge of relational databases and SQL.
  • 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 utilizing Greenplum.

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories