Brochure
Enquire- 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
- Home
- Mindmajix Technologies
- Courses
- Bigdata Greenplum DBA Training
Bigdata Greenplum DBA Training
BY
Mindmajix Technologies
Learn the skills and methodologies required for big data analysis and administration using the Bigdata Greenplum DBA ...Read more
Online
Quick Facts
| particular | details | ||||
|---|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
MindMajix Technologies Inc. created the Bigdata Greenplum DBA Training certification course for students who wish to advance in their careers by learning the core topics such as Greenplum's big data principles and big data analytics methodologies in order to be better prepared for future employment prospects.
Bigdata Greenplum DBA Training online classes will educate you on how the database takes a global perspective of execution throughout the computer network and how to implement potential execution strategies. Bigdata Greenplum DBA Training online course is separated into 15 sections that cover major Greenplum subjects such as Greenplum architecture, broadcasting, distribution policy, distributed database, Greenplum security, monitoring, data distribution optimization, and much more. The course also includes Mindmajix's premium services such as resume building, counselling, and mock interviews.
The highlights
- Certificate of completion
- Certification oriented curriculum
- Lifetime self-paced video access
- Flexible schedule
- Project use cases
- 30 hours session
- 20 hours of labs
- Quizzes & Mocks
- Free demo on request
- One-on-one doubt resolution
- 100% money-back guarantee
- 24/7 lifetime assistance
Program offerings
- Certificate of completion
- Certification oriented curriculum
- Lifetime self-paced video access
- Flexible schedule
- Project use cases
- 30 hours session
- 20 hours of labs
- Quizzes & mocks
- Free demo on request
- One-on-one doubt resolution
Course and certificate fees
certificate availability
Yes
certificate providing authority
Mindmajix Technologies
Who it is for
What you will learn
Database management
After completing the Bigdata Greenplum DBA Training online certification, applicants will gain a comprehension of the big data and Greenplum database as well as their concepts and functionalities. Applicants will study the segment mirroring and query processing method. Applicants will learn about various distribution policies, distributed databases, database application interfaces, and data loading and unloading. Applicants will also learn about various security measures and techniques, such as client authentication, access control, and routine reindexing.
The syllabus
Greenplum Module: 1
Greenplum Module: 2
- About Distributed Databases
- Understanding Greenplum Distribution Policies
- Broadcast
Greenplum Module: 3
- About Greenplum Query Processing
- Understanding Query Planning and Dispatch in Greenplum
- Understanding Greenplum Query Plans
- Understanding Parallel Query Execution in Greenplum
Greenplum Module: 4
- 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
Greenplum Module: 5
- Configuring Greenplum Client Authentication
- Allowing Connections to Greenplum Database
- Limiting Concurrent Connections in Greenplum
Greenplum Module: 6
- 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
Greenplum Module: 7
- 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
Greenplum Module: 8
- 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
Greenplum Module: 9
- Starting and Stopping Greenplum
- Overview
- Starting Greenplum Database
- Stopping Greenplum Database
Greenplum Module: 10
- Loading and Unloading Data
- Greenplum data loading options
- Greenplum External tables
- Example of loading data with External Tables and greenplum dist
- Green plum load
Greenplum Module: 11
- 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
Greenplum Module: 12
- Monitoring a Greenplum System
- Monitoring Greenplum System State
- Viewing the Greenplum Database Server Log Files
Greenplum Module: 13
- Routine System Maintenance Tasks
- Routine Vacuum and Analyze
- Routine Reindexing
- Managing Greenplum Database Log Files
Greenplum Module: 14
- Common Causes of Performance Issues
- Identifying Hardware and Segment Failures
- Managing Workload
- Maintaining Database Statistics
- Optimizing Data Distribution
- Optimizing Your Database Design
Greenplum Module: 15
- Investigating a Performance Problem
- Checking System State
- Checking Database Activity
- Troubleshooting Problem Queries
- Investigating Error Messages
Articles
Popular Articles
prev
next
