Oracle DBA Training in Bangalore

Mindmajix Technologies

Learn the administrative concepts required to manage and monitor multiple Oracle databases, functionalities, and architecture.

Online

50 Hours

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based	Frequency of Classes Weekdays, Weekends

Course overview

MindMajix Technologies offers the Oracle DBA Training in Bangalore online certification for professionals looking for opportunities to gain knowledge of both fundamental and core concepts of database management. The Oracle DBA Training in Bangalore online classes are designed with two distinct learning methods that cater to two distinct audiences with distinct learning preferences.

Oracle DBA Training in Bangalore online course by MindMajix Technologies is taught by specialists that strive to convey all of the fundamentals required for beginners and advanced levels in real-time. This course covers DBA concepts such as multi-tenant architecture, container naming, pluggable databases, PDB structures, cloning PDBs, and changing PDB modes. Applicants will collaborate with professionals on two real-world projects to get practical expertise with local temporary tablespaces, local schemas, revoking roles, generating non-shared objects, partial PDB backup, Flashback CDB, heat map, and archiving solutions.

The highlights

Certificate of completion
Certification oriented curriculum
Lifetime self-paced video access
Flexible schedule
Project use cases
50 hours session
Quizzes & Mocks
Free demo on request
One-on-one doubt resolution
100% money-back guarantee
24/7 lifetime assistance

Program offerings

Certificate of completion
Certification oriented curriculum
Lifetime self-paced video access
Flexible schedule
Project use cases
50 hours session
Quizzes & mocks
Free demo on request
One-on-one doubt resolution

Course and certificate fees

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

Who it is for

Computer systems administrator Network engineer

What you will learn

Knowledge of computer networking

After completing the Oracle DBA Training in Bangalore certification course, applicants will be acquainted with the fundamentals of Oracle Database Administrator. Applicants will learn the principles of multi-container databases and pluggable databases, as well as how to create and manage them. Applicants will gain knowledge of automatic data optimization, heat maps, and managing tablespaces and users in CDB and PDB. Applicants will also learn about audits, auditing types, and security, as well as the Oracle data pump, SQL*loader, and recovery manager.

The syllabus

Module 1 - Oracle Database Architecture

Oracle Database Architecture Overview
Oracle ASM Architecture Overview
Process Architecture
Memory structures
Logical and physical storage structures
Architecture 2
Architecture 3

Module 2 - Installing your Oracle 19c Software

Tasks of an Oracle Database Administrator
Tools Used to Administer an Oracle Database
Installation: System Requirements
Oracle Universal Installer (OUI)
Installing Oracle Database Software on Linux 7

Module 3 - Creating an Oracle Database

Planning the Database
Create Manual database
Using the DBCA to Create a Database
Password Management
Using the DBCA to Delete a Database

Module 4 - Managing the Oracle Instance

Start and stop the Oracle database and components
Access a database with SQLPlus
Modify database installation parameters
Describe the stages of database startup
Describe database shutdown options
View the alert log
Access dynamic performance views

Module 5 - Managing Database Storage Structures(TABLESPACE MANAGEMENT)

Storage Structures
How Table Data Is Stored
Anatomy of a Database Block
Space Management in Tablespaces
Tablespaces in the Preconfigured Database
Actions with Tablespaces
Oracle Managed Files (OMF)
spfile and pfile management

Module 6 - Administering User Security

Database User Accounts
Predefined Administrative Accounts
Benefits of Roles
Predefined Roles
Implementing Profiles

Module 7 - Managing Undo Data

Data Manipulation
Transactions and Undo Data
Undo Data Versus Redo Data
Configuring Undo Retention

Module 8 - Flashback

Flashback query, Flashback version query
Flashback transaction query, Flashback drop table

Module 9 - Oracle Networking

Create and configure the Listener
Use tnsping to test Oracle Net connectivity
Database links and materialized views

Module 10 - Controlfile and redologfile management

Controlfile multiplexing
DB renaming
Redolog file multiplexing
Archivelog mode and NO Archivelog mode

Module 11 - Backups

Logical backup ---- Exp, Expdp(datapump)
Physical backup ----- Cold and hot backup
Rman

Module 12 - RMAN Topics

Backup Strategies
RMAN Architecture
RMAN backup components
RMAN catalog and configuration
RMAN Commands
Monitoring RMAN backups
Restoring and recovering using RMAN
Database cloning using RMAN
Best practices

Module 13- Performing Database Backups using RMAN

Backup Solutions: Overview
Oracle Secure Backup
User-Managed Backup
Terminology
Recovery Manager (RMAN)
Configuring Backup Settings
Backing Up the Control File to a Trace File
Opening a Database
Data Recovery Advisor
Loss of a Control File
Loss of a Redo Log File
Data Failures
Listing Data Failures

Module 14 - Using the RMAN Recovery Catalog

Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts --- local, global scripts
Back up the recovery catalog
Create and use a virtual private catalog

Module 15 - Configuring Backup Specifications

Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Module 16 - Using RMAN to Create Backups

Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup

Module 17 - Performing User-Managed Backup and Recovery

Recover from a lost TEMP file and redo log group
Recover from the loss of password file
Perform user-managed complete and incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

Module 18 - Using RMAN to Perform Recovery

Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Using RMAN to Duplicate a Database
Creating a duplicate database
Using a duplicate database

Module 19 - RMAN

Block change tracking
Incremental,complete, cumulative backup
Virtual private catalog
Tablespace point in time recovery
Table level recovery
Flashback database, Flashback data archive

Module 20 - Implementing Oracle Database Auditing

Describe DBA responsibilities for security
Enable standard database auditing
Specify audit options
Unified auditing
Review audit information
Maintain the audit trail
Manage optimizer statistics
Manage the Automatic Workload Repository (AWR)
Use the Automatic Database Diagnostic Monitor (ADDM)
Describe and use the advisory framework
Use server-generated alerts
Use automated tasks

Module 21 - Performance Management

Performance Monitoring
Managing Memory Components
Enabling Automatic Memory Management (AMM)
Automatic Shared Memory Advisor
Using Memory Advisors
Dynamic Performance Statistics
Troubleshooting and Tuning Views
Invalid and Unusable Objects

Module 22 - Manage the ASM Instance

Set up initialization parameter files for ASM instance
Start up and shut down ASM instances
Administer ASM disk groups

Module 23 - ASM TOPICS

Database Architecture and ASM
Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups
Storage Fundamentals
ASM Concepts
Preparing ASM Storage
ASM Instance setup
ASM diskgroupsFailure groups (Redundancy)
Managing Diskgroups
Backing up Diskgroups
Monitoring Diskgroups
Creating Database on ASM
Managing Database on ASM
Basic architecture
Storage concepts

Module 24 - Multitenent Database architecture

Creating container databases(CDB) using DBCA
Creating pluggable databases(PDB)
Managing pluggable databases
Start and stop of pluggable databases
Export and import of PDBS
Cloning methods of PDB databases

Module 25 - Data guard/Standby database/DR site

Configuring Standby database
Changing protection modes
Switchover , failover

Module 26 - Upgrade database from 12c to 19c

Upgrade 12c db to 19c using dbua
Upgrade 12c db to 19c using manual scripts

Module27 - Oracle 23ai Orientation for DBAs

What changes in 23ai: AI Vector Search and the native VECTOR datatype
JSON Relational Duality Views
True Cache
Lock-Free Reservations and Priority Transactions
Using Oracle Database 23ai Free for practice
The supported 19c → 23ai upgrade/patch path.

Module 28 - Automation & Cloud Orientation for DBAs

Shell scripting and Python for routine DBA automation
Automating Data Pump and RMAN jobs
Introduction to Oracle Cloud Infrastructure (OCI) database services
Autonomous Database, and where the DBA role is heading.

Module29 - Practice Test & Interview Questions

Instructors

Ms Ashwini
Instructor
Mindmajix Technologies

Articles

Trending Courses

Popular Courses

General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Data Science Courses Cyber Security Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Swayam Courses Edx Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses IIT Kanpur Courses Emeritus Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Open in App

Get the Careers360 App today!

And never miss an important update

Download Careers360 App

All this at the convenience of your phone

Regular Exam Updates
Best College Recommendations
College & Rank predictors
Detailed Books and Sample Papers
Question and Answers

Popular Searches