What is Greenplum Administrator Training about?
Gain in-depth knowledge on Greenplum Database Features, Benefits, and Architecture in terms of shared nothing, MPP design and how Greenplum database supports redundancy and high availability. Gain Hands-on experience to Install, Configure and Administer a Greenplum Database, query data, Implement security and access strategies. Be proficient with DDL, DML, and DQL to access, manage.

Learn how to Implement appropriate table storage models, compression, and tablespaces, data distributions, and table partitioning strategies to store data in a Greenplum database. Improve query performance by following a number of performance enhancement tips by understanding the Pivotal Query Optimizer, database tuning, query profiling, tuning and rewriting, and indexing strategies

Greenplum administrator course serves as a prerequisite for the Pivotal Greenplum Administrator Certification exam. At the end of this course, you will be able to confidently take the Pivotal Greenplum Administrator Exam and earn one of the highest paying certifications in the industry

Suggested Audience:

Administrators responsible for the installation and maintenance of the Greenplum database, including initial system preparation, installation, and configuration as well as the ongoing tuning and troubleshooting
Duration:

Classroom - 4 Days
Live Online - 24 Hours
What are the objectives of Greenplum Administrator Training ?
At the end of the greenplum administrator training, you should be able to:

• Describe Greenplum database features, benefits, and architecture in terms of shared nothing, MPP design and how Greenplum database supports redundancy and high availability
• Install, configure, and administer a Greenplum Database
• Be proficient with DDL, DML, and DQL to access, manage, and query data
• Implement appropriate table storage models, compression, and tablespaces, data distributions, and table partitioning strategies to store data in a Greenplum database
• Understand best practices for data loading
• Be proficient in data modeling and physical design decisions
• Improve query performance by following a number of performance enhancement tips by understanding the Pivotal Query Optimizer, database tuning, query profiling, tuning and rewriting, and indexing strategies
• Implement security and access strategies
• Perform backup and restore



Who is Greenplum Administrator Training for?
Anyone who wants to add Greenplum Administrator skills to their profile
Teams getting started on Greenplum Administrator projects
What are the prerequisites for Greenplum Administrator Training?
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 OutlineExpand All
1. INTRODUCTION
2. PSQL AND UTILITIES
3. DATABASE INSTALLATION AND INITIALIZATION
4. DEFINING AND SECURING THE DATABASE
5. DATA LOADING AND DISTRIBUTION
6. DATABASE MANAGEMENT AND ARCHIVING
7. DATA MODELING & DESIGN
8. PERFORMANCE ANALYSIS & TUNING
Lab - 9
Who is the instructor for this training?
The trainer for this Greenplum Administrator Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Greenplum Administrator Training - Certification & Exam
This course is aligned to Pivotal Greenplum Administration Certification.The certification fee is not included as part of the training fee.

The price of the exam is $200. Purchasing the Certification Exam entitles you to one (1) proctored exam attempt with a Pivotal-authorized testing center. You will receive exam scheduling and registration instructions via email after your purchase. Your exam must be scheduled and taken within 90 days of your exam purchase or your exam attempt will be forfeited.

Your exam must be scheduled and taken within 90 days of your exam purchase or your exam attempt will be forfeited.

The Pivotal Greenplum Administrator certification exam is designed to test and validate your proficiency with Pivotal Greenplum in the following areas:

Describing Greenplum features, benefits, and architecture
Database installation and initialization
Defining and securing the user database
Data loading and distribution
Database management and archiving
Data modeling and design
Performance analysis and tuning
Recommended Certification Path:

Experience with installing and maintaining the Greenplum database, including initial system preparation, installation, and configuration as well as ongoing tuning and troubleshooting
Take the proctored Pivotal Greenplum Administrator Certification exam
Exam Topics:

Architecture Design
Deployment
B & R
Security
Operations
Workload Management
Performance Management
Loading/Unloading