‹ Back To Training

Introduction to Greenplum Database

Timeline: 1 Day

Topics

Expand All › ‹ Collapse All

  • GPDB overview and positioning
  • Shared nothing and MPP
  • Master, segment hosts and interconnect
  • Redundancy and failover
  • Software vs DCA
  • Configuration options
  • Introduction to Single Node VM
  • ODBC/JDBC client setup
  • Client tools and psql
  • GPDB supported SQL
  • Postres vs GPDB
  • Distribution
  • Partitioning
  • Table design and optimization
  • Statistics/Analyze\
  • Vacuum
  • GPDB query execution steps
  • Explain overview
  • Overview
  • Copy, External tables, gpfdist, gpload
  • Aggregate expressions/Window functions overview
  • Built in functions overview
  • Database analytic extensions overview
  • Monitoring overview
  • System tables overview
  • System configuration overview
  • Backup overview
  • Security overview
  • Upgrade overview