Syllabus:

Chapter 1

  • Introduction to Oracle GoldenGate
  • Oracle GoldenGate supported processing methods and databases
  • Overview of the Oracle GoldenGate architecture
  • Overview of process types
  • Overview of groups
  • Overview of the Commit Sequence Number (CSN)

Chapter 2

  • Installing Oracle GoldenGate
  • Downloading Oracle GoldenGate
  • Setting ORACLE_HOME and ORACLE_SID
  • Specifying Oracle variables on UNIX and Linux systems
  • Specifying Oracle variables on Windows systems
  • Setting library paths for dynamic builds on UNIX
  • Preparing to install Oracle GoldenGate within a cluster
  • Installing as the Oracle user
  • Supported Oracle cluster storage
  • Deciding where to install Oracle GoldenGate binaries and files in the cluster
  • Installing Oracle GoldenGate on Linux and UNIX
  • Installing Oracle GoldenGate on Windows
  • Installing Oracle GoldenGate into a Windows Cluster
  • Installing the Oracle GoldenGate files
  • Specifying a custom Manager name
  • Installing Manager as a Windows service
  • Integrating Oracle GoldenGate into a cluster
  • General requirements in a cluster
  • Adding Oracle GoldenGate as a Windows cluster resource
  • Installing support for Oracle sequences

Chapter3

  • Configuring Manager and Network Communications
  • Overview of the Manager process
  • Assigning Manager a port for local communication
  • Maintaining ports for remote connections through firewalls
  • Choosing an internet protocol
  • Recommended Manager parameters
  • Creating the Manager parameter file
  • Starting Manager
  • Stopping Manager

Chapter4

  • Getting started with the Oracle GoldenGate process interfaces
  • Using the GGSCI command line interface
  • Using UNIX batch and shell scripts
  • Using Oracle GoldenGate parameter files
  • Supported characters in object names
  • Specifying object names in Oracle GoldenGate input

Chapter5

  • Using Oracle GoldenGate for live reporting
  • Overview of the reporting configuration
  • Considerations when choosing a reporting configuration
  • Creating a standard reporting configuration
  • Creating a reporting configuration with a data pump on the source system
  • Creating a reporting configuration with a data pump on an intermediary system
  • Creating a cascading reporting configuration

Chapter6

  • Using Oracle GoldenGate for realtime data distribution
  • Overview of the datadistribution configuration
  • Considerations for a datadistribution configuration
  • Creating a data distribution configuration

Chapter7

  • Configuring Oracle GoldenGate for realtime data warehousing
  • Overview of the datawarehousing configuration
  • Considerations for a data warehousing configuration
  • Creating a data warehousing configuration

Chapter8

  • Configuring Oracle GoldenGate for activeactive high availability
  • Overview of an activeactive configuration
  • Considerations for an activeactive configuration
  • Preventing data looping
  • Creating an activeactive configuration
  • Managing conflicts
  • Handling conflicts with the Oracle GoldenGate CDR feature
  • Configuring Oracle GoldenGate CDR
  • CDR example : All conflict types with USEMAX, OVERWRITE, DISCARD
  • CDR example : UPDATEROWEXISTS with USEDELTA and USEMAX
  • CRD example : UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE

Chapter9

  • Mapping and manipulating data
  • Limitations of support
  • Parameters that control mapping and data integration
  • Mapping between dissimilar databases
  • Deciding where data mapping and conversion will take place
  • Globalization considerations when mapping data
  • Mapping columns
  • Selecting rows
  • Retrieving before values
  • Selecting columns
  • Selecting and converting SQL operations
  • Using transaction history
  • Testing and transforming data
  • Using tokens

Chapter10

  • Handling Oracle GoldenGate processing errors
  • Overview of Oracle GoldenGate error handling
  • Handling Extract errors
  • Handling Replicat errors during DML operations
  • Handling Replicat errors during DDL operations
  • Handling TCP/IP errors
  • Maintaining updated error messages
  • Resolving Oracle GoldenGate errors

Chapter11

  • Associating replicated data with metadata
  • Configuring Oracle GoldenGate to assume identical metadata
  • Configuring Oracle GoldenGate to assume dissimilar metadata
  • Configuring Oracle GoldenGate to use a combination of similar and dissimilar definitions

Chapter12

  • Configuring online change synchronization
  • Overview of online change synchronization
  • Configuring change synchronization to satisfy a specific topology
  • Naming conventions for groups
  • Creating a checkpoint table
  • Creating an online Extract group
  • Creating a trail
  • Creating a parameter file for online extraction
  • Creating an online Replicat group
  • Creating a parameter file for online replication
  • Controlling online processes
  • Deleting a process group

chapter :13

  • Running an initial data load
  • Overview of initial data load methods
  • Using parallel processing in an initial load
  • Prerequisites for initial load
  • Loading data with a database utility
  • Loading data from file to Replicate
  • Loading data from file to database utility
  • Loading data with an Oracle GoldenGate direct load
  • Loading data with a direct bulk load to SQL*Loader
  • Loading data with Teradata load utilities

chapter: 14

  • Customizing Oracle GoldenGate processing
  • Overview of custom processing
  • Executing commands, stored procedures, and queries with SQLEXEC
  • Using Oracle GoldenGate macros to simplify and automate work
  • Using user exits to extend Oracle GoldenGate capabilities
  • Using the Oracle GoldenGate event marker system to raise database events

chapter:15

  • Monitoring Oracle GoldenGate processing
  • Overview of the Oracle GoldenGate monitoring tools
  • Using the information commands in GGSCI
  • Monitoring an Extract recovery
  • Monitoring lag
  • Monitoring processing volume
  • Using the error log
  • Using the process report
  • Using the discard file
  • Using the system logs
  • Reconciling time differences
  • Sending event messages to a NonStop system
  • Getting more help with monitoring and tuning

Chapter16

  • Performing administrative operations
  • Overview of administrative operations
  • Performing application patches
  • Adding process groups
  • Initializing the transaction logs
  • Shutting down the system
  • Changing database attributes
  • Changing the size of trail files

Chapter17

  • Undoing data changes with the Reverse utility
  • Overview of the Reverse utility
  • Reverse utility restrictions
  • Configuring the Reverse utility
  • Creating process groups and trails for reverse processing
  • Running the Reverse utility
  • Undoing the changes made by the Reverse utility

Oracle Oracle Real Application Clusters(RAC)

RAC components

Oracle clusterware

Background process in RAC

Database files in RAC

  1. Server parameter file
  2. Datafiles
  3. Control files
  4. Online redo log files
  5. Archived redo log files
  6. Other files

Maintaining read consistency in RAC

Cache Coherency

Cache fusion

Global Resource Directory

Mastering of resources

Lock management

Multi-instance transaction behavior

Recovery

  1. Cache recovery
  2. Transaction recovery
  3. Online block recovery

Storage Management

Disk fundamentals

  1. RAID concepts

Storage options for RAC

  1. RAW devices
  2. Clustered file system
  3. ASM
  1. Dataguard
  2. Dataguard Architecture
  3. Protection Modes
  4. Configuration Physical Standby
  5. Configuration Logical Standby
  6. Switchcover and Failover
  7. Cascaded Standby Database
  8. Oracle Database Advance Administration
  9. Automatic Storage Management
  10. ASM Architecture
  11. Configuring ASM
  12. Configuring Raw Device
  13. Configuring ASM Disks
  14. Start and Shutdown ASM
  15. Maintaining Disk groups
  16. Migrating from and to ASM ASMCMD command Line
  17. Workshop with scenariors Assessment 

Oracle Database Administration

Exploring the Oracle Database Architecture

  • Explain the Memory Structures
  • Describe the Process Structures
  • Overview of Storage Structures

Preparing the Database Environment

  • Identify the tools for Administering an Oracle Database
  • Plan an Oracle Database installation
  • Install the Oracle software by using Oracle Universal Installer (OUI)

Creating an Oracle Database

  • Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance

  • Setting database initialization parameters
  • Describe the stages of database startup and shutdown
  • Using alert log and trace files
  • Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment

  • Configure and Manage the Oracle Network
  • Using the Oracle Shared Server architecture

Managing Database Storage Structures

  • Overview of tablespace and datafiles
  • Create and manage tablespaces
  • Space management in tablespaces

Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Data and Concurrency

  • Monitor and resolve locking conflicts

Managing Undo Data

  • Overview of Undo
  • Transactions and undo data
  • Managing undo

Database Maintenance

  • Use and manage optimizer statistics
  • Use and manage Automatic Workload Repository (AWR)
  • Use advisory framework
  • Manage Alerts and Thresholds

Performance Management

  • Use Automatic Memory Management
  • Use Memory Advisors
  • Troubleshoot invalid and unusable objects

