Big Data Greenplum DBA Online Training

TekSlate’s syndicate of online trainers are experienced experts in knowledge transfer. The best place for learning, if you are aiming to learn the crux of any technology

Big Data Greenplum DBA Online Training Course Content:

Greenplum Architecture

Greenplum Master
Greenplum Segments
Greenplum Interconnect
Greenplum Concepts, Features and Benefits

Redundancy and Failover in Greenplum Database

Segment Mirroring
Master Mirroring
Data Distribution in greenplum

Checking for Uneven Data Distribution

Database Installation and Configuration

Lab – Database Installation and Configuration

Access Control and Security

Managing Roles and Privileges

Security Best Practices for Roles and Privileges
Creating New Roles (Users)
Altering Role Attributes
Creating Groups (Role Membership)
Managing Object Privileges
Configuring Client Authentication

Allowing Connections to Greenplum Database
Editing the pg_hba.conf File
Limiting Concurrent Connections
Accessing the Database

Establishing a Database Session
Supported Client Applications
Greenplum Database Client Applications
PgAdmin III for Greenplum Database
Database Application Interfaces
Third-Party Client Tools
Troubleshooting Connection Problems
Lab

Managing Workload and Resources

Overview of Greenplum Workload Management
How Resource Queues Work in Greenplum Database
Steps to Enable Workload Management
Configuring Workload Management
Resource Queues
Database Administration

Defining Database Objects (databases, schema, table, sequence etc)
Creating and using databaseso Creating and using schemas
Creating and Using Sequences
Indexes in Greenplum Database
Creating and Managing Views
Managing Data

Vacuuming the Database
Querying Data
Query Performance
EXPLAIN Output, EXPLAIN ANALYZE Output
Partitioning Large Tables

Understanding Table Partitioning in Greenplum Database
Deciding on a Table Partitioning Strategy
Creating Partitioned Tables
Loading Partitioned Tables
Maintaining Partitioned Tables
Lab

Greenplum Database Loading Tools Overview

About External Tables
About gpload
About COPY
Using the Greenplum Parallel File Server (gpfdist)

System Administration

Starting and Stopping Greenplum
Routine admin tasks
Uploading Configuration File Changes Only
Configuring Your Greenplum System

About Greenplum Master and Local Parameters
Setting Configuration Parameters
Setting a Local Configuration Parameter
Setting a Master Configuration Parameter
Enabling Alerts and Notifications

Checking for Failed Segments

Recovering a Failed Segment

Recovering a Failed Master

Backing up and Restoring Databases

Backup and Restore Operations
Expanding a Greenplum System

Lab

Monitoring a Greenplum System

Monitoring Database Activity and Performance
Monitoring System State
Enabling System Alerts and Notifications
Checking System Stateo Checking Disk Space Usage
Routine System Maintenance Tasks

Routine Vacuum and Analyze
System Catalog Maintenance
Managing Greenplum Database Log Files

Performance Tuning

Common Causes of Performance Issues
Identifying Hardware and Segment Failures
Managing Workload
Maintaining Database Statistics
Identifying Statistics Problems in Query Plans

Tuning Statistics Collection

Optimizing Data Distribution

Optimizing Your Database Design

Lab

GP-development

Functions
Basic shell scripts
Investigating a Performance Problem

Checking System State
Checking Database Activity
Checking for Active Sessions (Workload)
Checking for Locks (Contention)
Checking Query Status and System Utilization
Troubleshooting Problem Queries
gp_toolkit administration schema

System catalog

Performance issues and tips

Automation scripts for GPDB administration

Lab

Materials/tools used

1. Training ppts
2. Greenplum admin guide.
3. Greenplum installation guide.
4. Pg admin installer for windows. (Greenplum client for windows)
5. Greenplum community edition.
6. Putty
7. GP connectivity tools.

Expected from audience (for Lab)

1. Laptop or desktop with centos installed.
2. Internet.

To Attend Free Demo (Or) For any Queries Write to us at

[email protected] (or)
[email protected] (or)
[email protected]

Call us on

USA :- +1 415-830-3823
India :- 91 954-262-2288