Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.
Module 1: Greenplum Architecture
  • About the Greenplum Master
  • About the Greenplum Interconnect
  • About Segment Mirroring
  • Segment Failover and Recovery
  • About Master Mirroring
Module 2: About Distributed Databases
  • Understanding Greenplum Distribution Policies
  • Broadcast
Module 3: About Greenplum Query Processing
  • Understanding Query Planning and Dispatch
  • Understanding Greenplum Query Plans
  • Understanding Parallel Query Execution
Module 4: Access control and security
  • Managing Roles and Privileges
  • Security Best Practices for Roles and Privileges
  • Creating New Roles (Users)
  • Creating Groups (Role Membership)
  • Managing Object Privileges
  • Encrypting Data
  • Time-based Authentication
  • Required Permissions
  • How to Add Time-based Constraints
Module 5: Configuring Client Authentication
  • Allowing Connections to Greenplum Database
  • Limiting Concurrent Connections
Module 6: Accessing the Database
  • Establishing a Database Session
  • Supported Client Applications
  • Greenplum Database Client Applications
  • Database Application Interfaces
  • Third-Party Client Tools
  • Troubleshooting Connection Problems
Module 7: 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
  • Partitioning Large Tables
  • Creating and Using Sequences
  • Using Indexes in Greenplum Database
  • Creating and Managing Views
Module 8: Managing Data
  • About Concurrency & Isolation in GPDB
  • Inserting New Rows
  • Updating Existing Rows
  • Deleting Rows
  • Vacuuming the Database
Module 9: Starting and Stopping Greenplum
  • Overview
  • Starting Greenplum Database
  • Stopping Greenplum Database
Module 10: Loading and Unloading Data
  • Greenplum data loading options
  • External tables:
  • Example of loading data with External Tables and gpfdist
  • gpload
Module 11: Backing Up and Restoring Databases
  • Overview of Backup and Restore Operations
  • Backing Up a Database
  • Restoring From Parallel Backup Files
  • pg_dump
Module 12: Monitoring a Greenplum System
  • Monitoring System State
  • Viewing the Database Server Log Files
Module 13: Routine System Maintenance Tasks
  • Routine Vacuum and Analyze
  • Routine Reindexing Bigdata Greenplum DBA