All Courses

Oracle Database Training & Certification Courses:

Course 1: Oracle 11g DBA OCA & OCP Certification Training

OraGyan offers a course on Oracle 11g DBA OCA & OCP. Oracle 11g DBA training takes the database administrator beyond the basic tasks covered in the SQL NEW and Administration Workshop I. Students will gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. After completing this course, students will be able to diagnose and repair data failures with Flashback technology and manage space to optimize database storage.
  • Configure for Recoverability
  • Use the RMAN Recovery Catalog
  • Configure Backup Settings
  • Create Backups with RMAN
  • Restore and Recovery Task
  • Use RMAN to Perform Recovery
  • Monitor and Tune RMAN
  • Diagnose the Database
  • Use Flashback Technology I
  • Use Flashback Technology II
  • Perform Flashback Database
  • Manage Memory
  • Manage Database Performance
  • Manage Performance by SQL Tuning
  • Manage Resources
  • Automate Tasks with the Scheduler
  • Manage Space in Blocks
  • Manage Space in Segments
  • Manage Space for the Database
  • Duplicate a Database
  • Basic understanding of databases
  • Working knowledge of RDBMS concepts & SQL
  • Working knowledge of Oracle 9i or 10g
  • Understanding of Linux
  • Fees for this course is - $1399.

Please contact us for more details.

enquire_now_button

 

Course 2: Oracle 12c DBA OCA & OCP Certification Training

This Oracle database 12c release comes re-engineered for Cloud computing. It also offers a multitenant infrastructure that ensures unparalleled software and hardware efficiencies, including high performance and management benefits, along with efficient and fast Cloud provisioning. Oracle Database 12c certification emphasizes the complete practical knowledge required by DBAs in today's competitive world. Oracle Database 12c OCA DBA certification will provide advanced skills and expertise required of proficient database administrators. Achieving this Oracle Database 12c OCA DBA credential will validate your skills in managing Oracle databases effectively and efficiently while optimizing their performance.

Oracle Database 12c OCP DBA certification provides advanced level expertise in administering Oracle databases while gaining deep understanding of underlying architecture and internal workings of this latest version of Oracle database 12c deployment. The OCP DBA credential in this latest version of Oracle Database 12c will help professionals confirm their advanced skills in complete database management and maintenance.

  • Installing Oracle Grid Infrastructure for Standalone Servers.
  • Managing components with Oracle Restart.
  • Upgrading existing versions of Oracle Database to the latest Oracle Database 12c.
  • Creating container databases and provisioning pluggable databases.
  • Creating and maintaining Oracle Database Instances.
  • Building and managing Storage Structures.
  • Configuring and managing the Network Environment.
  • Creating and managing users.
  • Monitoring and troubleshooting the database while ensuring performance.
  • Learning basic backup and recovery techniques.
  • Updating the Oracle Database software using My Oracle Support or Oracle Support Workbench.
  • Managing the performance of pluggable databases and multitenant container databases
  • Configuring resource manager for sharing resources between and within a multitenant container database and a pluggable database
  • Implementing unified auditing
  • Making use of SQL*Loader and Oracle Data Pump in pluggable databases
  • Monitoring the operations and performance of multitenant container database and pluggable database
  • Completely understand the multitenant architecture
  • Creating multitenant container databases from scratch
  • Creating pluggable databases using various prescribed techniques
  • Plugging a non-CDB into a multitenant container database
  • Administering the storage structures of multitenant container databases and pluggable databases
  • Creating and administering user accounts
  • Performing specific operations such as Oracle Data Pump loading, transportation, auditing, and encryption
  • Managing local and common user privileges and roles
  • Configuring backup and recovery operations for pluggable databases and multitenant container databases
  • Managing storage and security for pluggable databases and multitenant container databases
  • Familiarity with data processing concepts and techniques
  • Basic knowledge of Linux Operating System
  • Prior knowledge of 11g Database would be an added advantage
  • Fees for this course is - $1699.

Please contact us for more details.

enquire_now_button

Oracle Middleware Training & Certification Courses:

Course 1: Oracle Enterprise Manager Cloud Control 12c Install & Upgrade

OraGyan offers a course on Oracle Enterprise Manager Cloud Control 12c Install & Upgrade. After completing this course, students will be able to learn how to: perform a new single-server installation and employ Add Host and Add Non-host functionality to discover targets on a host. 
  • Comprehend Virtualization with Oracle VM Server
  • Comprehend Oracle VM Server in the Classroom
  • Comprehend Compatibility And Differences Between Versions
  • Comprehend Agent Push Installation
  • Comprehend Deployment Topologies
  • Comprehend Single Server Installation Process
  • Upgrade Paths Map
  • Comprehend The Enterprise Manager Implementation Lifecycle
  • Comprehend OMR Lifecycle and Security
  • Comprehend Sizing the Repository
  • Comprehend The Implementation Plan
  • Oracle Database Knowledge - Listeners, Database Configuration
  • Having exposure on Linux would be an added advantage
  • Fees for this course is - $550.

Please contact us for more details.

enquire_now_button

Course 2: Oracle Enterprise Manager Cloud Control 12c - Deployment & Configuration

This training familiarizes students with the functionalities and usage of Enterprise Manager Cloud Control 12c. Participants learn several tasks, such as managing Cloud control, health monitoring, and generating custom reports. After completing this course, students will be able to: manage compliance, compare configurations, and deploy services and systems.
  • Managing targets, groups, and hosts
  • Managing configurations
  • Monitoring targets
  • Using Enterprise Manager reporting, and job system tools
  • Managing compliance
  • Comparing configurations
  • Deploying services and systems
  • Basic Knowledge of Linux Commands
  • Oracle Database Knowledge - Listeners, Database Configuration
  • Middleware Knowledge would be an added advantage

Fees for this course is - $500. Please contact us for more details.

enquire_now_button

 Oracle Data Guard Training & Certification Courses:

Course 1: Oracle Database 11g: Data Guard Administration

OraGyan offers a course on Oracle Database 11g: Data Guard Administration. In this course, students will learn how to use Oracle Data Guard to protect their Oracle database against planned and unplanned downtime. Students will also get to know how to use Data Guard standby databases to support production functions such as reporting, querying and testing.
  • Creating a Physical Standby Database by Using SQL and RMAN Commands
  • Using DGMGRL to Create a Data Guard Broker Configuration
  • Creating a Physical Standby Database by Using Enterprise Manager Grid Control
  • Monitoring a Data Guard Broker Configuration
  • Managing Data Protection Modes
  • Optimizing a Data Guard Configuration
  • Using Flashback Database in a Data Guard Configuration
  • Performing Role Transitions
  • Enabling Fast-Start Failover
  • Implementing Client Failover Procedures
  • Creating and Managing a Snapshot Standby Database
  • Using Oracle Active Data Guard
  • Creating a Logical Standby Database
  • Managing the Data Guard Configuration
  • Upgrading Databases in a Data Guard Configuration
  • Oracle Database 11g: Administration Workshop I
  • Oracle Database 11g: Administration Workshop II
  • Linux working knowledge is required
  • Fees for this course is - $850.

Please contact us for more details.

enquire_now_button

Course 2: Oracle Database 12c: Data Guard Administration

This course will teach students how to develop the best disaster recovery solution using the new Oracle Data Guard 12c features and architecture. Students will get a chance explore topics like Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases. Furthermore, enrolling in this course will help you learn how to manage and troubleshoot a Data Guard configuration.

Audience: This course is best suited for Database Administrators, Support Engineers, and Technical Consultants.

  • Create a Data Guard broker configuration
  • Create a physical standby database
  • Verify a Data Guard configuration
  • Edit database properties related to Data Guard
  • Test a Data Guard configuration
  • Describe the Architecture of Oracle Data Guard
  • Explain the applicability between physical and logical standby and snapshot databases
  • Explain the benefits of implementing Oracle Data Guard
  • Explain Data Guard use with the Oracle Multi-tennant databases
  • Configure client connectivity in a Data Guard configuration
  • Implement failover procedures to automatically redirect clients to a new primary database
  • Use Application Continuity in a Data Guard Environment
  • Good knowledge of Oracle Database
  • Oracle Database 12c: Administration Workshop
  • Working knowledge of Linux
  • Fees for this course is - $950.

Please contact us for more details.

enquire_now_button

 Oracle Golden Gate Training & Certification Courses:

Course 1: Oracle GoldenGate 11g Fundamentals for Oracle

The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances.
  • Configure Change Delivery
  • Install Oracle GoldenGate and prepare the environment
  • Leverage the GGSCI command line interface
  • Configure Change Capture and configure Initial Load
  • Extract trails and files
  • Manage Oracle GoldenGate instances
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Fees for this course is - $350.

Please contact us for more details.

enquire_now_button

Course 2: Oracle GoldenGate Director 11g: Essentials

