Course Outline

Greenplum Architecture

  • Parallel processing and symmetric multi-processing
  • Segment roles and cluster configuration
  • Scalability and data movement
  • Greenplum Data Warehouse architecture

Greenplum Table Structures

  • Distributed vs. randomly assigned tables
  • Heap vs. append-only tables
  • Row vs. columnar storage formats
  • Partitioned and clustered tables

Data Distribution and Hashing

  • Hashing logic and distribution keys
  • Skew handling and performance impact
  • Hash maps and row placement strategies

Indexes and Performance Optimization

  • Clustered and non-clustered indexes
  • B-tree and bitmap index use cases
  • Index scan and storage behavior

Physical Database Design

  • Normalization and logical model design
  • User access strategies and distribution analysis
  • Data demographics and indexing decisions

Denormalization Techniques

  • Derived data, summary tables, and pre-joins
  • Columnar tables as vertical partitioning
  • Data marts and materialized views

Advanced SQL and Query Execution

  • Join strategies and redistribution
  • OLAP and window functions
  • Temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Tuning

  • Reading and interpreting EXPLAIN output
  • Cost analysis and plan optimization
  • Join movement and segment-local operations

Greenplum Utilities and Best Practices

  • ANALYZE and VACUUM
  • Data loading and movement with Nexus
  • Security, permissions, and performance tips

Summary and Next Steps

Requirements

  • An understanding of relational databases and SQL
  • Experience with data warehousing or analytical systems
  • Familiarity with Linux command line operations

Audience

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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories


Fatal error: Uncaught TypeError: _isl_get_excluded_site(): Return value must be of type ?array, none returned in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc:38 Stack trace: #0 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(30): _isl_get_excluded_site() #1 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc(17): isl_get_excluded_site() #2 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(51): get_outline_isls() #3 /apps/hitra7/backdrop/modules/_custom/frontend/islc7/islc7.module(7): islc_prepare_links() #4 /apps/hitra7/npfrontend/nptemplates/default.php(272): islc7_sites_links_array_v3() #5 /apps/hitra7/npfrontend/modules/course/course.php(143): require_once('...') #6 /apps/hitra7/npfrontend/core/routes.php(15): course_menu_callback() #7 /apps/hitra7/npfrontend/__index.php(81): require_once('...') #8 /apps/hitra7/npfrontend/index.php(15): include_once('...') #9 /apps/hitra7/index.php(66): include_once('...') #10 {main} thrown in /apps/hitra7/backdrop/modules/_custom/frontend/islc7/isl_common.inc on line 38