Home / Online Oracle DBA Training

Online Oracle DBA Training

Course : Online Oracle DBA Training

Course Highlights:

We provide real time environmental support during our training which helps people to professionally learn and improve their skills. Our trainers will assist you in resume and interview preparations, showing live scenarios, on-call support even after training.

Salient Features:

  • Add-On supporting technologies such as SQL and Unix.
  • You will be proficient in Oracle database Architecture, Installation of Operating System and Oracle Software
  • More focus on High Availability features including Dataguard, RAC etc.
  • Course is designed in a way to provide more support on real time practical activities such as migration technologies etc.

About Faculty:

Real Time experienced professional with good coaching skills.

About Us:

DBA Centre was started in the year 2012 with a vision to provide online and classroom training’s worldwide. We are committed to provide high quality service with aim to satisfy each candidate.

Course Topics:

Main topics are highlighted here.

  • Oracle Database Architecture
  • Oracle Software Installations
  • Managing Schemas
  • Tablespace Management
  • Oracle Managed Files (OMF)
  • Data Encryption
  • Oracle Data Pump
  • Backup and Recovery
  • Migration Technologies (RMAN Cloning, Cross Platform Migration etc)
  • Dataguard (Managing Standy databases)
  • ASM Management

Other Advanced Courses offered:

  • Real Application Clusters
  • Golden Gate

What You will learn:

After going through this course, students will get thorough knowledge about ORACLE database architecture concepts. They will be able to install, configure and manage databases on Linux platform. Students will also get real time issues and problems solving skills which will help them in confidently facing the interviews. Complete course content can be referred below:



Sl. No
1. Introduction to RDBMS
  • What is Database? Why Database?
  • Major Databases and Database Vendors, Editions
  • Roles and Responsibilities of DBA
2. Software Installation
  • Requirements for Installation
  • Installation steps for REDHAT linux and OEL
  • Oracle 11g software installation using ORACLE universal installer
3. Introduction to Unix and SQL
  • Basic Linux commands necessary for DBA
  • User and group creation in Linux and permissions
  • Basic SQL operations like DDL, DML, TCL etc
4. Oracle Database Configuration
  • Planning the database
  • Create Database using Database Configuration Assistant
  • Database creation manual steps
  • Database & Instance
5. Oracle Database Architecture (General Overview)
  • Memory Structures – Instance (SGA & PGA)
  • Background Processes and Server Processes
  • Logical and Physical structures
6. Starting and Stopping Database
  • Startup and Shutdown methods
  • Use and necessity of startup modes
  • Read-only & Restricted modes
7. Parameters and Parameter Files
  • Initialization Parameters
  • Static and Dynamic parameters
  • Parameter Files (PFILE & SPFILE)
  • System & Session Level Parameters
  • Alter and update parameters
8. Data Dictionary Views
  • Understanding Data Dictionary
  • Static & Dynamic Performance Views
  • Using Data Dictionaries
9. Diagnostic Data Management
  • Diagnostic files and its usage
  • Automatic Diagnostic Repository (ADR)
  • Viewing Diagnostic data
10. Oracle Database Architecture (In detail)
  • Database structure
  • Blocks, Extents, Segments
  • Logical vs Physical structures
  • Background processes vs memory structures
11. Datafiles and Tablespace Management
  • Understanding Tablespace and Data Files Concepts
  • Explain logical structures Blocks, Extents and Segments
  • Understanding Space Management
  • Creating & Managing Tablespaces
  • Big file Tablespaces
  • Tablespace Quotas
  • Configuring Multi-Block Support
12. Oracle Managed Files (OMF)
  • Use and necessity of OMF management
  • File Naming Conventions using OMF
  • Creating Tablespaces and Datafiles with OMF
13. Managing Temporary Tablespaces
  • Understanding Temporary Tablespaces
  • Managing Temporary Tablespaces
  • Temporary Tablespace Groups
14. Managing Security for Users
  • Creating Users Accounts
  • Account management
  • Schema , Session
  • Using profiles to implement complex
  • passwords and resource limits
15. User Privileges and Roles
  • Understanding Privileges , Managing Privileges
  • Understanding Roles, Managing Roles
16. Managing Undo Data
  • Transactions and Undo Data ,Configuring Undo Retention
  • Managing Undo data , Creating Undo Tablespaces
17. Managing Control Files
  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files
18. Redo Log Files and Archiving
  • Online & Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode
19. Oracle Net Services
  • Understanding Oracle Net Services
  • Net Listener, Naming Methods
  • Net configuration tools- netca, netmgr
  • Configuring Listener & Naming methods
  • Establishing Database connectivity from Oracle Database Clients
  • Distributed Databases, Database Links
20. Oracle Datapump
  • Concepts of Logical backups & Refresh
  • Data Pump Exports & Imports
  • Table, Schema, Tablespace and Database level Emport/Import
21. Hot/Cold Backups and Recovery
  • Taking Hot & Cold Backups
  • Backup modes
22. RMAN (Recovery Manager)
  • Backup & Recovery Concepts
  • Recovery Catalog
  • Full & Incremental Backups
  • Image Copy & Backup Set backups
  • Backup & Recovery using RMAN
  • Hot & Cold backups using RMAN
  • Complete & In-Complete Recovery
  • SQL & DESCRIBE commands in RMAN
  • RMAN Cloning
23. Transportable Tablespaces
  • Concepts of Transportable Tablespaces
  • Transporting Tablespaces across Databases
24. Flashback Technologies
  • Flashback Database
  • Flashback Table
  • Flashback Drop Table
25. Database Performance Tuning
  • Oracle Tools for Performance Tuning
  • Execution Plans, using EXPLAIN PLAN
  • Application Tracing, TKPROF
  • Constraints and Partitioned Tables and Indexes
26. Dataguard
  • Overview of Data Guard
  • Benefits of Implementing Data Guard
  • Standby Database Concepts
  • Implementing Physical Standby Database
27. ASM (Automatic Storage Management)
  • Overview of ASM
  • Types of ASM disk groups
  • Mirroring Concepts in ASM
  • Configuring ASM disks
28. Database Upgradation & Patching
  • Oracle 11g to Oracle 12C
29. Oracle 12c Software Installation and Database Creation
  • Oracle Multitenant Architecture
  • Exploring the seed database
  • Multitenant Container Database Architecture
  • Databases (PDB)
  • Creating CDBs & PDBs
  • Managing CDBs & PDBs

We provide online training services in India, Asia, Europe, America, UAE, Africa, etc. We also provide classroom training in our Hyderabad Institute.


Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.