LIVE Instructor-Led Courses
Dismiss

Oracle Goldengate Essentials training course

Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

TAILOR-MADE
Enquire & get a quote
PUBLIC COURSES
Next on 18 Jul - see prices
JBI training course London UK

•    Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives
•    Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products
•    Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI
•    Extend GoldenGate functionality through APIs and reduce your IT operational expenditure
•    Enhance system management and monitoring in your GoldenGate environment
•    Generate real-time statistics to gauge data throughput and performance

  Oracle GoldenGate 12c Introduction
•    Describing Oracle GoldenGate Files
•    Contrasting Batch and Online Operation
•    Explaining Change Capture and Delivery (with and without a Data Pump)
•    Describing Commit Sequence Number (CSN)
•    Describing Oracle GoldenGate Process Groups
•    Explaining Initial Data Load
•    Explaining Oracle GoldenGate Checkpointing
Installing Oracle GoldenGate
•    Get help information on GGSCI commands
•    Installing Oracle GoldenGate on Linux
•    Identify the types of GGSCI commands available
•    Using Obey Files and OS Shell
•    Preparing the Operating System
•    Running GoldenGate Commands from the GGSCI Prompt,
Configuration Overview and Preparing the Environment
•    Describing the High-level Configuration Steps
•    Preparing a Source Database for Transaction Capture
•    Generating a Source Definitions File
•    Configuring and Starting the Manager Process
Configuring Extracts
•    Configuring and Starting an Extract Process
•    Adding Local and Remote Trails
•    Marking Tables with TRANDATA
•    Configuring and Starting an Extract Data Pump
•    Describing the Extract Process
Configuring Initial Load
•    Describing Oracle GoldenGate Initial Load Methods
•    Describing a Variety of Database-specific Methods
•    Explaining the Advantages of Oracle GoldenGate Methods
•    Configuring an Initial Load using Oracle GoldenGate
Configuring Replicat
•    Describing Avoid and Handle Collisions Between Changes and the Initial Load Data
•    Explaining the Replicat Process
•    Explaining Adding, Configuring and Starting a Replicat Process
Extracting Trails and Files
•    Reversing the Sequence of Operations in an Extract Trail or File to Back out Changes
•    Investigating Different Formats
•    Describing and Contrast Extract Trails and Files
•    Viewing Extract Trails and Files with Logdump
Working with Parameters
•    Describing Commonly-used Parameters for GLOBALS, Manager, Extract and Replicat
•    Editing Parameter Files
•    Contrasting GLOBALS with Process Parameters
Using Data Selection and Filtering
•    Using SQLEXEC to Interact Directly with a Database
•    Selecting and Filtering Data for Replication
•    Using Built-in Functions
•    Mapping Columns Between Different Schemas
Using Additional Transformation Concepts
•    Setting and retrieving User Tokens
•    Replicating Oracle Sequences
Setting Up DDL Replication
•    Explaining DDL String Substitution
•    Understanding the Concept of DDL Replication
•    Explaining the Requirements for Oracle DDL Replication
•    Describing GoldenGate Options for DDL Replication

 

JBI training course London UK

The course is suitable for technical personnel who need to learn how to administer and maintain Oracle Goldengate

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

JBI training course London UK
 
Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

All 20 points are in our latest Newsletter - Delivered directly to your inbox



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course