Corporate training for Greenplum and PostgreSQL

Working with Greenplum Platform and PostgreSQL Customized Hands-on Workshop

 

Total Duration: 40 Hours

 

Setup: Online in 10 sessions / 4 hours each

1. Greenplumand PostgreSQLFundamental Concepts (4 hours / 1 session)

• Introduction to PostgreSQL Architecture
• Basics of Data Warehousing
• Greenplum Concepts, Features, and Benefits
• Greenplum Architecture
  • Shared Nothing and MPP Implementation
• Versioning, Rereleases, Appliances and Pluggable Modules

2. Database Installation and Initialization(8 hours / 2 sessions)

• Setup of PostgreSQL Single Instance
• Greenplum distribution of PostgreSQL Instances
• Systems Preparation and Verification
• Greenplum Database Initialization
• Basic Validation and Administration Commands
• Connecting to Greenplum from Different Applications

3. Greenplum Database Tools, Utilities, and Internals(4 hours / 1 session)

• PostgreSQL Core Database Functionality
• PSQL Client and Greenplum Utilities
• Greenplum Performance Monitor
• Greenplum Database Server Configuration
• Greenplum Database Internals

4. Defining and Securing the User Database(4 hours / 1 session)

• Understanding Greenplum Platform Structure
• Data Definition Language
• Data Manipulation and Data Query Language
• Roles, Privileges, and Resources

5. Data Loading and Distribution(4 hours / 1 session)

• Data Loading
• Table Partitioning
• Streaming and Real-time Tools
• Integration with Analytics Platforms

6. Database Management and Archiving(4 hours / 1 session)

• Managing PostgreSQL Instances
• Managing the Greenplum Database
• Backup and Restores
• Patching and Maintenance Operations

7. Data Modeling and Design(4 hours / 1 session)

• Data Modeling
• Physical Design Decisions
• Performance turning overview
• Database Tuning and Indexing

8. 8.Functions, Analysis and Advanced SQL (8 hours / 2 sessions)

• Advanced Analysis Using Online Analytic Processing (OLAP)
• PostgreSQL Functions
• User-Defined Functions for Greenplum Cluster
• Advanced SQL Topics and Performance Tips