OraGyan offers a course on Oracle GoldenGate Director 11g: Essentials. After completing this course, students will be able to learn how to setup powerful and extensive notification alert system to guarantee that the operators are notified whenever TDM processes require attention, add GoldenGate Components, create Data Definitions, work with Diagrams, and use Web GGSCI Commands.
  • Describe the Oracle GoldenGate Architecture
  • Label GoldenGate Director Server Components
  • Describe GoldenGate Director Client
  • Label GoldenGate Director Web Components
  • Describe GoldenGate Director Administrator
  • Describe the GoldenGate Installation System Requirements
  • Install GoldenGate Director Server
  • Install GoldenGate Director Client
  • Start Oracle WebLogic Server
  • Start GoldenGate Director Server
  • Start GoldenGate Director Client
  • Start GoldenGate Director Web
  • Access GoldenGate Director Administrator
  • Change Administrator User Information
  • Manage User Accounts
  • Manage Data Sources
  • Configure the Monitor Agent
  • Set Default Domain Suffixes
  • Add GoldenGate Components
  • Add an Initial Load
  • Create Data Definitions
  • Work with Diagrams
  • Create Email Alerts
  • Use Web GGSCI Commands
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Knowledge of Golden Gate Installation and Basic Configuration
  • Fees for this course is - $500.

Please contact us for more details.

enquire_now_button

Course 3: Oracle GoldenGate 11g Troubleshooting and Tuning

Oracle GoldenGate 11g Troubleshooting and tuning course allows students to learn to be self-sufficient in gathering and examining evidence, solving cases that each contain problems to solve, clues to their cause, and methods of resolution. Each of the practices challenges the student to diagnose and troubleshoot the issue using the GoldenGate software.

Students also learn methods of Oracle GoldenGate 11g performance tuning by identifying the causes of slow startups, evaluating lag statistics, and solving network and disk bottlenecks. Students utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, to troubleshoot system issues.

  • Use the Oracle GoldenGate troubleshooting tools such as Knowledge Documents, Documentation, SHOWSYNTAX parameter, the Logdump utility
  • Perform troubleshooting different problems, such as Extract and Replicat problems, mapping problems and synchronization problems
  • Identify causes of slow start ups, monitor lag and statistics, identify network and disk bottlenecks, and perform tuning of key components
  • Use GGSCI commands for gathering process evidence
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Oracle DBA 11g or Equivalent Knowledge
  • Oracle Golden Gate Installation and Configuration
  • Fees for this course is - $650.

Please contact us for more details.

enquire_now_button

Oracle Real Application Cluster Training & Certification Courses:

Course 1: Oracle Database 12c: Clusterware Administration

The Oracle GoldenGate 11g: Fundamentals for Oracle course focuses on Oracle-to-Oracle data replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environment. The course teaches how to use the Oracle GoldenGate command line interface efficiently. Participants configure Change Capture, Initial Load, and Change Delivery. They learn to extract trails and files, create parameter files, and to manage Oracle GoldenGate instances.
  • Configure Change Delivery
  • Install Oracle GoldenGate and prepare the environment
  • Leverage the GGSCI command line interface
  • Configure Change Capture and configure Initial Load
  • Extract trails and files
  • Manage Oracle GoldenGate instances
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Fees for this course is - $350.

Please contact us for more details.

enquire_now_button

Course 2: Oracle Database 12c: RAC Administration

OraGyan offers a course on Oracle GoldenGate Director 11g: Essentials. After completing this course, students will be able to learn how to setup powerful and extensive notification alert system to guarantee that the operators are notified whenever TDM processes require attention, add GoldenGate Components, create Data Definitions, work with Diagrams, and use Web GGSCI Commands.
  • Describe the Oracle GoldenGate Architecture
  • Label GoldenGate Director Server Components
  • Describe GoldenGate Director Client
  • Label GoldenGate Director Web Components
  • Describe GoldenGate Director Administrator
  • Describe the GoldenGate Installation System Requirements
  • Install GoldenGate Director Server
  • Install GoldenGate Director Client
  • Start Oracle WebLogic Server
  • Start GoldenGate Director Server
  • Start GoldenGate Director Client
  • Start GoldenGate Director Web
  • Access GoldenGate Director Administrator
  • Change Administrator User Information
  • Manage User Accounts
  • Manage Data Sources
  • Configure the Monitor Agent
  • Set Default Domain Suffixes
  • Add GoldenGate Components
  • Add an Initial Load
  • Create Data Definitions
  • Work with Diagrams
  • Create Email Alerts
  • Use Web GGSCI Commands
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Knowledge of Golden Gate Installation and Basic Configuration
  • Fees for this course is - $500.

