Who should attend
This course is intended for any person who presently or plans to:
- Install Greenplum Database
- Design and develop for Greenplum Database implementation
- Administer and manage the Greenplum Database
Prerequisites
To understand the content and successfully complete this course, a student should have knowledge and skills associated with the following:
- Basic UNIX or Linux commands
- SQL syntax
- Fundamental relational database concepts
A list of specific prerequisite courses can be found in EMC Education Services Learning Management System.
Course Objectives
Upon successful completion of this course, participants should 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
- Install, initialize, validate, and configure Greenplum Database
- Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues
- Implement system-level and database-level security
- Use table partitioning to logically divide data and load data into a Greenplum database instance using external tables, SQL COPY, and ETL.
- 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
- Identify and describe the data models used in data warehousing and describe how data is stored in Greenplum
- Distribute and store data in Greenplum using a distribution key and partitioning
- Use EXPLAIN and EXPLAIN ANALYZE to help the 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
Course Content
This EMC Education Services 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.