» Oracle Database Administration | Bionic System Website

Oracle Database Administration

Course Image

Course Summary

Title	Content
Course Fee
Training Method
Total Modules
Course Duration	72 Hours
Total Session
Class Duration	2 Hours

Register Now

Oracle Database Administration Training

Module-1

Introduction to Oracle Database

What is a Database?
Introduction to Oracle Corporation
Oracle Database Editions (XE, SE, EE)
Oracle Architecture Overview
Installation Prerequisites

Module-2

Oracle Database Architecture

Instance vs Database
Memory Structures (SGA, PGA)
Background Processes (DBWn, LGWR, SMON, PMON)
Logical & Physical Storage Structures

Module-3

Installing Oracle Database

Hardware & Software Requirements
Oracle Installation Steps (Linux/Windows)
DBCA: Database Creation Assistant
Silent Installation

Module-4

Oracle Tools & Utilities

SQL*Plus
Oracle SQL Developer
Enterprise Manager (OEM/DB Express)
Using Listener & Net Configuration

Module-5

Basic SQL for DBAs

SELECT, INSERT, UPDATE, DELETE
WHERE, ORDER BY, GROUP BY
JOINS and Subqueries
DDL vs DML

Module-6

Managing Users & Schemas

Creating Users
System vs Object Privileges
Roles and Profiles
Default Tablespaces

Module-7

Tablespaces & Datafiles

What is a Tablespace?
Permanent vs Temporary vs Undo
Adding, Resizing, Renaming Datafiles

Module-8

Managing Tables & Indexes

Creating & Modifying Tables
Table Constraints
Indexes: B-tree, Bitmap
Rebuilding & Dropping Indexes

Module-9

Backup & Recovery Concepts

Importance of Backup
Types: Logical vs Physical
Consistent vs Inconsistent Backup
Overview of RMAN