Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts.
  • The role of segments and cluster configuration.
  • Strategies for scalability and data movement.
  • The architecture of the Greenplum Data Warehouse.

Greenplum Table Structures

  • Comparing distributed and randomly assigned tables.
  • Differences between heap and append-only tables.
  • Row versus columnar storage formats.
  • Partitioned and clustered table implementations.

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Clustered and non-clustered index types.
  • Application scenarios for B-tree and bitmap indexes.
  • Understanding index scans and storage behaviour.

Physical Database Design

  • Normalisation principles and logical model design.
  • User access strategies and distribution analysis.
  • Data demographics and informed indexing decisions.

Denormalization Techniques

  • Utilising 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 processes.
  • OLAP capabilities and window functions.
  • Working with temporary tables, subqueries, and derived tables.

EXPLAIN Plans and Query Tuning

  • Decoding and interpreting EXPLAIN output.
  • Cost analysis and techniques for plan optimisation.
  • Join movement and segment-local operations.

Greenplum Utilities and Best Practices

  • Utilising ANALYZE and VACUUM commands.
  • Data loading and movement using Nexus.
  • Security, permissions, and key performance tips.

Summary and Next Steps

Requirements

  • A solid grasp of relational databases and SQL fundamentals.
  • 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 utilising Greenplum.

Testimonials (1)

Related Categories