Oracle DBA 11G & 12C Combo Syllabus

Duration of Training: 30 days (Daily and Weekend)

Linux Installation

Vmware Installation and vmware architecture

Winscp software Installation

Learn to install Linux with relevant packages.

1)      Understand HDD partitioning

2)      Package download and Installation

Understanding DNS and DHCP

1)      Installation of configuration of DNS.

2)      Installation and configuration of DHCP

Installing 11g and 12c Oracle Software

1) Download Oracle database software

2) Install and configure 11g and 12c Oracle Database Software 

Creating 11g and 12c databases (manual)

1)      Creating 11g Database and 12c Database manually 

11g and 12c Architecture.

   1) Thorough understanding of 11g and 12c architecture

Oracle Administration and management.

1)      starting databases

2)      understanding control files / redo log files / archive files

3)      understanding Server parameter file and password files

4)      Automatic memory management

5)      Different components in SGA and PGA 

Tablespaces / segments / extents and blocks

1)      Dictionary managed versed locally managed tablespaces.

2)      Automatic Segment space management

3)      Understanding Segments / extents and blocks

4)      Block utilization parameters

6)      Different block Sizes 

12c Multitenant Database concepts and new features

1)      Understanding multitenant architecture

2)      Overviews of Pluggable databases  

3)      Installation of Pluggable database with different way      

Oracle networking and shared process overview

1)      Configuring and maintaining listeners

2)      SQL Developer Installation

3)      Understand how to connect SQL Developer with Oracle 11g and 12C    database.

 ASM overview and benefits

1)      Complete Overview of ASM

2)     Understand the need of ASM

3)     ASM instance parameters

Rman and conventional Backup / Recovery

1)      Defining backup strategy

2)      Complete understanding of RMAN and conventional backups 

Rman and Conventional Cloning

1)      Cloning database using conventional methods

2)      Cloning database using rman

Applying patches

1)      Different types of Patches

2)      How to apply patch to database

Database upgrade

1)      Upgrade Database from 11g to 12c

2)      Coverting 12c noncdb to 12c pluggable database

Physical and logical Standby/ Data guard

1)      Configure physical standby database

2)      Understanding logical and snapshot standby database

Oracle Shell Scripting overview.

1)      understanding cronjob

2)      writing basic scripts

AWR reports / ADDM reports / ASH report

1)      Understand how to read the AWR  / ADDM / ASH reports

expdp / impdp backups

1)      Taking logical backups using expdp

2)      Data pump usage and scenarios

Real time Scenarios

Loss of a Control File

Loss of a Redo Log File

Loss of a Data File in NOARCHIVELOG Mode

Loss of a Noncritical Data File in ARCHIVELOG Mode

Loss of a System-Critical Data File in ARCHIVELOG Mode

Oracle Recovery Manager

Oracle Recovery Catalog maintenance

Backups using Oracle Recovery Manager

Recovery using Oracle recovery manager

Database Cloning using RMAN

Tablespace Point in time recovery

Incomplete recovery 

Database and Instance Metrics

Reacting to Performance Issues

Proactive Maintenance

Server Generated Alerts


Setting Thresholds

Performance tuning

Index Rebuild

Stats gather

Generate AWR reports / ADDM reports / ASH report

Blocking in SQL statement

Interview Questions

Frequently asked Interview question will cover after end of session

Mock Interview

Will take mock interview and also provide solution which will help to crack interview

Contact us for Registration

Mob No : +91 9960262955