Course Outline

Greenplum Architecture for Government

  • Parallel processing and symmetric multi-processing capabilities
  • Segment roles and cluster configuration options
  • Scalability features and data movement strategies
  • Greenplum Data Warehouse architecture design

Greenplum Table Structures for Government

  • Distributed versus randomly assigned tables
  • Heap versus append-only table types
  • Row versus columnar storage formats
  • Partitioned and clustered table configurations

Data Distribution and Hashing for Government

  • Hashing logic and distribution key selection
  • Skew management and its impact on performance
  • Hash maps and row placement strategies

Indexes and Performance Optimization for Government

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

Physical Database Design for Government

  • Normalization techniques and logical model design
  • User access strategies and distribution analysis
  • Data demographics and indexing decision-making processes

Denormalization Techniques for Government

  • Derived data, summary tables, and pre-join operations
  • Columnar tables as a method of vertical partitioning
  • Data marts and materialized views implementation

Advanced SQL and Query Execution for Government

  • Join strategies and data redistribution methods
  • OLAP capabilities and window functions
  • Temporary tables, subqueries, and derived table usage

EXPLAIN Plans and Query Tuning for Government

  • Reading and interpreting EXPLAIN output results
  • Cost analysis techniques and plan optimization strategies
  • Join movement and segment-local operation considerations

Greenplum Utilities and Best Practices for Government

  • ANALYZE and VACUUM operations
  • Data loading and movement using Nexus tools
  • Security measures, permissions management, and performance optimization tips

Summary and Next Steps for Government

Requirements

  • A comprehensive understanding of relational databases and SQL
  • Practical experience with data warehousing or analytical systems
  • Proficiency in Linux command line operations

Audience for Government

  • 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