Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing mechanisms and symmetric multi-processing
  • Segment roles and cluster configuration details
  • Scalability factors and data movement dynamics
  • Structure of the Greenplum Data Warehouse

Greenplum Table Structures

  • Differences between distributed and randomly assigned tables
  • Comparison of heap and append-only table types
  • Row-based versus columnar storage formats
  • Implementation of partitioned and clustered tables

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Characteristics of clustered and non-clustered indexes
  • Applying B-tree and bitmap indexes to specific use cases
  • Understanding index scans and storage behavior

Physical Database Design

  • Normalization processes and logical model construction
  • User access strategies and distribution analysis
  • Considerations for data demographics and indexing choices

Denormalization Techniques

  • Utilizing derived data, summary tables, and pre-joins
  • Using columnar tables for vertical partitioning
  • Implementing data marts and materialized views

Advanced SQL and Query Execution

  • Join strategies and data redistribution methods
  • OLAP concepts and window function application
  • Use of temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Techniques for reading and interpreting EXPLAIN output
  • Cost analysis and optimization of execution plans
  • Join movement and segment-local operational efficiency

Greenplum Utilities and Best Practices

  • Execution of ANALYZE and VACUUM commands
  • Data loading and movement utilizing Nexus
  • Security protocols, permission management, and performance advice

Summary and Next Steps

Requirements

  • Solid grasp of relational databases and SQL fundamentals
  • Practical experience with data warehousing or analytical systems
  • Proficiency with Linux command line operations

Intended 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