Oracle Golden Gate Training Self Paced
About Oracle Golden Gate Training (Self-Paced):
Oracle Golden Gate is a complete software package for replication and real time data integration in heterogeneous IT environments. The product suite delivers real time data integration, high availability solutions, data replication, verification between analytical and operational enterprise systems, transactional change data capture, transformations and data replication. Oracle Golden Gate allows the manipulation and exchange of data at the transaction level among heterogeneous, multiple platform across the enterprise. Oracle Golden Gate training covers advance level of database skills.
Oracle GoldenGate moves committed transactions with minimal overhead on your existing infrastructure and transaction integrity. Oracle Golden Gate modular design gives you the replicate selected data records and flexibility to extract, changes to DDL and transactional changes across a variety of topologies.
What is Oracle Golden Gate Self-Paced Course?
Oracle Golden Gate self-paced course includes complete video sessions for the modules. All video sessions are explained by the real time professionals. In self- paced you find study material and interview question. You can access the videos any number of times until you get the complete knowledge on the subject. If you’re not getting any point, you can clarify with our trainers by following some additional procedures.
Oracle GoldenGate Course Target:
• Design replication solutions using Oracle GoldenGate products and environments.
• Install Oracle Golden Gate and prepare the target and source database .
• Issue GGSCI commands.
• Illustrate Oracle Golden Gate implemented configuration options.
• Manage extract trails and files using data pump and utilities such as logdump.
• Introduce the new integrate Replicate feature for improved data delivery.
• Mange and control network transmission.
• Integrate Oracle GoldenGate with Oracle cluster configurations.
Oracle Golden Gate course audience:
Oracle golden gate training is targeted for Freshers, non IT professionals who are having basic knowledge of database skills.
Oracle Golden Gate prerequisite:
• Basic knowledge of Oracle 11g essential.
• Basic knowledge of database skills.
Oracle Golden Gate Course Curriculum
Module: 1. Introduction
Goal Set: This oracle golden gate training module covers- understand the features and the functionality of Oracle Golden Gate 11g(126.96.36.199.0), what is a golden gate, deep understanding of oracle golden gate architecture, gain knowledge on Oracle Golden-Gate real-time data integration solutions.
Topics: What is a golden gate, Description: Features and functionality of Oracle GoldenGate 11g (188.8.131.52.0), Identification: key capabilities and differentiators, Description: Oracle Golden-Gate high-availability and disaster tolerance solutions, Oracle real-time data integration solutions, oracle golden gate architecture.
Module: 2. Technology Overview
Goal set: This module covers- Oracle golden gate 12c fundamentals for Oracle, list of the supported databases and platforms, Oracle database GoldenGate functionality.
Topics: List the building blocks that make up Oracle GoldenGate functionality, List the supported databases and platforms, Oracle forms, Oracle golden gate installation.
Describe the Oracle golden gate 12c product line: Oracle GoldenGate Veridata, Management Pack, Director, Monitor, Flat File, Oracle Java, Oracle Golden gate 12c documentation.
Module: 3. Oracle GoldenGate Architecture
Goal set: This oracle golden gate tutorials module covers- logical Oracle Golden Gate architecture and components and complete detail about commit sequence number and files.
Topics: Description: Logical Oracle Golden Gate architecture and components, Oracle Golden Gate process groups, Explanation: Change capture and delivery, initial data load, Comparison: Batch and online operations, Explanation: Oracle check pointing, Description: Commit sequence number (CSN), files.
Module:4. Installing Oracle GoldenGate
Goal set: This oracle golden gate training module covers- how to download, install and run commands by using Oracle golden gate software.
Topics: Download the required Oracle Golden Gate Media Pack, Installation on Linux, UNIX, and Windows, oracle golden gate configuration step by step, Run Oracle Golden Gate commands from the Golden Gate Software, Oracle golden gate 12c installation step by step.
Module: 5. Command Interface (GGSCI)
Goal set: This oracle golden gate training module covers – identification of various GGSCI commands and understand the usage of the Obey files.
Topics: Identify the types of GGSCI commands available, Use Obey files.
Module: 6. Configuration Overview and Preparing the Environment
Goal set: This oracle golden gate tutorials module covers- configuration overview and preparation of environment, high-level configuration steps, preparation of source database for transaction capture, generate source definition files in detail.
Topics: Description: High-level configuration steps, Configure and start the Manager Process, Configure supplemental logging (On the database, at the table level), Generate source definitions files, Preparation: Source database for transaction capture.
Module: 7. Configuring Change Capture
Goal set: This oracle golden gate tutorials module covers- configuring change capture, extraction process, configure extract to access logs on Oracle Automatic Storage Management, start, and stop in detail.
Topics: Describe what the Extract process does, Configure, start, and stop an Extract process, Configure, start, and stop an Extract data pump, Add local and remote trails, Configure Extract to access logs on Oracle Automatic Storage Management (ASM).
Module: 8. Configuring Change Delivery
Goal set: This oracle golden gate training module covers- configuring change delivery, Repicate process, troubleshoot on started solution, handling of collisions between changes and Initial load data.
Topics: Explanation: Replicate process does, Configuration & Start: Replicate process, Configure Replicate to handle collisions between changes and the Initial Load data, Troubleshoot a started solution.
Module: 9. Extract Trail and Files
Goal set: This oracle golden gate tutorials module covers- extract trail and files, reverse the sequence of operations in an extract trail or file in detail.
Topics: Describe and contrast Extract trails and files, Describe the formats that Extract trails and files can have, View Extract trails and files with logdump, Reverse the sequence of operations in an Extract trail or file (to back out changes).
Module: 10. Configuring the Initial Load
Goal set: This oracle golden gate tutorials module covers- Initial load methods, the configuration of initial load by making use of Oracle GoldenGate and advantage of methods.
Topics: Description: Initial load methods, identification: Prerequisites before initiating an initial load, Explanation: Advantages of Oracle Golden Gate methods, Configuration: Initial load by using Oracle GoldenGate.
Module: 11. Oracle GoldenGate Parameters
Goal set: This module covers- Oracle GoldenGate parameters, edit parameter files, parameters for GLOBALS, replicate, extract, etc in detail.
Topics:Compare GLOBALS parameters with process parameters, Describe commonly used parameters for (GLOBALS, Manager, Extract, Replicate, Both Extract and Replicate).
Module: 12. Data Selection and Filtering
Goal set:This module covers- data selection and filtering for replication and making use of SQLEXEC to interact with database in detail.
Topics: Select and filter data for replication, Map columns between different schemas (Use built-in @ functions, Use SQLEXEC to interact directly with a database).
Module: 13. Bidirectional Oracle Golden Gate Replication
Goal Set:This module covers- bidirectional Oracle Golden Gate replication and methods to handle issues such as detect and resolve conflicts.
Topics: Describe bidirectional configuration, Detect and avoid loops, Handle bidirectional issues such as loop detection, Detect and resolve conflicts, Handle identity types.
Module: 14. DDL Replication
Goal Set:This module covers – DDL Oracle Golden Gate replication and understand how to activate DDL capture in detail.
Topics:Concept: DDL replication, explanation: Requirements for Oracle DDL replication, Description: Oracle GoldenGate options for DDL replication, Explanation: How to activate DDL capture.
No Reviews found for this course.