Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts.
  • Segment roles and cluster configuration details.
  • Scalability considerations and data movement mechanics.
  • Overview of the Greenplum Data Warehouse architecture.

Greenplum Table Structures

  • Comparing distributed versus randomly assigned tables.
  • Distinctions between heap and append-only tables.
  • Row-oriented versus columnar storage formats.
  • Implementation of partitioned and clustered tables.

Data Distribution and Hashing

  • Hashing logic and the role of distribution keys.
  • Managing skew and its impact on performance.
  • Utilizing hash maps and row placement strategies.

Indexes and Performance Optimization

  • Clustered versus non-clustered index types.
  • Applicable 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 techniques.
  • Data demographics and informed indexing decisions.

Denormalization Techniques

  • Use of derived data, summary tables, and pre-joins.
  • Columnar tables as a form of vertical partitioning.
  • Implementing data marts and materialized views.

Advanced SQL and Query Execution

  • Join strategies and data redistribution methods.
  • Application of OLAP and window functions.
  • Utilizing temporary tables, subqueries, and derived tables.

EXPLAIN Plans and Query Tuning

  • Reading and interpreting EXPLAIN output effectively.
  • Cost analysis and plan optimization strategies.
  • Join movement and segment-local operations.

Greenplum Utilities and Best Practices

  • Using ANALYZE and VACUUM for maintenance.
  • Data loading and movement using Nexus.
  • Security protocols, permissions, and performance tips.

Summary and Next Steps

Requirements

  • A solid foundation in relational databases and SQL.
  • Practical experience with data warehousing or analytical systems.
  • Proficiency in Linux command-line operations.

Target Audience

  • Data architects and engineers.
  • Database administrators and technical leads.
  • BI developers and analytics specialists working with Greenplum.

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories