Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing mechanisms
  • Segment roles and cluster configuration fundamentals
  • Scalability principles and data movement dynamics
  • Greenplum Data Warehouse structural overview

Greenplum Table Structures

  • Distributed vs. randomly assigned table types
  • Heap vs. append-only storage models
  • Row vs. columnar storage format considerations
  • Implementation of partitioned and clustered tables

Data Distribution and Hashing

  • Hashing logic and the role of distribution keys
  • Managing skew and assessing performance impact
  • Hash maps and row placement strategies

Indexes and Performance Optimization

  • Clustered and non-clustered index distinctions
  • Application scenarios for B-tree and bitmap indexes
  • Index scan mechanics and storage behavior

Physical Database Design

  • Normalization principles and logical model design
  • User access strategies and distribution analysis
  • Data demographics and indexing decision-making

Denormalization Techniques

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

Advanced SQL and Query Execution

  • Join strategies and data redistribution
  • OLAP operations and window functions
  • 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 operation optimization

Greenplum Utilities and Best Practices

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

Summary and Next Steps

Requirements

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

Target 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