Oracle Apps DBA

Oracle Apps DBA

Sample Description
Sample Description

R12 Oracle Applications Install

  • Oracle Applications Overview
  • Preparing for Your Installation
  • Single-node Installation
  • Multi-node Installation
  • Finishing Your Installation

R12 Oracle E-Business Suite Architecture

  • Oracle Applications Technology
  • Oracle Applications Environment Files, Server Process Scripts, and Languages
  • Oracle Applications File System
  • Oracle Applications Database

R12 Use Oracle Applications AD Utilities

  • What are the AD Utilities?
  • AD Administration
  • Special Utilities
  • Context Editor
  • AutoConfig
  • License Manager
  • Reporting Utilities
  • Configuration Utilities

R12 Patch and Maintain Oracle Applications

  • What are the AD Utilities?
  • AD Administration
  • Special Utilities
  • Context Editor
  • AutoConfig
  • License Manager
  • Reporting Utilities
  • Configuration Utilities

R12 Patch and Maintain Oracle Applications

  • Patching and the Auto Patch Process
  • Patch Advisor
  • Running AutoPatch
  • Other Patching Topics
  • Patch History Database

Oracle Applications Advanced Topics

  • Cloning Oracle Applications
  • Advanced Cloning Options
  • Other Advanced Topics

R12 System Administrator Fundamentals

  • Managing Application Security
  • Managing Concurrent Programs and Reports
  • Administering Concurrent Managers
  • Managing Profile Options
  • Incorporating a Custom Program
  • Auditing System Resources
  • Managing Printers
  • System Management using Oracle Application Manager (OAM)
  • Applications DBA Duties
  • Introduction to Oracle Workflow
  • Overview of Oracle Alert

DB2 DBA

DB2 DBA

DB2 DBA

This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms. DB2 runs under the z/OS, VM, Linux, UNIX, and Windows operating systems, to name a few. The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

  • List and describe the major components of IBM's relational database, DB2
  • Explain the characteristics of a DB2 table
  • Relate the basic concepts of data modeling
  • Comprehend the processing instructions given to DB2 via simple SQL statements
  • List and describe steps needed to imbed SQL statements in an application program
  • Explain some of the functions performed by, and the responsibilities of, database and system administrators
  • Establish a base for more specialized DB2 education
  • Any Graduates(B.A,B.Com,B.Sc)
  • Engineering Students(B.Tech, B.E, M.Tech)
  • BCA,MCA
  • Any Diploma Holder
  • Any Working Professionals
  • Data Warehouse Administrators
  • Database Administrators
  • Software Tester
  • Project Manager
  • MIS Support

DB2 LUW DATABASE ADMINISTRATION

Curriculum based on Real time DBA activity

  • DB2 Introduction
  • DB2 Database Architecture
  • DB2 installation
  • Database creation – Lab Work

Creation and Identification of DB2 database objects – Lab Work

  • Table
  • Index
  • View
  • Tablespace
  • Buffer pool Concept

  • Create
  • Alter
  • Drop

Database diagnostics and administrator notification Log

Overview of Database Transaction – Lab Work

  • Select
  • Insert
  • Update
  • Delete

Important Database Parameters

STMM Concept

Tablespace State

Automatic Storage Concept

Database Granularity and Locking

Brief Overview of SQL

Database Utilities– Lab Work

  • Import
  • Export
  • Load

Database Tools– Lab Work

  • Db2pd
  • Db2look
  • Db2tops

Introduction to Database security – Lab Work

  • DB2 authorizations and privileges
  • security administrator role
  • Audit facility
  • trusted context
  • row column access control (RCAC)
  • LBAC

