Oracle Apps DBA Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

897 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Architecture & Configuration

  • Overview of Oracle DBA tasks
  • Oracle as a flexible, complex & robust RDBMS
  • He evolution of hardware and the relation to Oracle
  • Different DBA job roles(VP of DBA, developer DBA, production DBA, database babysitter)
  • The changing job role of the Oracle DBA
  • Environment management (network, CPU, disk and RAM)
  • Instance management (managing SGA regions)
  • Oracle table and index management.

Instance Architecture

  • Instance vs database
  • Components of an instance
  • Creating the OFA file structure (DBA, bdump, udump, pfile).  

Oracle Instance Internals

  • SGA vs PGA
  • Background processes
  • Interfaces with server and disk I/O subsystem. 

Using SQL Plus for DBA management

  • Connecting and executing SQL
  • Using the 'as sysdba' syntax
  • Overview of SQL Plus DBA commands (startup, etc.) 

User and privilege management

Creating New Database Users

  • Using pre-spawned Oracle connections
  • Auditing User activity
  • Identifying System and Object Privileges
  • Granting and Revoking Privileges
  • Creating and Modifying Roles
  • Displaying user security Information from the Data Dictionary 

Schema, File & tablespace management

  • Describing the relationship between data files, tablespaces and table
  • Understanding Oracle segments
  • Creating Tablespaces – using the autoextend option
  • Changing the Size of Tablespaces – alter database data file command
  • Defining a TEMP tablespace
  • Changing the default storage Settings for a tablespace
  • Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  • Monitoring Chained rows (fetch continued rows)
  • Monitoring Insert and Update performance (pctused, APPEND) 

Database Maintenance

  • Reason for reorgs – chained rows, imbalanced freelists
  • Reorganizing Tables using Export and Import
  • Using CTAS to reorganize data
  • Index rebuilding
  • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 

Database Maintenance

  • Reason for reorgs – chained rows, imbalanced freelists
  • Reorganizing Tables using Export and Import
  • Using CTAS to reorganize data
  • Index rebuilding
  • Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 

Backup & Recovery

  •  OS-level backups
  •  Hardware-level backup & recovery
  •  Block-level change tracking
  •  Disk mirroring
  • Backup & recovery and RAID level
  • Oracle-level backups (exp, expdp & RMAN)
  • Hot vs. Cold backups 

Course Description

What are the objectives of this Training course?

  • Gain an overview of Oracle E-Business Suite
  • Install Oracle E-Business Suite
  • Describe Oracle E-Business Suite architecture
  • Navigate the Oracle E-Business Suite file system
  • Identify key features of the Oracle E-Business Suite database
  • Identify key files and their purposes at Oracle apps DBA 11g r12.2.x online training.

Who Should Attend Oracle Apps Training?

  • Application Developers.
  • Database Administrators.
  • System Administrator.
  • Java Developers.
  • Technical Consultant.
  • Functional Implementer.
  • Systems Architects.
  • Application Server Administrators.

What Are The Pre-Requisites For Oracle Apps DBA Training ?

  • Oracle Database Administration (DBA) & Linux
  • Must have awareness in Concepts of Oracle PL/SQL and D2K.
  • Basic knowledge on Java Programming is required.
  • Basic knowledge of databases.
  • Working knowledge of SQL & RDBMS concepts.
  • Working Knowledge on oracle 10g.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Mahesh

Had a Great Experience in learning the Course with LTB. Trainer has a Practical Knowledge about the subject and taught us with real-time scenarios. Thank you LTB.

Aishwarya

HI Friends this is Aishwarya. I glad to share my experience. I completed Oracle Apps DBA Training in LTB. They gave excellent training. Faculty teaching was very nice. Now I am working in top MNC. Thanks to LTB.

Avanthika

Hi myself Avanthika, I really impressed with the experience in LTB. Our trainer is one of the best I have ever seen. He taught each and every concept in detailed manner. Thank you so much.