Please contact us for more details.

enquire_now_button

Course 3: Oracle 11g: RAC and Grid Infrastructure Administration

Oracle GoldenGate 11g Troubleshooting and tuning course allows students to learn to be self-sufficient in gathering and examining evidence, solving cases that each contain problems to solve, clues to their cause, and methods of resolution. Each of the practices challenges the student to diagnose and troubleshoot the issue using the GoldenGate software.

Students also learn methods of Oracle GoldenGate 11g performance tuning by identifying the causes of slow startups, evaluating lag statistics, and solving network and disk bottlenecks. Students utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, to troubleshoot system issues.

  • Use the Oracle GoldenGate troubleshooting tools such as Knowledge Documents, Documentation, SHOWSYNTAX parameter, the Logdump utility
  • Perform troubleshooting different problems, such as Extract and Replicat problems, mapping problems and synchronization problems
  • Identify causes of slow start ups, monitor lag and statistics, identify network and disk bottlenecks, and perform tuning of key components
  • Use GGSCI commands for gathering process evidence
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Oracle DBA 11g or Equivalent Knowledge
  • Oracle Golden Gate Installation and Configuration
  • Fees for this course is - $650.

Please contact us for more details.

enquire_now_button

Course 4: Oracle Database 11g: RAC Administration

Oracle GoldenGate 11g Troubleshooting and tuning course allows students to learn to be self-sufficient in gathering and examining evidence, solving cases that each contain problems to solve, clues to their cause, and methods of resolution. Each of the practices challenges the student to diagnose and troubleshoot the issue using the GoldenGate software.

Students also learn methods of Oracle GoldenGate 11g performance tuning by identifying the causes of slow startups, evaluating lag statistics, and solving network and disk bottlenecks. Students utilize all of the existing GoldenGate tools, such as GGSCI and Logdump, to troubleshoot system issues.

  • Use the Oracle GoldenGate troubleshooting tools such as Knowledge Documents, Documentation, SHOWSYNTAX parameter, the Logdump utility
  • Perform troubleshooting different problems, such as Extract and Replicat problems, mapping problems and synchronization problems
  • Identify causes of slow start ups, monitor lag and statistics, identify network and disk bottlenecks, and perform tuning of key components
  • Use GGSCI commands for gathering process evidence
  • Basic Knowledge of Linux Commands
  • Medium level of knowledge in Oracle Database
  • Oracle DBA 11g or Equivalent Knowledge
  • Oracle Golden Gate Installation and Configuration
  • Fees for this course is - $650.

Please contact us for more details.

enquire_now_button

Oracle Enterprise Cloud Control & Certification Courses

Course 1: Oracle Enterprise Manager Cloud Control 12c Install & Upgrade

OraGyan offers a course on Oracle Enterprise Manager Cloud Control 12c Install & Upgrade. After completing this course, students will be able to learn how to: perform a new single-server installation and employ Add Host and Add Non-host functionality to discover targets on a host. 
  • Comprehend Virtualization with Oracle VM Server
  • Comprehend Oracle VM Server in the Classroom
  • Comprehend Compatibility And Differences Between Versions
  • Comprehend Agent Push Installation
  • Comprehend Deployment Topologies
  • Comprehend Single Server Installation Process
  • Upgrade Paths Map
  • Comprehend The Enterprise Manager Implementation Lifecycle
  • Comprehend OMR Lifecycle and Security
  • Comprehend Sizing the Repository
  • Comprehend The Implementation Plan
  • Oracle Database Knowledge - Listeners, Database Configuration
  • Having exposure on Linux would be an added advantage
  • Fees for this course is - $550.

Please contact us for more details.

enquire_now_button

Course 2: Oracle Enterprise Manager Cloud Control 12c - Deployment & Configuration

This training familiarizes students with the functionalities and usage of Enterprise Manager Cloud Control 12c. Participants learn several tasks, such as managing Cloud control, health monitoring, and generating custom reports. After completing this course, students will be able to: manage compliance, compare configurations, and deploy services and systems.
  • Managing targets, groups, and hosts
  • Managing configurations
  • Monitoring targets
  • Using Enterprise Manager reporting, and job system tools
  • Managing compliance
  • Comparing configurations
  • Deploying services and systems
  • Basic Knowledge of Linux Commands
  • Oracle Database Knowledge - Listeners, Database Configuration
  • Middleware Knowledge would be an added advantage

Fees for this course is - $500. Please contact us for more details.

enquire_now_button

s2Member®
Skip to toolbar