Oracle Training Introduction

grrrgrapeInternet and Web Development

Oct 31, 2013 (4 years and 7 days ago)

69 views

Oracle Training Introduction



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.

Why Oracle


No:1 in Database market


No:1 in Financials ERP (EBusiness Suite)


No:1 in HRMS ERP (PeopleSoft)


No:1 in CRM ERP (Siebel)


No:1 in Business Reporting Tool (OBIEE)


Leading integration technology leader (SOA)


Second largest Hardware Vendor with Sun Acquisition


Largest Middleware/Application Server Vendor


Holding 80% of Database and 50% of ERP Market


Holding 80% of Application Server Technologies in the Market



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.


Oracle


An Overview

Database

Middleware

Applications

Server &

Storage System

-
Oracle Database

-
Real Application Clusters

-
Real Application Testing

-
Data Warehousing

-
Database Security

-
Exadata

-
Enterprise Manager and
Database

-
Embedded, Spatial

-
MySQL

-
Dataguard, Total Recall

-
Advanced Compression

-
Data Mining

-
OLAP, Partitioning

-
Java

-
Weblogic

-
Service Oriented Architecture

-
Content Management

-
Webcenter

-
OBIEE

-
Identity Management

-
EM and Middleware

-
Developer Tools

-
BPM

-
Application Grid

-
SOA Governance

-
Exalogic

-
Oracle E
-
Business Suite

-
PeopleSoft Enterprise

-
Siebel

-
JD Edwards EnterpriseOne

-
JD Edwards World

-
Hyperion

-
Primavera

-
AIA

-
Oracle Retail

-
SCM

-
Procurement

-
UPK

-
Oracle On Demand

-
Sun Servers

-
Sun Storage and Tape

-
Sun Oracle DB M/C

-
Solaris

-
Linux

-
Virtualization

-
EM Ops Centre

-
Microelectronics

-
Desktops

-
Networking



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.

Major Industries Using Oracle

Automotive


Over
400 automotive

companies run EBusiness Suite.


40
of the top

45

global suppliers run Oracle technologies.


5
of the top

5

Fortune 500 automotive manufacturers run Oracle EBusiness Suite.

Communication




98

of the top
100

telcos


EBusiness Suite



97

of the top
100

telcos


Oracle Fusion Middleware



100

of the top
100

telcos


Oracle Database



10

of the top
10
network equipment providers rely on Oracle's Sun hardware



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.

Major Industries Using Oracle

Financial Services


Oracle is
#1

in Financial Services customer relationship management


Oracle is
#1

in Financial Services human capital management


20

of the
20

top banks run Oracle

Health Care




Only solution capable of aggregating clinical data meaningfully across
disparate systems



Comprehensive solution

from recruitment to succession planning using
Oracle EBusiness Suite HRMS and Financials Modules



Only integrated enterprise solution for secure provider collaboration



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.

Major Industries Using Oracle

Public Sector


25 of the 25 Top Governments Get Better Results with Oracle EBusiness Suite and
Middleware Fusion Technologies

Retail




20

of the top
20

global retailers run Oracle



10

of the top
10

global fashion retailers run Oracle



20

of the top
20

global grocers run Oracle



10

of the top
10
European retailers run Oracle



10

of the top
10

North American retailers run Oracle



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.

Other Industries


Aerospace and Defence


Chemicals


Consumer Products


Education and Research


Engineering and Construction


High Technology


Industrial Manufacturing


Insurance


Life Science


Media and Entertainment


Natural Resources


Oil and Gas


Professional Services


Travel and Transportation


Utilities


Wholesale Distribution



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



Industry
-

Oracle Job Categories


Project Manager


Solution Architect


Infrastructure Architect


Technical Architect


Functional Consultant


Apps DBA


DBA


Technical Developer


Tester




SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.





Project Life Cycle and Job Roles

Requirement

Gathering & CRP

(10%)

Design Phase

(20%)

Dev

(60%)

Project Manager

Solution Architect

Func Consultant

SIT/UAT/

Perf
. Testing

(10%)

Project Manager

Solution Architect

Tech Arch

Infrastructure Arch

Project Manager

Solution Architect

Tech Arch

Infrastructure Arch

Func Consultant

Apps DBA/DBA

Tech Developer

Project Manager

Solution Architect

Tech Arch

Infrastructure Arch

Func Consultant

Apps DBA/DBA

Tech Developer

Tester

GoLive/

Post GoLive

(on going)

Tech Lead

Apps
DBA/DBA

Tech Developer



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



Training Model


Classroom Sessions


Virtual Classes


Corporate Training


Cloud Practical Session


coming soon


Demo Environment for practice


coming soon




SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



Training Categories

Oracle Technology

-

Core DBA

-

RAC Specialization

-

High Availability
and DR Training

-

Weblogic
Administration

-

SOA Administration

-

UCM,
Webcenter

Administration

-

OBIEE, ODI
Administration

-

Oracle Fusion Apps

-

SOA Development

-

UCM,
Webcenter

Development

-

OBIEE
Development

Oracle ERP

-

Apps DBA

-

Apps Development

-

Financial Functional

-

CRM Functional

-

HRMS and Payroll

-

Supply Chain

-

Fusion Apps Admin

-

PeopleSoft
Administration

-

PeopleSoft
Functional

-

BI Apps

-

Siebel Analytics

Operating System, Virtualization

-

Linux
Administration

-

Sun Solaris
Administration

-

HP
-
UX
Administration

-

Oracle VM

-

Oracle Cloud

-

Exadata

-

Exalogic





SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



ADVANTAGES OF ORACLE OVER
OTHER DATABASES


ROW LEVEL LOCKING


ORACLE CAN HANDLE MILLIONS OF TB OF DATA


ORACLE COMES WITH NEW VERSIONS WITH NEW
FEATURES IMPLEMENTED


BACKWARD COMPATIBLE


ORCLE DOCUMENTATION IS USER FRIENDLY


FLASH BACK TECHNOLOGY


ORACLE HAS ACID
PROPERTY



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



ROW
-
LEVEL LOCKING


LOCKS ARE A SCARE RESOURCE IN OTHER DATABASES


IN ORACLE, THE OVERHEAD OF HAVING 1 LOCK IS THE
SAME AS HAVING 1BILLION LOCKS


OTHER DATABASES CONSUME MEMORY SPACE AND ARE
STORED IN IN
-
MEMORY DATA STRUCTURES


ORACLE’S LOCK IMPLEMENTATION ARE SO DIFFERENT AS
NOT TO BE COMPARABLE


PROVIDES READ CONSISTANCY



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



ORACLE CAN HANDLE MILLIONS
OF TB OF
DATA



ORACLE IS BETTER IF YOU ARE GOING TO HAVE
LARGE DB USAGE


BETTER WITH MEMORY LEAKS AND HANDLES
MULTIPLE THREADS


DTS (Data Transformation Service) IS
POWERFUL


HANDLES LARGE AMOUNT OF DATA , AND IT
WONT BE SLOW ON SERVER


BACKING UP EVEN LARGE AMOUNT OF DATA IS
A EASY TASK



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



ORACLE COMES WITH NEW VERSIONS
WITH NEW FEATURES IMPLEMENTED



ORACLE COMES WITH NEW VERSIONS WITH
NEW FEATURES IMPLEMENTED IN NEW
VERSION WHILE THE FEATURES OF EARLIER
VERSIONS STILL BEING MAINTAINED.


HIGHER VERSION HAVE MORE FEATURES AND
BETTER CAPABILITIES.


ORACLE COMPANY KEEPS UPGRADING AND
RELEASING NEW PRODUCTS INTO MARKET.


NEW VERSIONS SERVES BETTER THAN THE
EARLIER VERSIONS AND THUS THE
PERFORMANCE IS IMPROVED MUCH IN LATER
VERSIONS .



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



ORACLE DOCUMENTATION



WHEN ORACLE RELEASES NEW VERSION, THEIR
DOCUMENTATION CONTAINS A LIST OF ALL THE
FEATURES NEW TO THAT VERSION
.



THUS MAKES USER FRIENDLY FOR ONE TO
LEARN THE NEW FEATURES.



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



FLASHBACK TECHNOLOGY



PROVIDES AN EFFICIENT RECOVERY FROM
HUMAN ERRORS


FASTER DATABASE RECOVERY


HELPS IN SIMPLIFYING THE MANAGEMENT
AND
ADMINISTRATION
PROCESSES



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



CONCLUSION



GREATER SECURITY COMPARED TO OTHER
DATABASES
.



VERY GOOD PERFOMENCE
.



ORACLE
CAN MANAGE LARGE AMOUNT OF
DATA
.



ORACLE SUPPORTS THE CUSTOMER 24/7 ALL
OVER THE WORLD.



SOLISTECH

Copyri ght © 2008, Sol i stech. Al l ri ghts reserved
.



Reference Sites


http://
www.oracle.com/technetwork/index.html


https://blogs.oracle.com
/


http://tkyte.blogspot.co.uk
/


https://
blogs.oracle.com/ODA


https://
blogs.oracle.com/databaseinsider