Mindmajix Bigdata Greenplum DBA Online Training
Introduction to Greenplum DBA Greenplum Database builds on the foundations of open source database PostgreSQL. GreenPlum primarily functions as a data warehouse and utilizes a massively parallel (MPP) architecture. GreenPlum Database is partitioned across multiple segment servers and each segment owns and manages a distinct portion of the overall data. Benefits of Bigdata Greenplum DBA Online Training is to enhance skills on database administrators, preparing to deploy the Greenplum database system.
Course Curriculum Module 1: Topics: Greenplum Architecture, About the Greenplum Master, About the Greenplum Interconnect, About Segment Mirroring, Segment Failover and Recovery, About Master Mirroring
Module 2: Topics: About Distributed Databases, Understanding Greenplum Distribution Policies, Broadcast Module 3: Topics: About Greenplum Query Processing, Understanding Query Planning and Dispatch, Understanding Greenplum Query Plans, Understanding Parallel Query Execution
Module 4: Topics: Access control and security, Managing Roles and Privileges, Security Best Practices for Roles and Privileges, Creating New Roles (Users), Creating Groups (Role Membership) Module 5: Topics: Configuring Client Authentication, Allowing Connections to Greenplum Database, Limiting Concurrent Connections
Module 6: Topics: Accessing the Database, Establishing a Database Session, Supported Client Applications, Greenplum Database Client Applications, Database Application Interfaces. Module 7: Topics: Defining Database Objects, Creating and Managing Databases, Creating and Managing Tablespaces, Creating and Managing Schemas, Creating and Managing Tables, Choosing the Table Storage Model in Greenplum.
Module 8: Topics: Managing Data, About Concurrency & Isolation in GPDB, Inserting New Rows, Updating Existing Rows, Deleting Rows, Vacuuming the Database, QUERY PLAN Module 9: Topics: Starting and Stopping Greenplum, Overview, Starting Greenplum Database, Stopping Greenplum Database Module 10: Topics: Loading and Unloading Data, Greenplum data loading options, External tables, Example of loading data with External Tables and gpfdist, gpload Module 11: Topics: Backing Up and Restoring Databases, Overview of Backup and Restore Operations, Backing Up a Database, Restoring From Parallel Backup Files, pg_dump
Module 12: Topics: Monitoring a Greenplum System, Monitoring System State, Viewing the Database Server Log Files Module 13: Topics: Routine System Maintenance Tasks, Routine Vacuum and Analyze, Routine Reindexing, Managing Greenplum Database Log Files Module 14: Topics: Common Causes of Performance Issues, Identifying Hardware and Segment Failures, Managing Workload, Maintaining Database Statistics, Optimizing Data Distribution, Optimizing Your Database Design Module 15: Topics: Investigating a Performance Problem, Checking System State, Checking Database Activity, Troubleshooting Problem Queries, Investigating Error Messages
Our Bigdata Greenplum DBA Online Training batches starts every day. You can attend a DEMO for free
We Provide Online Training On TIBCO BW Tableau QlikView TIBCO Spotfire SAS BI SAP Hybris Selenium Oracle DBA Oracle SOA Oracle Financials IOS Development Android Data Modeling- Erwin Performance Testing SFDC SAP UI5 SAP Hana
We offers You 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access
7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions
Thank you Your feedback is highly important to improve our course material. For Free Demo Please Contact INDIA: +91-9246333245, US: +1-2013780518, Email id: info@mindmajix.com http://bit.ly/15wqLU8