Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2/1Z0-447

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Certification Training Course Overview

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1 training course focuses on Oracle-to-Oracle database replication. In Oracle GoldenGate 12c: Fundamentals for Oracle Ed 1 training you will learn deep dive into the Oracle GoldenGate architecture, walking you through various product features.

Who Should do this course?

  • Configuration Consultant
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Technical Consultant
This course prepares you for Exam 1Z0-447. Test your current knowledge Qubits42

Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2800
08 - 11 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 09 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 3250
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Technology Overview
  • Creating Oracle GoldenGate Topologies
  • Reviewing Oracle GoldenGate Use Cases
  • Assembling Building Blocks
  • Listing Supported OS
  • Listing Supported Databases
  • Listing the Oracle GoldengGate Product Line
  • Describing GUI Management Options
  • Listing Non-Database Sources and Targets
Module 2: Oracle GoldenGate Architecture
  • Describing Oracle GoldenGate Process Groups
  • Explaining Change Capture and Delivery (with and without a Data Pump)
  • Explaining Initial Data Load
  • Contrasting Batch and Online Operation
  • Explaining Oracle GoldenGate Checkpointing
  • Describing Commit Sequence Numbers (CSN)
  • Describing Oracle GoldenGate Files and Directories
Module 3: Installing Oracle GoldenGate
  • Listing System Requirements
  • Performing Installation
  • Configuring Environment Variables
  • Using GGSCI
  • Running Oracle GoldenGate from the OS shell.
Module 4: Configuration Overview and Preparing the Environment
  • Reviewing Configuration Overview
  • Configuring Manager Process
  • Creating Source Definitions
  • Preparing the Source Database
  • Assigning Oracle Database Roles/Privileges Required
  • Using DBMS_GOLDENGATE_AUTH Package
Module 5: Configuring Change Capture (Extract)
  • Reviewing Extract Overview
  • Accessing Logs on Oracle ASM
  • Accessing Logs Remotely
  • Configuring Extract Tasks
  • Adding Extract Group
  • Editing Extract Parameters
  • Extracting Use of Archived Transaction Logs
  • Adding Trails
Module 6: Configuring Change Delivery (Replicat)
  • Reviewing Replicat Overview
  • Configuring Replicat Tasks
  • Configuring a Sample Environment
  • Configuring New Integrated Replicat
Module 7: Configuring Extract Trails and Files (Data Pump)
  • Reviewing Extract Trails and Files Overview
  • Describing Trail Formats
  • Using Logdump for Viewing Trails
  • Reversing the Trail Sequence
  • Configuring and Using Data Pumps
Module 8: Performing Initial Load
  • Oracle GoldenGate Methods
  • Listing Database-specific Methods
  • Describing Resource Limitations
  • Listing Advantages of Oracle GoldenGate Methods
  • Configuring File Load Methods
  • Configuring Direct Load Methods
  • Handling Collisions with Initial Load
Module 9: Editing Configuration Parameters
  • Editing Parameter Files
  • Contrasting GLOBALS versus Process Parameters
  • Configuring GLOBALS Parameters
  • Configuring Manager Parameters
  • Configuring Extract Parameters
  • Configuring Replicat Parameters
Module 10: Filtering and Data Selection
  • Filtering and Data Selection
  • Mapping Columns Between Different Schemas
  • Using Built-in "@" (at) Functions
  • Using SQLEXEC to Interact Directly with a Database
  • Configuring New Coordinated Replicat
Module 11: Additional Transformation Concepts
  • Configuring and Using Macros
  • Configuring and Using User Tokens
  • Configuring and Using User Exits
  • Configuring and Using Oracle Sequences
Module 12: Configuration Options
  • Configuring and Using BATCHSQL
  • Configuring and Using Compression
  • Configuring and Using Encryption
  • Configuring and Using Event Actions
  • Configuring New Wallet Security
Module 13: Bidirectional Replication
  • Reviewing Bidirectional Considerations
  • Detecting Loops
  • Avoiding Conflicts
  • Configuring and Using Conflict Detection and Resolution
  • Describing Identity Types Issues
Module 14: DDL Replication
  • Reviewing Data Description Language Replication Overview
  • Configuring and Using Options for DDL Replication
  • Configuring and Using String Substitution in DDL
Download Course Contents

Request More Information

Course Prerequisites
  • Familiarity with Oracle Database and basic SQL using SQL*Plus
  • Familiarity with editing Linux text files using gedit or vi

On Completion of this course you will be able to:-

  • Technology Overview
  • Oracle GoldenGate Architecture
  • Installing Oracle GoldenGate
  • Configuration Overview and Preparing the Environment
  • Configuring Change Capture (Extract)
  • Configuring Change Delivery (Replicat)
  • Configuring Extract Trails and Files (Data Pump)
  • Performing Initial Load
  • Editing Configuration Parameters
  • Filtering and Data Selection
  • Additional Transformation Concepts
  • Configuration Options
  • Bidirectional Replication
  • DDL Replication

Top Trending Technologies

 Cloud Computing Certification Training Courses
 IT Security and Cybersecurity Certification Courses
 Fundamentals Training and Certification Courses
 System Administration Training and Certification Courses
 Cloud Architect Certification Training Courses
 CRM Training and Certification Courses
 Big Data Analytics Courses & Certification Training
 Data Analytics Certification and Training Courses
 Security Testing Training & Certification Courses
 Programming Courses Training and Certifications

FAQ's