50 Hrs
3707+ Enrollments
Bigdata Greenplum DBA Training
This course will help you gain hands-on experience with the Greenplum DBA environment. You will learn about Greenplum architecture, how to install and configure Greenplum, and how to manage and monitor a Greenplum cluster. In addition, you will learn about backup and recovery procedures, performance tuning, and security management.
50 Hrs
3707+ Enrollments
Bigdata Greenplum DBA Training
Greenplum DBA
Overview of Course
Bigdata Greenplum DBA Training is a comprehensive course designed to teach you the skills required to manage and maintain a Greenplum data warehouse. This course is perfect for individuals who are interested in building a career in Big Data Administration.
Course Highlights
In-depth coverage of Greenplum architecture and administration
Hands-on experience with Greenplum installation and configuration
Practical knowledge of managing and monitoring a Greenplum cluster<br /><br />
Key Differentiators
Personalized Learning with Custom Curriculum
Training curriculum to meet the unique needs of each individual
-
Trusted by over 100+ Fortune 500 Companies
We help organizations deliver right outcomes by training talent
-
Flexible Schedule & Delivery
Choose between virtual/offline with Weekend options
-
World Class Learning Infrastructure
Our learning platform provides leading virtual training labs & instances
-
Enterprise Grade Data Protection
Security & privacy are an integral part of our training ethos
-
Real-world Projects
We work with experts to curate real business scenarios as training projects
Skills You’ll Learn
#1
Greenplum architecture and administration
#2
Installation and configuration of Greenplum
#3
Management and monitoring of a Greenplum cluster
#4
Backup and recovery procedures
#5
Performance tuning and security management
Training Options
1-on-1 Training
On Request
Access to live online classes- Flexible schedule including weekends
- Hands-on exercises with virtual labs
- Session recordings and learning courseware included
- 24X7 learner support and assistance
- Book a free demo before you commit!
Corporate Training
On Request
- Everything in 1-on-1 Training plus
- Custom Curriculum
- Extended access to virtual labs
- Detailed reporting of every candidate
- Projects and assessments
- Consulting Support
- Training aligned to business outcomes
For Corporates
Unlock Organizational Success through Effective Corporate Training: Enhance Employee Skills and Adaptability- Choose customized training to address specific business challenges and goals, which leads to better outcomes and success.
- Keep employees up-to-date with changing industry trends and advancements.
- Adapt to new technologies & processes and increase efficiency and profitability.
- Improve employee morale, job satisfaction, and retention rates.
- Reduce employee turnovers and associated costs, such as recruitment and onboarding expenses.
- Obtain long-term organizational growth and success.
Course Reviews
Curriculum
- Greenplum Architecture
- About the Greenplum Master
- About the Greenplum Interconnect
- About Segment Mirroring in Greenplum
- Segment Failover and Recovery in Greenplum
- About Master Mirroring in Greenplum
- About Distributed Databases
- Understanding Greenplum Distribution Policies
- Broadcast
- About Greenplum Query Processing
- Understanding Query Planning and Dispatch in Greenplum
- Understanding Greenplum Query Plans
- Understanding Parallel Query Execution in Greenplum
- Access control and Greenplum security
- Managing Roles and Privileges in Greenplum
- Security Best Practices for Roles and Privileges
- Creating New Roles (Users) for Greenplum
- Creating Groups (Role Membership) in Greenplum
- Managing Object Privileges
- Encrypting Data in Greenplum
- Greenplum Time-based Authentication
- Required Permissions for Greenplum
- How to Add Time-based Constraints in Greenplum
- Configuring Greenplum Client Authentication
- Allowing Connections to Greenplum Database
- Limiting Concurrent Connections in Greenplum
- Accessing the Greenplum Database
- Establishing a Database Session
- Supported Client Applications
- Greenplum Database Client Applications
- Greenplum Database Application Interfaces
- Third-Party Greenplum Client Tools
- Troubleshooting Greenplum Connection Problems
- Defining Greenplum Database Objects
- Creating and Managing Greenplum Databases
- Creating and Managing Greenplum Tablespaces
- Creating and Managing Schemas in Greenplum
- Creating and Managing Tables in Greenplum
- Choosing the Table Storage Model in Greenplum
- Partitioning Large Tables
- Creating and Using Sequences
- Using Indexes in Greenplum Database
- Creating and Managing Views in Greenplum
- Managing Data in Greenplum
- About Concurrency & Isolation in Greenplum database
- Inserting New Rows in Greenplum
- Updating Existing Rows in Greenplum
- Deleting Rows in Greenplum
- Vacuuming the Greenplum Database
- QUERY PLAN
- Starting and Stopping Greenplum
- Overview
- Starting Greenplum Database
- Stopping Greenplum Database
- Loading and Unloading Data
- Greenplum data loading options
- Greenplum External tables
- Example of loading data with External Tables and greenplum dist
- Green plum load
- Backing Up and Restoring Greenplum Databases
- Overview of Backup and Restore Greenplum Operations
- Backing Up a Greenplum Database
- Restoring From Parallel Backup Files
- pg_dump
- Monitoring a Greenplum System
- Monitoring Greenplum System State
- Viewing the Greenplum Database Server Log Files
- Routine System Maintenance Tasks
- Routine Vacuum and Analyze
- Routine Reindexing
- Managing Greenplum Database Log Files
- Common Causes of Performance Issues
- Identifying Hardware and Segment Failures
- Managing Workload
- Maintaining Database Statistics
- Optimizing Data Distribution
- Optimizing Your Database Design
- Investigating a Performance Problem
- Checking System State
- Checking Database Activity
- Troubleshooting Problem Queries
- Investigating Error Messages
- Less lessons
Contact Learning Advisor
Meet the instructor and learn about the course content and teaching style.- Make informed decisions about whether to enroll in the course or not.
- Get a perspective with a glimpse of what the learning process entails.
Description
Target Audience:
- Database Administrators
- System Administrators
- Data Analysts
- Big Data Professionals
- IT Professionals
Prerequisite:
- Basic knowledge of Linux commands
- Familiarity with SQL
Benefits of the course:
- Gain hands-on experience with Greenplum DBA environment
- Learn from experienced instructors
- Develop skills required to manage and maintain a Greenplum data warehouse
- Enhance your career prospects in the field of Big Data Administration
Exam details to pass the course:
- There is no exam required to pass this course.
- However, to receive a completion certificate, you must complete all the modules and pass the assessments.
Certification path:
- There are no specific certifications needed to learn this course.
- However, upon completion of the course, you will receive a completion certificate from Skillzcafe.
Career options after doing the course:
- Big Data Administrator
- Database Administrator
- Data Analyst
- Data Scientist
Why should you take this course from Skillzcafe:
Why should you take this course from Skillzcafe:
Experienced instructors- Flexible learning options
- Hands-on experience with Greenplum DBA environment
- Affordable pricing
- Access to a community of learners
FAQs
No, prior knowledge of Greenplum is not required for this course.
The course duration is 50 hours.
No, you will have access to a Greenplum environment through a virtual machine provided by Skillzcafe.
Equip your employees with the right skills to be prepared for the future.
Provide your workforce with top-tier corporate training programs that empower them to succeed. Our programs, led by subject matter experts from around the world, guarantee the highest quality content and training that align with your business objectives.
-
1500+
Certified Trainers
-
200+
Technologies
-
2 Million+
Trained Professionals
-
99%
Satisfaction Score
-
2000+
Courses
-
120+
Countries
-
180+
Clients
-
1600%
Growth
Live Chat