Bigdata Greenplum DBA Online Training

1
Mindmajix

• Bigdata Greenplum DBA Online Training

2
Introduction to Greenplum DBA
Greenplum Database builds on the foundations of
open source database PostgreSQL. GreenPlum
primarily functions as a data warehouse and
utilizes a massively parallel (MPP) architecture.
GreenPlum Database is partitioned across multiple
segment servers and each segment owns and manages
a distinct portion of the overall data. Benefits
of Bigdata Greenplum DBA Online Training is to
enhance skills on database administrators,
preparing to deploy the Greenplum database system.
3
Course Curriculum
Module 1  Topics Greenplum Architecture, About
the Greenplum Master, About the Greenplum
Interconnect, About Segment Mirroring, Segment
Failover and Recovery, About Master
Mirroring Module 2 Topics About Distributed
Databases, Understanding Greenplum Distribution
Policies, Broadcast Module 3 Topics About
Greenplum Query Processing, Understanding Query
Planning and Dispatch, Understanding Greenplum
Query Plans, Understanding Parallel Query
Execution
4
Module 4 Topics Access control and security,
Managing Roles and Privileges, Security Best
Practices for Roles and Privileges, Creating New
Roles (Users), Creating Groups (Role
Membership) Module 5 Topics Configuring Client
Authentication, Allowing Connections to Greenplum
Database, Limiting Concurrent Connections Module
6 Topics Accessing the Database, Establishing a
Database Session, Supported Client Applications,
Greenplum Database Client Applications, Database
Application Interfaces. Module
7 Topics Defining Database Objects, Creating
and Managing Databases, Creating and Managing
Tablespaces, Creating and Managing Schemas,
Creating and Managing Tables, Choosing the Table
Storage Model in Greenplum.
5
Module 8 Topics Managing Data, About
Concurrency Isolation in GPDB, Inserting New
Rows, Updating Existing Rows, Deleting Rows,
Vacuuming the Database, QUERY PLAN Module
9 Topics Starting and Stopping Greenplum,
Overview, Starting Greenplum Database, Stopping
Greenplum Database Module 10 Topics Loading
and Unloading Data, Greenplum data loading
options, External tables, Example of loading data
with External Tables and gpfdist, gpload Module
11 Topics Backing Up and Restoring Databases,
Overview of Backup and Restore Operations,
Backing Up a Database, Restoring From Parallel
Backup Files, pg_dump
6
Module 12  Topics Monitoring a Greenplum
System, Monitoring System State, Viewing the
Database Server Log Files Module
13  Topics Routine System Maintenance Tasks,
Routine Vacuum and Analyze, Routine Reindexing,
Managing Greenplum Database Log Files Module
14  Topics Common Causes of Performance Issues,
Identifying Hardware and Segment Failures,
Managing Workload, Maintaining Database
Statistics, Optimizing Data Distribution,
Optimizing Your Database Design Module
15  Topics Investigating a Performance Problem,
Checking System State, Checking Database
Activity, Troubleshooting Problem Queries,
Investigating Error Messages
7
Our Bigdata Greenplum DBA Online Training  batches
starts every day. You can attend a DEMO for
free
8
We Provide Online Training On
TIBCO BW Tableau QlikView TIBCO Spotfire SAS
BI SAP Hybris Selenium Oracle DBA Oracle
SOA Oracle Financials IOS Development Android Data
Modeling- Erwin Performance Testing SFDC SAP
UI5 SAP Hana
9
We offers You
1. Interactive Learning at Learners convenience 2
. Industry Savvy Trainers 3.Real
Time" Practical scenarios 4. Learn Right from
Your Place 5. Customized Course Curriculum 6.
24/7 Server Access 7. Support after Training and
Certification Guidance 8. Resume Preparation and
Interview assistance 9. Recorded version of
sessions  
10
Thank you  Your feedback is highly important to
improve our course material. For Free Demo
Please Contact   INDIA 91-9246333245, US
1-2013780518, Email id info_at_mindmajix.com   htt
p//bit.ly/15wqLU8