Backup and Recovery Concepts

  • Identify the types of failure that can occur in an Oracle database
  • Describe ways to tune instance recovery
  • Identify the importance of checkpoints, redo log files, and archived log files
  • Overview of flash recovery area
  • Configure ARCHIVELOG mode

Performing Database Backups

  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups, view backup reports and monitor the flash recovery area

Performing Database Recovery

  • Overview of Data Recovery Advisor
  • Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Moving Data

  • Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
  • Explain the general architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases

Configuring for Recoverability

  • Configure multiple archive log file destinations to increase availability
  • Define, apply and use a retention policy
  • Configure the Flash Recovery Area
  • Use Flash Recovery Area

Using the RMAN Recovery Catalog

  • Identify situations that require RMAN recovery catalog
  • Create and configure a recovery catalog
  • Synchronize the recovery catalog
  • Create and Use RMAN stored scripts
  • Back up the recovery catalog
  • Create and use a virtual private catalog

Configuring Backup Specifications

  • Configure backup settings
  • Allocate channels to use in backing up
  • Configure backup optimization

Using RMAN to Create Backups

  • Create image file backups
  • Create a whole database backup
  • Enable fast incremental backup
  • Create duplex backup and back up backup sets
  • Create an archival backup for long-term retention
  • Create a multisection, compressed and encrypted backup
  • Report on and maintain backups

Using RMAN to Perform Recovery

  • Perform complete recovery from a critical or noncritical data file loss using RMAN
  • Perform incomplete recovery using RMAN
  • Recover using incrementally updated backups
  • Switch to image copies for fast recovery
  • Restore a database onto a new host
  • Recover using a backup control file
  • Perform Disaster recovery

Using RMAN to Duplicate a Database

  • Creating a duplicate database
  • Using a duplicate database

Performing Tablespace Point-in-Time Recovery

  • Identify the situations that require TSPITR
  • Perform automated TSPITR

Monitoring and Tuning RMAN

  • Monitoring RMAN sessions and jobs
  • Tuning RMAN
  • Configure RMAN for Asynchronous I/O

Storage options for RAC

  • 1. RAW devices
  • 2. Clustered file system
  • 3. ASM

Chapter 1 - Retrieving Data Using the SQL SELECT Statement

  • The SELECT Statement
  • The SELECT and FROM Clauses
  • Conditions and the WHERE Clause
  • Other Conditional Operators
  • logical operators

Chapter 2 - Restricting and Sorting Data

  • The ORDER BY Clause
  • Column Aliases
  • Arithmetic Expressions
  • Precedence of Operators

Chapter 3 - Using Single-Row Functions to Customize Output

  • Function Types
  • >Using Table dual to try out Functions
  • Numeric Functions
  • Character Functions
  • String Concatenation
  • Date Arithmetic and Date Functions

Chapter 4 - Using Conversion Functions and Conditional Expressions

  • Conversion Functions
  • NVL and NVL2
  • DECODE
  • CASE Expressions
  • COALESCE and NULLIF

Chapter 5 - Reporting Aggregated Data Using the Group Functions

  • SUM()
  • COUNT()
  • MIN()
  • MAX()
  • AVG()

Chapter 6 - Displaying Data from Multiple Tables

  • Overview of Table Joins
  • Inner Joins
  • Table Aliases
  • Outer Joins
  • Self Joins
  • ANSI Standard Joins

Chapter 7 - Using Sub queries to Solve Queries

  • Overview of Subqueries
  • Simple Subqueries
  • Complex Subqueries
  • Subquery Rules
  • Using the ANY, ALL and IN Operators

Chapter 8 - Using the Set Operators

  • UNION ,UNION ALL,INTERSECT and MINUS

Chapter 9 - Manipulating Data

  • Inserting Rows
  • Updating Rows
  • >
  • Deleting Rows
  • Verifying Updates
  • >
  • Transaction Control
  • Commit and Rollback
  • Save points
  • Commits and Constraints
  • Amending Data in SQL Developer

Chapter 10 - Using DDL Statements to Create and Manage Tables

  • Creating Tables
  • Specifying Constraints
  • Altering Tables, Columns and Constraints
  • Dropping Tables, Columns and Constraints
  • Copying Tables
  • Data dictionary

Chapter 11 - Creating Other Schema Objects

  • Creating Indexes
  • Dropping Indexes
  • Listing Indexes
  • Creating and Using Views
  • Dropping Views
  • Listing Views
  • Create a Sequence
  • View Sequence Details
  • Create a Synonym
  • List Synonyms

Oracle11g content

  • Introduction to PL/SQL
  • What is PL/SQL
  • PL/SQL Environment
  • Benefits of PL/SQL
  • Overview of the Types of PL/SQL blocks
  • Create and Execute a Simple Anonymous Block
  • Generate Output from a PL/SQL Block

Declaring PL/SQL Identifiers

  • Identify the Different Types of Identifiers in a PL/SQL subprogram
  • Use the Declarative Section to Define Identifiers
  • List the Uses for Variables
  • Store Data in Variables
  • Declare PL/SQL Variables

Writing Executable Statements

  • Describe Basic Block Syntax Guidelines
  • Use Literals in PL/SQL
  • Customize Identifier Assignments with SQL Functions
  • Use Nested Blocks as Statements
  • Reference an Identifier Value in a Nested Block
  • Qualify an Identifier with a Label
  • Use Operators in PL/SQL
  • Use Proper PL/SQL Block Syntax and Guidelines

Interacting with the Oracle Server

  • Identify the SQL Statements You Can Use in PL/SQL
  • Include SELECT Statements in PL/SQL
  • Retrieve Data in PL/SQL with the SELECT Statement
  • Avoid Errors by Using Naming Conventions When Using Retrieval and DML Statements
  • Manipulate Data in the Server Using PL/SQL
  • The SQL Cursor concept
  • Use SQL Cursor Attributes to Obtain Feedback on DML
  • Save and Discard Transactions

Writing Control Structures

  • Control PL/SQL Flow of Execution
  • Conditional processing Using IF Statements
  • Conditional Processing CASE Statements
  • Handle Nulls to Avoid Common Mistakes
  • Build Boolean Conditions with Logical Operators
  • Use Iterative Control with Looping Statements

Working with Composite Data Types

  • Learn the Composite Data Types of PL/SQL Records and Tables
  • Use PL/SQL Records to Hold Multiple Values of Different Types
  • Inserting and Updating with PL/SQL Records
  • Use INDEX BY Tables to Hold Multiple Values of the Same Data Type

Using Explicit Cursors

  • Cursor FOR Loops Using Sub-queries
  • Increase the Flexibility of Cursors By Using Parameters
  • Use the FOR UPDATE Clause to Lock Rows
  • Use the WHERE CURRENT Clause to Reference the Current Row
  • Use Explicit Cursors to Process Rows
  • Explicit Cursor Attributes
  • Cursors and Records

Handling Exceptions

  • Handling Exceptions with PL/SQL
  • Predefined Exceptions
  • Trapping Non-predefined Oracle Server Errors
  • Functions that Return Information on Encountered Exceptions
  • Trapping User-Defined Exceptions
  • Propagate Exceptions
  • Use The RAISE_APPLICATION_ERROR Procedure To Report Errors To Applications

Creating Stored Procedures and Functions

  • Differences Between Anonymous Blocks and Subprograms
  • Creating and invoking Procedure
  • Creating and invoking Functions
  • Passing Parameter to the Function

Packages

  • What are packages
  • Advantages of packages
  • Examples on packages

Triggers

  • What are triggers?
  • Types of triggers.
  • Advantages of triggers.

Oracle SQL Training Syllabus

Introduction to Oracle Database

  • List the features of Oracle Database 11g
  • Discuss the basic design, theoretical, and physical aspects of a relational database
  • Categorize the different types of SQL statements
  • Describe the data set used by the course
  • Log on to the database using SQL Developer environment
  • Save queries to files and use script files in SQL Developer

Retrieve Data using the SQL SELECT Statement

  • List the capabilities of SQL SELECT statements
  • Generate a report of data from the output of a basic SELECT statement
  • Select All Columns
  • Select Specific Columns
  • Use Column Heading Defaults
  • Use Arithmetic Operators
  • Understand Operator Precedence
  • Learn the DESCRIBE command to display the table structure

Learn to Restrict and Sort Data

  • Write queries that contain a WHERE clause to limit the output retrieved
  • List the comparison operators and logical operators that are used in a WHERE clause
  • Describe the rules of precedence for comparison and logical operators
  • Use character string literals in the WHERE clause
  • Write queries that contain an ORDER BY clause to sort the output of a SELECT statement
  • Sort output in descending and ascending order

Usage of 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

Invoke 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

Aggregate Data Using the Group Functions

  • Use the aggregation functions in SELECT statements to produce meaningful reports
  • Divide the data in groups by using the GROUP BY clause
  • Exclude groups of date by using the HAVING clause

