Introduction to Greenplum distributed database development to proficient (architecture, deployment, management, development and optimization) [course sharing], greenplum Tuning

Introduction to Greenplum distributed database development to proficient (architecture, deployment, management, development and optimization) [course sharing], greenplum Tuning
Greenplum introduction to distributed database development is proficient (architecture, deployment, management, development and optimization)

If you are interested in this course, you can add my qq2059055336 to contact me

Course outline

1 Greenplum Architecture

What is Greenplum

Greenplum Architecture

Greenplum high availability architecture

 

2 install Greenplum

Configure the environment

Install and initialize the GPDB System

Start or stop a database

Configure the GP system

 

3 distributed database storage

How data is stored

Distribution Policy

 

4 GBDB Query Processing

Query Command Execution

SQL Query Processing Mechanism

Parallel query plan

 

5. Role permissions and client authentication management

Client Authentication

Manage users and groups

 

6. client interfaces and programs

PgAdmin III

PSQL

 

7. Define database objects

Create and manage databases

Create and manage tablespaces

Create and manage Modes

Create and manage tables

Partition Table

Data Distribution and partitioning

Compressed Storage and row and column Storage

Sequence, index, and view

8. Manage data

Insert, update, and delete records

Transaction Management

Space recycling and statistics

 

9. query data

Define Query

Use functions and operators

Query Analysis

 

10 workload and resource management

Overview of GP workload management

Configure workload management

Create resource queue

Allocate resource queue

Check resource queue status

11 Load And Unload data

Overview of GP load commands

Load data to GP

Detach data from GP

Format a data file

 

12. Backup Recovery

Serial backup and recovery

Parallel recovery and recovery

 

13 Performance Tuning

How to optimize

Common performance problems

14 GP system configuration parameters

Master and localization parameters of GP

Set configuration parameters

Configuration Parameter types

 

15. Enable High Availability

Overview of GP High Availability

Enable Mirror of GP

When Segment fails

Failed Segment recovery

Failed Master recovery

16 GP MapReduce

MapReduce Basics

GP MapReduce Programming

MapReduce job execution and Fault Diagnosis