BID DATA GREEN PLUM DBA ONLINE TRAINING IN INDIA

TekSlate’s syndicate of online trainers are experienced experts in knowledge transfer. The best place for learning, if you are aiming to learn the crux of any technology Big Data Green Plum DBA Online Training Course Content: Greenplum Architecture Greenplum Master Greenplum Segments Greenplum Interconnect Greenplum Concepts, Features and Benefits Redundancy and Failover in Greenplum Database Segment Mirroring Master Mirroring Data Distribution in greenplum Checking for Uneven Data Distribution Database Installation and Configuration Lab – Database Installation and Configuration Access Control and Security Managing Roles and Privileges Security Best Practices for Roles and Privileges Creating New Roles (Users) Altering Role Attributes Creating Groups (Role Membership) Managing Object Privileges Configuring Client Authentication Allowing Connections to Greenplum Database Editing the pg_hba.conf File Limiting Concurrent Connections Accessing the Database Establishing a Database Session Supported Client Applications Greenplum Database Client Applications PgAdmin III for Greenplum Database Database Application Interfaces Third-Party Client Tools Troubleshooting Connection Problems Lab Managing Workload and Resources Overview of Greenplum Workload Management How Resource Queues Work in Greenplum Database Steps to Enable Workload Management Configuring Workload Management Resource Queues Database Administration Defining Database Objects (databases, schema, table, sequence etc) Creating and using databaseso Creating and using schemas Creating and Using Sequences Indexes in Greenplum Database Creating and Managing Views Managing Data Vacuuming the Database Querying Data Query Performance EXPLAIN Output, EXPLAIN ANALYZE Output Partitioning Large Tables Understanding Table Partitioning in Greenplum Database Deciding on a Table Partitioning Strategy Creating Partitioned Tables Loading Partitioned Tables Maintaining Partitioned Tables Lab Greenplum Database Loading Tools Overview About External Tables About gpload About COPY Using the Greenplum Parallel File Server (gpfdist) System Administration Starting and Stopping Greenplum Routine admin tasks Uploading Configuration File Changes Only Configuring Your Greenplum System About Greenplum Master and Local Parameters Setting Configuration Parameters Setting a Local Configuration Parameter Setting a Master Configuration Parameter Enabling Alerts and Notifications Checking for Failed Segments Recovering a Failed Segment Recovering a Failed Master Backing up and Restoring Databases Backup and Restore Operations Expanding a Greenplum System Lab Monitoring a Greenplum System Monitoring Database Activity and Performance Monitoring System State Enabling System Alerts and Notifications Checking System Stateo Checking Disk Space Usage Routine System Maintenance Tasks Routine Vacuum and Analyze System Catalog Maintenance Managing Greenplum Database Log Files Performance Tuning Common Causes of Performance Issues Identifying Hardware and Segment Failures Managing Workload Maintaining Database Statistics Identifying Statistics Problems in Query Plans Tuning Statistics Collection Optimizing Data Distribution Optimizing Your Database Design Lab GP-development Functions Basic shell scripts Investigating a Performance Problem Checking System State Checking Database Activity Checking for Active Sessions (Workload) Checking for Locks (Contention) Checking Query Status and System Utilization Troubleshooting Problem Queries gp_toolkit administration schema System catalog Performance issues and tips Automation scripts for GPDB administration Lab Materials/tools used 1. Training ppts 2. Greenplum admin guide. 3. Greenplum installation guide. 4. Pg admin installer for windows. (Greenplum client for windows) 5. Greenplum community edition. 6. Putty 7. GP connectivity tools. Expected from audience (for Lab) 1. Laptop or desktop with centos installed. 2. Internet.