Learn Oracle

[#1]

Hello,

I m fresher in sap basis and i think to learn basis first i have to clear the concepts of database that is why i m planing to go for oracle training ... but i need to know what all the concepts should be covered in my training or for which course of oracle should i go .....please reply asap because in i wud like to learn basis as quick as possible.

Best regards,

Rohit

[Former Member · Accepted solution]

whats about this:

???

Peter

[Former Member · Accepted solution]

hey Thx peter ,

lot of help buddy..almost got it ..so its good to go for Oracle Dba right..?

Regards,

Rohit

[andreas_herzog · Accepted solution]

start with oracle (but not only dba...there's lots of basis stuff out there, too) and the next step towards other databases (db2, maxdb) is not far

GreetZ, AH

[Former Member · Accepted solution]

Thx greetz for ur reply...

Can u please tell me in points ..wt other stuff will come under basis oracle database?

regards,

Rohit

[andreas_herzog · Accepted solution]

are you going for dba only?

or sap basis as well?

GreetZ, AH

[Former Member · Accepted solution]

first i will do dba and then from any other institue i will go for basis training.

That's why i need to cover the concepts of oracle which is related to sap basis ..that is what i only need to know.

regards,

Rohit

[andreas_herzog · Accepted solution]

yup...here's some info: (taken from sap's certification test topics)

<u>ORACLE:</u>

1. Database Overview

• Database Architecture

• Connecting to the Database

• Database Administration Tools

• Administration of Oracle Instaces

2. Backup Restore & Recovery

• Backup Strategy

• Backup Tools and Tape Management

• Performing Backups

• Restore and Recovery

• Advanced Backup Techniques

3. Monitors and Tools

• Introduction to Oracle Data Management

• Database System Check

• CCMS Alert Monitor

4. Storage Management

• Tablespace Administration

• Housekeeping and Troubleshooting

• Reorganization

5. Oracle SQL Cache Analysis

• Analyzing SQL Statements

• Update Statistics

• Identify Coding

<u>SAP WebAS for Oracle:</u>

1. SAP Web AS Fundamentals

• SAP Solution Offering

• Navigation

• SAP System Architecture

• Enterprise Services Architecture

• SAP NetWeaver, Overview

2. SAP Web AS Administration I

• Starting and Stopping SAP systems

• Configuring SAP Web AS ABAP

• Configuring SAP Help (Documentation)

• Archiving SAP Data

• User Management in SAP Web AS ABAP

• Configuring Remote Connections

• Patching SAP Web AS ABAP

• Scheduling Background Jobs

• Setting up Printers of types C, L, S, U and F, planning a spool environment

• Monitoring SAP Systems

• Introduction to Structured Error Analysis

• Introduction to System Security

3. SAP Web AS Administration II

• Technology Components for Browser-based User Interfaces

• Configuring Central User Administration

• Using LDAP to integrate Directory Servers with SAP Systems

4. SAP Web AS Java Administration

• Java Basics (non-programming topics)

• Starting and Stopping SAP Web AS Java

• Configuring SAP Web AS Java

• User Management in SAP Web AS Java

• Patching SAP Web AS Java

• Software Logistics for SAP Web AS Java

• Monitoring SAP Web AS Java

5. SAP System Installation

• Installation Planning

• Installation Preparation

• Installing SAP GUI

• Installation Process

• Post-Installation Activities

• Patching the Kernel

• Unicode Conversion

• Troubleshooting Installation Problems

6. Software Logistics

• SAP System Architecture from a Software Logistics point of view

• TMS and Extended Transport Control

• Customizing and Development in ABAP

• Transporting changes in ABAP

• Client Tools

• Note Assistant

• Introduction to Upgrade Technology

7. Workload Analysis

• Components of a Dialog Step

• Workload Analysis Monitors

• SAP Memory Management

• Verifying the Hardware Capacity (Sizing)

• Analysing Expensive SQL Statements

• SAP Table Buffering

• RFC Monitoring

GreetZ, AH

[Former Member · Accepted solution]

Hey thx AH,

I think its enough for me or for anyone who is fresher.

thx again .

Regards,

Rohit

[andreas_herzog · Accepted solution]

no prob...have fun!

GreetZ, AH