One of the most sought-after and highly rewarding IT Career is ‘Oracle DBA’. Major IT organizations and IT using organizations across the world recruit DBAs to support their Oracle Database environments. There is ever increasing demand for highly skilled DBAs across IT Industry.

Download Brochure

What you will learn?

This course provides students with comprehensive understanding of Oracle Database Architecture and Administration. It provides hands-on exposure to all aspects of Database Administration like Installing, Administering, Backing up, Securing, Tuning Oracle Databases and provides knowledge and skills required to transform individuals into a complete DBA Professional.

Who can attend?

  • IT beginners
  • Developers
  • System Administrators
  • Support Engineers

Suggested Pre-requisites

  • Unix / Linux
  • Oracle SQL

Training Highlights

  • Free Training on Linux & Oracle SQL
  • Training on Latest versions
  • Extensive syllabus, compared to any other institute
  • In-depth coverage with real world examples and scenarios
  • Top Quality course material for self-study and future reference
  • Server Access for practice
  • DBA Module exams for practise and self-evaluation
  • Interview questions & Guidance on Oracle certifications
  • Assistance on resume preparation
  • Free Linux & Oracle software installation on your personal Laptops
  • 100% Placement assistance by full-fledged in-house placement cell

Module – 1

1. Introduction to DBA

  • What is Database? Why Database?
  • Major Databases and Database Vendors
  • Roles and Responsibilities of DBA
2. Oracle Database Architecture

  • Database & Instance
  • Memory Structures – SGA, PGA
  • Background Processes
  • Server Processes
  • Database Files
  • Physical & Logical Structures
3. Installing Oracle 12c Database Server

  • Requirements for Installation
  • Oracle Universal Installer (OUI)
  • Installing Oracle Software
4. Creating Oracle Database

  • Planning the Database
  • Creating Database
  • Exploring the seed database
5. Starting & Stopping Database

  • Startup & Shutdown modes
  • Starting & Stopping the database
  • Read-only & Restricted modes
6. Parameters & Parameter Files

  • Initialization Parameters
  • Static and Dynamic parameters
  • Parameter Files
  • Text & Server Parameter Files
  • System & Session Level Parameters
  • Changing Parameter values
7. Data Dictionary

  • Understanding Data Dictionary
  • Static & Dynamic Performance Views
  • Using Data Dictionary
8. Managing Diagnostic data

  • Diagnostic files
  • Automatic Diagnostic Repository (ADR)
  • Viewing Diagnostic data

Module – 2

9. Managing Data Files & Tablespaces

  • Tablespace and Data Files Concepts
  • Blocks, Extents, Segments
  • Understanding Space Management
  • Creating & Managing Tablespaces
  • Big file Tablespaces
  • Tablespace Quotas
  • Configuring Multi-Block Support
10. Managing Undo Data

  • Transactions and Undo Data
  • Managing Undo data
  • Creating Undo Tablespaces
  • Configuring Undo Retention
11. Managing Temporary Tablespaces

  • Understanding Temporary Tablespaces
  • Managing Temporary Tablespaces
  • Temporary Tablespace Groups
12. Managing Control Files

  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files
13. Redo Log Files & Archiving

  • Online & Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode
14. Oracle Managed Files (OMF)

  • OMF Concepts and Use
  • File Naming Conventions using OMF
  • Creating Tablespaces with OMF
15. User Administration

  • Creating Users Accounts
  • Account management
  • Schema , Session, Killing Sessions
  • Using profiles to implement complex passwords and resource limits
16. Privileges & Roles

  • Understanding Privileges
  • Managing Privileges
  • Understanding Roles
  • Managing Roles
17. 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
  • Configuring Shared Servers and Dispatchers
18. Database Links

  • Distributed Databases
  • Creating Database Links
  • Managing Database Links

Module – 3

19. Backup and Recovery using RMAN

  • 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
20. Flashback Technologies

  • Oracle Flashback Technologies
  • Flashback Database
  • Flashback Table
  • Flashback Drop Table
21. Oracle Data Pump

  • Concepts of Logical backups & Refresh
  • Data Pump Exports & Imports
22. Transportable Tablespaces

  • Concepts of Transportable Tablespaces
  • Transporting Tablespaces across Databases
23. Database Cloning

  • Cloning Concepts and Considerations
  • Cloning Techniques
  • Cloning Oracle Home and Database
  • Manual Cloning
  • Cloning using RMAN
24. Data Guard

  • Overview of Data Guard
  • Benefits of Implementing Data Guard
  • Standby Database Concepts
  • Implementing Physical Standby database
25. Database Patching

  • Patching Concepts
  • Interim Patches, CPU, PSU patches
  • Patch Sets
  • Downloading & Analysing Patches
  • Applying Patches
26. Database Upgrade

  • Understanding the upgrade process
  • Upgrade methods
  • Upgrading Oracle11g to Oracle 12c
27. Database Performance Tuning

  • Oracle Tools for Performance Tuning
  • Instance & Database Tuning
  • Execution Plans, using EXPLAIN PLAN
  • Application Tracing, TKPROF
  • AWR, ADDM, ASH
28. Oracle Multitenant Architecture

  • Multitenant Architecture
  • Pluggable Databases (PDB) & Container Database (CDB)
  • Creating & Managing CDBs & PDBs
  • Users, Roles, Privileges in CDB
  • Parameters in CDB
  • Backup, Recovery of CDBs & PDBs

UCLID IT School is the pioneer in Oracle DBA training.  At UCLID, you are assured to get pure and clean Oracle DBA training. We have mastered the art of teaching Oracle DBA and changed many lives for good.  At UCLID, we follow an easy, simple and no-nonsense approach towards making you a master in Oracle DBA.

With it’s enviable & impeccable track record of training and placing thousands of students as Oracle DBAs in many IT organizations, Uclid has the following unique advantages:

  • Training by former employees of Oracle India and real time IT professionals from various top IT firms
  • Training on Real Time scenarios and case studies
  • Most in-depth and comprehensive training on every topic of the course
  • Well structured Training Material for future reference
  • Training on Latest Versions – Oracle 12c
  • Individual attention and group discussions for Interview preperation
  • Dedicated systems for Lab practice supported by qualified Lab Administrators and UPS for power backup
  • Unlimited Lab Access till you get job
  • 100% Placement Assistance backed by many top IT organizations (around 16 Top IT companies hire fresher DBAs from Uclid)
  • 100% Satisfaction guarenteed

Our Faculties

Uclid has best of the best teaching faculties who are real time IT Professionals working with top MNCs. Each faculty has a minimum 10 years of real time experience in Oracle DBA and working in the capacity of project leaders and project managers in various MNCs. You will benefit from their rich experience by going through the real time scenarios and case studies during the training. At the end of the course you will not only learn Oracle DBA but familiarize yourself with the real time aspects of Oracle DBA