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.

Oracle 19c DBA Training in Chennai | Best Institute

COURSE CURRICULUM

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

Module 1 - Database Administration

01 Introduction Topics

Describe the differences in Oracle Database editions
Explain the sample database that will be used in the course practices

02 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

03 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

04 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

05 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

06 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

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 Creating and Managing Tablespaces Topics

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

09 Managing Storage Space Topics

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

10 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

11 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

12 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

13 Backup and Recovery Configuration Topics

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

14 Recovery Manager Architecture Topics

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

15 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 Autobackups
About RMAN Incremental Backups & Retention Policies

16 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
Making Database Backups for Long-Term Storage

17 Creating Database Backups Topics

Create consistent database backups
Back up your database without shutting it down
Create incremental backups

18 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

19 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

20 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

21 Performing In-Complete Recovery Scenarios Topics

Incomplete Recovery scenarios Loss of Redologs
Incomplete Recovery scenarios Loss of Controlfiles
Incomplete Recovery scenarios Loss of All Files

22 RMAN Incremental Backups and Point-inTime Recovery Topics

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

23 RMAN Troubleshooting and Maintenance commands Topics

Troubleshooting backups using RMAN
List, report, croscheck and delete maintenance commands

24 Using Flashback Technologies Topics

Understand and configure your database to use flashback technologies
Perform FB query, version query, transaction backout
Perform FB table, recyclebin, flashback data archive

25 Using Flashback Database Topics

Describe Flashback Database architecture
Configure your database to support Flashback Database

Module 3 - Database Tuning & Additional Topics

26 Monitoring and Tuning Database Performance Topics

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

27 Memory Management Topics

Overview ASMM & Automatic Memory Management (AMM) concepts
Configure automatic Memory Management

28 Tuning SQL Topics

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

29 Database Optimizer and Execution Plan Topics

Understand Optimizer & Execution Plan
DB Tracing ( Services, trcsess, tkprof ), DBMS_XPLAN

30 Duplicating a Database / Database Cloning Topics

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

31 Data Guard Architecture & Configuration Topics

Understand Hiigh Availability and the requirement of Data Guard
Configure and Manage Dataguard Setup
Dataguard Roles, Modes and perform Switchover & Failover

32 Software Installations Topics

Installing Oracle Linux and Oracle database software
Creating database using DBCA

33 Understand Database Patching & Upgrade Topics

Understand Database Patching & Upgrade

HANDS-ON LABS YOU WILL WORK ON

MEET YOUR TRAINER

Trainer information is currently being updated.

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.

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.

Rithika Student

★★★★★

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. ...Let's see when the Golden Gate classroom training will start.

Anumitha Reddy Student

★★★★★

Excellent oracle DBA training! Akali sir's teaching is top-notch,backed by his 24 years of experience.The institute has a great learning environment and offers lab access for a month after training.Highly recommend!

swathi Student

★★★★★

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

Sandeep kumar Student

★★★★★

I have attended Oracle DBA and RAC classes recently in AKSWAVE Oracle trainings institute. Mr.Akal Singh is the one of the best triner in Hyderabad for Oracle courses.Well structured Course content and Excellent Lab facilities are available.

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 19c DBA Training in Chennai

COURSE OVERVIEW

WHO SHOULD JOIN?

CAREER OUTCOMES

PRACTICE LIKE A REAL PROFESSIONAL

What You Will Learn to Do in Real-World Projects

COURSE CURRICULUM

HANDS-ON LABS YOU WILL WORK ON

WHAT'S INCLUDED IN THIS PROGRAM

35 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