About Trainer

  • 8 years of Oracle DBA experience
  • Oracle Database Certified
  • Working as a Senior Core DBA
  • Sound Technical skills
  • Teaching from 4+ years

About Oracle Core


Course Pre-requisites:

Lab setup:

  • Oracle Enterprise Linux (OEL)
  • Oracle 11.x

Training Material:

  • Class PPT’s (Soft copy)
  • Class recordings (Optional)
  • Interview Questions


Unit 1: OS Installation and Oracle Software Installation

  • OEL 5.8 Installation as per Metalink Note
  • Configuration of OEL to install Oracle Software
  • Creating required OS level Users and groups
  • Installing Oracle Software 11.2.0 (11gR2)

Unit 2: Architecture

  • What is Oracle Instance?
  • What is Oracle Database?
  • What is Oracle Server?
  • Physical and Logical Structure of Database
  • Mandate and Optional Memory Structures
  • Mandate and Optional Background Processes
  • How SQL Statements are processed (Select, Insert and Update)
  • What is User process and Server process?

Unit 3: Database Maintenance

  • Creating Database (Manual, dbca)
  • Database Startup and Shutdown modes
  • Tablespaces, data files and storage
  • Creating Users, Roles and Profiles
  • Managing Privileges and Roles
  • Networking Architecture and Configuration
  • DB Links and Materialized views
  • Multiplexing of Control files and Redo log files

Unit 4: Backup & Recovery

  • What/Where/How to Backup?
  • Logical Backups (Data Pump / exp)
  • User Managed Backups (Cold and Hot)
  • RMAN Backups

Unit 5: Patching

  • Patch Utility
  • Patch Repository
  • Patch Application

Unit 6: Cloning

  • Database Cloning using RMAN Utility (Industry standard)

Unit 7: ASM

  • ASM Architecture
  • Installation of Grid infrastructure
  • Implementation of ASM
  • Creating Database on ASM storage

Unit 8: Data Guard

  • Data Guard Concepts and Architecture
  • Configuration of database in Data Guard
  • Active Standby Database

Unit 9: Database Upgrades

  • ORACLE DATABASE 10gR2 to 11gR2

Unit 10: Database Migration

  • Windows to Linux

Unit 11: Performance Tuning

  • Database Tuning
  • Application Tuning
  • Memory Tuning
  • Network Tuning



  • The fact that they have a set format of teaching, which creates a schedule for a student, and a step-by-step process that covers the entire Netezza syllabus. I can surely assure eTraining provides a great help for Netezza curriculum.
    - Shannon D.

  • The BEST I liked about the tutors in eTraining is the amount of practical knowledge these guys have and the way they bring in the same to students perspective while Teaching. Glad I took DB2 course from eTraining.
    - Rubeena Khan

  • I found classes very helpful. What you Teach is AWESOME
    - Gopal