Oracle DBA 19c Training

​Let us look out for the Oracle DBA training syllabus.

Duration of Training: 45 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 19c Oracle Database Software

 

1) Download Oracle database software

 

2) Install and configure 19c Oracle Database Software

 

3) Database Installation using Silent Mode

 

Creating 19c databases (manual)

 

1)      Creating 19C Database manually

 

19c database Architecture.

 

1) Thorough understanding of 19C 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 19C  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 12C to 19C

 

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

 

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

 

Thresholds

 

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

 

Visit oracle official website for more learning.

 

​Don’t think to call us. LearnoMate is the best oracle dba training center in pune location.

 

Contact us for Registration

 

Mob No : +91 7757062955

 

Email: info@learnomate.org