Pivotal Greenplum Administrator
This course provides administrators with the necessary background to install and maintain the Greenplum database. Students will learn the essential skills required to use the Greenplum database system. The course explores fundamental concepts using the psql CLI, DDL, DML, and DQL, data loading, backup and restore; data modeling, as well as some performance tuning strategies.
Duration: 40-45hrs
Course Content:
INTRODUCTION
- Overview
PSQL AND UTILITIES
- psql CLI utility
- Command Center
DATABASE INSTALLATION AND INITIALIZATION
- System preparation and verification
- Greenplum Database Initialization
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
- Pivotal Query Optimizer
- DB Tuning
- Query profiling
- Query tuning and rewriting
- Statistics
- Indexing strategies