Display Data From Multiple Tables Using Joins

  • Write SELECT statements to access data from more than one table
  • View data that generally does not meet a join condition by using outer joins
  • Join a table by using a self join

Use Sub-queries to Solve Queries

  • Describe the types of problem that sub-queries can solve
  • Define sub-queries
  • List the types of sub-queries
  • Write single-row and multiple-row sub-queries

The SET Operators

  • Describe the SET operators
  • Use a SET operator to combine multiple queries into a single query
  • Control the order of rows returned

Data Manipulation Statements

  • Describe each DML statement
  • Insert rows into a table
  • Change rows in a table by the UPDATE statement
  • Delete rows from a table with the DELETE statement
  • Save and discard changes with the COMMIT and ROLLBACK statements
  • Explain read consistency

Use of DDL Statements to Create and Manage Tables

  • Categorize the main database objects
  • Review the table structure
  • List the data types available for columns
  • Create a simple table
  • Decipher how constraints can be created at table creation
  • Describe how schema objects work

Other Schema Objects

  • Create a simple and complex view
  • Retrieve data from views
  • Create, maintain, and use sequences
  • Create and maintain indexes
  • Create private and public synonyms

Control User Access

  • Differentiate system privileges from object privileges
  • Create Users
  • Grant System Privileges
  • Create and Grant Privileges to a Role
  • Change Your Password
  • Grant Object Privileges
  • How to pass on privileges?
  • Revoke Object Privileges

Management of Schema Objects

  • Add, Modify and Drop a Column
  • Add, Drop and Defer a Constraint
  • How to enable and disable a Constraint?
  • Create and Remove Indexes
  • Create a Function-Based Index
  • Perform Flashback Operations
  • Create an External Table by Using ORACLE_LOADER and by Using ORACLE_DATAPUMP
  • Query External Tables

Manage Objects with Data Dictionary Views

  • Explain the data dictionary
  • Use the Dictionary Views
  • USER_OBJECTS and ALL_OBJECTS Views
  • Table and Column Information
  • Query the dictionary views for constraint information
  • Query the dictionary views for view, sequence, index and synonym information
  • Add a comment to a table
  • Query the dictionary views for comment information

Manipulate Large Data Sets

  • Use Subqueries to Manipulate Data
  • Retrieve Data Using a Subquery as Source
  • Insert Using a Subquery as a Target
  • Usage of the WITH CHECK OPTION Keyword on DML Statements
  • List the types of Multitable INSERT Statements
  • Use Multitable INSERT Statements
  • Merge rows in a table
  • Track Changes in Data over a period of time

Data Management in Different Time Zones

  • Time Zones
  • CURRENT_DATE, CURRENT_TIMESTAMP, and LOCALTIMESTAMP
  • Compare Date and Time in a Session’s Time Zone
  • DBTIMEZONE and SESSIONTIMEZONE
  • Difference between DATE and TIMESTAMP
  • INTERVAL Data Types
  • Use EXTRACT, TZ_OFFSET and FROM_TZ
  • Invoke TO_TIMESTAMP,TO_YMINTERVAL and TO_DSINTERVAL

Retrieve Data Using Sub-queries

  • Multiple-Column Subqueries
  • Pairwise and Nonpairwise Comparison
  • Scalar Subquery Expressions
  • Solve problems with Correlated Subqueries
  • Update and Delete Rows Using Correlated Subqueries
  • The EXISTS and NOT EXISTS operators
  • Invoke the WITH clause
  • The Recursive WITH clause

Regular Expression Support

  • Use the Regular Expressions Functions and Conditions in SQL
  • Use Meta Characters with Regular Expressions
  • Perform a Basic Search using the REGEXP_LIKE function
  • Find patterns using the REGEXP_INSTR function
  • Extract Substrings using the REGEXP_SUBSTR function
  • Replace Patterns Using the REGEXP_REPLACE function
  • Usage of Sub-Expressions with Regular Expression Support
  • Implement the REGEXP_COUNT function

 

Sgraph Infotech
MSBI | DOT NET | AWS | Data Science | Python
Address :
3rd Floor, JP Royale- 90/4, Above ICICI Bank, Outer Ring Road, Opposite Radisson Blu, Marathahalli,
Bengaluru,
Karnataka - 560037
India.
Tel : 9620885025
Email : sgraphinfotech@gmail.com

OUR TRAINING COURSES

Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore

CONTACT FORM

© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap