Course Code: greenplumdatabase
Duration: 14 hours
Prerequisites:
  • An understanding of ___.
  • Experience with ___.
  • ___ programming experience.

Audience

  • ___
  • ___
  • ___
Course Outline:

INTRODUCTION 

  • Greenplum Database Overview
  • What is Greenplum Database?
  • Greenplum Database features
  • Greenplum Database architecture

PSQL AND UTILITIES 

  • psql CLI utility 
  • Command Center   

DATABASE INSTALLATION AND INITIALIZATION 

  • System preparation and verification 
  • Greenplum Database Initialization   

ADMINISTRATION

  • Creating users
  • Creating a group
  • Adding users

DATABASE

  • Creating a database
  • Granting privileges
  • Creating a schema

DEFINING AND SECURING THE DATABASE 

  • DDL, DML, DQL 
  • Roles and Privileges 
  • Controlling Access 
  • Managing Resources 
  • GP Workload Manager   

DATA LOADING AND DISTRIBUTION 

  • Implementing table storage models, compression,  and tablespaces 
  • Data loading 
  • Table partitioning   

DATABASE MANAGEMENT AND ARCHIVING 

  • Managing the Greenplum Database 
  • Backups and Restores   

DATA MODELING & DESIGN 

  • Data modeling in Greenplum 
  • Physical design decisions   

PERFORMANCE ANALYSIS & TUNING 

  • Query Optimizer 
  • DB Tuning 
  • Query profiling 
  • Query tuning and rewriting 
  • Statistics 
  • Indexing strategies
  • Analyzing tables
  • Changing optimizers