Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Concepts of parallel processing and symmetric multi-processing
  • Roles of segments and cluster configuration details
  • Mechanisms of scalability and data movement
  • Structural overview of the Greenplum Data Warehouse

Greenplum Table Structures

  • Comparison between distributed and randomly assigned tables
  • Differences between heap and append-only tables
  • Advantages of row versus columnar storage formats
  • Implementation of partitioned and clustered tables

Data Distribution and Hashing

  • Logic behind hashing and selection of distribution keys
  • Managing skew and its effect on performance
  • Utilization of hash maps and row placement tactics

Indexes and Performance Optimization

  • Application of clustered and non-clustered indexes
  • Use cases for B-tree and bitmap indexes
  • Behavior of index scans and storage interactions

Physical Database Design

  • Normalization principles and logical model design
  • Strategies for user access and distribution analysis
  • Considering data demographics for indexing choices

Denormalization Techniques

  • Use of derived data, summary tables, and pre-joins
  • Columnar tables as a form of vertical partitioning
  • Construction of data marts and materialized views

Advanced SQL and Query Execution

  • Techniques for join strategies and data redistribution
  • Application of OLAP and window functions
  • Management of temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Interpreting and analyzing EXPLAIN output
  • Conducting cost analysis and optimizing execution plans
  • Optimizing join movement and segment-local operations

Greenplum Utilities and Best Practices

  • Utilizing ANALYZE and VACUUM commands
  • Data loading and movement using Nexus
  • Enhancing security, permissions, and performance

Summary and Next Steps

Requirements

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

Audience

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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories