Left

Pivotal Certified Architecture Administration and Implementation Training

Live Online & Classroom Certification Training

Pivotal Certified Architecture Administration and Implementation course is an amazingly designed course to teach Greenplum features, benefits, and architecture in terms of shared nothing and the MPP design and how Greenplum supports redundancy and high availability, Install, initialize, validate, and configure Greenplum Database etc.

(4.7) 193 Learners
Instructed by SPRINGPEOPLE
INDIA

No Public/Open-house class on the topic scheduled at the moment!

Course Description

Overview

This course provides customers partners and internal employees who will participate in the design and implementation of the Greenplum environment the information they need to install configure and manage the Greenplum database system. The Greenplum Architecture Administration and Implementation course introduces students to the Greenplum environment consisting of the Greenplum Database and supported systems. Students are introduced to fundamental concepts on data warehousing business intelligence and how Greenplum helps to solve business problems in managing and analyzing Big Data. Students will install configure and manage the Greenplum database system by evaluating logical models and business requirements to determine the best physical design for a Greenplum database

Objective

At the end Greenplum Architecture, Administration & Implementation training course, participants will be able to:

  • Describe Greenplum features, benefits, and architecture in terms of shared nothing and the MPP design and how Greenplum supports redundancy and high availability
  • Identify and describe the data models used in data warehousing and describe how data is stored in Greenplum
  • Install, initialize, validate, and configure Greenplum Database
  • Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues
  • Use table partitioning as a design methodology for handling large tables
  • Load data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities
  • Use data manipulation language and data query language to access, manage, and query data
  • Perform system administrative tasks, including managing and checking the state of the Greenplum database and its data and checking the distribution of data
  • Perform backup and restoration of Greenplum data
  • Distribute and store data in Greenplum using a distribution key and partitioning
  • Use EXPLAIN and EXPLAIN ANALYZE to help the Greenplum query plan optimizer determine how to handle a submitted query
  • Improve query performance by keeping statistics up to date and tuning the database for sampling size and error conditions
  • Determine when it is best to use an index and what type of index to use
  • Improve query performance by following a number of performance enhancement tips

Suggested Audience - Database Administrators

Duration - 5 Days

Prerequisites

  • Basic UNIX or Linux command-line navigation and administration skills
  • Database query language basics, including, but not limited to basic SQL knowledge for accessing database objects
  • Fundamental relational database concepts

Course Curriculum

Expand All
  • The Basics of Data Warehousing
  • Greenplum Concepts, Features, and Benefits
  • Greenplum Architecture - Shared nothing and Massively Parallel Processing Implementation
  • Systems Preparation and Verification
  • Greenplum Database Initialization
  • PSQL Client and Greenplum Utilities
  • Greenplum Performance Monitor
  • Greenplum Database Server Configuration
  • Greenplum Database Internals
  • Data Definition Language
  • Data Manipulation and Data Query Language
  • Roles, Privileges, and Resources
  • Data Loading
  • Table Partitioning
  • Managing the Greenplum Database
  • Backup and Restore
  • Data Modeling
  • Physical Design Decisions
  • JOIN Tables - Types and Methods
  • Database Tuning
  • Explain the EXPLAIN Plan - Analyzing Queries
  • Improve Performance with Statistics
  • Indexing Strategies
  • Advanced Reporting Using OLAP
  • PostgreSQL Functions
  • Advanced SQL Topics and Performance Tips

Certification

SpringPeople works with top industry experts to identify the leading certification bodies on different technologies - which are well respected in the industry and globally accepted as clear evidence of a professional’s “proven” expertise in the technology. As such, these certification are a high value-add to the CVs and can give a massive boost to professionals in their career/professional growth.

Our certification courses are fully aligned to these high-profile certification exams; at the end of the course, participants will have detailed knowledge, be eligible and be fully ready take up these certification exams and pass with flying colours.

 

Resources

SpringPeople Corporate Learning Center

Job Trends

About the Instructor

Founded in 2009, SpringPeople is a global premier eLearning marketplace for Online Live, Instructor-led classes in the region. It is a certified training delivery partner of leading technology creators, namely Pivotal, Elastic, Lightbend, EMC, VMware, MuleSoft, RSA, and... Read More


Course Rating and Reviews

4.7

Average Rating
5 Stars
28
4 Stars
12
3 Stars
1
2 Stars
0
1 Star
0

SPRINGPEOPLE SpringPeople Trainer

Mahender Pandiri

Course:
Instructor:
Course Material:
Class Experience:
NA

SPRINGPEOPLE SpringPeople Trainer

Vinayak Suryawanshi

Experis
Course:
Instructor:
Course Material:
Class Experience:
Trainer can ask few queries related to subject to students randomly during session so that they will attend carefully. :)

SPRINGPEOPLE SpringPeople Trainer

Stanley

Course:
Instructor:
Course Material:
Class Experience:
Not as such

This class is intended for participants with some prior exposure to the technology and are now looking to build up their expertise on the topic.

On successful completion of the course, participants will be eligible to sit of the related certification exam (see course overview). All participants receive a course completion certificate, demonstrating their expertise on the subject.

Total duration of the online, live instructor led sessions. Sessions are typically delivered as short lectures (2-hrs weekdays/3-hrs weekends) and detailed hands-on guidance.

Expected offline lab work hours that participants will need to complete and submit to the trainer, during and after the instructor-led online sessions.

  1. We are happy to refund full fee paid - no questions asked - should you feel that the training is not up to your expectations.
  2. Our dedicated team of expert training enablement advisors are available on email, phone and chat to assist you with your queries.
  3. All courseware, including session recordings, will always be available to access to you for future reference and rework.

Contact Us

+91-80-6567-9700 (BLR)

training@springpeople.com

Request Call Back

Related Courses

Recently Viewed