Greenplum Architecture, Administration & Implementation

No Reviews Yet

HSR Layout, Bangalore

Course ID: 21354

HSR Layout, Bangalore

TBA picture
No Reviews Yet

Date and Time

Not decided yet.

TBA picture

B.Tech, M.Tech

About TBA

The trainer is an expert and has 12+ years of exhaustive experience in the IT industry with vast exposure to designing and developing applications. He is able to create rich, interactive and lively learning experience. His ability to powerfully communicate complex
technology concepts to audiences of various levels is highly appreciated by his trainees and training managers. Global giants, such as Nokia, IBM, Sun, Capgemini, GE, Sap Labs, Accenture, HP, NSN, Honeywell etc have benefited from his training deliveries, and keep coming back for repeated deliveries.
No reviews currently

About the Course

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

Topics Covered

* Greenplum fundamental concepts
* Database installation and initialization
* Greenplum database tools, utilities and internals
* Defining and Securing the user database
* Data loading and Distribution
* Database management and Archiving
* Data modeling and Design
* Performance analysis and Tuning
* Developing reports using advanced SQL

Who should attend

Database Administrators


* 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

What you need to bring


Key Takeaways

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


No reviews currently


Post your requirement and let us connect you with best possible matches for Database Training classes Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more