Introduction

• Relational and Object Relational Database Management System
• Relational Database Concept
• Definition of a Relational Database
• Entity Relationship Model
• Entity Relationship Modeling Conventions
• Relational Database Terminology
• Relational Database Properties
• Communicating with a RDBMS Using SQL
• SQL Statements

Writing Basic SQL SELECT Statements

• Capabilities of SQL SELECT Statements
• Basic SELECT Statemen
• Selecting All Columns
• Selecting Specific Columns
• Writing SQL Statements
• Column Heading Defaults
• Arithmetic Expressions
• Using Arithmetic Operators
• Operator Precedence
• Using Parentheses
• Defining a Null Value
• Null Values in Arithmetic Expressions
• Defining a Column Alias
• Duplicate rows
• Displaying Table Structure

Restricting and Sorting Data

• Limiting Rows Using a Selection
• Using the WHERE Clause
• Comparison Conditions
• Using the BETWEEN Condition
• Using the IN Condition
• Using the LIKE Condition
• Using the NULL Conditions
• Logical Conditions
• Using the AND Operator
• Using the OR Operator
• Using the NOT Operator
• Rules of Precedence
• ORDER BY Clause
• Sorting in Descending Order
• Sorting by Multiple Columns

Single-Row Functions

• SQL Functions
• Two Types of SQL Functions
• Single-Row Functions
• Character Functions
• Case Manipulation Functions
• Character-Manipulation Functions
• Number Functions
• Using the ROUND Function
• Using the TRUNC Function
• Using the MOD Function
• Working with Dates
• Arithmetic Operators with Dates
• Date Functions
• General Functions
• NVL Function
• Using the NVL2 Function
• Using the COALESCE Function
• The CASE Expression
• Using the CASE Expression
• The DECODE Function

Aggregating Data Using Group Functions

• What Are Group Functions?
• Types of Group Functions
• Group Functions Syntax
• Using the AVG and SUM Functions
• Using the MIN and MAX Functions
• Using the COUNT Function
• Using the DISTINCT Keyword
• Group Functions and Null Values
• Using the NVL Function with Group Functions
• Creating Groups of Data: The GROUP BY Clause Syntax
• Using the GROUP BY Clause on Multiple Columns
• Excluding Group Results: The HAVING Clause
• Nesting Group Functions

Displaying Data from Multiple Tables (Joins)

• Obtaining Data from Multiple Tables
• Cartesian Products
• Generating a Cartesian Product
• Types of Joins
• Joining Tables Using Oracle Syntax
• What is Equi Join?
• Retrieving Records with Equijoins
• Additional Search Conditions Using the AND Operator
• Qualifying Ambiguous Column Names
• Using Table Aliases
• Joining More than Two Tables
• Non-Equijoins
• Retrieving Records with Non-Equijoins
• Outer Joins
• Outer Joins Syntax
• Using Outer Joins
• Self Joins
• Creating Joins with the USING Clause
• Retrieving Records with the USING Clause
• Creating Joins with the ON Clause
• Retrieving Records with the ON Clause
• INNER Vs OUTER JOIN

Subqueries

• Using a Subquery to Solve a Problem
• Subquery Syntax
• Guidelines for Using Subqueries
• Types of Subqueries
• Single-Row Subqueries
• Executing Single-Row Subqueries
• Using Group Functions in a Subquery
• Multiple-Row Subqueries
• Using the ANY Operator in Multiple-Row Subqueries
• Using the ALL Operator in Multiple-Row Subqueries
• Null Values in a Subquery

Manipulating Data

• Data Manipulation Language
• Adding a New Row to a Table
• The INSERT Statement Syntax
• Inserting New Rows
• Inserting Rows with Null Values
• Copying Rows from another Table
• Changing Data in a Table
• The UPDATE Statement Syntax
• Updating Rows in a Table
• Updating Two Columns with a Subquery
• DELETE statement
• Deleting Rows from a Table
• Deleting Rows Based on another Table
• Using a Subquery in an INSERT Statement
• The MERGE Statement
• The MERGE Statement Syntax
• Database Transactions
• Advantages of COMMIT and ROLLBACK Statements
• Controlling Transactions
• Rolling Back Changes
• Implicit Transaction Processing
• State of the Data before COMMIT or ROLLBACK
• State of the Data after COMMIT
• Committing Data
• State of the Data after ROLLBACK
• Locking
• Implicit Locking

Creating and Managing Tables

• Database Objects
• Naming Rules
• The CREATE TABLE Statement
• Referencing another User’s Tables
• The DEFAULT Option
• Creating Tables
• Tables in the Oracle Database
• Querying the Data Dictionary
• Creating a Table by Using a Subquery
• The ALTER TABLE Statement
• Adding a Column
• Modifying a Column
• Dropping a Column
• The SET UNUSED Option
• Dropping a Table
• Changing the Name of an Object
• Truncating a Table

Oracle Date Time Functions

• TIMESTAMP Data Type
• TIMESTAMP with Time Zone Data Type
• TIMESTAMP with Local Time Data Type

Pseudo columns

• What is Pseudocolumns?
• Rownum
• Rownum in camparison

Including Constraints

• Objectives
• What are Constraints?
• Constraint Guidelines
• Defining Constraints
• The NOT NULL Constraint
• The UNIQUE Constraint
• The PRIMARY KEY Constraint
• The FOREIGN KEY Constraint
• FOREIGN KEY Constraint Keywords
• The CHECK Constraint
• Adding a Constraint Syntax
• Dropping a Constraint
• Disabling Constraints
• Enabling Constraints
• Viewing Constraints

Sequence

• What is a Sequence?
• The CREATE SEQUENCE Statement Syntax
• Creating a Sequence
• Confirming Sequences
• NEXTVAL and CURRVAL Pseudocolumns
• Using a Sequence
• Modifying a Sequence
• Guidelines for Modifying a Sequence
• Removing a Sequence

Creating Views

• What is Database Objects
• What is a View?
• Why to use Views?
• Simple Views and Complex Views
• Creating a View
• Retrieving Data from a View
• Querying a View
• Modifying a View
• Creating a Complex View
• Rules for Performing DML Operations on a View
• Using the WITH CHECK OPTION Clause
• Denying DML Operations (With read only Option)
• Removing a View
• Inline Views

Index

• What is an Index?
• How Are Indexes Created?
• Creating an Index
• When to Create an Index
• When Not to Create an Index
• Confirming Indexes
• Removing an Index

Controlling User Access

• Objectives
• Controlling User Access
• Privileges
• System Privileges
• Creating Users
• User System Privileges
• Granting System Privileges
• What is a Role?
• Creating and Granting Privileges to a Role
• Changing Your Password
• Object Privileges
• Granting Object Privileges
• Using the WITH GRANT OPTION and PUBLIC Keywords
• How to Revoke Object Privileges
• Revoking Object Privileges

Synonyms

• What is Synonyms?
• C How Are Synonyms Created?
• Removing Synonyms

Introduction

• Introduction to PL/SQL
• PL/SQL Execution Environment
• PL/SQL Development Environment
• Introduction to PL/SQL Procedures
• Introduction to PL/SQL Functions
• Introduction to PL/SQL Packages
• Introduction to PL/SQL Triggers
• Coding PL/SQL
• The correct structure of a PL/SQL program block
• Declare and initialize a variable
• Declare and initialize data types and Boolean variables

Decision Making

• IF Statement
• IF-ELSIF Statements

Loops

• Implement suitable control structures in PL/SQL
• Implement a suitable loop construct in PL/SQL for a given scenario
• Characteristics of FOR and nested loops in PL/SQL
• Implementation of WHILE LOOP
• Implementation of DO WHILE LOOP
• EXIT Keyword
• GOTO Statement

Sub Blocks

• What is Sub Block?
• Sub Blocks implementation
• Modular Programming
• Create and populate a user-defined record in PL/SQL
• Create a record using the %ROWTYPE attribute and use it to insert and update a row
• Create a record and use it to update a table

Cursors

• What is Cursor?
• Cursor Types
• Implicit Cursor
• Use explicit cursors to retrieve data
• Cursor attributes
• For Loop Cursors
• Advantages of For Loop Cursors
• Default values in cursors
• Use parameters to make cursors reusable in a given scenario
• Use an explicit cursor to retrieve and update data

Exceptions

• What is Exception?
• Exception Section
• About The Exception Section
• Isolating the Specific Exception
• Outline how each of the PL/SQL exception types are raised and handled
• Trap predefined and non-predefined exceptions in PL/SQL
• Trap user-defined exceptions and identify error codes and messages
• Use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL
• Handle exceptions in PL/SQL
• Pragma Exception_Init
• SQLcode & SQLerrm Example
• SQL%Rowcount

Stored Procedures

• Create, remove, and view PL/SQL stored procedures
• Use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs
• Outline how to view values returned by OUT parameters
• Create stored procedures with suitable parameters
• Assign values to multiple parameters
• Handle exceptions in stored procedures

Stored Functions

• Create a stored function
• Execute a stored function
• Call, remove, and view stored functions in PL/SQL

Managing Subprograms

• Definer Rights
• Invoker rights
• List all Procedures and Functions

Packages

• Identify features of PL/SQL packages
• Sequence steps for developing PL/SQL packages
• Identify the syntax for creating a PL/SQL package
• Identify tasks involved in managing PL/SQL packages
• Identify features of the overloaded subprograms contained in PL/SQL packages
• Identify features of forward referencing in PL/SQL packages

Managing LOBs

• Identify features of the DBMS_LOB package
• Identify the code to work with Large Object (LOB) values
• Identify methods of selecting Character Large Object (CLOB) values
• Identify features of temporary Large Objects (LOBs)

Triggers

• Identify features of Triggers
• Identify the code to create a Data Manipulation Language (DML) trigger
• Identify the code to create a Data Manipulation Language (DML) row Trigger
• Match the options for managing triggers with their descriptions
• Identify guidelines for testing triggers
• Identify the benefits of triggers in different business application scenarios
• Identify the syntax for creating triggers for DDL and system events

Advanced Triggers

• Creating Trigger on DDL Statements
• LOGON & LOGOFF Trigger Example
• CALL Statement in Trigger
• Advantages of trigger
• Conditional Security

Introduction

• Objectives
• Understand Oracle Architecture
• Create / Manage Database
• Optimization of Database
• Disaster Management
• Duties & Responsibilities of DBA
• Installation of Oracle Server & Application Tools
• Allocation of Space and sizing storage requirements
• Creation of Primary Database & Schema Objects
• Modification of Database structure
• Creating /maintaining of user
• Performance Tuning
• Backup & recovery

Oracle Architecture

• Optimal Flexible Architecture (OFA) complaint
• Standard Architecture
• Oracle Instance
• Oracle Database
• Single Process
• Multi-Process
• Database Structure
• Logical (Tablespace, Segments, Extents, Schema Objects)
• Physical (Control file, Data file, Redo log files)
• Roll back segments
• Transaction Management
• Data Dictionary

Hardware Considerations

• Stand alone host
• Multiple Databases
• Networked Host
• Clustered Servers

Startup & Shutdown

• Invoking SVRMGRL
• Startup
• Start the Instance
• Mount The Database
• Open the Database
• Shutdown
• Normal
• Immediate
• Transactional
• Abort
• Alter Database
• Enable Restricted Session
• Parameter file

Database Storage

• Tablespaces & Datafiles
• Managing Tablespaces
• Managing / Sizing Schema Objects
• Managing Datafiles
• Allocation of Space
• Segments
• Extents
• Database Blocks
• Index
• Temporary
• Rollback
• Tables
• Views
• Indexes
• Partitioning of tables & Indexes
• Snapshots
• Sequences
• Synonyms
• Database Links

Creating & Customising The Database

• Create a Database
• Determine Instance
• Copy & Edit Parameter Settings
• Start the Instance
• Connect the Instance
• Physically Create the Database
• Add Control File
• Multiplexing Control files
• Add Redo log Members
• Multiplexing Redo log Members
• Data dictionary users
• Display Data Dictionary Views
• Rollback segments
• Create rollback segments
• Alter Rollback segments
• Guidelines for Managing RBS
• Managing Locks
• Types of Locks
• Table Locks
• Dictionary Locks
• Dead Lock Detection
• Monitor locking Activity

Create And Manage Database User / Enterprise Manager

• Create User
• Alter User
• Drop User
• Monitor User
• Profiles
• Create Profile
• Alter Profile
• Drop Profile
• Managing database security for Users
• User Authentication

Managing Privileges And Roles Command Line & Enterprise Manager

• Types of Privileges
• Different Roles
• Default Roles
• Dropping Roles
• Changing Default Roles
• Granting System Privileges & roles
• Granting object Privileges
• Revoke system Privileges & roles
• Revoking Object Privileges
• Cascading effects
• Listing Privileges & Role Information

Performance Tuning

• SQL Tuning
• Memory Tuning
• SGA
• Library Cache
• Dictionary Cache
• Redo log Buffer Cache
• I/O Tuning
• Disk Contention
• Space in data block
• Trace files & Alert Files
• Contention for Rollback segments
• Tune free lists
• Tune Checkpoints
• SQL Trace facility & TKPROF Utility
  1. Multiple Database/ Distributed Database Management
  2. Database Auditing & Security
  3. NET8

OFA Complaint Backup & Recovery

• Operating System Backups (Cold Backups)
• Online Backup (Hot Backups)
• Recovery Structure
• Archive Modes
• Change Archive Modes
• Enable Archive Processing
• Archive Log Files
• Database Errors
• Recovers from User error
• Recovery from Statement Failures
• Recover from Instance failure
• Recovery from Media Failure
• Recovery with Archiving
• Recovery Without Archiving
• Disable Archive Processing
• Backup Control file
• Recover a Control file
• Legato Storage Manager
• Recovery Manager (RMAN)

Server Utilities

• Export
• Export Basics
• Export Parameters
• Incremental Export
• Cumulative Export
• Complete Export
• Import
• Import basics
• Import modes
• Import Parameters
• Incremental Import
• Cumulative Import
• Complete Import
• SQL*Loader
• Basics
• Direct path Loads
• Conventional Path Loads
• Logging information
• Control file
• Data file
• Discard File
• Bad file
• Case Studies
  1. Monitoring Common Problem Areas & Useful DBA Scripts
  2. Oracle Standard Installation
  3. Oracle (OFA) Installation
  4. Oracle Database Connectivity With Front Ends

Oracle E-Business Suite Overview

• Oracle E-Business Suite Home Page
• Oracle E-Business Suite Architecture
• Oracle E-Business Suite Technology Stack
• Installation Tools
• Oracle E-Business Suite Products

Preparing For Your Installation

• Overview of Rapid Install
• Supported Platforms and Environments
• Prerequisites and Preparatory Tasks
• Starting Rapid Install
• Obtaining Help

Performing an Installation

• Installation Types and Options
• Standard Installation
• Express Installation

Finishing Your Installation

• Required Post-Installation Steps
• Conditional Post-Installation Steps
• Administration and Maintenance Tasks

Oracle E-Business Suite Components

• Oracle E-Business Suite Technology Stack
• Desktop Tier
• Application Tier
• Database Tier
• Oracle E-Business Suite Technology Layer
• Oracle Applications DBA
• Oracle Application Object Library
• Oracle E-Business Suite Utilities

Environment Files, Control Scripts, and Languages

• Oracle E-Business Suite Environment Files
• Application Tier Service Control Scripts
• Character Sets
• Globalization Features
• Language Support

Oracle E-Business Suite File System

• File System Overview
• INST_TOP Directory Structure
• Database Tier File System
• Application Tier File System
• APPL_TOP Directory Structure
• Product Directories
• Technology Stack Directory
• Database Directories

Oracle E-Business Suite Database

• Database Overview
• Oracle E-Business Suite Database Objects and Schemas
• Implementing Multiple Organizations
• Reporting Currencies
• Monitoring Features
• Performance Features
• Scalability Features
• Database Tier Server Control Scripts

Advanced Configuration Options

• Shared Application Tier File System
• Load Balancing
• Network Features

Using the AD Utilities

• Overview
• Setting the Environment
• The AD Utilities
• Command Line Arguments and Flags
• AD Utilities Features and Prompts
• Parallel Processing Options and Distributed AD
• Log and Restart Files
• Maintenance Mode

AD Administration: Generate Applications Files Tasks

• Preliminary Tasks
• Prompts and Log Files
• Generate Applications Files Menu
• Generate Message Files
• Generate Form Files
• Generate Report Files
• Generate Product JAR Files

AD Administration: Maintain Applications Files Tasks

• Maintain Applications Files Menu
• Relink Applications Programs
• Copy Files to Destinations
• Convert Character Set
• Maintain Snapshot Information
• Checking for Missing Files
• Performing File System Tasks

AD Administration: Compile/Reload Database Entities Tasks

• Compile/Reload Database Entities Menu
• Compile APPS Schema
• Compile Menu Information
• Compiling Flexfield Data in AOL Tables
• Reloading JAR Files into Database

Special Utilities

• AD Controller Overview
• Worker Status Flow
• Restarting an AD Utility
• Shutting Down Managers
• AD Relink Overview
• Running AD Relink

AutoConfig

• AutoConfig Overview
• Context Files
• AutoConfig Tasks
• Running AutoConfig
• AutoConfig Log Files
• Rolling Back an AutoConfig Session
• Running AutoConfig in Test Mode
• Other AutoConfig Features

License Manager

• AD Configuration
• AD File Identification
• AD Job Timing Report

Configuration Utilities

• AD Splicer Overview
• AD Splicer Control Files
• Editing newprods.txt File
• Post-Splice Steps
• File Character Set Converter

Patching and the AutoPatch Process

• Patch Terminology and Components
• Downloading Patches
• AutoPatch Features
• Patch Wizard
• Running AutoPatch
• OAM Timing Reports
• Other Patching Topics
• Applied Patches Information

Cloning Oracle E-Business Suite

• Principles and Terminology
• Cloning Scenarios
• Prerequisite Steps
• Cloning Steps
• Finishing Tasks
• Refresh a Target System
• Clone a Multi-Node System
• Add a Node to an Existing System

Oracle 12c R2 Grid Infrastructure Concepts

• What is a Cluster
• Grid Foundation Components
• Oracle Clusterware Architecture
• Oracle Clusterware Software and Storage
• Describe ASM Architecture
• Creating and Managing ASM Disk Groups
• Creating and Managing ASM Cluster File systems
• Administering Oracle Clusterware
• Troubleshooting Oracle Clusterware

Grid Infrastructure Installation and Configuration

