Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts
  • Segment roles and cluster configuration details
  • Scalability factors and data movement mechanisms
  • Greenplum Data Warehouse architectural components

Greenplum Table Structures

  • Distributed versus randomly assigned table types
  • Heap versus append-only table implementations
  • Row versus columnar storage format options
  • Partitioned and clustered table designs

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Clustered and non-clustered index types
  • Applicable use cases for B-tree and bitmap indexes
  • Index scan behaviors and storage interactions

Physical Database Design

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

Denormalization Techniques

  • Utilizing derived data, summary tables, and pre-joined structures
  • Employing columnar tables as a form of vertical partitioning
  • Designing data marts and materialized views

Advanced SQL and Query Execution

  • Join strategies and data redistribution methods
  • OLAP operations and the use of window functions
  • Working with temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Reading and interpreting EXPLAIN output effectively
  • Conducting cost analysis and plan optimization
  • Optimizing join movement and segment-local operations

Greenplum Utilities and Best Practices

  • Executing ANALYZE and VACUUM commands
  • Data loading and movement procedures using Nexus
  • Security protocols, permissions, and performance tips

Summary and Next Steps

Requirements

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

Target Audience

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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories