Course Description

In this training you will majorly learn about the following topics in about 100+ lectures

• Oracle Application Express:

In this Oracle application express part of the Oracle  training bundle, you will majorly learn the topics like Installation process, General Maintenance, Listener Options‚ Architecture‚ Associated Roles, Post Installation Tasks, Creating Workspace, Logging in as Workspace Administrator and Developer, Creating Websheet Applications as Workspace Administrator, Debugging an Application and much more.

• Oracle SOA Suite 11 g- Introductory course

In this Oracle SOA Suite 11 g, part of the Oracle  training bundle, you will majorly learn the topics like SOA Composite, SCA Bindings, SOA Suite 11g Architecture, Service Engines, Components, Business Rules, Human Workflow, Creating SOA Composite, BPEL Architecture, BPEL Orchestrator, Business Rule components, Human Task components and much more.

• Oracle Flashback Technologies

In this Oracle Flashback Technologies, part of the Oracle  training bundle, you will majorly learn the topics like Flashback Delete and Update, Archive Log Mode Being Enabled, Version Query Delete Commit, Table Theory, behavior of Index during Flashback Table Operation, Flashback Table to Before Drop, Database Concepts, Restrictions and Effects on Datafile, Normal vs Guaranteed Restore Points, Assigning of Tables in various flashback data archive objects and much more.

• Oracle Cloning

In this Oracle Cloning, part of the Oracle  training bundle, you will majorly learn the topics like Cloning Compared to Database Refresh, Database Replication, Standby Database, Physical Structure of ORCL and Copying Password File, Creating the Service CLONEDB, Creating the Parameter Files, RMAN Set New Name and Duplicate, Creation of CloneDB, Deletion of CloneDB using DBCA, Schema Cloning by Data Pump and much more.

Oracle Course Objective:

• To enhance the participants skills in Oracle Application Express, Oracle SOA Suite 11g, Oracle Flashback technologies, Oracle Cloning.

What is the Target Audience of this Oracle Course?

• IT Students
• IT professionals
• Anyone who wants to learn about Oracle in detail

What are the Pre-Requisites of this Oracle Course?

• Basic Computer Knowledge
• Internet Connection to view the training material of Oracle Training Bundle

Curriculum

Section 1: Oracle Application Express Online Training

1                  General Introduction

2                  Pre-Installation Tasks and Role of the Web Listener

3                  Listener Options‚ Architecture‚ Associated Roles

4                  General Maintenance

5                  Installation

6                  Post Installation Tasks

7                  Installing ORDS – 1

8                  Installing ORDS – 2

9                  Configuring RESTful Services with APEX

10               Logging In

11               Creating Workspace

12               Creating Another Workspace‚ Developer‚ Workspace

13               Logging in as Workspace Administrator and Developer

14               Comparing Database Application with Websheet Application

15               Create Application Wizard-Overview

16               Deletion of Application‚ Managing UI‚ Page

17               Creating a Form Page and Entering Data

18               Creating a Form Page and Entering Data continued

19               Creating a Report Page in Classic Style

20               Shared Components – Removing Tab

21               Shared Components – Managing Authentication Scheme

22               Shared Components and Globalization Attributes

23               Using the Find Icon and Managing Developer and Database Comments

24               Application Utilities – 1

25               Application Utilities – 2

26               Managing Application Groups

27               Creating Websheet Applications as Workspace Administrator

28               Packaged Applications

29               Packaged Applications continued

30               Debugging an Application

Section 2: Oracle SOA Suite 11 g- Introductory course

31               SCA Component

32               SOA Composite

33               SCA Bindings

34               Benefits of SCA

35               SOA Suite 11g Architecture

36               Service Infrastructure

37               Service Engines

38               Metadata Store

39               Components

40               Adapter

41               Mediator

42               BPEL

43               Business Rules

44               Human Workflow

45               Creating SOA Composite

46               Creating SOA Composite part 2

47               SOA Composite Editor

48               WebLogic Server Domain

49               Purchase Order Processing Demo

50               Oracle BAM

51               Oracle Service Bus

52               Introduction to BPEL process components

53               BPEL Architecture

54               Strengths of BPEL

55               BPEL Orchestrator

56               Oracle Enterprise Bus and Mediator

57               Business Rule components

58               Human Task components

59               OSB, Mediator and BPEL

Section 3: Oracle Flashback Technologies

60               Overview and Undo Management

61               Accidental Delete Scenario

62               Flashback Delete and Update

63               Archive Log Mode Being Enabled

64               Version Query Delete Commit

65               Transaction Query

66               Transaction Query continued

67               Table Theory

68               Table To Timestamp Lab Example

69               Table To Restore Point Lab Example

70               Behavior of Index during Flashback Table Operation

71               Flashback Table to Before Drop Theory

72               Flashback Table to Before Drop Theory continued

73               Flashback Table to Before Drop – Simple Example

74               Flashback Table to Before Drop – Truncate Table

75               Flashback Table to Before Drop – Same Table Dropped Multiple Times

76               Flashback Database Concepts, Restrictions and Effects on Datafile

77               Database Concepts, Restrictions and Effects on Datafile continued

78               State of the Database and Flashback Log Mode Being Enabled

79               Database To SCN – Simple Example

80               Normal vs Guaranteed Restore Points

81               Concepts, Creation, Alteration, Dropping of Flashback Data Archives

82               Concepts, Creation, Alteration, Dropping of Flashback Data Archives continued

83               Assigning of Tables in various flashback data archive objects

84               Flashback Transaction

Section 4: Oracle Cloning

85               Origin of the Word Clone

86               Cloning in Oracle and its Uses

87               Cloning Compared to Database Refresh

88               Cloning compared to Database Migration and Upgrade

89               Cloning Compared to Database Replication

90               Cloning compared to Standby Database

91               Physical Structure of ORCL and Copying Password File

92               Creating the Service CLONEDB

93               Updating Listener.ora and Tnsnames.ora files

94               Creating the Parameter Files

95               Starting Auxiliary Instance in Nomount Mode

96               RMAN Backup of the Production Database

97               RMAN Set New Name and Duplicate

98               Creation of CloneDB Completed

99               Deletion of CloneDB using DBCA

100             Installing Oracle 10g Express Edition and EXPDP of TEST from ORCL DB

101             Schema Cloning by Data Pump

102             IMPDP of TEST into XE DB and Removal of the Express Edition

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address