• Hardware Requirements
• Network Requirements
• Software Requirements
• DNS and DHCP Configuration
• Grid Plug and Play Considerations
• Single Client Access Names
• Post installation tasks

Oracle Automatic Storage Management concepts

• ASM Instance
• ASM Disks
• ASM Disk Groups
• ASM Redundancy

Cluster installation Prerequisite for Oracle 12c R2 RAC

• Linux OS Software Installation
• Create OS Group and User Accounts
• Networking
• Synchronizing the Time on ALL Nodes
• Configuring Kernel Parameters
• Set shell limits for the oracle & grid user
• Create the Oracle Inventory Directory
• Creating the Oracle Grid Infrastructure Home Directory
• Creating the Oracle Base Directory
• Creating the Oracle RDBMS Home Directory
• Stage the Oracle Software
• Check OS Software Requirements
• Cluster Verification Utility

Shared Storage Configuration

• Types of Shared Storage
• Partition the Shared Disks
• Installing and Configuring ASMLib
• Using ASMLib to Mark the Shared Disks as Candidate Disks

Oracle 12c Grid Infrastructure Installation

• Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)…
• Grid Infrastructure Home Patching
• RDBMS Software Install
• Run ASMCA to create disk groups

Oracle 12c R2 RAC Database Software Installation

• Installing The Oracle Database Software
• Creating A Cluster Database
• Post database Creation Tasks

Administering Oracle Clusterware

• Managing Clusterware with Enterprise Manager
• Determining the Location of the Oracle Clusterware Configuration Files
• Backing Up and Recovering the Voting Disk
• Adding, Deleting, or Migrating Voting Disks
• Locating the OCR Automatic Backups
• Oracle Local Registry
• Migrating OCR Locations to ASM
• Managing Network Settings
• Managing Oracle Clusterware

Administering ASM Instances

• ASM Initialization Parameters
• Adjusting ASM Instance Parameters in SPFILEs
• Starting and Stopping ASM Instances Using srvctl
• Starting and Stopping ASM Instances Using ASMCA and ASMCMD
• Starting and Stopping ASM Instances Containing Cluster Files
• Starting and Stopping the ASM Listener
• Administering ASM Disk Groups
• Creating and Deleting ASM Disk Groups
• ASM Disk Group Attributes
• ASM Disk Group Maintenance Tasks
• Viewing ASM Disk Statistics

Prerequisite Steps for Extending a Cluster

• Using addNode.sh to add a Node to a Cluster
• Rolling Patches and Rolling Upgrades
• Installing a Patchset with the OUI Utility
• Installing a Patch With The opatch Utility

Cluster Node Management

• Add/Deleting the Instance
• Add the Node
• Remove the Node
• Single-Instance Conversion Using rconfig
• Single-Instance Conversion Using DBCA

Troubleshooting Oracle Clusterware

• Oracle Clusterware Log Files
• Gathering Log Files Using diagcollection.pl
• Component-level Debugging
• RAC-Specific Wait Events, Global Enqueues, and System Statistic
• Implementing the Most Common RAC Tuning Tips
• Using the Cluster Database Performance Pages
• Using the Automatic Workload Repository in RAC
• Using Automatic Database Diagnostic Monitor in RAC

Introduction to Oracle OSB

• Overview of service-oriented architecture (SOA)
• Overview XML, XSD, WSDL, Webservices
• Why is OSB?
• Introducing the Service Oriented Architecture
• Describing the Oracle Service Bus Architecture
• Introducing the Role of Oracle Service Bus

Installations

• Overview of weblogic server
• Overview of OSB server and meta data schemas
• Creating domain in weblogic server.
• Install OSB Server
• Overview of start and stop steps of OSB server and Admin Server.

OSB Concepts

• Business Service
• Proxy Service
• Message Flow
• Resources of OSB
• Change Centre in OSB
• Export and Import of OSB Coding
• How to create and use of Customization file in OSB

Message Flow

• Introducing the Oracle Service Bus Resources
• Explaining the Message Context Model and the Message Context Variables
• Understanding the Message Flow and the Nodes/Elements of a Message Flow

Message Flow Actions

• Describing the Communication Actions You Can Add to a Route or a Stage in a Message Flow
• Describing the Flow Control Action You Can Add to a Route or a Stage in a Message Flow
• Describing the Message Processing Actions You Can Add to a Stage in a Message Flow
• Describing the Reporting Actions You Can Add to a Stage in a Message Flow
• Using XQuery Mapping and Transformations

Transports in Oracle Service Bus

• Describing Oracle SOA Suite Transport (SOA-DIRECT)
• How to Import XSD/WSDL
• How to Create Business service using other WS
• Describing JCA Transport

Debugging with Oracle Service Bus

• Describing and Configuring Error Handling in Oracle Service Bus
• Configuring Validation in Oracle Service Bus
• Explaining the Usage of the Reporting Action

Introducing Oracle Fusion Middleware Platform

• Intro about Web logic Server
• What is an application server
• Middleware
• J2EE Technologies
• Web & WLS Terms

Setting up a Web logic Server Environment

• Web Logic Server Architecture
• Download of WebLogic
• Installing of Web Logic Server 11g (GUI /Console /Silent) on both Windows/Linux
• Starting and Stopping Web Logic Server
• Various types of Start/Stop of Servers

Configure a Web Logic Server Environment

• Intro about Admin, Managed Servers, Domain, Machine and Node Manager
• Configuring Admin Servers
• Configuring Managed Servers
• Configuring Node Manager
• Configuring of Machine
• Console Administration
• Command Line Administration
• Configuration of Domain using Dev and Prod Mode
• Difference between Dev and Prod Mode of Domain

Introduction to Clustering

• The Benefits of Oracle WebLogic Cluster
• Types of Cluster (Vertical/Horizontal)
• Configuring Vertical / Horizontal Cluster
• Communication Among Clustered Server Instances
• The Key Criteria for Selecting Suitable Cluster Architecture

Configuring a Cluster

• Preparing Your Environment for a Cluster
• Creating and Configuring a Cluster for Vertical / Horizontal.
• Adding Servers to a Cluster
• Starting Up and Shutting Down Clustered Servers.

Web logic Configuring Resources

• Finding Weblogic Sever Version
• PassBasis Commands
• What is Classpath? How to set Classpath in WebLogic
• Importance of setWLSEnv/setDomainEnv.sh file
• Importance of config.xml file
• Importance of boot.properties file
• Importance of nodemanger.properties file
• Monitoring and handling of Servers, Domains
• Enabling of Administration Port
• Virtual Host

Deploying Applications

• Overview of Deployment
• Various types of Deployment
• Java Applications
• Web Applications
• Advanced Deployment

Understanding JNDI and Setting up JDBC

• Introduction to JNDI
• Overview of JDBC
• Data Sources
• Types of Data Sources (Generic/GridLink/Multi)
• Configuration of Data Sources
• Administration of Data Sources
• Explaining the Components of JDBC URLs
• Monitoring and Testing a Data Source
• Overview of Transactions (XA and Non-XA)

Setting Up Java Message Service (JMS) Resources

• Describing JMS
• Describing How Oracle WebLogic Server JMS is Implemented
• Configuring JMS Server
• Configuring Connection Factories
• Configuring Queues and Topics
• Configuring Persistent Messages
• Deploying an Application that Uses JMS
• Monitoring JMS Resources and Messages

Security Concepts and Configuration

• Over view of Security Realms
• Configuring Users and Groups
• Admin Server Password Reset
• Build

Monitoring and log file handling Logs

• Overview of Log Management
• Various Types of Log File for Trouble Shooting
• Server Log and access logs
• Log Management
• Rotation/Archiving/ log files
• Troubleshooting issues in WebLogic

Performance Tuning and WebLogic Web Container

• The JVM
• Memory Management
• Garbage Collection Mechanism
• GC Performance Improvements
• Heap Management
• Thread Management
• Thread / heap Dump
• Oracle Patching /Upgrade
• Backup Plan in Web logic

WebLogic Scripting Tool

• Introduction to WLST
• Modes
• Script Generation
• Script Recording

Introduction to Oracle SOA Suite

• Overview of service-oriented architecture (SOA)
• Overview XML, XSD, WSDL, Web services
• Why is SOA?
• What is SCA?

Installations

• Overview of weblogic server
• Overview of SOA server and meta data schemas
• Creating domain in weblogic server.
• Install SOA Server
• Overview of start and stop steps of SOA server and Admin Server.

Interaction Patterns

• Synchronous Pattern
• Asynchronous pattern
• One way invoke

SCA Architecture

• Define a composite application
• Describe SOA Composite Editor
• Explain Component Type Files.

SOA Composite Build and Deploy

• Explain SOA composite.
• Lab
• Understand BPEL designer (JDeveloper) and activities
• Creating your first BPEL Process – HelloWorld
• Xpath Expression Builder
• Deploying the SOA Composite application.
• Managing Deployments/Un-Deployments with Enterprise Manager 11g

Build of Synchronous and Asynchronous Services

• Orchestrating Services with BPEL for Synchronous, Asynchronous and One-way Service
• Overview of Partner Link. Why do we need myRole-PartnerRole concept
• Lab
• Create a synchronous process
• Create an asynchronous process
• Create One-way

Transformation Services

• XSLT mapping tool
• XSLT map Testing and analysing at design time

Parallel processing and Conditional branching

• Understanding activities XSL, Switch, flow and While.
• Lab
• Processing with Parallel Flows
• Using Flown activity
• Conditional Branching

Exploring Pick activity and OnAlarm branch

• Lab
• Develop BPEL process to use pick(Receive inputs from Multiple Operations)
• Develop BPEL process that can time out a call to an Async process, using OnAlarm branch

Adapters Concepts

• Understanding File, Database and JMS Adapter
• Lab
• Read and write a file using file adapter
• Poll for new rows in a table using DB adapter
• Insert data into JMS queue using JMS adapter

Mediators

• Working with Mediator Components
• Explain the Mediator component and its features
• Parallel Flows and sequential flows.
• Lab
• Creating a Mediator Component
• Adding Routing Rules
• Create XSL Transformations with XSLT Mapper
• Create Content Based Routing filters

Human Workflow and work list application

• Human Workflow Service Concepts
• Features of workflow service
• Lab
• Sending an approval notification
• Modeling workflows

Business Rules

• Introduction to Business Rules.
• Introduction to Decision tables
• Lab
• Using Business Rules and Decision tables in BPEL

Fault Handling and Exception Management

• Explain Fault Types
• System faults
• Business faults
• Process based Fault handling
• Policy based fault handling
• Lab
• Using Throw activity to throw faults
• Using Fault Handler to handle faults
• Compensation handler
• Using policy files

Introduction to Oracle Applications and OAF

• Oracle Applications Framework
• OAF and MVC
• OAF Process Flow
• More about OAF

JDeveloper Overview

• JDeveloper Features
• Building OAF Application in JDeveloper
• Configuring JDeveloper Preferences

Basics of the Model

• Understand the basics of BC4J
• Understand an Entity Object
• Understand a View Object
• Understand an Application Module

Basics of the View

• Understand the terminology
• Building a basic OA Framework page
• List of Values
• Building Search Regions

Debugging OA Framework Applications

• Using JDeveloper debugger
• Examine Runtime variables and arguments
• Modify Runtime variables and arguments

Basics of the Controller

• Understanding OA Framework Controller
• Enhance an OA Framework page
• OA Framework : Message Dictionary

OA Framework Event Flows

• Initial Setup Flow
• Controller Event Flows
• Request Flow (GET)
• Submit Flow (POST)

Naming Conventions and Standards

• General Naming Rules
• Package Naming
• Page and Region Naming
• Item Naming

Error Handling

• Exception types and Classes
• Bundled exceptions
• Dialog pages
• Debugging messages

Implementing Business Logic

• Client Validations
• Required values and Data types
• Server Validations
• Entity object and View object validations

Partial Page Rendering

• Using Auto Submit
• Using Partial Submit
• Trigger and Target Components
• Implementing Partial Page Rendering

OA Framework State Management

• OA Framework State Caches
• Passivation
• “Back” button support

OA Framework Extension

• Types of Extension
• Overriding Default Values
• Override Attribute Validation

OA Framework Performance Tuning

• BC4J and JDBC Guidelines
• SQL Tracing
• Monitor Connection Pool
• OA Framework Performance Standards

Application Menus and Function Security

• OA Framework page menus
• Registering functions for OA Framework pages
• Creating Responsibilities and Users
• Using JSP test page

Implementing Internationalization

• Date and Timezone Internationalization
• Number and Currency Internationalization
• Testing Internationalization

Deploying OA Framework Applications

• Creating Deployment Profiles
• Deploying Model
• Deploying View and Controller

Introducing Oracle Forms Developer and Forms Services

• Grid Computing
• Oracle 10g Products
• Oracle Application Server 10g Architecture
• Benefits and Components of Oracle Developer Suite 10g
• Running a Forms Developer Application
• Working in the Forms Developer Environment

Creating Forms Modules

• Creating a Basic Forms Module
• Creating a Master-Detail Forms Module
• Modifying the Data Block
• Modifying the Layout

Working with Data Blocks and Frames

• Using the Property Palette
• Managing Object Properties
• Creating and Using Visual Attributes
• Controlling the Behavior and Appearance of Data Blocks
• Controlling Frame Properties
• Creating Control Blocks
• Deleting Data Blocks

Working with Input Items

• Creating Text Items
• Controlling the Behavior and Appearance of Text Items
• Creating LOVs
• Defining Editors
• Creating Check Boxes
• Creating List Items
• Creating Radio Groups

Working with Non Input Items

• Creating a Display Item
• Creating an Image Item
• Creating a Push Button
• Creating a Calculated Item
• Creating a Hierarchical Tree Item
• Creating a Bean Area Item

Working with Windows and Canvases

• Overview of Windows and Canvases
• Displaying a Forms Module in Multiple Windows
• Creating a New Window
• Displaying a Forms Module on Multiple Layouts
• Creating a New Content Canvas
• Creating a New Stacked Canvas
• Creating a New Toolbar Canvas
• Creating a New Tab Canvas

Producing Triggers

• Grouping Triggers into Categories
• Defining Trigger Components: Type, Code, and Scope
• Specifying Execution Hierarchy
• Using the PL/SQL Editor
• Writing Trigger Code
• Using Variables and Built-ins
• Using the When-Button-Pressed and When-Window-Closed Triggers

Debugging Triggers

• The Debugging Process
• The Debug Console
• Setting Breakpoints
• Debugging Tips
• Running a Form in Debug Mode
• Stepping through Code

Adding Functionality to Items

• Coding Item Interaction Triggers
• Defining Functionality for Check Boxes
• Changing List Items at Run Time
• Displaying LOVs from Buttons
• Populating Image Items
• Populating and Displaying Hierarchical Trees
• Interacting with JavaBeans

Run-Time Messages and Alerts

• Built-ins and Handling Errors
• Controlling System Messages
• The FORM_TRIGGER_FAILURE Exception
• Using Triggers to Intercept System Messages
• Creating and Controlling Alerts
• Handling Server Errors

Query Triggers

• SELECT Statements Issued During Query Processing
• WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
• Writing Query Triggers
• Query Array Processing
• Coding Triggers for Enter-Query Mode
• Overriding Default Query Processing
• Obtaining Query Information at Run Time

Validation

• Validation Process
• Controlling Validation Using Properties
• Controlling Validation Using Triggers
• Performing Client-Side Validation with PJCs
• Tracking Validation Status
• Using Built-ins to Control When Validation Occurs

Navigation

• Navigation Overview
• Understanding Internal Navigation
• Using Object Properties to Control Navigation
• Writing Navigation Triggers: When-New

OA Framework Performance Tuning

• BC4J and JDBC Guidelines
• SQL Tracing
• Monitor Connection Pool
• OA Framework Performance Standards

Application Menus and Function Security

• OA Framework page menus
• Registering functions for OA Framework pages
• Creating Responsibilities and Users
• Using JSP test page

Implementing Internationalization

• Date and Timezone Internationalization
• Number and Currency Internationalization
• Testing Internationalization

Deploying OA Framework Applications

• Creating Deployment Profiles
• Deploying Model
• Deploying View and Controller

Introducing Oracle Forms Developer and Forms Services

• Grid Computing
• Oracle 10g Products
• Oracle Application Server 10g Architecture
• Benefits and Components of Oracle Developer Suite 10g
• Running a Forms Developer Application
• Working in the Forms Developer Environment

Introduction to Oracle Reports Developer

• Business Intelligence
• Enterprise Reporting
• Oracle Reports Developer
• Oracle Database 10g
• Oracle Developer Suite 10g
• Oracle Application Server 10g
• OracleAS Reports Services
• OracleAS Reports Services Architecture for the Web

Designing and Running Reports

• Understanding User Requirements
• Designing Reports
• Tabular
• Master-Detail
• Master with Two Details
• Matrix
• Retrieving and Sharing Data
• Running a Report

Working in Oracle Reports Developer

• Reports Developer Executables
• Invoking Reports Builder
• Reports Builder Modules
• Report Data and Layout
• Reports Builder Components
• Object Navigator
• Report-Level Objects
• Data Model Objects

Creating a Paper Report

• Report Module Components
• Building a Paper Report
• Viewing the Paper Report Output
• Saving the Report Definition
• Reentering the Wizard
• Creating Break Reports
• Break Report Labels
• Creating Mailing Labels and Letters

Enhancing a Basic Paper Report

• What Is the Paper Design?
• The Paper Design Window
• Modifying a Report
• Aligning Columns
• Setting a Format Mask
• Manipulating Objects
• Modifying Visual Attributes
• Applying Conditional Formatting

Managing Report Templates

• Using Report Templates
• Modifying a Template
• Customizing the Template Margin
• Adding Web Links to a Template for Report HTML Output
• Predefining Your Own Templates
• Adding a Template Preview Image

Creating a Web Report

• What Is JSP Technology?
• JSP Advantages
• Simple JSP Example
• Building a Web Report
• Using the Report Wizard
• Report Editor: Web Source View
• JSP Tags
• Web Source Example

Enhancing Reports Using the Data Model: Queries and Group

• The Data Model Objects
• Modifying Properties of a Query
• Applying Changes
• Changing the Group Structure
• Group Hierarchy
• Ordering Data in a Group
• Query Modifications
• Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources

• Data Source Types
• Pluggable Data Sources
• Using XML as a Data Source
• Document Type Definition File
• OLAP Data Source
• Using Text as a Data Source
• Using JDBC as a Data Source
• Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns

• Data Model Columns
• Maintaining Data Source Columns
• Producing File Content Output
• Creating a Column
• Creating Summary Columns
• Displaying Subtotals
• Displaying Percentages
• Creating a Formula Column

Enhancing Reports Using the Paper Layout

• Viewing the Paper Layout
• Designing Multi-panel Report
• Printing Multi-panel Reports
• Different Objects in the Paper Layouts
• The Paper Layout Layers
• Report Processing
• Paper Layout Tools
• Report Bursting

Controlling the Paper Layout: Common Properties

• Modifying Paper Layout Object Properties
• Common Layout Properties
• Sizing Objects
• Anchors
• Layout Object Relationships
• Pagination Icons in the Paper Layout
• Controlling Print Frequency
• Using Format Triggers

Controlling the Paper Layout: Specific Properties

• Properties of a Repeating Frame
• Specifying Print Direction
• Controlling the Number of Records per Page
• Controlling Spacing Between Records
• Minimum Widow Records
• System Variables
• Valid Source Columns
• Displaying File Contents

Web Reporting

• Comparing Static and Dynamic Reporting
• Adding Dynamic Content
• Creating a Report Block
• Invoking the Report Block Wizard
• Examining the Web Source Code
• rw:foreach Tag
• rw:field Tag
• Customizing Reports JSPs

Extending Functionality Using XML

• Why Use XML Report Definitions?
• Creating XML Report Definitions
• Partial Report Definitions: Format Modification Example
• Partial Report Definitions: Format Exception Example
• Full Report Definition: Data Model Modification Example
• Running XML Report Definitions
• Debugging XML Report Definitions

Creating and Using Report Parameters

• Creating User Parameters
• Referencing Parameters in a Report Query
• Using Bind References
• Using Lexical References
• Hints and Tips When Referencing Parameters
• Creating a List of Values
• Referencing System Parameters
• Building a Paper Parameter Form

Embedding a Graph in a Report

• Adding a Graph to a Paper Report
• Adding a Graph to a Web Report
• Selecting the Graph Type
• Selecting the Graph Data
• Adding Options to the Graph
• Customizing Web Graphs
• The rw:graph Tag
• Customizing Graphs Using the Graph.XML File

Enhancing Matrix Reports

• The Matrix Data Model
• The Matrix Paper Layout
• Creating Matrix Summaries
• Creating the Matrix Manually
• The Matrix with Group Data Model
• The Matrix with Group Layout
• Building a Nested Matrix
• Nested Matrix Paper Layout

Coding PL/SQL Triggers

• Types of Triggers in Reports
• Trigger Code
• Using Report Triggers
• Using Data Model Triggers: PL/SQL Group Filter
• Using Data Model Triggers: Parameter Validation
• Using Layout Triggers
• Using Format Triggers
• Event-Based Reporting

Extending Functionality Using the SRW Package

• Contents of the SRW Package
• Outputting Messages
• Executing a Nested Report
• Restricting Data
• Initializing Fields
• Creating a Table of Contents
• Performing DDL Statements
• Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services

• Running Reports Using OracleAS Reports Services
• Report Request Methods
• Oracle Application Server Components
• Enabling Single Sign-On Access
• Running the Web Layout: JSP Run-time Architecture
• Running the Paper Layout: Servlet Run-time Architecture
• Running a Paper Report on the Web
• Queue Manager

Building Reports: Efficiency Guidelines

• Tuning Reports
• Performance Measurement
• Non SQL Data Sources
• Investigating the Data Model
• Investigating the Paper Layout
• Running the Report
• Different Development and Run-Time Environments
• Developing Reports to Run in Different GUIs

Introduction to Oracle Applications

• Role of Technical Consultant
• Architecture
• Architecture of Oracle Application Package
• Product Directory Structures
• Users
• Responsibilities
• Role of Apps Database User
• File Objects in Oracle Applications
• Database objects in Oracle Applications
• Profile Options
• Registration
• Table Registration
• Table Registration using AD_DD package
• View Registration
• Sequence Registration
• New Application/New Module Development
• Form Registration
• Form Functions
• Non-Form Functions
• Basic Report Registration
• Parametric Report Registration
• Registration of SQL*Plus files
• Registration of SQL*Loader files
• Report Development
• Customization of Reports – Adding DFF Info
• Customization of Reports – Removing Parameter s
• Flexfield Report with Single Structure
• Interface Development
• Interface Scenarios
• Usage of Standard Import Programs
• Daily Rates Import
• GL_Interface
• Up-gradation
• Forms Up-gradation
• Reports Up-gradation
• Menus Up-gradation
• XML Publisher
• Introduction
• Generating XML File through Report Builder
• Creating a Template
• Generating RTF Output
• Register XML Report in APPS
• Discoverer Administration Edition
• Creating a private end user layer for a new tutorial
• database user
• Connecting to discoverer administrator , using the load
• wizard and the work area
• Modifying the Business Area
• Working with Custom Folders
• Creating Joins
• Customizing Items
• Designing a complex Folder
• Working with Hier archies
• Form Development Process
• Template Form Architecture
• Appsstand Architecture
• FNDMENU Architecture
• Coding Standards
• Name Conventions
• Form Development Process
• WHO Information Tracking
• Row LOV
• Queries find Window
• Customization of Forms
• Programming of Non-Form Functions
• Calendar s
• Flexfields
• Introduction to Key and Descriptive Flexfields
• Enabling a DFF
• DFF Registration
• KFF Registration
• Define a KFF Flexfields Structure
• Invoking DFF form of New Form
• Invoking KFF Form of New Form
• Report Development
• Report Coding Standar ds
• User Exits in Report design
• Customization of Reports – Adding Parameter s
• Customization of Reports – Adding Logos
• Discoverer User Edition
• Creation of Simple Workbook
• To design parameterized workbook
• To change Heading items
• To insert new sheet in the Workbook
• To add and remove items from Workbook
• To create duplicate sheet in Workbook
• To add title to the Worksheet
• To insert date, time, page numbers and image on
• Header /Title of Workbook
• To apply Conditional For matting

Introduction to Oracle Applications

• Introduction to ERP
• What is oracle
• History of Oracle & People behind Oracle Corp
• What is Oracle Application/E-Business suite
• Versions available in Oracle
• Versions available in Oracle Application
• What are major modules available in Oracle
• ERP’s available in the market
• Why Oracle application is so popular
• What Basically Implementation is?
• Overview of Implementation of Oracle Application
• Companies Implementing Oracle Application
• Overview of AIM
• Job Opportunities & Academic requirement

