Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Explore parallel processing mechanisms and symmetric multi-processing capabilities
  • Examine segment roles and cluster configuration strategies
  • Discuss scalability considerations and data movement workflows
  • Overview of the Greenplum Data Warehouse architectural model

Greenplum Table Structures

  • Compare distributed tables with randomly assigned tables
  • Contrast heap storage with append-only table formats
  • Evaluate row-oriented versus columnar storage options
  • Implement partitioned and clustered table designs

Data Distribution and Hashing

  • Analyze hashing logic and the selection of distribution keys
  • Address data skew issues and their impact on system performance
  • Review hash maps and strategies for optimal row placement

Indexes and Performance Optimization

  • Distinguish between clustered and non-clustered index types
  • Identify use cases for B-tree and bitmap indexes
  • Understand index scanning behavior and its effect on storage access

Physical Database Design

  • Apply normalization principles and logical model design techniques
  • Develop user access strategies and conduct distribution analysis
  • Make informed indexing decisions based on data demographics

Denormalization Techniques

  • Utilize derived data, summary tables, and pre-joined structures
  • Implement columnar tables as a form of vertical partitioning
  • Create data marts and materialized views for enhanced access

Advanced SQL and Query Execution

  • Implement join strategies and manage data redistribution
  • Leverage OLAP features and window functions
  • Utilize temporary tables, subqueries, and derived tables effectively

EXPLAIN Plans and Query Tuning

  • Learn to read and interpret EXPLAIN output efficiently
  • Perform cost analysis and optimize execution plans
  • Manage join movement and execute segment-local operations

Greenplum Utilities and Best Practices

  • Execute ANALYZE and VACUUM maintenance tasks
  • Facilitate data loading and movement using Nexus
  • Apply security, permission management, and performance tuning tips

Summary and Next Steps

Requirements

  • A solid grasp of relational databases and SQL syntax
  • Prior experience working with data warehousing or analytical systems
  • Proficiency in Linux command-line operations

Target Audience

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

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories