Login

Oracle DBA

Self Paced Learning
  • 135+  step-by-step video tutorials
  •  50+ hours of premium learning content
  • 1 Year, 24/7 anytime, anywhere access
  •  Doubts Clarification via Community, Whatsapp, eMail , Phone Call
  • Free Course updates 
  • Course Completion Certificate
  • Learn at your own pace
  • Your Course, Your Time, Your Comfort
  • Less cost compared to Live Training
  • Recommended for busy/working professionals
Buy now (₹15,000, $215)

How it Works?

  1. Enroll in the course and get instant access
  2. Start learning immediately at your own pace and free time, using step-by-step video tutorials
  3. Clarify doubts, if any, via - Community/Whatsapp/Email/Phone Call
  4. Complete the course as soon as you can and open the doors for world of opportunities

Course Videos

Try them for FREE (click Preview button against the video)

Buy now (₹15000, $215)

Course Materials

Slides
Lab Guide

LESSON 1: Introduction to DBMS and RDBMS

Overview of DBMS, RDBMS
Preview

LESSON 2: Introduction to Oracle Database Server

What is Oracle Database Server?
Preview
Responsibilities of Oracle DBA
Preview
Oracle Database Versions, Editions and Management Packs
Preview

LESSON 3: Architecture of Oracle Database Server

Database and Instance
Preview
Instance Configurations
Preview
Applications and Databases
Preview
Tablespaces, Data Files, Data Blocks, Schema
Overview of Data Dictionary
Client Process and Server Process
Dedicated Server and Shared Server
Overview of SGA and Background Processes
Shared Pool
Database Buffer Cache
Redo Log Buffer
Writing of modified Buffers to the Database
Instance Recovery
Fixed SGA
Process Monitor
Concluding the Instance Concepts
PGA Memory
Initialization Parameters
Oracle Database Memory Management

Overview of Oracle Database Installation

Overview of Oracle Database Installation

Creating Linux VM

Download and Install VirtualBox
Creating VM
Downloading Oracle Linux
Installing Oracle Linux
Configuring Oracle Linux

Installing Oracle Database

About Optimal Flexible Architecture (OFA)
Understanding Installation Requirements
Configuring Installation Requirements
Downloading Oracle Database Software
Installing Oracle Database Software
Creating Database

Post Installation Tasks

Setting Environment Variables
How to start/stop DB, VM, Physical Machine?
Understanding the Installed Database

Data Dictionary

About Data Dictionary
Lab Practices

Managing Database Startup and Shutdown

Overview of Database Startup
Lab Practices: Database Startup
Overview of Database Shutdown
Lab Practice: Database Shutdown

Managing Initialization Parameters

Managing Initialization Parameters
Lab Practice: Managing Initialization Parameters

Managing Diagnostic Data

Managing Diagnostic Data
About Diagnostic Data
Lab Practice: Managing Diagnostic Data

Managing Tablespaces and Data Files

Overview of Tablespaces
Overview of Data Files
Overview of ROWID
How Database allocates Space?
Extent Management
Segment Space Management
Row Chaining and Row Migration
Fragmentation
High Water Mark (HMW)
Shrinking Segments
Classification of Tablespaces
About default Tablespaces
Lab Practice: Querying information about default tablespaces
Lab Practice: Creating Tablespaces
Managing Tablespaces
Managing Data Files - Part1
Managing Data Files - Part2
More Demos

Managing Temporary Tablespaces

Overview of Managing Temporary Tablespaces
Lab Practices: Managing Temporary Tablespaces

Managing Undo Tablespaces

Overview of Undo Tablespace
Overview of Managing Undo Tablespaces
Lab Practices: Managing Undo Tablespaces

Managing Control Files

Overview of Control Files
Overview of Managing Control Files
Lab Practices: Managing Control Files

Managing Redo Log

Overview of Redo Log Files
Overview of Managing Online Redo Log
Lab Practices: Managing Online Redo Log

Managing Archive Log

Overview of Archive Log Mode
Lab Practices: Archive Log

Oracle Managed Files (OMF)

About Oracle Managed Files
Configuring OMF
OMF Name Formats
Lab Practices: Configuring and Using OMF

User Administration

Overview of Administering User Accounts
About Predefined Accounts and Schema only Accounts
Lab Practices: Administering User Accounts

Profiles Administration

Overview of Profiles
Lab Practices: Using Profiles

Privileges and Roles

Managing Database Privileges and Roles

Oracle Net Services

About Oracle Net Services
Components of Oracle Net Services
About Oracle Net Listener
Overview of Creating and Managing Oracle Net Listeners
Overview of Establishing Net Connections
How to Implement and Test Oracle Net Services on Laptop
Lab Practice: Configuring Network between Physical Machine and VM
Lab Practice: Starting Default Listener
Lab Practice: Installing Oracle Client
Lab Practice: Establishing Remote Database Connectivity
Creating Custom Listener using NETCA
Creating Custom Listener Manually
Using TNSPING utility

Recovery Manager (RMAN)

About Recovery Manager (RMAN)
RMAN Concepts
Backup Set Backup and Image Copy Backup
Lab Practice: Starting RMAN and Managing RMAN Configuration Parameters
Performing Backup and Reporting operations using RMAN
Overview of Configuring Recovery Catalog
Lab Practice: Configuring Recovery Catalog
Registering Target Database in Recovery Catalog
Overview of Recovery using RMAN
Recovering Non-System Data Files
Recovering Non-System Tablespace
Recovering System Data Files
Recovering ALL Data Files
Recovering Control Files
Recovering SPFILE
Recovering Complete Database
Restoring to a NEW Location
Recovery using Image Copies
Database Point in Time Recovery
Tablespace Point in Time Recovery

Flashback Features

Overview of Flashback Database
Lab Practice: Configuring Flashback Database
Lab Practice: Performing Flashback Database Operation
Overview of Flashback Drop Table
Lab Practice: Performing Flashback Drop Table Operation

Oracle Data Pump

Overview of Oracle Data Pump
Lab Practices: Using Data Pump

Patching

Updating Software using Patches
Links to download Patch files

Upgrading

Upgrading the Database

Multitenant Container Database Administration

Creating Container Database
Administering Container Database

About the Course

Oracle DBA Training course provides students with comprehensive understanding of Oracle Database Architecture and Administration. Students will get hands-on exposure to all aspects of Oracle Database Administration like Installation, Administration, Backup & Recovery, Patching, Upgrading etc…

 You will gain thorough knowledge on all the concepts related to Oracle Database Administration and also get hands-on knowledge required to perform DBA tasks in real project environments.

Course Prerequisites

This course requires basic knowledge of Unix/Linux and SQL.

Course Curriculum

  • Introduction to the Course
  • Understanding Oracle Database Architecture
  • Installing Oracle Database Server
  • Creating & Configuring Oracle Database
  • Database Start up & Shutdown
  • Managing Initialization Parameters
  • Data Dictionary
  • Managing Diagnostic Data
  • Managing Tablespaces & Data Files
  • Managing Undo Data
  • Managing Control Files
  • Managing Redo Log Files
  • Archiving & Archive Log Files
  • Oracle Managed Files (OMF)
  • User Administration
  • Profiles Administration
  • Managing Privileges
  • Managing Roles
  • Oracle Net Services
  • Backup & Recovery
  • Flashback Database
  • Data Pump
  • Database Patching
  • Database Upgrade
  • Multitenant Architecture

What will you Learn?

  • Gain solid understanding of Oracle Database Architecture and Components
  • Install Oracle Database Server on Linux
  • Hands-on management of Oracle Database Instance
  • Use Data Dictionary to view information about the database and database objects
  • Use Diagnostic data – Alert log, trace files and other files to troubleshoot database issues
  • Manage Database Storage, Data Files, Tablespaces
  • Manage Control Files, Online Redo Log Files, Archiving and Archive Log files
  • Manage Database Undo & Redo
  • Configuring Oracle Managed Files
  • Managing Users, Privileges, Roles, Profiles
  • Configuring Oracle Net Services and implement Client/Server access
  • Configure and Use RMAN to perform Database Backup & Recovery
  • Use RMAN to repair data corruptions
  • Use Flashback features to recover from logical errors
  • Apply Software Update/Patches
  • Upgrade your Oracle Database to Higher versions
  • Configure and Administer Oracle Multitenant Architecture 

Key Highlights

  • Instructor-led Live Online Training using zoom meetings
  • Interactive Training with Live Doubt Clarifications
  • Free Access to Linux Essentials for DBAs course (worth 5000 rupees)
  • The most comprehensive, high quality and up-to-date course content
  • 100% Hands-on training with In-depth explanation and demonstration of each Lesson
  • Simple and easy to understand lectures
  • Step-by-step practical implementation of each Lab Practice
  • 1 Year unlimited access to Live Class Recordings
  • Downloadable Course Materials - Slides, Lab Guide
  • Lifetime Membership in Course Community
  • Course Completion Certificate
  • Learn the Best, Learn from the Best

Course Instructor

Muralidhar Punyala (Murali), is the course instructor for this course and also the founder of Uclid IT School.

Murali is a certified IT Professional with 27 years of Global IT experience on Oracle Database and Cloud Technologies. Murali's core skills include - Oracle DBA, Oracle RAC, Performance Tuning, Oracle Exadata, Oracle Cloud and AWS Cloud. Throughout his career Murali worked with various global IT companies in India, USA, UK, Singapore and Hong Kong. Murali also worked with Oracle India as a Practice Manager.

Get Support

Anytime. Lifetime.

You are not alone in your learning journey. If you get stuck anywhere in the course, just ask for help in our Private Group anytime. We will be there to help you.

✔️VIP group for our Students

✔️Your queries answered.

Testimonials

More Testimonials...

Buy now

  •  Enroll and activate your instant access
  • Start learning immediately 
  • Learn at your own pace, convenience and free time
  •  135+  step-by-step video tutorials
  •  50+ hours of premium learning content
  • 1 Year, 24/7 anytime, anywhere access
  •  Doubts Clarification via Community, Whatsapp, eMail , Phone Call
  • Free Course updates 
  • Course Completion Certificate
  • Less cost compared to Live Training
  • Recommended for busy/working professionals
Buy now (₹15000, $215)

Oracle Database Administration

  • 137 Lessons
  • 365-day access