loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Greenplum Architecture

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With SpringPeople Software Private Limited

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Greenplum Architecture

HSR Layout, Bangalore

No Reviews Yet
1 Interested

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

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

Who should attend

Suggested Audience - Database Administrators

Pre-requisites

*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

Laptop

Key Takeaways

1. Greenplum fundamental concepts
2. Database installation and initialization
3. Greenplum database tools, utilities and internals
4. Defining and Securing the user database
5. Data loading and Distribution
6. Database management and Archiving
7. Data modeling and Design
8. Performance analysis and Tuning
9. Developing reports using advanced SQL
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

TBA

B.Tech, M.Tech


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.
Seats Left-

Students Interested 1

Course Id: 21355