바로가기 메뉴
본문 바로가기
주메뉴 바로가기

Oracle

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 초급 Oracle GoldenGate 11g: Fundamentals for Oracle 1차
교육기간 2019-05-27 ~ 2019-05-30
교육시간 09:30~17:00(1일 6시간, 총 24시간)
교육장 영우글로벌러닝  지도보기
강사
정원 20명
교육비 1,444,000원(VAT별도)


교육소개
The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course provides presentations and hands-on practice of the commands, parameters, functions and features for installing and configuring Oracle GoldenGate for Oracle-to-Oracle database replication on a Linux or Windows platform.This course is based on Oracle Golden Gate version 11.2.1.
교육목표
○ Design replication solutions using Oracle GoldenGate products and environments
○ Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
○ Prepare the source and target database environments (assumes Oracle-to-Oracle replication)
○ Issue GGSCI commands (batch Obey scripts and command-line interactive)
○ Configure, start, stop, and monitor Change Capture (Extract)
○ Configure, start, stop, and monitor Change Delivery (Replicat)
○ Configure, start, stop, and monitor Initial Load
○ Manage Extract trails and files using Data Pump and utilities such as logdump
○ Control network transmission using compression and encryption
○ Create parameter files
○ Transform data
○ Manage multiple Oracle GoldenGate instances
교육대상
Data Warehouse Developer / Configuration Consultant / Data Warehouse Administrator
/ Database Administrators / Database Designers / System Integrator / Data Warehouse Analyst
/ Technical Consultant
교육내용

 

□ Course Topics

 

○ Introduction
Listing Course Objectives
Discussing Required versus Suggested Knowledge
Discussing Course Non-Objectives (available as other follow-on courses)


○ Configuration Options
Listing the Oracle Goldengate Product Line
Describing GUI Management Options
Listing Supported OS
Assembling Building Blocks
Listing Non-Database Sources and Targets
Listing Supported Databases
Reviewing Oracle GoldenGate Use Cases
Creating Oracle GoldenGate Topologies


○ Oracle GoldenGate Architecture
Explaining Initial Data Load
Describing Commit Sequence Numbers (CSN)
Explaining change Capture and Delivery (with and without a data pump)
Contrasting Batch and Online Operation
Describing Oracle GoldenGate Files and Directories
Describing Oracle GoldenGate Process Groups
Explaining Oracle GoldenGate Checkpointing


○ Installing Oracle GoldenGate
Listing System Requirements
Configuring Environment Variables
Performing Installation
Using GGSCI
Running Oracle GoldenGate from the OS shell.


Configuration Overview and Preparing the Environment
Assigning Oracle Database Roles/Privileges Required
Configuring Manager Process
Reviewing Configuration Overview
Creating Source Definitions
Preparing the Source Database


○ Configuring Change Capture (Extract)
Accessing Logs on Oracle ASM
Extracting Use of Archived Transaction Logs
Adding Extract Group
Configuring Extract Tasks
Accessing Logs Remotely
Adding Trails
Reviewing Extract Overview
Editing Extract Parameters


○ Configuring Change Delivery (Replicat)
Reviewing Replicat Overview
Configuring Replicat Tasks
Configuring a Sample Environment


○ Configuring Extract Trails and Files (Data Pump)
Describing Trail Formats
Configuring and Using Data Pumps
Reversing the Trail Sequence
Reviewing Extract Trails and Files Overview
Using Logdump for Viewing Trails


○  Performing Initial Load
Oracle GoldenGate Methods
Configuring Direct Load Methods
Listing Database-specific Methods
Handling Collisions with Initial Load
Describing Resource Limitations
Listing Advantages of Oracle GoldenGate Methods
Configuring File Load Methods


○  Editing Configuration Parameters
Contrasting GLOBALS versus Process Parameters
Configuring Extract Parameters
Configuring Manager Parameters
Configuring Replicat Parameters
Configuring GLOBALS Parameters
Editing Parameter Files


○ Filtering and Data Selection
Mapping Columns Between Different Schemas
Using Built-in @ (at) Functions
Filtering and Data Selection
Using SQLEXEC to Interact Directly with a Database


○  Additional Transformation Concepts
Configuring and Using User Tokens
Configuring and Using User Exits
Configuring and Using Macros
Configuring and Using Oracle Sequences


○  Configuration Options
Configuring and Using Event Actions
Configuring and Using Compression
Configuring and Using BATCHSQL
Configuring and Using Encryption


  Bidirectional Replication
Describing Identity Types Issues
Detecting Loops
Configuring and Using Conflict Detection and Resolution
Avoiding Conflicts
Reviewing Bidirectional Considerations


  DDL Replication
Configuring and Using Options for DDL Replication
Configuring and Using String Substitution in DDL
Reviewing Data Description Language Replication Overview

 

학원의 설립ㆍ운영 및 과외교습에 관한 법률 시행령에 따라 다음과 같이 수강료를 환불해드립니다.

  1. 반환기한 : 반환사유가 발생한 경우 반환기준에 따라 반환사유 발생일로부터 5일 이내에 교습비등을 환불해 드리겠습니다.
  2. 반환기준
    • 1) 교습을 할 수 없거나 교습장소를 제공할 수 없게 된 날을 기준으로 이미 납부한 교습비등을 일할 계산한 금액을 환불해 드리겠습니다.
    • 2) 교습기간이 1개월 이내인 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 총 교습시간 1/3 경과 전 : 이미 납부한 교습비등의 2/3에 해당하는 금액
      - 총 교습시간 1/2 경과 전 : 이미 납부한 교습비등의 1/2에 해당하는 금액
      - 총 교습시간 1/2 경과 후 : 반환하지 않음
    • 3) 교습기간이 1개월을 초과하는 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 교습시작 후 : 반환사유가 발생한 해당월의 반환 대상 교습비등(교습기간 1개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액