Get in Touch

Course Outline

Greenplum Database Architecture

  • Parallel processing capabilities and symmetric multi-processing implementation
  • Segment roles and cluster configuration parameters
  • System scalability and data mobility mechanisms
  • Architecture of the Greenplum Data Warehouse solution

Table Organization and Structure

  • Differences between distributed and randomly assigned table types
  • Comparison of heap storage versus append-only formats
  • Row-based versus columnar storage configurations
  • Implementation of partitioned and clustered table structures

Data Distribution Algorithms and Hashing

  • Hashing logic and the selection of distribution keys for government data sets
  • Management of data skew and its impact on system performance
  • Hash map generation and strategies for row placement

Indexing Strategies and Performance Optimization

  • Utilization of clustered and non-clustered indexes
  • Application scenarios for B-tree and bitmap index structures
  • Behavioral characteristics of index scans and storage requirements

Physical Database Design Principles

  • Data normalization and logical model development
  • User access protocols and analysis of data distribution patterns
  • Evaluation of data demographics to inform indexing decisions for government systems

Denormalization Methods

  • Use of derived data, summary tables, and pre-computed joins
  • Application of columnar tables for vertical partitioning
  • Implementation of data marts and materialized views

Advanced SQL Operations and Query Execution

  • Join strategies and data redistribution techniques
  • Application of OLAP processes and window functions
  • Management of temporary tables, subqueries, and derived datasets

Query Plan Analysis and Tuning with EXPLAIN

  • Interpretation of EXPLAIN command output for performance analysis
  • Cost-based optimization and plan refinement
  • Optimization of join operations and segment-local processing tasks

Greenplum Utilities and Operational Best Practices

  • Maintenance procedures for ANALYZE and VACUUM commands
  • Data ingestion and mobility protocols using Nexus tools
  • Security controls, permission management, and performance recommendations for government deployments

Summary and Recommended Next Steps

Requirements

  • Comprehensive knowledge of relational database management systems (RDBMS) and structured query language (SQL)
  • Practical experience implementing data warehousing solutions or analytical platforms
  • Proficiency in executing operations via the Linux command-line interface

Intended Audience

  • Data architects and data engineers
  • Database administrators (DBAs) and technical leads
  • Business intelligence (BI) developers and analytics professionals leveraging Greenplum for government data initiatives
 21 Hours

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories