Get in Touch
 Duration 21 hours

Course Outline

Greenplum System Architecture

  • Parallel processing mechanisms and symmetric multi-processing models
  • Definition of segment responsibilities and cluster structural configuration
  • Scaling capabilities and methodologies for inter-node data transfer
  • Architectural framework of the Greenplum Data Warehouse

Greenplum Tabular Construction

  • Distinction between distributed and randomly allocated table structures
  • Comparative analysis of heap-based versus append-only storage
  • Selection of row-oriented versus columnar storage formats
  • Implementation of partitioned and clustered table designs

Data Dispersion and Hashing Mechanisms

  • Logical hashing processes and selection of distribution keys
  • Management of data skew and its effect on operational performance
  • Utilization of hash maps and strategies for row placement

Indexing and Performance Enhancement

  • Application of clustered and non-clustered index types
  • Use cases for B-tree and bitmap indexing within analytics
  • Behavioral analysis of index scans and underlying storage interactions

Physical Database Architecture

  • Normalization principles and logical model structuring
  • Strategies for user access control and distribution pattern analysis
  • Analysis of data demographics to inform indexing decisions

Denormalization Methodologies

  • Creation of derived datasets, summary tables, and pre-joined structures
  • Application of columnar tables as a form of vertical partitioning
  • Deployment of data marts and materialized views for efficiency

Advanced SQL Application and Query Execution

  • Join processing strategies and data redistribution techniques
  • Implementation of OLAP capabilities and window functions
  • Management of temporary tables, subqueries, and derived tables

EXPLAIN Plans and Query Refinement

  • Interpretation and analysis of EXPLAIN execution output
  • Cost-based analysis and optimization of query plans
  • Optimization of join placement and segment-local processing

Greenplum Toolset and Operational Best Practices

  • Execution of ANALYZE and VACUUM maintenance tasks
  • Data ingestion and movement using Nexus utilities
  • Security protocols, permission management, and performance recommendations

Conclusion and Subsequent Actions

Requirements

  • Foundational understanding of relational databases and SQL syntax
  • Practical experience with data warehousing or analytical systems
  • Familiarity 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