WhatsApp : +918121020333 / +919849510373

India: +91 40 6050 1418

USA: +1 516 8586 242

UK: +44 (0)203 371 0077

grrenplum

Topic 1:

 

  • Architecture Of Greenplum  
  •  Greenplum Master
  •  Greenplum Interconnect
  •  Segment Mirroring in Greenplum
  • Segment Failover &  Recovery in Greenplum
  •  Master Mirroring in The Greenplum
Topic  2:

 

  • Understand Greenplum Distribution Policies, Distributed Database & Broadcast.
  • Distributed Databases Greenplum
  • Understanding The Greenplum Distribution Policies
  • Broadcast
Topic 3:

 

  • The Greenplum Query Processing
  •  Query Planning & Dispatch in Greenplum
  •  Greenplum Query Plans
  •  Parallel Query Execution in Greenplum
Topic4:

 

  • Access control &  Greenplum security
  • Managing Roles & Privileges in Greenplum
  • Security Best Practices for Roles & Privileges
  • Creating New Roles (Users) for the Greenplum
  • Creating Groups  in Greenplum
  • Managing The Object Privileges
  • Encrypting Of Data in Greenplum
  • Greenplum Time-based_ Authentication
  • Permissions for Greenplum
  • How to Add Time-based Constraints in the Greenplum
Topic5:

 

  • Configuring The Greenplum Client Authentication
  • Allowing Connections to the Greenplum Database
  • Limiting the Concurrent Connections in the Greenplum
Topic6:

 

  • Accessing Of Greenplum Database
  • Establishing an Database Session
  • Supported Client-Applications
  • The Greenplum Database Client Applications
  • The Greenplum Database Application Interfaces,
  • Troubleshooting Greenplum Connection Problems
Topic7:

 

  • Defining Of Greenplum Database Objects
  • Creating & Managing Greenplum Databases
  • Creating&  Managing Greenplum Tablespaces
  • Creating &Managing Schemas in Greenplum
  • Creating & Managing Tables in Greenplum
  • Choosing the Table Storage Model in Greenplum
  • Partitioning Of  Large Tables
  • Creating &  Using Sequences
  • Using Of Indexes in Greenplum Database
  • Creating & Managing Views in Greenplum
Topic8:

 

  • Managing Of Data in Greenplum
  • About Concurrency and Isolation in Greenplum database
  • Inserting Of New Rows in Greenplum
  • Updating The  Existing Rows in Greenplum
  • Deleting Of Rows in Greenplum
  • Vacuuming Greenplum Database
Topic9:

 

  • Starting /Stopping Greenplum
  • Overview
  • Starting Of  Greenplum Database
  • Stopping Of Greenplum Database
Topic10:

 

  • Loading & Unloading Data
  • The Greenplum data loading options
  • The Greenplum External tables
  • Example of loading data with External Tables  
Topic11:

 

  • Backing Up & Restoring Greenplum Databases
  • Overview of Backup & Restore Greenplum Operations
  • Backing Up an Greenplum Database
  • Restoring Of Parallel Backup Files
Topic12:

 

  • Monitoring an Greenplum System
  • Monitoring Of Greenplum System State
  • Viewing Of the Greenplum Database Server Log Files
Topic13:

 

  • Routine System Maintenance Tasks
  • Routine Vacuum &  Analyze
  • Routine Of Reindexing
  • Managing The Greenplum Database Log Files
Topic14:

 

  • Common Causes of Performance Issues
  • Identifying Hardware & Segment Failures
  • Managing The Workload
  • Maintaining Of Database Statistics
  • Optimizing Of Data Distribution
  • Optimizing of Database Design
Topic15:.

 

  • Investigating an Performance Problem
  • Checking the System State
  • Checking of Database Activity
  • Troubleshooting the Problem Queries
  • Investigating the Error Messages