Get in Touch
 Duration 21 hours

Course Outline

Greenplum Architecture

  • Parallel processing mechanisms and symmetric multi-processing
  • Segment responsibilities and cluster setup
  • Scalability considerations and data migration flows
  • Greenplum Data Warehouse architectural overview

Greenplum Table Structures

  • Comparison of distributed tables versus randomly assigned tables
  • Heap-based versus append-only table implementations
  • Row-oriented versus columnar storage methodologies
  • Partitioned and clustered table configurations

Data Distribution and Hashing

  • Hashing algorithms and selection of distribution keys
  • Managing data skew and assessing performance implications
  • Hash mapping and row placement tactics

Indexes and Performance Optimization

  • Clustered versus non-clustered index structures
  • Appropriate use cases for B-tree and bitmap indexes
  • Index scanning behaviors and storage interactions

Physical Database Design

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

Denormalization Techniques

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

Advanced SQL and Query Execution

  • Join methodologies and data redistribution
  • OLAP capabilities and window functions
  • Management of temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Analyzing and interpreting EXPLAIN command output
  • Cost evaluation and execution plan refinement
  • Join mobility and segment-local processing

Greenplum Utilities and Best Practices

  • Execution of ANALYZE and VACUUM commands
  • Data ingestion and transfer using Nexus
  • Security protocols, permission management, and performance optimization tips

Summary and Next Steps

Requirements

  • Foundational knowledge of relational databases and SQL
  • Prior exposure to data warehousing or analytical platforms
  • Proficiency with Linux command-line interface operations

Intended Audience

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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories