Module 1: Greenplum Architecture
- About the Greenplum Master
- About the Greenplum Interconnect
- About Segment Mirroring
- Segment Failover and Recovery
- About Master Mirroring
- Understanding Greenplum Distribution Policies
- Broadcast
- Understanding Query Planning and Dispatch
- Understanding Greenplum Query Plans
- Understanding Parallel Query Execution
- Managing Roles and Privileges
- Security Best Practices for Roles and Privileges
- Creating New Roles (Users)
- Creating Groups (Role Membership)
- Managing Object Privileges
- Encrypting Data
- Time-based Authentication
- Required Permissions
- How to Add Time-based Constraints
- Allowing Connections to Greenplum Database
- Limiting Concurrent Connections
- Establishing a Database Session
- Supported Client Applications
- Greenplum Database Client Applications
- Database Application Interfaces
- Third-Party Client Tools
- Troubleshooting Connection Problems
- Creating and Managing Databases
- Creating and Managing Tablespaces
- Creating and Managing Schemas
- Creating and Managing Tables
- Choosing the Table Storage Model in Greenplum
- Partitioning Large Tables
- Creating and Using Sequences
- Using Indexes in Greenplum Database
- Creating and Managing Views
- About Concurrency & Isolation in GPDB
- Inserting New Rows
- Updating Existing Rows
- Deleting Rows
- Vacuuming the Database
- QUERY PLAN
- Overview
- Starting Greenplum Database
- Stopping Greenplum Database
- Greenplum data loading options
- External tables:
- Example of loading data with External Tables and gpfdist
- gpload
- Overview of Backup and Restore Operations
- Backing Up a Database
- Restoring From Parallel Backup Files
- pg_dump
- Monitoring System State
- Viewing the Database Server Log Files
- Routine Vacuum and Analyze
- Routine Reindexing Bigdata Greenplum DBA