Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture Fundamentals

  • Parallel processing mechanisms and symmetric multi-processing
  • The role of segments and cluster configuration strategies
  • Scalability principles and data movement dynamics
  • Understanding the Greenplum Data Warehouse structure

Greenplum Table Structures

  • Comparing distributed tables versus randomly assigned tables
  • Differences between heap tables and append-optimized tables
  • Selecting between row-oriented and columnar storage formats
  • Managing partitioned and clustered table designs

Data Distribution and Hashing Mechanics

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

Indexing and Performance Enhancement

  • Distinctions between clustered and non-clustered indexes
  • Application scenarios for B-tree and bitmap indexes
  • Behavior of index scans and storage interactions

Physical Database Design Principles

  • Applying normalization and logical model design
  • Developing user access strategies and distribution analyses
  • Making informed indexing decisions based on data demographics

Denormalization Strategies

  • Using derived data, summary tables, and pre-joined data
  • Leveraging columnar tables as a form of vertical partitioning
  • Implementing data marts and materialized views

Advanced SQL and Query Execution

  • Optimizing join strategies and data redistribution
  • Utilizing OLAP capabilities and window functions
  • Working with temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Reading and analyzing EXPLAIN output effectively
  • Conducting cost analysis and plan refinement
  • Managing join movement and segment-local operations

Greenplum Utilities and Best Practices

  • Executing ANALYZE and VACUUM maintenance tasks
  • Facilitating data loading and movement using Nexus
  • Addressing security, permissions, and performance optimization tips

Course Summary and Future Directions

Requirements

  • A solid grasp of relational database concepts and SQL fundamentals
  • Prior exposure to data warehousing solutions or analytical systems
  • Proficiency with Linux command-line interfaces

Intended Audience

  • Data architects and engineering professionals
  • Database administrators and technical leadership
  • BI developers and analytics specialists working within Greenplum ecosystems

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories