Oracle BPEL Course Contents :

Introducing Service-Oriented Architecture Concepts and Oracle SOA Suite 10g

• Describing Service-Oriented Architecture and Standards Enabling SOA
• Describing Oracle ESB Architecture
• Orchestrating Services with BPEL
• Adding Business Rules and Decision Services
• Oracle BPEL Process Designer and Oracle ESB Designer
• Creating Connections in Oracle JDeveloper
• Creating an Application Server and Integration Server Connection

Providing Services for SOA

• Defining an XML Schema and Creating the WSDL Document
• Creating the Web Service by Using Oracle JDeveloper 10g
• Deploying and Testing a Java Web Service
• Oracle Service Registry Consoles
• Publishing a Service Provider and WSDL Service
• Testing a Web Service in the Service Registry

Configuring Oracle Enterprise Service Bus (ESB)

• Enterprise Service Bus Architecture: Single Instance
• Creating an ESB Project in JDeveloper and Creating a ESB System
• Creating an ESB Service and Routing Rules in ESB
• Adding Target Service to Routing Rules
• Adding a SOAP Service to an ESB Project
• ESBBPEL Native Integration
• Registering an ESB Project
• Benefits of ESB

Developing a Simple BPEL Process

• Introducing Business Process Execution Language (BPEL)
• Describing Oracle BPEL Process Designer
• Creating a BPEL Process Project
• Designing the BPEL Process and Orchestrating with BPEL Activities
• Describing the Assign Activity
• Using the XPath Expression Builder
• Examining the BPEL Process XML Source Structure
• Deploying the BPEL Process and Executing a BPEL Process

Orchestrating Services with BPEL

• Developing a BPEL Process
• Importing a User-Defined XML Schema
• Creating and Configuring a Partner Link
• Exchanging Message Data with a Service
• Grouping Activities by Using a BPEL Scope
• Adding Activities to a Scope and Configuring a Scope

Processing BPEL Activities in Parallel

• Processing Activities in Parallel
• Processing in Parallel with a FlowN Activity
• Working with a FlowN Activity
• Adding a While Activity for Execution Loops
• Implementing a Pick Activity
• BPEL Deployment Descriptor Properties
• Defining Preference Properties
• Defining Deployment Descriptor Properties in JDeveloper

Integrating Services with Adapters

• Describing the Adapter Framework
• Identifying OracleAS Adapter Types
• Technology, Application, Legacy, and Custom Adapters
• File and FTP Adapter
• Working with the File Adapter
• Creating and Configuring a File Adapter in BPEL and ESB
• Invoking a Database Adapter from BPEL
• Configuring the Database Adapter

Transforming Data in ESB and BPEL

• Routing Rules in ESB
• Adding a Filter Expression to a Routing Rule
• Synchronous or Asynchronous Execution
• Transformation Services in BPEL and ESB
• Adding and Configuring Transformation Services in BPEL
• Using the XSLT Mapper in BPEL
• Adding Transformation to an ESB Service
• Dictionary and Report Generation

Administration and Exception Handling in ESB

• Managing ESB Metadata Server and ESB Runtime Server
• Testing an ESB Service
• Error Handling in ESB
• Errors Raised in Synchronously and Asynchronously Called Services
• Changing Routing Rules
• Viewing Application Logs in ESB
• Configuring Logging Levels
• Import and Export Utilities in ESB

Handling Exceptions and Monitoring in BPEL

• Reviewing the Scope Activity
• Managing Faults
• Throwing Exceptions in BPEL
• Compensation in Transactions
• BPEL compensation Handler
• Monitoring BPEL Processes with Sensors
• Introduction to Monitoring with Oracle BAM
• Interfacing with Oracle BAM

Developing Business Rules

• Introducing Business Rules Technology
• Introducing Oracle Business Rules and Decision Service
• Developing a Rule-Enabled Application and accessing Oracle Rule Author
• Defining Oracle Business Rules Development Concepts
• Creating a Rule Repository and Rule Definitions 1
• Identifying the Structure of a Rule and creating a Rule
• Integrating Rules with a BPEL Process
• Creating a Decision Service PartnerLink

Implementing Human Workflow in BPEL

• Workflow Services in Oracle BPEL Process Manager
• Implementing Human Workflow Services
• Workflow Exchange Patterns
• Describing Workflow As a Service
• Creating a Human Task in BPEL
• Working with Notification Services
• Configuring E-Mail Notification for a BPEL Process
• Understanding XMail E-Mail Server and Configuring the E-Mail Client

Integrating Java Applications and BPEL

• Invoking a BPEL Process from Java
• Invoking One-Way and Two-Way Operations from Java
• Invoking a BPEL Process from JSP and with the JSP Tag Library
• Executing Java Code in a BPEL Process
• Web Services Invocation Framework
• Java Code with WSIF Bindings
• WSIF Java Calls
• Embedding Java Code in BPEL

Configuring the Oracle WSM Component Archit

• Oracle WSM Component Architecture and Oracle WSM Server Components
• Configuring a Gateway and a Server Agent
• Registering a Web Service with the Gateway
• Policy Management in Oracle WSM
• Understanding Oracle WSM Policy Steps
• Pipeline Templates
• Creating a Policy Pipeline Template
• Using the Pipeline Template in the Server Agents Policy

Securing BPEL and ESB Services with Oracle WSM

• Securing the Endpoints of the SOA Order Booking Application
• Invoking a Secured Service from BPEL
• Using Oracle WSM Client and Server Agents to Enforce Security Policies
• Installing and Configuring a Client Agent
• Securing a BPEL Process in Oracle WSM
• Invoking a Secured Web Service from BPEL
• Deploying and Testing the BPEL Process
• Invoking a Secured Web Service from ESB

BPEL Process Deployment Compiling and Deploying a BPEL Process..

• Compiling and Deploying on JDeveloper BPEL Designer.
• Compiling Without Deploying on JDeveloper BPEL Designer.
• Compiling and Deploying on Eclipse BPEL Designer..
• BPEL Suitcase JAR File.

Domain Management Creating and Managing a BPEL Domain

• Changing the Default Domain Password
• Changing Oracle BPEL Admin Console Password…
• Creating a BPEL Domain
• Changing Oracle BPEL Server Mode.
• Deploying a BPEL Suitcase to a Specific Domain…
• Location of BPEL JAR Suitcase Files in a Specific Domain..
• Underplaying a BPEL Process from a Specific Domain

Viewing BPEL Processes in Oracle BPEL Console…

• Dashboard Tab: Viewing Processes..
• BPEL Processes Tab: Managing the Process Life Cycle…
• Process Life Cycle Recommendations for a Production Environment…
• Example: Life Cycle of Processes..
• Instances Tab: Viewing Process Instances
• Activities Tab: Viewing Process Activities…

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

ORACLE DBA SYLLABUS

Describe Oracle Database Architechture

Ø  Install and configure Oracle 11g

Ø  Configure Oracle Net Services

Ø  Manage the database storage structures

Ø  Create and administer user accounts

Ø  perform basic backup and recovery

Ø  Manage Users and schemas

Ø  Manage Data and Concurrency

Ø  Monitor and administer undo data

Ø  Backup and recover a database

Ø  Monitor performance

Ø  Use the database diagnostic Monitor

####Course Topics..####

Exploring the Oracle Database Architechture.

Ø  Oracle Database Architechture Overview

Ø  Oracle Asm Architechture Overview

Ø  Process Architechture

Ø  Memory Structures

Ø  Logical and Physical Storage Structures

Ø  Asm Storage Stuctures

####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

Ø  Manage the ASM instance

Ø  set up initialization parameter files for ASM instance

Ø  startup 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 the 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

Ø  Benifts of 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 Using Rman ###

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 controlfile

loss of a redolog file

Data Recovery Advisor

Data failures

Listing Data Failures

Data Recovery Advisor Views

## Data Replication ##

Describe Ways to Move Data

Create and Use directory Objects

Use SQL * Loader to move Data

Use external tables to move data

General architechture 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

### RMAN Topics ###

Backup Strategies

Flash Recovery Area

RMAN Architechture

RMAN backup Components

RMAN catalog and Configuration

RMAN Commands

Monitoring RMAN backups

Tuning RMAN Jobs

Restoring and recovering using RMAN

Database cloning using RMAN

Troubleshooting RMAN Issues

Best Practises

### 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

Backup 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 backup sets

create an archival backup for long term retention

create a multisection, compressed and encrypted backup

report on and maintain backups

### Performing User- Managed Backup and Recovery ###

Recover from a lost TEMP file

Recover from a lost redo log group

Recover from the loss of a password file

Perform User - Managed Complete database recovery

Perform User - Managed incomplete database recovery

Perform User - Managed and server Managed Backups

Identify the need of backup mode

Backup and recover a control file

#### Using RMAN to perform Recovery ####

Perform complete recovery from a critical or non critical

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

Monitoring and tuning RMAN

#### Monitoring RMAN Sessions and jobs ###

Tuning RMAN

Configure RMAN for Asynchronous I/O

### ASM TOPICS ###

## Database Architecture and ASM ##

Describe Automatic Storage Management (ASM)

set up initialization parameter files for ASM and database

instances

start up and shut down ASM Instances

Administer ASM disk groups

Storage Fundamentals

ASM Concepts

Preparing ASM Storage

ASM Instance Setup

ASM diskgroups Failure groups (Redundancy)

Managing Disk groups

Backing up Diskgroups

Monitoring Diskgroups

Creating Database on ASM

Managing Database on ASM