Trainer

24 yrs exp

Duration

35 Days

Recordings

60 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

The Oracle 19c DBA Training focuses on delivering hands-on expertise in Oracle database management, from installation to advanced performance tuning and high availability.

By the end of the course, participants will be able to:

  • Oracle Database Architecture — Understand architecture and memory structures.
  • Database Creation and Management — Create and manage CDBs and PDBs.
  • Oracle Net Services — Configure listeners and database links.
  • User Management & Security — Manage users, roles, and profiles.
  • Storage Management — Create tablespaces and implement encryption.
  • Backup & Recovery — Configure RMAN backups and redo log multiplexing.
  • RMAN Operations — Perform backups, recovery, and troubleshooting.
  • Flashback Technologies — Recover data using flashback archives.
  • Performance Tuning — Optimize performance with AWR and ADDM.
  • High Availability & Advanced Topics — Implement Data Guard, patching, and cloning.

✅ Real-time case studies | ✅ Practical hands-on labs | ✅ Certification Guidance

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

Oracle SQL and Basics of Linux commands

Course Overview

Course Content

Expand All
  • Describe the differences in Oracle Database editions
  • Explain the sample database that will be used in the course practices
  • List the major architectural components of Oracle Database
  • Explain memory structures
  • Describe background processes
  • Correlate logical and physical storage structures
  • Describe multitenant architecture
  • 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
  • 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
  • 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
  • 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
  • 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
  • Explain how table data is stored in the database
  • Use SQL*Plus to:
  • 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
  • Describe how the Oracle Database server automatically manages space
  • Save space by using compression
  • Proactively monitor and manage tablespace space usage
  • Describe segment creation in the Oracle database
  • Control deferred segment creation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Manage resumable space allocation
  • 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
  • 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
  • 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
  • About Configuring the Environment for RMAN Backups
  • 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
  • About the RMAN Environment
  • About RMAN Command-Line Client and Channels
  • About the RMAN Repository
  • About Media Management Using RMAN
  • About the Fast Recovery Area
  • 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 Autobackups
  • About RMAN Incremental Backups & Retention Policies
  • 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
  • Making Database Backups for Long-Term Storage
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • 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
  • Determine the need for performing recovery
  • Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor and Recovery datafiles
  • 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
  • Incomplete Recovery scenarios Loss of Redologs
  • Incomplete Recovery scenarios Loss of Controlfiles
  • Incomplete Recovery scenarios Loss of All Files
  • Overview of RMAN Incremental Backups
  • Performing Incremental Backups & recovery scenario
  • Performing point-in-time Recovery (PITR) scenarios
  • Troubleshooting backups using RMAN
  • List, report, croscheck and delete maintenance commands
  • Understand and configure your database to use flashback technologies
  • Perform FB query, version query, transaction backout
  • Perform FB table, recyclebin, flashback data archive
  • Describe Flashback Database architecture
  • Configure your database to support Flashback Database
  • Describe the activities to manage database performance
  • Use Enterprise Manager, Performance views, AWR and ADDM to monitor database instance performance
  • Describe the Oracle performance tuning methodology
  • Describe the server statistics and metrics collected
  • Overview ASMM & Automatic Memory Management (AMM) concepts
  • Configure automatic Memory Management

  • Describe the SQL tuning methodology
  • Collect and Manage Optimizer statistics
  • Use SQL Tuning Advisor to identify and tune SQL statements
  • Use SQL Access Advisor to tune a workload
  • Understand Optimizer & Execution Plan
  • DB Tracing ( Services, trcsess, tkprof ), DBMS_XPLAN
  • List the purposes and create duplicate database with RMAN
  • Duplicate a database based on a running instance
  • Understand Hiigh Availability and the requirement of Data Guard
  • Configure and Manage Dataguard Setup
  • Dataguard Roles, Modes and perform Switchover & Failover
  • Installing Oracle Linux and Oracle database software
  • Creating database using DBCA
  • Understand Database Patching & Upgrade
Download Brochure

Modes of Training

Akswave_classroom

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Akswave_Online

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Akswave_Selfpaced

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 24 yrs experience, delivered 650+ batches.
  • QUALITY CONTENT : Covers in-depth and industry-relevant advance topics.
  • LAB ACCESS : Practice hands-on with dedicated online servers, anytime, anywhere.
  • BEST PRICE : Best value training at a competitive price.
  • SESSION RECORDINGS : Access to session recordings for easy revision.
  • REAL-TIME SCENARIOS : Learn through practical scenarios and live projects.
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 24 yrs exp
  • 35 Live classroom sessions
  • Access for 60+ hrs of Recorded videos
  • Reading material and Lab activity guide
  • One-to-one dedicated server access for practice
  • 100 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Certified technical assistance
31-Jul

9:00am to 10:30am IST

35 Days (Mon-Fri)

04-Aug

9:00am to 10:30am IST

35 Days (Mon-Fri)

07-Aug

9:00am to 10:30am IST

35 Days (Mon-Fri)

Course Fee : ₹ 20,000/-

Discount : ₹ 5,000/- (25%)

Offer Price : ₹15,000/-

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 24 yrs exp
  • 35 Virtual online sessions
  • Access for 60+ Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 100 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
30-Jul

9:00am to 10:30am IST

35 Days (Mon-Fri)

05-Aug

9:00am to 10:30am IST

35 Days (Mon-Fri)

08-Aug

9:00am to 10:30am IST

35 Days (Mon-Fri)

Course Fee : ₹ 30,000/-

Discount : ₹ 6,000/- (20%)

Offer Price : ₹24,000/- $280

SELF-PACED LEARNING

This Course Includes:
  • Access for 60+ Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 100 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

₹18,000/-

Our Instructor

Akal Singh

Akal Singh

Oracle Certified Master

  • 4.9 Instructor Rating
  • 8,852 Reviews
Akal Singh stands at the forefront of the fastest-evolving technologies in the IT industry. With over 24 years of experience as an Oracle DBA, he has honed expertise in DBA support, high availability design and implementation, technical solutions, automation through scripting, and database design. In addition to his technical skills, Akal Singh has made a significant impact as a corporate trainer.

He holds an impressive array of certifications, including OCP, Oracle Certified Expert/Specialist (OCE), and Oracle Certified Master (OCM). His extensive technical knowledge spans operating system administration, virtualization/VMWare, and multiple Oracle Database versions—from 8i through 23ai. His skills also cover Hardware, OS Administration, DBA, Oracle Apps, RAC, Data Guard, ASM, Oracle Exadata, performance tuning, Golden Gate, Streams, and advanced security measures.

Recognized as a Senior Corporate Instructor, Akal Singh has also served with Oracle University, delivering over 300 corporate trainings on advanced database concepts. His deep industry insights and real-time project implementations continue to influence the IT and database community significantly.

Certifications include :
  • 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)

Demo Video

No Video Found

No Demo Video

Certification Guidence

  • This course is specifically designed to help you successfully clear the Oracle Database Administration 2019 Certified Professional certification exam. Our comprehensive course content, combined with guidance from expert trainers, ensures that you gain the skills and knowledge needed to confidently pass the certification.

    Certification Details:
    This certification requires passing two exams:
    ✅ Upon Course completion: You will receive the Akswave Course Completion Certificate, validating your achievement and readiness for industry opportunities.
AksWave Certificate

Faq

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.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8M & X10M
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Suraj Kumar
3 months ago

I had privilege of learning 19c Oracle DBA course from Akal Sir from AKSWAVE Tranings. I am extremely grateful for the opportunity to learn from Akal Sir, It was very Informative, interactive, and well-structured teaching everting was effectively explained complex concepts with clarity, making them easy to understand. His teaching style was engaging, with plenty of real-world examples and hands-on practice. Sir provided additional support whenever needed. I feel more confident in my DBA Skills thanks to his dedication and guidance. Overall, it was an excellent learning experience.

Shailesh Kumar
5 months ago

I took a oracle dba course from akswave oracle training institute..Mr.Akal singh sir is very good teaching and good lab environment..this is the best institute in Hyderabad.

AKAL SINGH S
10 months ago

Nice training program

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8