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.
Mindmajix
is one of the leading IT institution which offers Big
data Greenplum DBA Online Training. Greenplum optimizer uses a
cost-based algorithm to evaluate potential execution plans and Database takes a
global view of execution across the computer cluster. The factors in the cost
of moving data between nodes. The training course also explains the concepts
and in-depth features by specialized experience professional with hands-on. Our
team trainer’s expertise in each phase of the eLearning modules.
Course
Curriculum
Introduction
to Greenplum
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
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), Managing Object Privileges, Encrypting Data, Time-based
Authentication, Required Permissions, How to Add Time-based Constraints
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,
Third-Party Client Tools, Troubleshooting Connection Problems
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, Partitioning Large Tables,
Creating and Using Sequences, Using Indexes in Greenplum Database, Creating and
Managing Views
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
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
To Learn
More Follow Below Link:
No comments:
Post a Comment