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 vs. randomly assigned tables.
  • Heap vs. append-only tables.
  • Row vs. columnar storage formats.
  • Partitioned and clustered tables.

Data Distribution and Hashing

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

Indexes and Performance Optimisation

  • Clustered and non-clustered indexes.
  • B-tree and bitmap index use cases.
  • Index scans and storage behaviour.

Physical Database Design

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

Denormalisation Techniques

  • Derived data, summary tables, and pre-joins.
  • Columnar tables as vertical partitioning.
  • Data marts and materialised views.

Advanced SQL and Query Execution

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

EXPLAIN Plans and Query Tuning

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

Greenplum Utilities and Best Practices

  • ANALYZE and VACUUM operations.
  • Data loading and movement with Nexus.
  • Security, permissions, and performance tips.

Summary and Next Steps

Requirements

  • A solid grasp of relational databases and SQL.
  • Practical experience with data warehousing or analytical systems.
  • Familiarity with Linux command-line operations.

Audience

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

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customised Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from £4800 + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories