COURSE CURRICULUM
44+ Course Topics • Hands-on Labs • Real-Time Practice
COURSE MODULES
01
Administering User Security
Topics
- Create and manage database user accounts:
- Grant and revoke privileges
- Create and manage roles & profiles
02
Managing the Database Instance
Topics
- Start and stop the Oracle database instance and components
- Modify database initialization parameters
- Describe the stages of database startup & shutdown options
- Access dynamic performance views & view alert log
03
Managing Database Storage Structures
Topics
- Describe the storage of table row data in blocks
- Create and manage tablespaces & obtain information
04
Exploring Oracle Database Architecture
Topics
- List the major architectural components of Oracle Database
- Explain memory structures and background processes
- Correlate logical and physical storage structure
- Describe pluggable databases
05
Managing Data Concurrency
Topics
- Describe the locking mechanism and how Oracle manages concurrency
- Monitor and resolve locking conflicts
06
Managing Undo Data & Temp
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
07
Configuring the Oracle Network Environment
Topics
- Create Listeners, Net Service aliases
- Use the Listener Control Utility to manage Oracle Net Listener
- Use tnsping to test Oracle Net connectivity
- Identify when to use shared servers and when to use dedicated servers
08
Implementing Oracle Database Auditing
Topics
- Describe DBA responsibilities for security and auditing
- Enable and create unified auditing policies
- Maintain the audit trail
09
Moving Data
Topics
- Explain the general architecture of Oracle Data Pump
- Describe ways to move data, Create and use directory objects
- Use Data Pump Export and Import to move data between Oracle DBs
- Use SQL*Loader to load data from a non-Oracle DB (or user files)
- Use external tables to move data via platform-independent files
10
Backup and Recovery Concepts
Topics
- Describe database architecture as it relates to backup and recovery
- Describe NOARCHIVELOG mode & tools for backup and recovery
- Perform basic backup and recovery
11
Configuring for Recoverability
Topics
- Configure and manage RMAN settings, Configure FRA
- Configure the control files & redo log files for recoverability
- Configure ARCHIVELOG mode and the archived redo log files for recoverability
12
Using the RMAN Recovery Catalog
Topics
- Describe the use of the RMAN recovery catalog, Create Catalog
- Register a database in the RMAN recovery catalog
13
Backup Strategies and Terminology
Topics
- Describe Oracle backup solutions, RMAN backup types
- Describe, compare, and determine your backup strategy
- Schedule backups accordingly, perform whole backups
14
Performing Backups
Topics
- Perform full and incremental backups
- Use Oracle-suggested backup strategy, Report and manage backups
- Begin refining your basic backups:
- Configure Block Change tracking, Perform incremental level backups
- Recover an incremental level 0 backup with level 1 incremental
15
Improving Your Backups
Topics
- Compress backups, Use media manager
- Create multi-section backups of very large files
- Create proxy copies, duplexed backup sets, archival backups
- Back up other files:
- Back up a control file to trace
- Back up archived redo log files, ASM metadata
- Catalog additional backup files
16
Using RMAN-Encrypted Backups
Topics
- Describe and create RMAN-encrypted backups
- Use Transparent-mode, Password-mode & Dual-mode encryption
17
Diagnosing Database Failures
Topics
- Detect and repair database corruption
- Use the Automatic Diagnostic Repository (ADR)
- Analyze instance recovery with ADRCI
- Use the Data Recovery Advisor
18
Restore and Recovery Concepts
Topics
- Understand how to employ the best Oracle Database recovery technology for your failure situation
- Describe instance or crash recovery
- Describe complete and point-in-time recovery
- Describe recovery through RESETLOGS
19
Performing Recovery, Part
Topics
- Perform the appropriate type of restore and recovery
- Recover from media failures in data files
- Perform complete and incomplete or “point-in-time” recoveries
20
Performing Recovery, Part
Topics
- Recover from the loss of the server parameter file
- Recover from control file and redo log file failures
- Re-create the password authentication file
- Recover index and read-only tablespaces
- Review the automatic recovery of the tempfile
- Describe the basic procedure of restoring the database to a new host
21
Performing Point-in-Time Recovery
Topics
- Distinguish and describe point-in-time recovery (PITR) of table, tablespace, and database
- List what operations occur when you perform a point-in-time recovery
- Determine the correct target time for the point-in-time recovery
- Perform automated TSPITR, Perform table recovery from backups
22
Using Flashback Technologies
Topics
- Understand flashback technologies from various types of errors
- Configure your database to use flashback technologies
- Perform flashback query, version query, transaction backout
- Perform flashback table, recyclebin, flashback data archive
23
Using Flashback Database
Topics
- Describe Flashback Database architecture
- Configure your database to support Flashback Database
24
Managing Backup Space or Transporting Data
Topics
- Transport tablespaces between databases by using image copies or backup sets
- Transport databases by using data files or backup sets
25
Duplicating a Database ( Database Cloning )
Topics
- List the purposes and create duplicate database with RMAN
- Duplicate a database based on a running instance
26
Performing Database Maintenance
Topics
- Manage the Automatic Workload Repository (AWR)
- Use the Automatic Database Diagnostic Monitor (ADDM)
- Describe and use the advisory framework
- Set alert thresholds, Use server-generated alerts
27
Managing Performance
Topics
- Enterprise Manager to monitor performance
- Automatic Memory Management (AMM)
- The Memory Advisor to size memory buffers
28
Managing Performance: SQL Tuning
Topics
- Manage optimizer statistics
- Use the SQL Tuning Advisor to:
- Identify SQL statements that are using the most resources
- Tune SQL statements that are using the most resources
- Use the SQL Access Advisor to tune a workload
29
Managing Resources by Database Resource Manager
Topics
- Configure the Database Resource Manager
- Access and create resource plans, Create consumer groups
- Map consumer groups to plans, Activate a resource plan
- Monitor the Resource Manager
- Automating Tasks by Using Oracle Scheduler
30
Managing Space
Topics
- Describe how the Oracle Database server automatically manages space
- Save space by using compression
- Control deferred segment creation & Use the Segment Advisor
- Reclaim wasted space using the segment shrink
- Manage resumable space allocation
31
Container and Pluggable Database Architecture
Topics
- Describe the multitenant architecture
- Describe the root and pluggable database containers
- Differentiate the root from a pluggable database
- Explain pluggable database plugging
- List impacts in various areas
32
CDB and PDB Creation
Topics
- Configure and create a CDB, Create a PDB from PDB$SEED
- Plug or clone a non-CDB into a CDB
- Clone a local or remote PDB into a CDB
- Unplug and plug a PDB from one CDB to another CDB
- Explore the instance and structure of PDBs
- Migrate a pre-12.1 non-CDB database to CDB
33
Managing a CDB and PDBs
Topics
- Connections to CDB / PDB, Start up and shut down a CDB
- Open and close PDBs
- Change the different modes and settings of PDBs
- Evaluate the impact of parameter value changes
34
Managing Tablespaces and Users in CDB and PDBs
Topics
- Permanent & temporary tablespaces in CDB and PDBs
- Common and local users, roles and privileges
35
Backup, Recovery, and Flashback CDBs and PDBs
Topics
- Perform CDB and PDB backups
- Recover CDB and PDB from essential file loss
- Perform flashback database
36
Managing Performance
Topics
- Describe activity tracking with Heat Map
- Describe Automatic Data Optimization
- Use views and procedures to monitor ADO
- Move a data file online, Move a partition online
37
Miscellaneous
Topics
- Describe the new RMAN enhancements
- Perform cross-platform data transport
- Use Table Recovery
38
Data Guard Architecture and Configuration
Topics
39
Oracle Linux Installation
Topics
40
Oracle Grid Infrastructure Installation
Topics
41
Administering ASM Instance & Disk Groups
Topics
42
Database Software Installation & database creation (DBCA)
Topics
43
Oracle Database Patching
Topics
44
Oracle Database Upgrades
Topics
WHAT'S INCLUDED IN THIS PROGRAM
40 Live Sessions
60+ hrs Recordings
70% Hands-On Training
30% Essential Theory
NA+ hrs Lab Practices
Guided Implementation
24×7 Lab Access
Practice Anytime
Resume Building
LinkedIn Optimization
Job Support
Post-Placement Support
Real-World Projects
Industry Capstone Projects
Internship Opportunities
Hands-on Exposure
Technical Mentorship
Expert-Led Guidance
Career Guidance
Personalized Roadmap
GitHub Portfolio
Project Documentation
Interview Preparation
Mock Interviews
Course Completion Certificate
- Verified Achievement
- Course Completion
- Certification Support
- Project Portfolio Included
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
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
LIVE ONLINE
TRAINING
- Live interactive classes
- Learn from anywhere
- Recorded sessions
- Flexible schedule
SELF-PACED
LEARNING
- Learn anytime, anywhere
- HD recorded video lessons
- 3 years course access
- Practice at your own speed
FAQs
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.
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.
For practical execution, our trainer/technical team will provide server access details to the student
Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.
Live-Online training is where you can have live session with the trainer and clarify queries parallely.
Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.
You can contact our support team, or just drop an email to online@akswave.com with your queries.
The course material and recorded videos which are provided during the course period. You can download it anytime.
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.
* 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.
READY TO BECOME A TECHNOLOGY EXPERT?
Join 2,567+ learners who have chosen AKSWAVE for practical training.
