Bigdata Greenplum DBA

Bigdata Greenplum DBA

0 STUDENTS ENROLLED

    Introduction

    Keen Online training is a renowned provider of online training offering an entire range of IT professional courses across the globe. An industry leader with an astounding track record of well placed students, Keen Online is the preferred choice of professionals as well as corporate.

    Greenplum DBA is one of the strongest pillars of Big Data Analytics. It is capable of analyzing Terabytes to Petabyte of data and improves user experience over traditional RDBMS products A sought after specialization in the field of Big Data; It has a bright future ahead. The Online Tutorial Classes offered at Keen Tech is an all-inclusive dynamic course that constantly adds the new developments in the field of Greenplum and Big Data analytics. An instructor-led online training course that is at par with classroom training

    COURSE SUMMARY

    Course Name Bigdata Greenplum DBA Online Training
    Contents Fundamentals of Big data,
    Duration 50 Hours with Flexible timings
    Delivery Instructor Led-Live Online Training
    Eligibility Basic understanding of programming ,SQL Syntax and Knowledge of relational database
    Ideal For Professionals keen on learning about Big Data Analytics and those who would like to install, design or administer and manage the Greenplum DBA
    Next Batch Please visit the schedule section

    Course Objectives

    HIGHLIGHTS OF GREENPLUM DBA ONLINE TRAINING AT KEEN TECH

    • Detailed coverage on Greenplum DBA with a focus on the aspects plaguing the Industry
    • Experiential learning with focus on features, benefits, and architecture in terms of shared nothing and the MPP design
    • Focuses on how Greenplum supports redundancy and high availability
    • Focuses on aspects of real time critical decision making and mechanisms to convert unstructured data into unstructured data
    • Thorough understanding of contemporary testing as per different business requirements
    • Helps you develop insight from large data so you can assist your customers with the right information
    • Teaches you how to accelerate data and benefit from the information available
    • Suited for Data Scientists as well as Data Analysts
    • Ensures you learn the latest topics and best practices in the field of Big data analytics and Greenplum DBA

    CORE BENEFITS OF LEARNING GREENPLUM DBA

    Greenplum database is gaining high popularity owing to its large number of advantages. Anyone using Greenplum DBA will vouch that with its use degradation is minimal even if work-load is high. Its column store architecture helps in aggregating large data volumes and makes it ideal for big databases. Moreover it is robust, scalable and flexible shaping itself as organizations grow.

    Course Curriculum

    Greenplum DBA at Keen Tech is a thorough course offering a real time feels of the industry scenario. The course focuses on features, benefits, and architecture in terms of shared nothing and the MPP design, and how Greenplum supports redundancy and high availability. It covers the basic from how to install to how to handle basic activities.

    INTRODUCTION 

    • Master – Overview
    • Segments
    • Interconnect

    CONCEPTS, FEATURES AND BENEFITS
    REDUNDANCY AND FAILOVER

    • Segment Mirroring
    • Master Mirroring

    DATA DISTRIBUTION 

    • 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
    • Editing the pg_hba.conf File
    • Limiting Concurrent Connections
    • ACCESSING THE DATABASE
    • Establishing a Database Session
    • Supported Client Applications
    • Database Client Applications
    • PgAdmin III
    • Database Application Interfaces
    • Third-Party Client Tools
    • Troubleshooting Connection Problems

    LAB
    MANAGING WORKLOAD AND RESOURCES

    • Overview of Greenplum Workload Management
    • How Resource Queues Work
    • Steps to Enable Workload Management
    • Configuring Workload Management
    • Resource Queues

    DATABASE ADMINISTRATION

    • Defining Database Objects (databases, schema, table, sequence etc)
    • Creating and using database
    • Creating and using schemas
    • Creating and Using Sequences
    • Indexes
    • Creating and Managing Views

    MANAGING DATA

    • Vacuuming the Database
    • Querying Data
    • Query Performance
    • EXPLAIN Output, EXPLAIN ANALYZE Output
    • PARTITIONING LARGE TABLES
    • Understanding Table Partitioning
    • Deciding on a Table Partitioning Strategy
    • Creating Partitioned Tables
    • Loading Partitioned Tables
    • Maintaining Partitioned Tables

    DATABASE LOADING TOOLS OVERVIEW

    • About External Tables
    • About gpload
    • About COPY

    SYSTEM ADMINISTRATION

    • Starting and Stopping
    • Routine admin tasks
    • Uploading Configuration File Changes Only
    • Configuring
    • 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

    MONITORING 

    • 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 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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews

    N.A

    ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 1 month
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details


      * Required

      Job Support

        Your Details


        * Required

        Course Features

        Live Instructor-led Classes

        This isn't canned learning. Its dynamic, its interactive, its effective

        Expert Educators

        Only the best or they're out. We are constantly evaluating our trainers

        24&7 Support

        We never sleep. Need something answered at 3 am? No Problem

        Flexible Schedule

        You don't learn as per our calendar. We work according to yours.

        Customized Training's

        The most part self-managed and adaptable to suit a person's particular adapting technology needs

        Priority Based Training's

        Real-time Scenario based Assignments and Case Studies

        COPYRIGHT © 2020 KEEN IT TECHNOLOGIES PVT.LTD, ALL RIGHTS RESERVED