Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing
  • Segment roles and cluster configuration
  • Scalability mechanisms and data movement
  • Greenplum Data Warehouse architecture

Greenplum Table Structures

  • Distributed versus randomly assigned tables
  • Heap versus append-only tables
  • Row versus columnar storage formats
  • Partitioned and clustered table design

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Clustered and non-clustered index types
  • B-tree and bitmap index application scenarios
  • Index scan behaviors and storage interactions

Physical Database Design

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

Denormalization Techniques

  • Derived data, summary tables, and pre-joined structures
  • Using columnar tables for vertical partitioning
  • Data marts and materialized views

Advanced SQL and Query Execution

  • Join strategies and data redistribution
  • OLAP capabilities and window functions
  • Temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

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

Greenplum Utilities and Best Practices

  • ANALYZE and VACUUM maintenance tasks
  • Data loading and movement using Nexus
  • Security, permissions, and performance optimization tips

Summary and Next Steps

Requirements

  • Solid knowledge of relational databases and SQL.
  • 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 working within Greenplum environments.

Testimonials (1)

Related Categories