Introduction to database Logging

  • Circular Logging
  • Archival Logging
  • Infinite Logging
  • Overview of Database logs

    • Active Log
    • Archive Log

    Introduction to database Backup – Lab Work

    • Offline Backup
    • Online Full Backup
    • Incremental Backup
    • Delta Backup

    Database Recovery – Lab Work

    • Database restoration
    • Roll forward recovery
    • Crash Recovery

    Overview of REORG – Lab Work

    • Offline Reorg
    • Online Table Reorg
    • Online Index Reorg
    • Online Table movement

    Overview of RUNSTATS – Lab Work

    HADR Replication:

    • HADR Concept
    • HADR State and Stages
    • HADR building

    Database Fix-pack Update – Lab Work

    • Process and Concept

    Database Migration – Lab Work

    • Process and Concept

    Database Mirroring Concept

    Database Ingest Utility

    MDC and ITC table concept

    Database Compression concept

    • Row Compression
    • Deep Compression
    • Adaptive Compression

    Database Performance Tuning

    • DB2ADVIS
    • INSERT TIME tuning
    • Backup Time tuning

    PL/SQL

    Sample DescriptionThe Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

    Learn To:

    • Use various features of PL/SQL.
    • Write anonymous blocks of code in PL/SQL.
    • Use various PL/SQL conditional constructs and loops in program blocks.
    • Interface the PL/SQL code with the database.
    • Use stored procedures and functions in their program blocks.
    • Handle Exceptions in PL/SQL code.

    Benefits To You

    Students will benefit from this course as it enables programmers with the skill of using this programming language. In the class students will learn to create anonymous PL/SQL blocks, to create procedures, functions and triggers. Students will learn to use explicit cursors in their program blocks. Demonstrations and hands-on practice reinforce the fundamental concepts. Students use Oracle SQL Developer to develop these program units. SQL*Plus is introduced as optional tools.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Introduction

    • Course Objectives, Course Agenda and Class Account Information
    • The Human Resources (HR) Schema
    • Appendices Used in this Course
    • PL/SQL Development Environments

    Introduction to PL/SQL

    • Understanding the benefits and structure of PL/SQL
    • Understanding PL/SQL Blocks
    • Generating output messages in PL/SQL

    Declaring PL/SQL Variables

    • Identifying valid and invalid identifiers
    • Declaring and initializing variables
    • Various data types
    • Identifying the benefits of using the %TYPE attribute
    • Using bind variables

    Writing Anonymous PL/SQL blocks

    • Lexical Units in a PL/SQL Block
    • Using SQL Functions in PL/SQL
    • Data Type Conversion
    • Using Nested Blocks as Statements
    • Referencing an Identifier Value in a Nested Block
    • Qualifying an Identifier with a Label
    • Operators in PL/SQL
    • Using Sequences in PL/SQL Expressions

    Using SQL Statements within a PL/SQL Block

    • Using SQL Statements in PL/SQL
    • Retrieving Data in PL/SQL with the SELECT statement
    • Using Naming Conventions in DML Statements and data retrieval
    • Manipulating Data on the Server Using PL/SQL
    • SQL Cursors
    • Using SQL Cursor Attributes to Obtain Feedback on DML
    • Saving and Discarding Transactions

    Writing Control Structures

    • Controlling PL/SQL Flow of Execution
    • Using IF and CASE Statements for conditional processing
    • Handling Nulls
    • Building Boolean Conditions with Logical Operators
    • Using Iterative Control with Loop Statements

    Working with Composite Data Types

    • Composite Data Types of PL/SQL Records and Tables
    • Using PL/SQL Records
    • Inserting and Updating PL/SQL Records
    • Using INDEX BY Tables
    • Using Associative arrays
    • Declaring and Using VArrays

    Using Explicit Cursors

    • Cursors
    • Explicit Cursor Operations
    • Controlling Explicit Cursors
    • Using Explicit Cursors to Process Rows
    • Cursors and Records
    • Cursor FOR Loops Using Subqueries
    • Explicit Cursor Attributes
    • %NOTFOUND and %ROWCOUNT Attributes

    Handling Exceptions

    • Concept of Exception
    • Handling Exceptions with PL/SQL
    • Predefined Exceptions
    • Trapping Predefined and Non-predefined Oracle Server Errors
    • Functions that Return Information on Exceptions
    • Usage of PRAGMA keyword
    • Trapping User-Defined Exceptions
    • Propagating Exceptions

    Creating Stored Procedures and Functions

    • Overview of Stored Procedures and Functions
    • Differentiating between anonymous blocks and subprograms
    • CREATE OR REPLACE PROCEDURE | FUNCTION
    • Understanding the Header Area of a Stored Procedure and Function
    • Creating Simple Procedures and Functions
    • Creating a Simple Procedure with an IN Parameter
    • Executing a Procedure and a Function
    • Design PL/SQL anonymous block that execute efficiently
    • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
    • Handle exceptions in the program units
    • Create and execute simple stored procedures and functions
    • Write PL/SQL code to interface with the database
    • Describe the features and syntax of PL/SQL

    Oracle Cloud 12C

    The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide you with a firm foundation in administration of an Oracle Database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner.

    Learn To:

    • Manage an Oracle Database instance.
    • Configure the Oracle Network environment.
    • Create and manage storage structures.
    • Manage and move data.
    • Create and manage users.
    • Monitor the database and manage performance.
    • Create and manage Database as a Cloud Service database deployments.

    Benefits To You

    You will benefit from this course as you learn detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

    To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Getting Started

    • Course Objectives

    Exploring Oracle Database Architecture

    • Introducing Oracle Database
    • Relation Database Models
    • Oracle SQL and PL/SQL
    • Oracle Database Server Architecture
    • Connecting to Oracle Databases
    • Oracle Database Tools
    • Oracle-Supplied User Accounts
    • Querying the Oracle Data Dictionary

    Managing Database Instances

    • Initialization Parameter Files
    • Starting Up Oracle Databases
    • Shutting Down Oracle Databases
    • Opening and Closing PDBs
    • Working with the Automatic Diagnostic Repository (ADR)
    • Querying Dynamic Performance Views

    Creating PDBs

    • Methods and Tools to Create PDBs
    • Creating PDBs from Seed with SQL*Plus
    • Cloning PDBs with SQL*Plus
    • Unplugging and Pluggin In PDBs with SQL*Plus
    • Dropping PDBs with SQL*Plus

    Configuring the Oracle Network Environment

    • Oracle Net Services
    • How Listeners Work
    • Configuring Listeners for Dynamic Service Registration
    • Configuring Listeners for Static Service Registration
    • Configuring Local Naming for Connections
    • Testing Oracle Net Connectivity with tnsping
    • Configuring Communidation Between Databases
    • Dedicated Versus Shared Server Configurations

    Administering User Security

    • Creating Users
    • Granting Privileges
    • Creating and Granting Roles
    • Revoking Privileges and Roles
    • Creating and Assigning Profiles
    • Authenticating Users
    • Assigning Quotas to Users
    • Applying the Principal of Least Privilege

    Creating and Managing Tablespaces

    • How Table Data is Stored
    • Creating Tablespaces in SQL*Plus
    • Altering and Dropping Tablespaces in SQL*Plus
    • Viewing Tablespace Information in SQL*Plus
    • Implementing Oracle Managed Files
    • Moving and Renaming Online Data Files in SQL*Plus

    Managing Storage Space

    • Oracle Database Space Management Features
    • Block Space Management
    • Row Chaining and Migration
    • Free Space Management Within Segments
    • Types of Segments
    • Allocating Extents
    • Understanding Deferred Segment Creation
    • Space-Saving Features
    Managing UNDO Data
    • Undo Data: Overview
    • Transactions and Undo Data
    • Storing Undo Information
    • Comparing Undo Data and Redo Data
    • Managing Undo
    • Local Undo Mode Versus Shared Undo Mode
    • Configuring Undo Retension
    • Categories of Undo

    Moving Data

    • Moving Data: General Architecture
    • Oracle Data Pump: Overview
    • Oracle Data Pump: Benefits
    • Data Pump Export and Import Clients
    • Data Pump Utility: Interfaces and Modes
    • Data Pump Import: Transformations
    • SQL*Loader Overview
    • Loading Methods

    Backup and Recovery Concepts

    • DBA Responsibilities
    • Categories of Failure
    • Understanding Instance Recovery
    • Understanding Types of Backups
    • Comparing Complete and Incomplete Recovery
    • Oracle Data Protection Solutions
    • Flashback Technology

    Monitoring and Tuning Database Performance

    • Managing Performance Activities
    • Performance Planning Considerations
    • Database Maintenance
    • Automatic Workload Repository (AWR)
    • Automatic Database Diagnostic Monitor
    • Performance Monitoring
    • Performance Tuning Methodology
    • Database Server Statistics and Metrics

    SQL Tuning

    • SQL Tuning Process
    • Oracle Optimizer
    • Optimizer Statistics
    • SQL Plan Directives
    • Adaptive Execution Plans
    • SQL Tuning Advisor
    • SQL Access Advisor
    • SQL Performance Analyzer

    Oracle Database Resource Manager

    • Oracle Database Resource Manager: Overview
    • Resource Manager Elements
    • Using Resource Manager to Allocate Resources
    • Creating a Simple Resource Plan
    • Creating a Complex Resource Plan
    • Using the Active Session Pool Feature
    • Limiting CPU Utilization at the Database Level
    • Limiting CPU Utilization at the Server Level

    Enterprise Manager Cloud Control

    • Controlling the Enterprise Manager Cloud Control Framework
    • Starting the Enterprise Manager Cloud Control Framework
    • Stopping the Enterprise Manager Cloud Control Framework

    Introduction to Oracle Database Cloud Service

    • Oracle Cloud: Overview
    • Database Cloud Service Offerings
    • DBCS Architecture
    • Features and Tooling
    • Additional Database Configuration Options

    Creating DBCS Database Deployments

    • Automated Database Provisioning
    • Creating a Database Deployment
    • How SSH Key Pairs are Used
    • Creating an SSH Key Pair
    • Storage Used for Database Files

    Managing DBCS Database Deployments

    • Cloud Tooling
    • Accessing Tools and Features from the DBCS Console
    • Managing the Compute Node Associated With a Database Deployment
    • Managing Network Access to DBCS
    • Enabling Access to a Compute Node Port
    • Scaling a Database Deployment

    Backing Up and Restoring DBCS Database Deployments

    • Backing Up and Recovering Databases on DBCS
    • Backup Destination Choices
    • Backup Configuration
    • Creating an On-Demand Backup
    • Customizing the Backup Configuration
    • Performing Recovery by Using the Console
    • Performing Recovery by Using the dbaascli Utility

    Patching DBCS Database Deployments

    • Patching DBCS
    • Using the DBCS Console to Manage Patches
    • Using the dbaascli Utility to Manage Patches

    Creating Master Encryption Keys for PDBs

    • CDB and PDB Master Encryption Keys
    • Determining Whether You Need to Create and Activate and Encryption Key for a PDB
    • Creating and Activating an Encryption Key

    Tablespace Encryption by Default

    • Tablespace Encryption by Default in DBCS
    • Transparent Data Encryption (TDE) Overview
    • Components of TDE
    • Using TDE
    • Defining the Keystore Location
    • Controlling Tablespace Encryption by Default
    • Managing the Software Keystore and Master Encryption Key
    • Managing the Keystore in CDBs and PDBs
    • Deploy management agents in various forms
    • Setup a load balancer within the EM framework
    • Understand techniques for disaster recovery of EM in an HA environment
    • Implement security of EM framework
    • Maximize the use of My Oracle Support
    • Become familiar with silent and command line EM operations
    • Deploy EM with a 2-node RAC repository for High Availability and Scalability
    • Configure Oracle Management Services (OMS) and expand to multiple OMSs

    SQL

    This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.

    Learn To:

    • Understand the basic concepts of relational databases ensure refined code by developers.
    • Create reports of sorted and restricted data.
    • Run data manipulation statements (DML).
    • Control database access to specific objects.
    • Manage schema objects.
    • Manage objects with data dictionary views.
    • Retrieve row and column data from tables.
    • Control privileges at the object and system level.
    • Create indexes and constraints; alter existing schema objects.
    • Create and query external tables.

    Benefits to You

    Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

    Learn Advanced Features of SQL

    This course will help you understand the advanced features of SQL. Learning these features will help you query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the date-time functions available in the Oracle Database are also covered. This course also discusses how to use the regular expression support in SQL through expert instruction.

    Use Development Tools

    The main development tool used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is appropriate for a 10g, 11g and 12c audience.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Introduction

    • Course Objectives, Course Agenda and Appendixes Used in this Course
    • Overview of Oracle Database 12c and Related Products
    • Overview of relational database management concepts and terminologies
    • Introduction to SQL and its development environments
    • What is Oracle SQL Developer?
    • Starting SQL*Plus from Oracle SQL Developer
    • The Human Resource (HR) Schema
    • Tables used in the Course

    Retrieving Data using the SQL SELECT Statement

    • Capabilities of the SELECT statement
    • Arithmetic expressions and NULL values in the SELECT statement
    • Column aliases
    • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    • Use of the DESCRIBE command

    Restricting and Sorting Data

    • Limiting the Rows
    • Rules of precedence for operators in an expression
    • Substitution Variables
    • Using the DEFINE and VERIFY command

    Using Single-Row Functions to Customize Output

    • Describe the differences between single row and multiple row functions
    • Manipulate strings with character function in the SELECT and WHERE clauses
    • Manipulate numbers with the ROUND, TRUNC and MOD functions
    • Perform arithmetic with date data
    • Manipulate dates with the date functions

    Using Conversion Functions and Conditional Expressions

    • Describe implicit and explicit data type conversion
    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • Nest multiple functions
    • Apply the NVL, NULLIF, and COALESCE functions to data
    • Use conditional IF THEN ELSE logic in a SELECT statement

    Reporting Aggregated Data Using the Group Functions

    • Group Functions
    • Creating Groups of Data
    • Restricting Group Results

    Displaying Data from Multiple Tables Using Joins

    • Introduction to JOINS
    • Types of Joins
    • Natural join
    • Self-join
    • Non equijoins
    • OUTER join

    Using Subqueries to Solve Queries

    • Introduction to Subqueries
    • Single Row Subqueries
    • Multiple Row Subqueries

    Using the SET Operators

    • Set Operators
    • UNION and UNION ALL operator
    • INTERSECT operator
    • MINUS operator
    • Matching the SELECT statements
    • Using ORDER BY clause in set operations

    Managing Tables using DML statements

    • Data Manipulation Language
    • Database Transactions

    Introduction to Data Definition Language

    • Data Definition Language

    Introduction to Data Dictionary Views

    • Introduction to Data Dictionary
    • Describe the Data Dictionary Structure
    • Using the Data Dictionary views
    • Querying the Data Dictionary Views

    Creating Sequences, Synonyms, Indexes

    • Overview of sequences
    • Overview of synonyms
    • Overview of indexes

    Creating Views

    • Overview of views

    Managing Schema Objects

    • Managing constraints
    • Creating and using temporary tables
    • Creating and using external tables

    Retrieving Data by Using Subqueries

    • Retrieving Data by Using a Subquery as Source
    • Working with Multiple-Column subqueries
    • Using Scalar subqueries in SQL
    • Correlated Subqueries
    • Working with the WITH clause

    Manipulating Data by Using Subqueries

    • Using Subqueries to Manipulate Data
    • Inserting by Using a Subquery as a Target
    • Using the WITH CHECK OPTION Keyword on DML Statements
    • Using Correlated Subqueries to Update and Delete rows

    Controlling User Access

    • System privileges
    • Creating a role
    • Object privileges
    • Revoking object privileges

    Manipulating Data

    • Overview of the Explicit Default Feature
    • Using multitable INSERTs
    • Using the MERGE statement
    • Performing flashback operations
    • Tracking Changes in Data

    Managing Data in Different Time Zones

    • Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
    • Working with INTERVAL data types
    • Identify the major structural components of the Oracle Database 12c
    • Manage objects with data dictionary views
    • Manage schema objects
    • Retrieve row and column data from tables
    • Run data manipulation statements (DML) in Oracle Database 12c
    • Use scalar and correlated sub-queries
    • Utilize views to display data
    • Write SELECT statements that include queries
    • Write multiple-column sub-queries
    • Control database access to specific objects
    • Create reports of aggregated data
    • Create reports of sorted and restricted data
    • Create tables to store data
    • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
    • Employ SQL functions to retrieve customized data

    RAC

    This Oracle Database 12c: Clusterware & RAC Admin Accelerated training covers 8 days worth of content in only 5 days. It starts with the Oracle Database 12c: Clusterware Administration course (4 days) and then covers the Oracle RAC database architecture(4 days); learn how these products work together.In this course, you will be introduced to Oracle Database Exadata Cloud Service.

    Learn To:

    • Perform Grid Infrastructure pre-installation tasks.
    • Install both Standard and Flex clusters.
    • Add and remove nodes from a cluster in addition to upgrading and patching existing Grid Homes.
    • Manage and administer both Standard Clusters and Policy-Managed Clusters.
    • Use Oracle Clusterware to make applications highly available.
    • Install Oracle RAC software.
    • Create cluster databases.
    • Administer both administrator and policy-managed Oracle RAC databases.
    • Monitor and address performance issues.
    • Learn about services in a RAC environment as well as highly available connection features including Application Continuity and Transaction Guard.
    • Create and administer a RAC One Node Database.
    • Create and manage multitennant RAC databases.
    • Gain an understanding of the Oracle Database Exadata Cloud Service.

    Benefits to You

    By taking this course, you'll know how to make applications highly available using Oracle Clusterware and RAC. You'll walk away with the ability to install, configure, manage and troubleshoot both Oracle Clusterware and Oracle RAC software. Ensure fast, reliable, secure and easy to manage performance as you learn to optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Grid Infrastructure: Overview

    • What is a Cluster?
    • What is a Flex Cluster ?
    • Clusterware Characteristics
    • Oracle Clusterware
    • Hardware and Software Concepts (High level)
    • RAC and Flex ASM

    RAC Databases Overview & Architecture

    • Overview of Oracle RAC
    • Oracle RAC One Node (High level)
    • Cluster-Aware Storage Solutions
    • Benefits of Using RAC
    • Scaleup and Speedup
    • I/O Throughput Balanced
    • Global Resources

    Installing and Configuring Oracle RAC

    • Installing the Oracle Database Software
    • Installation options
    • Creating the Cluster Database
    • Configuring Oracle RAC Reader Nodes
    • Post-installation Tasks
    • Single Instance to RAC Conversion using DBCA and rconfig

    Oracle RAC Administration

    • Separation of Duty for Administering Oracle RAC
    • Use Enterprise Manager Cluster Database Pages
    • RAC Alerts
    • RAC Metrics
    • Undo Tablespaces
    • Local Temporary Tablespaces
    • Redo Threads
    • Parameters and RAC - SPFILE, Identical and Unique Parameters

    Upgrading and Patching Oracle RAC

    • Ovierview of Upgrades and Patching
    • Release and Patch Set Upgrades
    • PSU, CPU and Interim Patches
    • Merge Patches
    • Performing Out of Place Database Upgrades
    • Planning and Preparing for Upgrade
    • Post Upgrade Tasks

    Managing Backup and Recovery for RAC

    • Instance Failure And Recovery In RAC - LMON and SMON
    • Redo Threads and Archive Logs Configurations and Admin
    • Parameter Settings Affecting Parallel Recovery and MTTR
    • RAC and the Fast Recovery Area
    • RMAN Configuration
    • RMAN Admin for RAC: Channels, Instances, Backup Considerations

    RAC Global Resource Management and Cache Fusion

    • Globally Managed Resources and Management
    • Library Cache Management
    • Row cache management
    • Buffer cache fusion
    • Buffer Cache Management Requirements
    • Accessing single blocks in RAC
    • Multi-block read considerations in RAC
    • Undo and read consistency considerations in RAC

    RAC Database Monitoring and Tuning

    • OCPU and Wait Time Latencies
    • Wait Events for RAC
    • Common RAC Tuning
    • Session and System Statistics
    • RAC specific V$ Views
    • Automatic Database Diagnostic Monitor for RAC
    • Monitoring RAC with Cluster Health Advisor (CHA)

    Managing High Availability of Services in a RAC Environment

    • Oracle Services
    • Services for Policy - and Administrator-Managed Databases
    • Service-Oriented Buffer Cache Access
    • Creating Services
    • Managing Services
    • Use Services with Client Applications
    • Services and Connection Load Balancing
    • Services and Transparent Application Failover

    Managing High Availability of Connections

    • Types of Workload Distribution
    • Client-Side Load Balancing
    • Server-Side Load Balancing
    • Runtime Connection Load Balancing and Connection Pools
    • Fast Application Notification
    • The Load Balancing Advisory FAN Event
    • Server-Side Callouts
    • Configuring the Server-Side ONS

    Application Continuity

    • What is AC?
    • What problem does it solve?
    • Benefits of AC
    • How AC works
    • AC Architecture
    • Side Effects
    • Restrictions
    • Application requirements

    RAC One Node

    • RAC One Node Concepts
    • Online database migration
    • Adding Oracle RAC One Node Database to an Existing Cluster
    • Convert an Oracle RAC One Node database to a RAC database
    • Convert an Oracle RAC database to a RAC One Node database
    • Use DBCA to convert a single instance database to a RAC One Node database

    Oracle Database In-Memory in RAC

    • Architecture of In-Memory Column Store
    • Implementing In-Memory Column Store in RAC
    • Implementing In-Memory FastStart

    Multitenant Architecture and RAC

    • Non-CDB Architecture
    • Multitenant Architecture: Benefits
    • CDB in a Non-RAC Environment
    • Containers
    • Terminology and Data Dictionary Views
    • Connection to a Non-RAC CDB
    • Oracle RAC and Multitenant Configuration
    • Oracle RAC and Multitenant Architecture

    Quality of Service Management

    • QOS Management concepts
    • Describe the benefits of using QoS Management
    • QoS Management components
    • QoS Management functionality

    Oracle Database Exadata Cloud Service Overview

    • Introducing Exadata Cloud Service
    • Service Configuration Options & Service Connection Options
    • Service Architecture & Availability
    • Management Responsibilities
    • Storage Configuration & Management Details
    • Simple Web-Based Provisioning & Management
    • REST APIs
    • Migrating to Exadata Cloud Service
    • Configure Oracle RAC Reader Nodes
    • Define redo log files in a RAC environment
    • Define undo tablespaces in a RAC environment
    • Define local temporary tablespaces in a RAC environment
    • Modify initialization parameters in a RAC environment
    • Perform post-database-creation tasks
    • Configure RMAN for the RAC environment
    • Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
    • Explain the necessity of global resources
    • Describe global cache coordination
    • Explain the principles and purposes of clusters
    • Describe the Oracle Clusterware architecture
    • Describe the benefits of Oracle RAC
    • Convert a single-instance Oracle Database to RACs
    • Install the Oracle Database software
    • Create a cluster database

    Oracle DBA

    This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

    Learn To:

    • Install Oracle Grid Infrastructure.
    • Create and manage users.
    • Install and configure an Oracle Database.
    • Create and manage storage structures.
    • Administer the Oracle Database.
    • Understand the Oracle database architecture and how its components work and interact with one another.
    • Perform backup and recovery.

    Benefits to You

    Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

    Create an Operational Database

    You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner. This includes performance monitoring, database security, user management and backup/recovery techniques.

    Training Requirements

    This Oracle Database 11g: Administration Workshop I Release 2 course fulfills the training requirement for an Oracle Certification Path. Only instructor-led online (LVC, LWC), in-class (ILT) or Training On Demand courses fulfill the requirement. Please note that Self-Study Courses and Knowledge Center courses do not fulfill the training requirement.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Exploring the Oracle Database Architecture

    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structrues
    • Logical and physical storage structures
    • ASM storage components

    Installing your Oracle Software

    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install

    Creating an Oracle Database

    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database

    Managing the Oracle Database Instance

    • Start and stop the Oracle database and components
    • Use Oracle Enterprise Manager
    • Access a database with SQLPlus
    • Modify database installation parameters
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the alert log
    • Access dynamic performance views

    Manage the ASM Instance

    • Set up initialization parameter files for ASM instance
    • Start up and shut down ASM instances
    • Administer ASM disk groups

    Configuring the Oracle Network Environment

    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers

    Managing Database Storage Structures

    • Storage Structures
    • How Table Data Is Stored
    • Anatomy of a Database Block
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Actions with Tablespaces
    • Oracle Managed Files (OMF)

    Administering User Security

    • Database User Accounts
    • Predefined Administrative Accounts
    • Benefits of Roles
    • Predefined Roles
    • Implementing Profiles

    Managing Data Concurrency

    • Data Concurrency
    • Enqueue Mechanism
    • Resolving Lock Conflicts
    • Deadlocks

    Managing Undo Data

    • Data Manipulation
    • Transactions and Undo Data
    • Undo Data Versus Redo Data
    • Configuring Undo Retention

    Implementing Oracle Database Auditing

    • Describe DBA responsibilities for security
    • Enable standard database auditing
    • Specify audit options
    • Review audit information
    • Maintain the audit trail

    Database Maintenance

    • Manage optimizer statistics
    • Manage the Automatic Workload Repository (AWR)
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe and use the advisory framework
    • Set alert thresholds
    • Use server-generated alerts
    • Use automated tasks

    Performance Management

    • Performance Monitoring
    • Managing Memory Components
    • Enabling Automatic Memory Management (AMM)
    • Automatic Shared Memory Advisor
    • Using Memory Advisors
    • Dynamic Performance Statistics
    • Troubleshooting and Tuning Views
    • Invalid and Unusable Objects

    Backup and Recovery Concepts

    • Part of Your Job
    • Statement Failure
    • User Error
    • Understanding Instance Recovery
    • Phases of Instance Recovery
    • Using the MTTR Advisor
    • Media Failure
    • Archive Log Files

    Performing Database Backups

    • Backup Solutions: Overview
    • Oracle Secure Backup
    • User-Managed Backup
    • Terminology
    • Recovery Manager (RMAN)
    • Configuring Backup Settings
    • Backing Up the Control File to a Trace File
    • Monitoring the Flash Recovery Area

    Performing Database Recovery

    • Opening a Database
    • Data Recovery Advisor
    • Loss of a Control File
    • Loss of a Redo Log File
    • Data Recovery Advisor
    • Data Failures
    • Listing Data Failures
    • Data Recovery Advisor Views

    Moving Data

    • Describe ways to move data
    • Create and use directory objects
    • Use SQL*Loader to move data
    • Use external tables to move data
    • General architecture of Oracle Data Pump
    • Use Data Pump export and import to move data

    Working with Support

    • Use the Enterprise Manager Support Workbench
    • Work with Oracle Support
    • Log service requests (SR)
    • Manage patches
    • Install Oracle Grid Infrastructure
    • Install and configure Oracle Database 11g
    • Configure Oracle Net services
    • Monitor and administer undo data
    • Manage the database storage structures
    • Create and administer user accounts
    • Perform basic backup and recovery of a database
    • Manage data concurrency
    • Monitor performance
    • Describe Oracle Database Architecture

    Data Guard

    This Oracle Database 12c: Data Guard training teaches you how to use Oracle Data Guard. Expert Oracle University instructors will demonstrate how this solution protects your Oracle database against planned and unplanned downtime. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

    Learn To:

    • Build highly available systems.
    • Offload business processing needs to another system.
    • Offload backup needs to another system.
    • Gain an understanding of Oracle Database Exadata Cloud Service.

    Benefits to You

    You'll walk away from this course with an understanding of how Data Guard standby databases can be used to support various production functions. These functions include reporting, querying and testing, while in a standby role.

    Oracle Data Guard 12c

    This course will also teach you about the new Oracle Data Guard 12c features and architecture. You'll get a chance to 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.

    Introduction to Oracle Data Guard

    • What Is Oracle Data Guard?
    • Types of Standby Databases
    • Types of Data Guard Services
    • Role Transitions: Switchover and Failover
    • Oracle Data Guard Broker Framework
    • Choosing an Interface for Administering a Data Guard Configuration
    • Oracle Data Guard: Architecture(Overview)
    • Primary Database Processes

    Networking for Oracle Data Guard

    • Networking Overview
    • Listener.ora Configuration
    • Statics vs. Dynamic Registration
    • Static Entries for Database Duplication and SQL Maintenence
    • Static Entries for Broker Operations
    • Oracle Network Configuration Tuning
    • Tnsnames.ora Configuration

    Creating a Physical Standby Database by Using SQL and RMAN Commands

    • Steps to Create a Physical Standby Database
    • Preparing the Primary Database
    • FORCE LOGGING Mode
    • Configuring Standby Redo Logs
    • Creating Standby Redo Logs
    • Using SQL to Create Standby Redo Logs
    • Viewing Standby Redo Log Information
    • Setting Initialization Parameters on the Primary Database to Control Redo Transport
    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support
    AUDIENCE This Oracle Data Guard training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.
    01 - Introduction to Data Guard
    •	What is Oracle Data Guard
    •	MAA - Maximum Availability Architecture
    •	Configurations
    •	Primary Database
    •	Standby Database
    •	Physical Standby Database
    •	Logical Standby Database
    •	Snapshot Standby Database
    •	Data Guard Services
    •	Redo Transport Services
    •	Apply Services
    •	Role Transitions
    •	Data Guard Broker
    •	Protection Modes
    •	Architecture
    •	Primary
    •	Standby
    •	Physical Redo Architecture
    •	Logical SQL Apply
    •	Redo Transport
    •	After Standby Startup
    •	Standby Startup
    •	Logical Apply
    •	Gap Detection and Resolution
    •	Complimentary Technology
    •	Benefits of Using Data Guard
    •	Licensing
    
    02 - Creating a Physical Standby (SQL & RMAN)
    •	Preparing the Primary
    •	Force Logging
    •	Configuring Standby Redo Logs
    •	Logfiles on the Standby
    •	Standby Redo Logs
    •	Using SQL to Create SRLs
    •	Initialization Parameters on Primary
    •	Role-Based Destinations
    •	Redo Transport Mode
    •	Oracle Net for Physical Standby
    •	Creating a Listener Entry
    •	Copying the Primary's Password File
    •	Standby Init.ora File
    •	Directory Path on the Target
    •	Starting the Physical Standby
    •	Invoking RMAN
    •	Real-Time Apply
    •	Starting Redo Apply
    •	Standby on the Same Server
    •	Data Corruption
    •	Lost Write Detection
    
    03 - Overview of Data Guard Broker
    •	Data Guard Broker Components
    •	Broker Configuration
    •	Data Guard Broker Architecture
    •	DMON Process
    •	Benefits of Using Data Guard Broker
    •	DGMRL Commands
    •	Enterprise Manager
    
    04 - Creating a Data Guard Broker Configuration
    •	Requirements
    •	Configuration File
    •	Log Files
    •	Workflow
    •	Changing Properties
    •	Database Properties
    •	Disable Broker Management
    
    05 - Configuring Data Protection Modes
    •	Data Protection Modes
    •	Maximum Protection
    •	Maximum Availability
    •	Maximum Performance
    •	Comparisons
    •	How to Set the Mode
    •	Using Grid Control to Set the Mode
    
    06 - Monitoring a Data Guard Configuration
    •	Monitoring Using Enterprise Manager
    •	Viewing Data Guard Status
    •	Data Guard Performance
    •	Viewing Data Guard Performance
    •	Viewing Log Files
    •	Data Guard Metrics
    •	Viewing Diagnostic Information
    •	Destination Settings
    
    07 - Optimizing a Data Guard Configuration
    •	Monitoring Performance
    •	Optimizing Redo Transport
    •	Optimizing Redo Transmissions
    •	MaxConnections Database Property
    •	RedoCompression Property
    •	Delaying the Application of Redo
    
    08 - Using Flashback Database in a Data Guard Configuration
    •	Flashback Database
    •	Configuring Flashback Database
    •	Enable Flashback Database
    •	Flash Recovery Area
    •	Flashback and Role Transitions
    •	Flashback Database After Failover
    •	Flashback Database Scenario
    
    09 - Performing Role Transitions
    •	Role Transitions   Role Management Services   Switchover   Switchover Using DGMGRL   Switchover •	Using Enterprise Manager   Problems
    •	Failover
    •	Failover Using DGMGRL
    •	Re-enable Disabled Databases
    •	Failover Using Enterprise Manager
    •	Failover - Back on the Standby
    
    10 - Backup and Recovery Considerations
    •	RMAN in Data Guard
    •	Maximum Availability Architecture (MAA)
    •	Offload Backups to a Physical Standby
    •	Usage   RMAN Recovery Catalog
    •	Create the Recovery Catalog
    •	Register the Primary Database
    •	Persistent Configuration Settings
    •	RMAN Parameters for Primary
    •	RMAN Parameters for Standby
    •	Daily Incremental
    •	RMAN Script
    •	Loss of Data File on Primary
    •	Using a Backup
    •	Using the Physical Standby
    •	Recovering a File on the Standby
    •	Block Media Recovery
    
    11 - Managing Client Connectivity
    •	Client Connectivity Issues
    •	Helping Make the Right Connection
    •	Managing Services
    •	Client Failover
    •	Automating Client Failover
    •	Client Failover Components
    •	Automatic Failover to a New Primary
    •	Data Guard Broker and FAN
    •	OCI Clients
    •	OLE DB Clients
    •	JDBC Clients
    •	AFTER STARTUP Trigger
    •	Service Names and tnsnames.ora File
    
    12 - Patching & Upgrading Databases in a Data Guard Configuration
    •	Data Guard Broker
    •	Upgrading with a Physical Standby
    •	Rolling Upgrade Workflow
    •	Rolling Upgrade
    
    • Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
    • Create and manage physical and logical standby databases
    • Use Enterprise Manager Cloud Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
    • Use Data Guard to achieve a highly available Oracle database
    • Gain an understanding of Oracle Database Exadata Cloud Service

    Data Science

    The Introduction to Data Science class will survey the foundational topics in data science, namely:

    • Data Manipulation
    • Data Analysis with Statistics and Machine Learning
    • Data Communication with Information Visualization
    • Data at Scale -- Working with Big Data
    • Introduction to R

    The class will focus on breadth and present the topics briefly instead of focusing on a single topic in depth. This will give you the opportunity to sample and apply the basic techniques of data science.

    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Data Science Overview

    Accelerate your career in data science by mastering concepts of Data Management, Statistics, Machine Learning and Big Data from most influential Data Science leaders.

    Learn. Experience. Master.

    • For the Industry, By the Industry
    • Domain Specialization
    • Career Guidance

    Data Science – A Definition

    Data Science is the science which uses computer science, statistics and machine learning, visualization and human- computer interactions to collect, clean, integrate, analyze, visualize, and interact with data to create data products.

    What is a data scientist to do?

    These data scientists, who have expertise in computer applications, data modeling, statistical analysis, and more. Not only analyzing and resolving informational problems of the organization, their role in providing information security is very important.

    Career Impact

    Thanks to the digital revolution that is sweeping the world and India in particular, data scientists are now the most sought-after professionals by big corporations as well as startups. And companies across industries are rewarding good data analysts​ and scientists​ with desirable career growth and salaries.

    Learn by Application

    Learn from our comprehensive collection of case-studies, hand-picked by industry experts, to give you an in-depth understanding of how data science moves industries like telecom, transportation, e-commerce & more.

    Curriculum Details

    Statistics with R

    • Understanding R and its data structures
    • Descriptive statistics
    • Data Distribution
    • Hypothesis testing
    • Graphs and plots
    • Summary statistics etc

    Regression analysis

    • Linear Regression and case study
    • Logistic Regression and case study
    • Case studies in Regression

    Time Series Analysis

    • Stationary Process
    • Augmented Reality Process
    • Moving Average Process
    • Auto Regressive Integrated Moving Average Model
    • ARIMA Modelling using R with examples

    Classification Learning Objectives

    • Meaning and types of classification
    • Decision tree classifier
    • K-nearest neighbors
    • Neural Network
    • Support vector machines
    • Naive Bayes
    • Probabilistic methods
    • Random forest classifier

    Clustering Algorithms

    • What is Clustering ?
    • k-means Clustering?
    • Hierarchical clustering

    Market Basket Analysis

  • What is Market Basket
  • What is Market Basket Model
  • Association Rule mining and case study
  • Case Study

    • Credit Risk evaluation using R
    • Hands on Training
    • Learners are taught to understand business intelligence and business and data analytics.
    • To understand the business data analysis through the powerful tools of data application.
    • Learn how to apply Tableau, MapReduce, and get introduced in to R and R+.
    • Understand the methods of data mining and creation of decision tree.
    • Explore different aspects of Big Data Technologies.
    • Learn the concepts of loop functions and debugging tools.

    Golden Gate

     
    Introduction
      Objectives
    • Oracle Golden Gate 11g
    • Key Capabilities and Technology Differentiators
    • Value Propositions for Oracle Golden Gate
    • Oracle Golden Gate Topologies
    • Oracle Middleware for Business Intelligence
    • Oracle Data Integrator EE and Oracle Golden Gate
    • Oracle Golden Gate for Real-Time Data Warehousing
    • Oracle Golden Gate Solutions for Oracle Database
    • Oracle Golden Gate for Oracle Database: Eliminate Down Time for Migration and Application Upgrade
    • Oracle Golden Gate for Oracle Database: Eliminate Down Time During Oracle
    • Database Upgrades
    • Oracle Golden Gate for Oracle Database: Eliminate Unplanned Down Time with Active Data Guard
    • Oracle Golden Gate for Oracle Database
    • Improve Production System Performance and Lower Costs
    • Oracle Golden Gate for Oracle Database: Offload Redo Logs
    • Oracle Golden Gate for Operational Reporting
    • Oracle GG for Oracle Database: Increase ROI on Existing Servers and Synchronize Global Data
     
    Technology Overview
     
    	Objectives 
    
    •	Roadmap  
    •	Oracle Golden Gate: Modular Building Blocks  
    •	Roadmap  
    •	Supported Databases  
    •	Supported Operating Systems  
    •	Roadmap  
    •	Oracle GoldenGate Product Line  
    •	Oracle Golden Gate Veridata  
    •	Oracle Golden Gate Director: Overview  
    •	Oracle Golden Gate Director  
    •	Oracle Golden Gate Monitor: Overview  
    •	Oracle Golden Gate Monitor  
    •	Enterprise Manager Cloud Control 12c  
    •	Adapter Integration Options for Oracle Golden Gate  
    •	Oracle Golden Gate for Flat File  
    •	Oracle Golden Gate Application Adapter for Java  
    •	JMS Messaging Capture
    
     
    Oracle Golden Gate Architecture
     
    	Objectives 
    
    •	Roadmap  
    •	Uses of Oracle GoldenGate  
    •	Oracle GoldenGate Components  
    •	Oracle GoldenGate Logical Architecture  
    •	Oracle GoldenGate Process Groups 
    •	Process-Group Naming Convention 
    •	GGSCI  
    •	Parameter Files  Roadmap  
    •	Change Data Capture (Extract) and Delivery 
    •	Change Data Capture (Extract) and Delivery Using a Data Pump  
    •	Extract Flavors  
    •	Distributed Topologies for Integrated Extract: Same Machine  
    •	Distributed Topologies for Integrated Extract: Different Machine, Real-Time Non-Real-Time 
    •	Supported Features Based on Source DB Version  
    •	Roadmap  
    •	Online Versus Batch Operation  
    •	Running an Initial Load  
    •	Checkpoints: Capture  
    •	Checkpoints: Pump 
    •	Checkpoints: Delivery 
    •	Commit Sequence Number (CSN)
    
     
    Installing Oracle Golden Gate
     
    	Objectives  
    
    •	Roadmap  
    •	System Requirements,Operating System Requirements  
    •	Downloading Oracle Golden Gate  
    •	Installation on UNIX, Linux, or z/OS  
    •	Installation on Windows  
    •	Oracle Golden Gate Directories  
    •	Oracle Golden Gate Documentation  
    •	GGSCI Command Interface  
    •	GGSCI Commands  
    •	GGSCI Examples  
    •	Obey Files  
    •	New Oracle Golden Gate 11gR1 GGSCI Miscellaneous Commands  
    •	Running Oracle Golden Gate from the OS Shell  
    
     
    Configuration Overview and Preparing the Environment
     
    	Objectives  
    
    •	Configuring Oracle Golden Gate  
    •	Character Set: National Language Support (NLS)  
    •	Mixed-Case Object Names: ‘Single’ and “Double” Quotes  
    •	Configuring Oracle Golden Gate  
    •	Preparing the Environment: Oracle Database  
    •	Using Command Security  
    •	Sample CMDSEC Statements  
    •	Handling TCP/IP Errors  
    •	tcperrs File  
    •	Roadmap  
    •	TranData Command  
    •	Preparing the Environment: Oracle Database  
    •	Preparing the Environment: Manager Overview  
    •	Preparing the Environment: Configuring Manager  
    •	Preparing the Environment: Sample Manager Parameter File  
    •	Preparing the Environment: Overview of Source Definition 
    •	Preparing the Environment: Running defgen  
    
     
    Configuring Change Capture
     
    	Objectives  
    
    •	Step 2: Change Capture  
    •	Extract Overview  
    •	Data Pump Overview  
    •	Data Pumps: One-to-Many Trails  
    •	Data Pumps: One-to-Many Target Systems  
    •	Setting Up Change Capture (Extract)  
    •	Add Extract Command  
    •	Add Extract: Examples  
    •	Editing Extract Parameters  
    •	Passive Alias Extract  
    •	Overview of Trails  
    •	Adding a Local or Remote Trail  
    •	Starting the Extract  
    •	Primary Extract Configuration for Oracle  
    •	Data Pump Configuration for Oracle  
    •	Automatic Storage Management (ASM)  
    •	Ensuring ASM Connectivity  
    •	ASM and DBLogReader  
    •	Practice 6 Overview: Configuring Change Capture  
    
     
    Configuring Change Delivery
     
    	Objectives  
    
    •	Step 4: Change Delivery (Replicate)  Replicate Overview  
    •	Change Delivery Tasks  
    •	Check point Table  
    •	Sample Configuration  
    •	Avoiding Collisions with Initial Load  
    •	Handling Collisions with Initial Load  
    •	Obtaining Process Information Through GGSCI  
    •	Process Report Files  
    •	Sample Extract Process Report  
    •	Discard Files  
    •	Using the ggserr.log Error Log  
    •	Using the System Logs  
    
     
    Extract Trail and Files
     
    	Objectives  
    
    •	Overview of Extract Trails and Files  
    •	Extract Trails and Files Distribution  
    •	Extract Trails and Files Contents  
    •	Extract Trails and Files Cleanup  
    •	Trail Format  
    •	Record Header Area  Record Data Area  
    •	Setting the Compatibility Level  
    •	Alternative Trail Formats  
    •	Format ASCII  
    •	Format ASCII Sample Output  
    •	Format SQL  
    •	Format SQL Sample Output  
    •	Format XML  
    •	Format XML Sample Output  
    •	Log dump Utility  
    •	Opening a Trail  
    •	Setting Up a View  
    •	Viewing the Trail File Header  
    •	Viewing Trail Records  
    •	Counting Records in the Trail  
    •	Filtering by a File Name  
    •	Locating a Hex Data Value  
    •	Saving Records to a New Trail  
    •	Keeping a Log of Your Session  
    •	Overview of the reverse Utility  
    •	Overall Process of the reverse Utility  
    •	reverse: Overall Process 
    •	Sample Parameter Files  
    
     
    Configuring the Initial Load
     
    	Objectives  
    
    •	Step 3: Initial Load  
    •	Initial Load: Advantages of Oracle Golden Gate Methods  
    •	Initial Load: Resource Limitations  
    •	Prerequisites for Initial Load  
    •	Initial Load: Oracle Golden Gate Methods  
    •	Initial Load: File to Replicate  
    •	Initial Load: File to Database Utility  
    •	Initial Load: Direct Load  
    •	Initial Load: Direct Bulk Load (to Oracle)  
    •	Practice 9 Overview: Configuring the Initial Load  
    
     
    Oracle Golden Gate Parameters
     
    	Objectives  
    
    •	Roadmap  
    •	Oracle Golden Gate Parameter Files  
    •	Using Parameter Files  
    •	GLOBALS versus Process Parameters  
    •	GLOBALS Parameters  
    •	Roadmap  
    •	Manager Parameters: Overview  
    •	Sample Manager Parameter File  
    •	Manager Parameter Categories  
    •	Managing Trail Files  
    •	Extract Parameter Overview  
    •	Extract Parameter Defaults  
    •	Sample Extract Parameter File  
    •	Extract Parameter Categories  
    •	Extract Example: Table Parameter  
    •	Extract Example: Tran Log Options Parameter  
    •	Replicat Parameter: Overview  
    •	Replicat Parameter Defaults  
    •	Sample Replicat Parameter File  
    •	Replicat Parameter Categories  
    •	Replicat Example: Map Parameter  
    •	DBOptions  
    
     
    Data Selection and Filtering
     
    	Objectives  
    
    •	Data Mapping and Manipulation: Overview  
    •	Types of Definition Files  
    •	Data Selection: Overview  
    •	Data Selection: Where Clause  
    •	Data Selection: Where Clause Examples  
    •	Data Selection: Filter Clause  
    •	Data Selection: Filter Clause Examples  
    •	Data Selection: Range Function  
    •	Data Selection: Range Function Examples  
    •	Column Mapping: Overview  
    •	Column Mapping: Example  
    •	Column Mapping: Building History  
    •	Data Transformation Using Functions  
    •	Functions: Performing Tests on Column Values  
    •	@IF Function  
    •	Functions: Working with Dates  
    •	@Date Function  
    •	Functions: Working with Strings and Numbers  
    •	@StrCat Function  
    •	@StrExt Function  
    •	Other Functions  
    •	SQLEXEC: Overview  
    •	SQLEXEC: Basic Functionality  
    •	SQLEXEC: DBMS and Data Type Support  
    •	SQLEXEC: Usage with a LOOKUP Stored Procedure  
    •	SQLEXEC: Usage with a SQL Query  
    •	SQLEXEC: Usage in a Table or Map Statement  
    •	SQLEXEC: Usage as a Stand-Alone Statement  
    
     
    Additional Transformation Topics
     
            Objectives  
    
    •	Macros: Overview  
    •	Creating Macros  
    •	Invoking a Macro  
    •	Reusing Parameter Sets  
    •	Creating Macro Libraries  
    •	Tracing Macro Expansion  
    •	User Tokens: Overview  
    •	Environmental Values Available to @GETENV  
    •	Unauthorized reproduction or distribution prohibited  
    •	User Tokens Display  
    •	Using User Tokens  
    •	Viewing User Tokens in Log dump  
    •	User Exits: Overview  
    •	Uses for User Exits  
    •	User Exits: High-Level Processing Logic  
    •	Implementing User Exits  
    •	User Exit Parameters  
    •	Sample User Exits  
    •	Calling User Exits  
    •	Oracle Sequences: Overview  
    •	Practice 12 Overview: Data Transformation  
    
     
    Configuration Options
     
    	Objectives  
    
    •	Roadmap  
    •	BatchSQL: Overview  
    •	BatchSQL Syntax  
    •	BatchSQL Results  
    •	Compression Options  
    •	Example of Compression  
    •	Compression and Ex adata  
    •	Encryption: Overview  
    •	Message Encryption  
    •	Options: Message Encryption  
    •	Trail or Extract File Encryption  
    •	Password Encryption: Method  
    •	Event Marker System  
    •	Uses for Event Actions  
    •	Event Actions Flowchart  
    •	Event Actions Order  
    •	Unauthorized reproduction or distribution prohibited 
    •	Event Actions: Heartbeat  
    •	Event Actions: Automated Switchover  
    •	Event Actions: Automated Synchronization  
    
     
    Bidirectional Replication
     
    	Objectives  
    
    •	Roadmap  
    •	Bidirectional Flowchart  
    •	Capabilities of a Bidirectional Configuration  
    •	Bidirectional Configuration Considerations 
    •	Preventing Data Looping  
    •	Loop Detection Techniques  
    •	Conflict Avoidance and Detection and Resolution  
    •	Conflict Detection by CompareCols  
    •	GetUpdateBefores, GetBeforeCols, CompareCols, and ResolveConflict  
    •	Conflict Detection by Filter  
    •	Conflict Resolution  
    •	Conflict Resolution: Example  
    •	Conflict Resolution by Applying Net Differences  
    •	Resolve Conflict Built-in Methods  
    •	Conflict Resolution Custom Methods  
    •	Oracle Sequence Numbers  
    •	Truncate Table Operations  
    •	Overview: Configuring Bidirectional Replication  
    
     
    DDL Replication
     
    	Objectives  
    
    •	Overview of DDL Replication  
    •	DDL Replication Requirements and Restrictions  
    •	Characteristics for DDL Replication  
    •	DDL Scopes  
    •	Using Unqualified Object Names  
    •	DDL Parameter  
    •	DDL String Substitution  
    •	DDL Error Handling  
    •	DDLOptions for Oracle  
    •	Mapping Schemas  
    •	Supporting DDL in an Active-Active Bidirectional Configuration  
    •	Activating Oracle DDL Capture  
    
    • Any Graduates(B.A,B.Com,B.Sc)
    • Engineering Students(B.Tech, B.E, M.Tech)
    • BCA,MCA
    • Any Diploma Holder
    • Any Working Professionals
    • Data Warehouse Administrators
    • Database Administrators
    • Software Tester
    • Project Manager
    • MIS Support

    Oracle GoldenGate Integrated Capture/integrated Delivery

    • What is Oracle GoldenGate Integrated Capture?
    • Why it is Needed and What Additional Replication Features it Makes Possible
    • How to Prepare a Database for Integrated Capture – Creation of Users, Assignments of Roles and Privileges, etc
    • Oracle GoldenGate Integrated Capture Deployment Modes
    • Integrated Replicat/Apply Architecture
    • Integrated Replicat: How it works
    • Integrated Delivery in Detail

    Oracle Goldengate With Oracle Real Application Clusters Configuration

    • Oracle RAC, Oracle GoldenGate and Business Continuity
    • Oracle GoldenGate Used in Combination with Oracle RAC
    • Oracle GoldenGate and the Oracle Database File System (DBFS)
    • Oracle DBFS and Oracle Clusterware
    • Configuring Oracle GoldenGate using the DBFS file systems

    Oracle GoldenGate Event Marker System

    • Starting, Suspending, Stopping Processes, Performing a Transformation, Reporting Statistics, and Capturing Lag History Using the Event Marker System
    • Invoking Stored Procedures When Specific Events Occur Using SQLEXEC
    • Activating Tracing Following the Exceeding of a Data Threshold
    • Running OS Shell Commands at the Occurrence of Specific Data-Driven Events
    • Extracting Details Analysis of the TABLE, MAP, FILTER, WHERE and SQLEXEC Statements
    • Implementing Event Marker Actions on the Extraction Side and on the Delivery Side of Replication

    Data Mapping, Data Selection/Filtering and Data Transformation

    • TABLE (for Extract) and MAP (for Replicat) Options Which Allow for Data Selection
    • COLMAP and COLMATCH Options
    • Exploring Simple Filtering (Achieved Through the WHERE Clause) and Complex Filtering (Using the FILTER Clause)
    • Data Transformation Functions: Enabling Concatenation, Substitution, Case Changing, Numeric Conversion and Date Conversion
    • SQLEXEC Parameter to Invoke Stored Procedures or to Perform Native SQL Queries

    Familiarize the student with Data Conflict Avoidance Techniques

    • Set up and manage advanced deployment models, such as 3-node multi master replication configurations
    • Integrate Oracle GoldenGate with Oracle cluster configurations
    • Explain Oracle GoldenGate Advanced Configuration options
    • Describe and take advantage of the Integrated Capture feature to extract complex data types and compressed data
    • Introduce the new Integrate Replicat feature for improved data delivery
    • Configure and implement the Oracle GoldenGate Event Marker system, to enable data transformation based on event records in the transaction logs or in the trail files
    • Master Oracle GoldenGate facilities to detect and resolve data conflicts in active-to-active replication implementations
    • Perform zero-downtime database migration