What is included in this training?

Name: ORACLE AI DATABASE and CLOUD
Rating: 5 (4414 reviews)

✅Best Oracle Database 19c/26ai DBA Cloud Training Institute

COURSE CURRICULUM

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

MODULE 1: LINUX / UNIX FOR ORACLE DBAs

01 UNIX Fundamentals & File System Topics

UNIX/Linux basic commands
User and server information
Directory navigation
File and directory management
ls, cd, pwd, cp, mv, rm
Wildcards and file types
Working with directories and nested directories
DBA filesystem structure
Oracle database file and directory practices

02 VI Editor & Configuration Files Topics

VI editor modes
Cursor navigation
Insert and edit operations
Copy, paste and delete
Search within files
Save and exit
Editing DBA configuration files
Editing shell/configuration files
VI hands-on practice

03 Filters & Log Analysis Topics

Pipes and command chaining
grep
less and more
head and tail
Searching and filtering command output
Working with Oracle log files
Alert log analysis
RMAN log analysis
Data Pump log analysis
DBA troubleshooting practice

04 Permissions & DBA Security Basics Topics

Linux permission model
User, group and others
Read / Write / Execute permissions
File vs directory permissions
Understanding ls -l
chmod symbolic method
chmod numeric method
Oracle directory permissions
Database server permission practice

MODULE 2: SQL FOR ORACLE DBAs

05 SQL Fundamentals & Data Retrieval Topics

SQL and Oracle SQL fundamentals
DDL, DML, DRL, TCL and DCL
SELECT statement
Selecting columns and expressions
Column aliases
DISTINCT
NULL values and NVL
Literals and concatenation
DESCRIBE
WHERE clause
ORDER BY
SQL query practice

06 Functions, Operators & Data Analysis Topics

Single-row functions
Character functions
Number functions
Date functions
TO_CHAR
NVL
Aggregate functions
GROUP BY
HAVING
AND, OR, NOT
BETWEEN
IN
IS NULL
LIKE
Advanced query practice

07 DML & Transaction Management Topics

INSERT
UPDATE
DELETE
Using WHERE with DML
COMMIT
ROLLBACK
SAVEPOINT
Transaction control
DML scenarios
Transaction lab exercises

08 DDL & Database Objects Topics

CREATE TABLE
Oracle datatypes
DEFAULT values
CTAS - Create Table As Select
ALTER TABLE
Add, modify, rename and drop columns
CREATE VIEW
DROP TABLE
TRUNCATE TABLE
DDL vs DML
Database object lab

MODULE 3: ORACLE DATABASE ARCHITECTURE & ADMINISTRATION

09 Oracle Database Introduction Topics

Oracle Database overview
Oracle Database editions
Database environments
Understanding the sample database used for hands-on practice
DBA role and database administration fundamentals

10 Oracle Database Architecture Topics

Oracle Database architecture
Major architectural components
Instance architecture
Memory structures
Background processes
Logical storage structures
Physical storage structures
Relationship between logical and physical storage
Multitenant architecture

11 Creating Databases, CDBs & PDBs Topics

Oracle database creation methods
Creating standard databases
CDB architecture
PDB architecture
Creating PDBs from the seed
Creating PDBs using SQL*Plus
Cloning PDBs
Unplugging and plugging PDBs
Dropping PDBs
Multitenant administration practice

12 Accessing an Oracle Database Topics

Connecting to Oracle Database
SQL*Plus
Database access tools
Oracle-supplied user accounts
Administrative users
SYS and SYSTEM
Data Dictionary
DBA_*, ALL_* and USER_* views
Querying database metadata

13 Managing Database Instances Topics

Initialization parameter files
PFILE and SPFILE
Viewing initialization parameters
Modifying initialization parameters
ALTER SYSTEM
Starting and shutting down databases
Database startup stages
Opening and closing PDBs
Automatic Diagnostic Repository - ADR
Dynamic Performance Views
V$ views
Instance administration practice

14 Oracle Net Services Topics

Oracle Net Services architecture
How listeners work
Listener configuration
Dynamic service registration
Static service registration
Local naming
listener.ora
tnsnames.ora
Testing connectivity with tnsping
Database connectivity troubleshooting
Creating database links

15 Administering User Security Topics

Creating database users
Granting privileges
System and object privileges
Creating roles
Granting roles
Revoking privileges and roles
User profiles
Assigning profiles
User quotas
Basic database security administration

16 Creating & Managing Tablespaces Topics

How table data is stored
Tablespace architecture
Creating tablespaces
Dropping tablespaces
Altering tablespaces
Viewing tablespace information
Datafiles
Oracle Managed Files - OMF
Moving online datafiles
Renaming online datafiles
Tablespace administration practice

17 Managing Storage Space Topics

Oracle space management
Automatic space management
Tablespace space usage
Monitoring free space
Proactive space management
Segment creation
Database storage monitoring
Compression concepts
Space management practice

18 Managing Undo Data Topics

DML and undo generation
Undo architecture
Undo data management
Monitoring undo
Administering undo
Undo vs redo
Undo retention
Configuring undo retention
Guaranteeing undo retention
Common undo-related issues

MODULE 4: DATABASE BACKUP & RECOVERY

19 Moving Data Topics

Methods of moving data
Oracle Data Pump architecture
Data Pump concepts
Export and import
Moving data between Oracle databases
Data migration practice

20 Backup & Recovery Concepts Topics

DBA responsibilities for backup and recovery
Database failure types
Backup and recovery strategy
Instance recovery
Complete recovery
Incomplete recovery
Recovery scenarios

21 Backup & Recovery Configuration Topics

Fast Recovery Area - FRA
Configuring the FRA
Control file multiplexing
Redo log multiplexing
Configuring ARCHIVELOG mode
Backup retention policy
RMAN backup optimization
CONFIGURE command
Archived redo log deletion policy

22 Recovery Manager - RMAN Architecture Topics

RMAN architecture
RMAN environment
RMAN command-line client
RMAN channels
RMAN repository
Media management
Fast Recovery Area
RMAN configuration practice

23 RMAN Backup Concepts Topics

Consistent and inconsistent backups
Online backups
Backup mode
Backup sets
Image copies
Multiple backup copies
Control file autobackup
SPFILE autobackup
Incremental backups
RMAN retention policies

24 Backing Up the Database Topics

RMAN backup workflow
Backup output options
Database file backups
CDB backups
PDB backups
Archived redo log backups
Incremental backups
RMAN backup commands
Backup verification practice

25 Creating Database Backups Topics

Creating consistent backups
Online database backups
Incremental backups
Backup validation
Backup scenarios
Hands-on RMAN backup exercises

26 Managing a Recovery Catalog Topics

Recovery Catalog architecture
Creating a Recovery Catalog
Registering databases
Maintaining the Recovery Catalog
Stored RMAN scripts
Managing stored scripts
Dropping a Recovery Catalog

27 Performing Database Recovery Topics

Identifying the need for recovery
Recovery options
RMAN recovery
Data Recovery Advisor
Recovering datafiles
Recovery decision-making
Recovery hands-on scenarios

28 Performing Complete Database Recovery Topics

Complete database recovery
Complete recovery process
CDB recovery
Recovery of non-critical datafiles
Recovery of critical datafiles
Recovery validation
Complete recovery lab

29 Incomplete Recovery Scenarios Topics

Understanding incomplete recovery
Loss of redo logs
Loss of control files
Loss of database files
Recovery planning
Incomplete recovery scenarios
Recovery hands-on practice

30 RMAN Incremental Backups & Point-in-Time Recovery Topics

Incremental backup concepts
Incremental backup strategy
Incremental backup and recovery
Point-in-Time Recovery - PITR
RMAN-based PITR scenarios
Recovery practice

31 Flashback Technologies Topics

Flashback technology overview
Configuring flashback features
Flashback Query
Flashback Version Query
Flashback Transaction
Transaction Backout
Flashback Table
Recycle Bin
Flashback Data Archive

32 Flashback Database Topics

Flashback Database architecture
Flashback Database requirements
Configuring Flashback Database
Flashback Database operations
Database recovery scenarios

MODULE 5: DATABASE PERFORMANCE & ADDITIONAL DBA SKILLS

33 Monitoring & Tuning Database Performance Topics

Oracle performance fundamentals
Performance monitoring methodology
Performance views
Server statistics
Database metrics
AWR
ADDM
Monitoring database instance performance
Identifying performance issues
DBA performance troubleshooting

34 Oracle Memory Management Topics

Oracle memory architecture
SGA and PGA overview
Automatic Shared Memory Management - ASMM
Automatic Memory Management - AMM
Automatic memory management concepts
Configuring automatic memory management
Memory monitoring practice

35 SQL Tuning Topics

SQL tuning methodology
Optimizer statistics
Collecting optimizer statistics
Managing optimizer statistics
SQL Tuning Advisor
Identifying SQL performance issues
SQL Access Advisor
SQL tuning practice

36 Database Optimizer & Execution Plans Topics

Oracle Optimizer
Execution plans
Understanding execution plan operations
Reading execution plans
DBMS_XPLAN
Database tracing
Services and tracing
trcsess
tkprof
Execution plan analysis

37 Database Duplication & Cloning Topics

Database duplication concepts
Purpose of database cloning
RMAN DUPLICATE
Creating a duplicate database
Duplicate database from a running instance
Database cloning scenarios
RMAN duplication hands-on practice

MODULE 6: ORACLE CLOUD FOUNDATION FOR DBAs

38 OCI Fundamentals for Oracle DBAs Topics

Oracle Cloud Infrastructure - OCI overview
Cloud computing fundamentals
OCI regions and availability domains
OCI compartments and tenancy
OCI Console and core services
Identity and Access Management - IAM
Users, groups, policies and compartments
Virtual Cloud Network - VCN
Subnets, route tables and security lists
Internet Gateway and NAT Gateway
Network connectivity fundamentals

39 Oracle Database Services on OCI Topics

Oracle Database options on OCI
OCI Base Database Service
Oracle Database Service architecture
Autonomous Database overview
Exadata Database Service overview
Selecting the right database service
Compute, storage and networking concepts for DBAs
Database provisioning concepts
Database lifecycle management

40 Provisioning & Connecting to Oracle Database Topics

Provisioning an Oracle Database on OCI
Database configuration options
Connecting to cloud databases
SQL*Plus connectivity
Oracle Net connectivity in OCI
Private and public connectivity concepts
Security considerations for database connectivity
Troubleshooting cloud database connectivity

41 Database Backup, Monitoring & Maintenance on OCI Topics

OCI database backup concepts
Automatic and manual backups
Recovery fundamentals
Database monitoring
Metrics and alarms
Database health monitoring
Logging fundamentals
Patching concepts
Database maintenance
Cloud DBA operational practices

42 OCI Hands-on for Oracle DBAs Topics

OCI Console navigation
Create and manage compartments
Configure IAM policies
Create a VCN and subnet
Configure database connectivity
Provision an Oracle Database service
Connect to the database
Monitor database resources
Configure backup
Perform basic database administration on OCI

MODULE 7: ORACLE AI DATABASE 26ai FOR DBAs

43 Oracle AI Database 26ai - Introduction Topics

Oracle AI Database 26ai overview
Evolution from traditional Oracle Database to AI Database
Key new capabilities for DBAs
AI workloads inside the database
AI-ready database architecture
Understanding AI and database convergence
New database capabilities and administration considerations

44 Vector Data & Vector Search Topics

Vector data fundamentals
Vector datatype
Embeddings and vectors
Vector storage in Oracle Database
Vector indexes
Vector search concepts
Similarity search
Distance metrics
SQL-based vector search
DBA considerations for vector workloads

45 AI Workloads, RAG & Database Architecture Topics

Generative AI fundamentals for DBAs
Large Language Models - LLMs
Embeddings
Retrieval-Augmented Generation - RAG
Oracle Database as a RAG data store
AI application architecture
Relational + vector data
AI workloads inside Oracle Database
Data security considerations for AI workloads

46 Managing AI-Ready Oracle Databases Topics

AI Database administration concepts
Managing vector data
Storage considerations
Index management
Performance considerations for vector search
Monitoring AI/database workloads
Security and access control
Backup and recovery considerations
Database lifecycle considerations
DBA responsibilities in AI-enabled environments

47 Oracle AI Database 26ai - DBA Hands-on Topics

Create and manage vector data
Work with vector datatype
Generate/use embeddings
Create vector indexes
Perform similarity searches
Execute vector SQL queries
Build a basic RAG workflow
Monitor AI-related database operations
Explore AI Database DBA scenarios
AI Database hands-on project

HANDS-ON LABS YOU WILL WORK ON

ORACLE INSTALLATION

LINUX/UNIX ADMINISTRATION

DATABASE CONFIGURATION

MULTITENANT DATABASE

RMAN BACKUP & RECOVERY

ASM STORAGE MANAGEMENT

RAC IMPLEMENTATION

PERFORMANCE TUNING

24×7 Access to Dedicated Cloud Lab

MEET YOUR TRAINER

Akal Singh

Oracle Certified Master

24+ Years of Experience

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)

Oracle DBA RAC Data Guard ASM Performance Cloud

STUDENT SUCCESS STORIES

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!

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.

Enquire Now

Download Brochure

ORACLE AI DATABASE and CLOUD

COURSE OVERVIEW

WHO SHOULD JOIN?

CAREER OUTCOMES

PRACTICE LIKE A REAL PROFESSIONAL