Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing concepts
  • Segment roles and cluster configuration details
  • Scalability mechanisms and data movement strategies
  • Overview of Greenplum Data Warehouse architecture

Greenplum Table Structures

  • Distributed versus randomly assigned tables
  • Comparison of heap and append-only tables
  • Row versus columnar storage formats
  • Partitioned and clustered table implementations

Data Distribution and Hashing

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

Indexes and Performance Optimization

  • Clustered and non-clustered index structures
  • Use cases for B-tree and bitmap indexes
  • Index scan behavior and storage characteristics

Physical Database Design

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

Denormalization Techniques

  • Utilizing derived data, summary tables, and pre-joins
  • Columnar tables as a form of vertical partitioning
  • Data marts and the application of materialized views

Advanced SQL and Query Execution

  • Join strategies and data redistribution mechanisms
  • OLAP operations and window functions
  • Working with temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

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

Greenplum Utilities and Best Practices

  • Executing ANALYZE and VACUUM operations
  • Data loading and movement utilizing Nexus
  • Security, permissions, and general performance tips

Summary and Next Steps

Requirements

  • A solid grasp of relational databases and SQL fundamentals
  • Practical experience with data warehousing or other analytical systems
  • Proficiency in using Linux command-line interfaces

Target Audience

  • Data architects and software engineers
  • Database administrators and technical leads
  • BI developers and analytics specialists working within Greenplum environments

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories