WILL I GET THE REFUND IF I CANCEL MY ENROLLMENT?

If request for cancelation is made within 2 days of enrolment for class, 100% refunded.If request made after 2 days, then Refund is made after deduction of administration fee.

Best Oracle Advance DBA Training - 100% Lab Access

COURSE CURRICULUM

43+ Course Topics • Hands-on Labs • Real-Time Practice

Module 1 - Database Administration

01 Oracle Database Architecture Topics

List the major architectural components of Oracle Database
Explain memory structures
Describe background processes
Correlate logical and physical storage structures
Describe multitenant architecture

02 Creating Standard Database, CDB's and PDBs Topics

Describe the methods and tools used to create PDBs
Create PDBs from seed by using SQL*Plus
Clone PDBs by using SQL*Plus
Unplug and plug in PDBs and Drop PDBs by using SQL*Plus

03 Accessing an Oracle Database Topics

Connect to an Oracle Database
Describe the tools used to access an Oracle Database
Describe the Oracle-supplied user accounts for Oracle Database
Query the data dictionary in an Oracle Database

04 Managing Database Instances Topics

Describe initialization parameter files and parameters
View and modify initialization parameters in SQL*Plus
Start up and shut down Oracle databases
Open and close PDBs
Work with the Automatic Diagnostic Repository (ADR)
Query dynamic performance views

05 Oracle Net Services Topics

Describe Oracle Net Services
Explain how listeners work
Configure listeners for dynamic or static service registration
Configure local naming for database connections
Test Oracle Net connectivity with tnsping
Configure communication between databases by creating database links

06 Creating and Managing Tablespaces Topics

Explain how table data is stored in the database
Create and drop tablespaces
Alter tablespaces, view tablespace information
Implement Oracle Managed Files (OMF)
Use SQL*Plus to move and rename online data files
Implement tablespace encryption

07 Administering User Security Topics

Create database users, Grant privileges to users
Create and grant roles to users or other roles
Revoke privileges and roles from users and other roles
Create and assign profiles to users
Explain the various authentication options for users
Assign quota to users

08 Managing Undo Data Topics

Explain DML and undo data generation
Monitor and administer undo data
Describe the difference between undo data and redo data
Configure undo retention
Guarantee undo retention
Enable temporary undo
Use the Undo Advisor

Module 2 - Database Backup And Recovery

09 Moving Data Topics

Describe ways to move data
Explain the general architecture of Oracle Data Pump
Use Data Pump to move data between Oracle databases
Use SQL*Loader to load data from a non-Oracle database (or user files)
Use external tables to move data via platform-independent files

10 Backup and Recovery Concepts Topics

Identify DBA responsibilities regarding database backup and recovery
Identify the types of failure that can occur in an Oracle database
Describe instance recovery
Describe complete and incomplete recovery

11 Backup and Recovery Configuration Topics

Configuring the Fast Recovery Area
Multiplex the control file & redo log files
Configure ARCHIVELOG mode
Configuring the Backup Retention Policy
Backup Optimization and the CONFIGURE command
Configuring an Archived Redo Log Deletion Policy

12 RMAN Backup Concepts Topics

About Consistent and Inconsistent RMAN Backups
About Online Backups and Backup Mode
About Backup Sets & Image Copies
About Multiple Copies of RMAN Backups
About RMAN Control File and Server Parameter File Auto backups
About RMAN Incremental Backups & Retention Policies

13 Backing Up the Database Topics

Overview of RMAN Backups
Specifying Backup Output Options
Backing Up Database Files with RMAN
Backing Up CDBs and PDBs
Backing Up Archived Redo Logs with RMAN
Making and Updating RMAN Incremental Backups

14 Managing a Recovery Catalog Topics

Overview of the RMAN Recovery Catalog
Creating a Recovery Catalog
Registering a Database in the Recovery Catalog
Managing Stored Scripts
Maintaining & dropping the Recovery Catalog

15 Performing Database Recovery Topics

Determine the need for performing recovery
Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor and Recovery datafiles

16 Performing Complete Database Recovery Topics

Overview of Complete Database Recovery
Performing Complete Database Recovery
Performing Complete Recovery of CDBs
Performing Recovery of Non-Critical datafiles
Performing Recovery of Critical datafiles

17 Performing In-Complete Recovery Scenarios Topics

Incomplete Recovery scenarios Loss of Redologs
Incomplete Recovery scenarios Loss of Control files
Incomplete Recovery scenarios Loss of All Files

18 RMAN Incremental Backups and Point-in-Time Recovery Topics

Overview of RMAN Incremental Backups
Performing Incremental Backups & recovery scenario
Performing point-in-time Recovery (PITR) scenarios

19 Duplicating a Database / Database Cloning Topics

List the purposes and create duplicate database with RMAN
Duplicate a database based on a running instance

Module 3 - High Availability With DataGuard

20 Understand Hiigh Availability and the requirement of Data Guard Topics

Manually configure and manage Dataguard Setup
Understanding Dataguard Roles & types of Modes

21 Using DGMGRL Topics

Configuration DGMGRL
Using DGMGRL for monitoring and configuring Dataguard setup
Performing switchover and failover tasks using DGMGRL

22 Configuring Standby Modes Topics

Configure Snapshot standby database
perfrom switchover and switchback from snapshot to physical standby
Monitor snapshot standby databases

Module 4 - Oracle Clusterware & ASM Admin

23 Oracle Clusterware Architecture Topics

High Availability with RAC design
RAC Architecture and purpose of VIP’s
SCAN NAME, SCAN VIPs, SCAN Listeners architecture
Standard cluster and Flex Cluster concepts
Components of Clusterware
Understanding Processes architecture

24 Grid Infrastructure: Preinstallation Tasks Topics

perform preinstallation tasks for Grid Infrastructure.

25 Grid Infrastructure Installation Topics

Perform an image-based Grid Infrastructure installation
Verify the installation
Configure Automatic Storage Management (ASM) disk groups

26 Traditional Clusterware Management Topics

Demonstrate your Clusterware management proficiency
Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
Manage network settings
Describe the scope and capabilities of what-if command evaluation

27 Flex ASM Topics

Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Administer Flex ASM

28 Administering ASM Instances Topics

Explain and apply Automatic Storage Management (ASM) initialization parameters
Manage ASM instances and associated processes
Monitor ASM

Module 5 - RAC Database Administration

29 Installing and Configuring Oracle RAC Topics

Install the Oracle database software
Create a cluster database
Convert a single-instance Oracle database to RAC

30 Oracle RAC Administration Topics

Use Enterprise Manager Cluster Database pages
Define redo log files in a RAC environment
Define undo tablespaces in a RAC environment
Explain the benefits of Local Temporary Tablespaces
Start and stop RAC databases and instances
Modify initialization parameters in a RAC environment

31 Managing Backup and Recovery for RAC Topics

The RAC database to use ARCHIVELOG mode and the fast recovery area
RMAN for the RAC environment

32 Global Resource Management Concepts Topics

Describe the need for global concurrency control
Describe Global Resource Directory
Explain how global resources are managed
Describe about RAC global resource access coordination

33 Managing High Availability of Services Topics

Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Configure services aggregation and tracing

34 High Availability for Connections and Applications Topics

Configure client-side connect-time load balancing
Configure client-side connect-time failover
Configure server-side connect-time load balancing
Configure Transparent Application Failover (TAF)
Describe the purpose of Transaction Guard and Application Continuity
Describe the key concepts relating to Application Continuity

35 Oracle RAC One Node Topics

Perform an online database relocation
Add an Oracle RAC One Node Database to an existing Cluster
Convert an Oracle RAC One Node database to a RAC database
Use DBCA to convert a single instance database to a RAC One Node database

36 Multitenant Architecture and RAC Topics

Describe the multitenant architecture in a non-RAC environment
Describe the multitenant architecture in a RAC environment
Create a RAC multitenant container database (CDB)
Create a pluggable database (PDB) in a RAC CDB
Use default CDB and PDB services
Create PDB services to associate PDB services with server pools
Drop a pluggable database (PDB) from a RAC CDB

MODULE 6 - RAC Patching And Upgrade

37 Upgrading and Patching Grid Infrastructure Topics

Describe the types of patches and upgrades available
Plan for rolling patches and rolling upgrades
Compare software versions with the active version
Install a patch with the opatch utility
Upgrade clusterware from 12.2 to 19c including practice

38 Upgrading and Patching Oracle RAC Topics

Describe the types of patches available
Install a patch set with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility
Patching and Upgrading database from 12.2 to 19c including practice

Module 7 - Understanding & Managing Exadata

39 Exadata Database Machine: Overview Topics

Provide an overview-level description of Exadata Storage Server and the different Exadata Database Machine configurations
Exadata X8M Hardware
Exadata Database Machine X8M-2
Exadata Database Machine X8M-8
RDMA Over Converged Ethernet (RoCE): Overview
Outline the key capacity and performance specifications for Exadata Database Machine

40 Exadata Database Machine Architecture Topics

The Exadata network architecture
RDMA over Converged Ethernet (RoCE)
How multiple Exadata racks can be interconnected
The Exadata software architecture
The Exadata Storage Server storage entities and their relationships
Disk Group Configuration

41 Key Capabilities of Exadata Database Machine Topics

Exadata Smart Scan Model
Exadata Storage Index: Overview
Hybrid Columnar Compression: Overview
Exadata Smart Flash Cache: Overview
Persistent Memory (PMEM)
In-Memory Columnar Caching on Storage Servers
Exafusion Direct-to-Wire Protocol
Exadata X8M RoCE: High Priority Networking
I/O Resource Management: Overview

42 Exadata Storage Server Configuration Topics

Configure Exadata Storage Server software
Create and configure ASM disk groups using Exadata storage

43 Using Smart Scan Topics

Describe Smart Scan and the query processing that can be offloaded to Exadata Storage Server
Describe the requirements for Smart Scan
Describe the circumstances that prevent using Smart Scan
Identify Smart Scan in SQL execution plans
Use database statistics and wait events to confirm how queries are processed

HANDS-ON LABS YOU WILL WORK ON

Oracle Database & CDB/PDB Administration

RMAN Backup & Recovery

Data Guard Configuration & Failover

Oracle Clusterware & RAC Administration

ASM & Flex ASM Administration

RAC Patching & Database Upgrades

Exadata Administration & Smart Scan

Oracle Net Services & Connectivity Troubleshooting

24×7 Access to Dedicated Cloud Lab

MEET YOUR TRAINER

Akal Singh

Oracle Certified Master | Founder – AKSWAVE Solutions Pvt. Ltd. | Senior Ex. Oracle University Instructor

Experience: 24+ Years

Specialization: Oracle Database Administration, High Availability, Performance Tuning, Cloud & Virtualization.

Professional Summary

Akal Singh is a seasoned Oracle Database Administrator (DBA) and a distinguished Oracle Certified Master (OCM) — Oracle’s highest level of certification. With over 24+ years of industry experience, he brings a deep understanding of database architecture, performance tuning, high availability, and real-time enterprise implementations.

As a Senior Ex. Oracle University Instructor, Akal Singh has successfully delivered 600+ Batches, mentoring 6,000+ IT professionals worldwide, including teams from Fortune 500 companies. His unique training approach blends hands-on labs, real-world scenarios, and expert insights, making him a sought-after mentor in the Oracle DBA community.

Certifications

Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
Oracle Certified RAC Expert (OCE)
Oracle RAC 11g Release 2 and Grid Infrastructure Administration
Oracle Database 12c: RAC and Grid Infrastructure Administrator
Oracle 11g Exadata Certified Implementation Specialist
Oracle Exadata X5 Administration
Oracle Database 12c: RAC and Grid Infrastructure Administrator
Oracle 10g Certified Master (OCM)
Oracle Cloud Autonomous Database Specialist
Oracle Cloud Infrastructure Certified Associate
Foundation Certificate in IT Service Management (ITIL Certificate)

Technical Expertise

Oracle DBA

RAC

Data Guard

ASM

Exadata

GoldenGate

Scripting

Oracle Security

Enterprise Manager (OEM)

Oracle E-business Suite

OS Admin & Virtualization (VMware)

Cloud Computing (OCI Autonomous DB)

STUDENT SUCCESS STORIES

Anushka Student

★★★★★

AKSWAVE is a good place for anyone who wants practical DBA knowledge. Akal Sir explains topics clearly, gives real project examples, and encourages students to ask questions. I personally found the hands-on sessions very useful.

Soham Student

★★★★★

Swathi Student

★★★★★

Had a great experience learning DBA at AKSWAVE. Akal Sir focuses more on understanding the concepts rather than just memorizing commands. The real-time scenarios and troubleshooting discussions were especially helpful.

Marshad Student

★★★★★

Akal Sir’s way of teaching Performance Tuning is simple and practical. He explains the ‘why’ behind issues, which makes the learning much more meaningful.

nikhil Student

★★★★★

Akal Sir’s way of teaching Performance Tuning is simple and practical. He explains the ‘why’ behind issues, which makes the learning much more meaningful.

nikhil Student

★★★★★

Really happy with my training at AKSWAVE. Akal Sir explains concepts from the basics and connects them with real-world DBA scenarios. Great experience overall.

satish Student

★★★★★

Completed my GoldenGate training with Akal Sir and really liked his teaching style. He explains even complex replication concepts in a simple way and is very patient when clearing doubts.

Sandhya Rani Student

★★★★★

Nice course.Exadata X-8M training given by AKS was very good and helpful to me.The instructor straightly injected the concepts,details of the architecture of Exadata,Techniques straightly into our minds in a very efficient manner.The lab facilíties provided by AKS were very good.

LEARNING MODES

Choose the mode that fits your schedule and learning style.

CLASSROOM
TRAINING

Instructor-led training
Interactive sessions
Real-time doubt clearing
Hands-on practice

CHOOSE CLASSROOM

LIVE ONLINE
TRAINING

Live interactive classes
Learn from anywhere
Recorded sessions
Flexible schedule

CHOOSE LIVE ONLINE

SELF-PACED
LEARNING

Learn anytime, anywhere
HD recorded video lessons
3 years course access
Practice at your own speed

CHOOSE SELF-PACED

FAQs

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that particular session.

Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

You can contact our support team, or just drop an email to online@akswave.com with your queries.

For practical execution, our trainer/technical team will provide server access details to the student.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

Live-Online training is where you can have live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you so that you can see, listen and learn anytime at your feasible place. For doubts in the videos you can mail the trainer regarding the same.

If request for cancelation is made within 2 days of enrolment for class, 100% refunded.
If request made after 2 days, then Refund is made after deduction of administration fee.

Enquire Now

Download Brochure

ORACLE ADVANCE DBA

COURSE OVERVIEW

WHO SHOULD JOIN?

CAREER OUTCOMES

PRACTICE LIKE A REAL PROFESSIONAL

What You Will Learn to Do in Real-World Projects

Advanced Oracle Database Administration

RMAN Backup & Recovery

RAC & Clusterware Administration

ASM & Storage Management

RAC & Clusterware Administration

Exadata Administration

Patching & Database Upgrades

Enterprise Troubleshooting & Optimization

COURSE CURRICULUM

HANDS-ON LABS YOU WILL WORK ON

Oracle Database & CDB/PDB Administration

RMAN Backup & Recovery

Data Guard Configuration & Failover

Oracle Clusterware & RAC Administration

ASM & Flex ASM Administration

RAC Patching & Database Upgrades

Exadata Administration & Smart Scan

Oracle Net Services & Connectivity Troubleshooting

WHAT'S INCLUDED IN THIS PROGRAM

40 Live Sessions

70% Hands-On Training

100+ hrs Lab Practices

24×7 Lab Access

Resume Building

Job Support

Real-World Projects

Internship Opportunities

Technical Mentorship

Career Guidance

GitHub Portfolio

Interview Preparation

Course Completion Certificate

MEET YOUR TRAINER

Akal Singh

Professional Summary

Certifications

Technical Expertise

STUDENT SUCCESS STORIES

PLACEMENT ASSISTANCE

ResumePreparation

MockInterviews

TechnicalInterview Q&A

CompanyReferrals

PlacementSupport

UPCOMING BATCHES

LEARNING MODES

CLASSROOMTRAINING

LIVE ONLINETRAINING

SELF-PACEDLEARNING

FAQs

READY TO BECOME A TECHNOLOGY EXPERT?

Resume
Preparation

Mock
Interviews

Technical
Interview Q&A

Company
Referrals

Placement
Support

CLASSROOM
TRAINING

LIVE ONLINE
TRAINING

SELF-PACED
LEARNING