Oracle General Ledger

• Introduction
• Calendars
• Flex fields
  1. Accounting Flex field
  2. GL Ledger Flex field
• Chart of accounts
• Accounting Setup Manager
• Define Legal Entities
• Define Ledgers
• Define Accounting Options
• Add Legal Entities to Ledgers
• Assign BSV to Legal Entities
• Ledger sets
• Definition Access Sets
• Auto copy journals
• Reversal journals
  1. Manual reversal
  2. Auto reversal
• Suspense Journals
• Recurring Journals
  1. Standard
  2. Skeleton
  3. Formula
• Inter Company & Intra company journals
  1. Without Qualifying method
  2. With Qualifying method
• Reporting Currency Ledgers
  1. Balance Method
  2. Journal Method
  3. Sub Ledger Method
  4. Adjustments Only
• Revaluation Process
• Consolidation Workbench
• Summary of Accounts
• Period Close Process

Oracle Purchasing

• MOAC Setup
  1. Define Locations
  2. Define Business Group
  3. Define Operating Units
  4. Define Security Profiles
  5. Define HR Organization
  6. Define Security and User Access
  7. Define Purchasing Options
  8. Define Jobs
  9. Define Positions
  10. Define Employees
  11. Define Employee/Position Hierarchies
  12. Define Buyers
  13. Define Approval Groups
  14. Approval Group Assignments
• Process Setups
  1. Define Master Items
  2. Create Requisitions
  3. Define Suppliers
  4. Create Purchase Orders
  5. Approving Purchase Orders
  6. Creating Receipts
  7. Self Billing Invoices (Auto Invoice)
  8. Create Document Styles
  9. Create Complex Work Orders
  10. Create Accounting
  11. Returns
  12. Receiving Options
  13. Close/ Cancel P.O Requisition P.O Gaps
• Oracle Payables
  
• MOAC Setup
• Define Financial Options
• Define Payables Option
• Invoice Work Bench
  1. Standard
  2. Credit Memo
  3. Debit Memo
  4. Mixed Invoices
  5. Pre Payments
  6. Retain Age Release
  7. Payment Request
  8. Expense Report
  9. Withholding Tax Invoices
  10. Interest Invoices
  11. Transportation Invoices
  12. Recurring Invoices
  13. Define Grants & Roles (User Management)
  14. Define Banks
  15. Define Branches
  16. Define Bank Accounts
  17. Define Payables Documents
  18. Define Organization Access
  19. Define Netting Accounts
• Payment Workbench
  1. Manual Payments
  2. Quick Payments
  3. Netting Payments
  4. Bills Receivables
  5. Refund Payments
• Period Close Process
• Holds
• Manual Hold
• System Hold
• Invoice Matching With P.O
• Quick Match
• Match (P.O)
• Adjustment Invoices
• Corrections
• Payment Terms
• Distribution Set
  1. Full Type
  2. Skeleton Type
• Cancellation Invoices
• Oracle Payments (ipayments)
  1. System Security Options
  2. XML Publisher Format Template
  3. Payment Format
  4. Payment Methods
  5. Payment Method Defaulting Methods
  6. Payment Process Profile
  7. Payments Manager
• Fixed Assets
  1. Flex filed
  • Category Flex field
  • Asset Key
  • Location
  2. Define System Controls
  3. Define Fiscal Years
  4. Define Calendars
     • Depreciation Calendar
     • Prorate Calendar
  5. Define Prorate Conventions
  6. Define Depreciation Methods
  7. Define Asset Categories
  8. Define Asset Books
  9. Addition of Assets
  10. CIP Addition
  11. Quick Addition
  12. Manual Addition
  13. Mass Addition
  14. Mass addition of Assets from Payables
  15. Run Depreciation
  16. Mass Retirements
  17. Mass Revaluation
  18. Mass Changes
  19. Mass Transfers
  20. Mass Re-Classifications
  21. Create Accounting
  22. Transferring Assets to GL
• Oracle Receivables
  1. MOAC Setups For Receivables
  2. Configure System Options
  3. Introduction to TCA
  4. TCA Setups
  5. DQM
     • Security
     • Profile Classes
     • Customers
     • Parties
     • Organizations
     • Relationships
     • Administration & Security
  6. Auto Accounting
  7. Transaction Types
  8. Transaction Batch Sources
  9. Document Sequencing
  10. Transaction Workbench
      • Invoices
      • Credit Memo
      • Debit Memo
      • Deposits
  11. Guarantee
  12. Charge back
  13. Bills Receivables
  14. Transaction With Rules
      • Invoicing Rules
      • Accounting Rules
  15. EBT (Enterprise Business Taxes)
      • Geography Codes
      • Tax Regimes
      • Taxes
      • Tax Statuses
      • Tax Jurisdiction
      • Tax Rates
      • Tax Rules
      • Application Tax Options
      • Configuration Tax Options
      • Create Party Tax Profile
      • Create Party Tax Profile for third parties
• Sub Ledger Accounting Methods
  1. Event Entities
  2. Event Classes
  3. Event Types
  4. Process Categories
  5. Sources
  6. Mapping set
  7. Journal Entry Description
  8. Journal Line Types
  9. Journal Line Definitions
  10. Application Accounting Definitions
  11. Sub ledger Accounting Methods
  12. Customizing SLA
• Cash Management
• MOAC for Cash Management
• Define System Parameters
• Define Reconciliation Controls At Internal Banks
• Manual Reconciliation
• Automatic Reconciliation
• Bank Account Transfers
• Oracle Technical – Application Object Library
  1. Introduction to Application Object Library
  2. About Application Folders
  3. Introduction to Interfaces
  4. Types of Interfaces
  5. Understanding SQL *Loader
  6. Interface – Journal Import Using – Excel Data
  7. Interface – Budget upload Using – Flat file Data
  8. Introduction to Concurrent Programs
  9. Concurrent Programs – – SQL Loader
  10. Concurrent Programs – Journal Line Report – Oracle D2K Reports
• Highlights of the Program
  1. Check our Course Curriculum before you join anywhere
  2. Attend 1 Free Demo Classes without any Registration
  3. Free FAQ’s Prepared by Faculty
  4. Learn Oracle Financials from the Experts to build your Career