Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts
  • Segment functions and cluster setup
  • Scalability mechanisms and data transfer
  • Greenplum Data Warehouse structural design

Greenplum Table Configurations

  • Distributed tables versus randomly distributed tables
  • Heap tables versus append-only tables
  • Row-oriented versus columnar storage formats
  • Partitioned and clustered table implementations

Data Distribution and Hashing

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

Indexing and Performance Enhancement

  • Clustered versus non-clustered index types
  • Use cases for B-tree and bitmap indexes
  • Index scanning behaviour and storage interactions

Physical Database Design

  • Normalization and logical model construction
  • User access strategies and distribution assessment
  • Data demographics and indexing decisions

Denormalization Techniques

  • Derived data, summary tables, and pre-joined structures
  • 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 features and window functions
  • Temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Interpreting and analysing EXPLAIN output
  • Cost analysis and plan refinement
  • Join mobility and segment-local operations

Greenplum Utilities and Best Practices

  • ANALYZE and VACUUM processes
  • Data loading and movement using Nexus
  • Security, permissions, and performance recommendations

Summary and Next Steps

Requirements

  • Solid comprehension of relational databases and SQL fundamentals
  • Prior exposure to data warehousing or analytical systems
  • Proficiency with Linux command-line interfaces

Target Audience

  • Data architects and engineers
  • Database administrators and technical leads
  • BI developers and analytics specialists utilising Greenplum

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories