Oracle DBA Classroom Training

Oracle DBA Training program with 100% COMPLETE PRACTICAL and REAL-TIME. Course starts from the basic Unix/Linux commands, SQL fundamentals commands, Oracle software installation, Database creation using Manual & DBCA methods, Oracle Database Architecture including Memory components (SGA, PGA & UGA), Oracle Background Processes and Storage (Control file, Data files & Online Redo log files), User & Tablespace types and management, Database links, Expdp/Impdp, RMAN Backups,Restore and Recovery with various secenerios, Benefits of RMAN Catalog, RMAN Active database clonning, Dataguard (DR Setup) Physical, Logical & Snapshot Standby DB configuraiton, and Switchover (DB Role conversion), DB Tunning at memory, storage and SQL level and Patching & Upgradaion including concepts of RAC and Golden Gate Techniques on version 12c and 11gr2. Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Schedules for Oracle DBA Classroom Training

Regular Schedules (Mon - Fri)

Location Trainer Register
1 6 AM - 7:30 AM Madhapur Mr. Mishra Register
2 8 AM - 9:30 AM Madhapur Mr. Mishra Register

Weekend Schedules (Sat, Sun)

1 8 AM - 11 AM Madhapur Mr. Mishra Register

Total Course Fee: INR 10000/-

Duration: 6 Weeks / 9 Weekends.

Training Highlights

Daily Tasks Weekly Interviews
Real-time Project Resume Guidance
Certification Guidance Placement Services

Who can take this Course?

This Oracle DBA Course is helpful for aspiring RAC DBAs, Oracle Golden Gate, Data Analysts, and more..!

Oracle DBA Training Course Contents:

Oracle DBA Course

Pre-Requisite : Module : 1 - Linux/UNIX Installation & Commands

CHAPTER 1 : Getting Started with UNIX

  • What is UNIX?
  • UNIX Architecture [Hardware, Kernel, Shell, Command & Utilities]
  • How to Login & Logout in UNIX?
  • Changing the Password of Logged in User
  • Listing the Files & Directories
  • List out the logged in Users
  • Modes of Shutdown the Linux/Unix OS 

CHAPTER 2 : UNIX File Management & the UNIX VI Editor

  • List the files & Hidden files
  • Meta characters [* and?]
  • Creating the files using various commands
  • Display the Content of the files
  • Editing the Files using vi Editor
  • Counting the Lines, Words and Characters in a file
  • Copy, Rename and Delete a file

CHAPTER 3 : UNIX Directories Management

  • Home Directory 
  • Absolute & Relative Pathnames
  • Create Directories & Creating Parent Directories
  • Copying and Renaming Directories
  • Removing Directories 
  • Changing Directories
  • The directories (. dot) and (.. dot dot) 

CHAPTER 4 : UNIX File & Directory Permission Setup

  • The Permission Indicators
  • File Access Modes [Read r, Write w, Execute x]
  • Directory Access Modes [Read r, Write w, Execute x]
  • Changing the Permissions chmod with Symbolic Permissions
  • Changing the Permissions Using chmod with Absolute Permissions
  • Changing the Ownership of File & Directory [chown command]
  • Changing the Group Ownership of File & Directory [chgrp command] 

CHAPTER 5 : UNIX User & Group Creation & Set the Environment

  • How to create Group?
  • How to create User?
  • How to modify User?
  • The .profile or .bash_profile file
  • Setting the Path 

CHAPTER 6 : UNIX Variable

  • Variable Naming convention
  • Defining Variables
  • Accessing Value from Variable
  • Read-Only Variable
  • Unsetting Variables
  • Variable Types
  • The grep, sort, pg and more commands 


CHAPTER 7 : Introduction to SQL Statements

  • SQL Fundaments [Types of SQL Commands (DML, DDL, TCL, DCL) & Description]
  • Oracle Data Types & Limitation of Data Types
  • Using the SELECT Statement
  • Column Alias Name
  • Use of DISTINCT Keyword
  • Use of DUAL Table
  • Use of WHERE clause with Comparison Operators [=, !=, <, <=, >, >=]
  • Use of Logical Operators [AND, OR, NOT]
  • Use of Other Operators [IN, NOT IN, BETWEEN, EXITS, IS NULL, IS NOT NULL, LIKE]
  • Sorting Rows by using ORDER BY clause
  • HAVING Clause
  • The CASE Expression
  • Using Ampersand Substitution Variables

CHAPTER 8 : Single Row Function

  • Single Row Function Fundamental
  • Using Single Row Character Function
  • Using Single Row Numeric Function
  • Using Single Row Date Function
  • Using Single Row Conversion Function
  • Using GROUP function 

CHAPTER 9 : Using Join & Sub Queries

  • Inner Join (Simple Inner Join)
  • Using Table Alias
  • Natural Join
  • Left Outer Join 
  • Right Outer Join
  • Full Outer Join
  • SELF Join
  • Single Row Sub Queries 
  • Multiple-Row Sub Queries 

CHAPTER 10 : Using DML Operation & Understanding Transaction Control

  • Insert New Records
  • Update Existing Records
  • Delete Records & TRUNCATE the Table
  • Commit 
  • Rollback
  • Rollback to Save-point 

CHAPTER 11 : Creating Table and Constraints

  • Database Object Overview
  • Creating Tables
  • Modifying Table [Adding Column, Dropping Column and Hiding Column]
  • Types of Constraints
  • Creating Constraint
  • Enabling & Disabling Constraint
  • Validating Constraints
  • Dropping Constraint
  • Renaming Table
  • Making Table READ ONLY
  • Dropping Table


CHAPTER 12 : Introduction Database & Oracle DBA

  • What is Database?
  • Why we need of Database?
  • List of major Databases and Database vendors
  • Tasks of Database Administrator (DBA)
  • Database related tools and utilities. 

CHAPTER 13 : Oracle Database Instance Architecture & Storage Structure

  • What is Oracle Database 11g & 12c?
  • What is Database Instance?
  • Oracle Database Instance Memory Architecture (SGA & PGA)
  • Subcomponents of Shared/System Global Area (SGA)
  • Oracle Database Process Architecture [PMON (CLMN), SMON, LREG, CKPT, DBWn, LGWR, MMON...]
  • Oracle Database Storage Structure
  • Oracle DB Logical Storage Structure [OS Block, Oracle Data block, Extents, Segment, Table-space]
  • Oracle DB Physical Storage Structure [Control file, Data files, Online Redo log files, Parameter files]
  • Oracle Database 12c Multitenant Architecture
  • Oracle Database 12c Container Database [CDB$ROOT] & Non Container Database
  • Oracle Database 12c SEED Database [PDB$SEED]
  • Oracle Database 12c Pluggable database [Application Container Database] 

CHAPTER 14 : Oracle Software Installation & Database Creation

  • Understand prerequisites for a successful Oracle RDBMS software installation.
  • Installation of Oracle 12cR1 database software with the latest patch set.
  • Installation of Oracle 12cR2 database software
  • Planning for Oracle Database Creation
  • Database Creation using DBCA (Database Configuration Assistance) GUI
  • Database Creation using script manually with CREATE DATABASE statement
  • Exploring the Database components Logical & Physically   

CHAPTER 15 : Oracle Database Start & Stop and Parameter

  • Oracle Database Open Read Only & Restricted Modes
  • Parameters
  • Initialization Parameters
  • Static & Dynamic Parameters
  • System & Session Level Parameters
  • Parameter files (Initialization Parameter & Server Parameter files) 
  • Changing the Parameter Value 
  • Data Dictionary Table & Views
  • Understanding Data Dictionary
  • Static & Dynamic Performance Views [V$...,X$......, DBA_, ALL_, USER_] 
  • Using Data Dictionary Views [ DICT, V$FIXED_TABLE] 


CHAPTER 16 : Managing the Control File

  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files
  • Control file related view (V$Controlfile)

CHAPTER 17 : Managing Online Redo log files

  • Redo Log Files & Archiving
  • Online & Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode

CHAPTER 18 : Datafiles & Tablespace Administration

  • What is Table-space?
  • Types of Table-spaces [Permanent, Temporary, Undo, Encrypted and Compressed Table-space]
  • Small File Table-space & Big File Table-space
  • Create, Alter & Drop the Permanent Table-space
  • Add & Resize the data files
  • Understand Segment space management
  • Understand the Extent Management
  • Create Big File Table-space
  • Configuring the Multi-block Table-space support
  • Temporary Table-space & Temporary Tablespace Group
  • Undo Table-space & Undo Segments
  • Overview of Encrypted & Compressed Table-space
  • Table-space related views [DBA_Tablespaces, DBA_data_files, V$Tablespace, V$Datafile]

CHAPTER 19 : Temporary Tablespace

  • Create Temporary Tablespace
  • Adding and Resize the temporary file
  • Temporary Table-space Group
  • Temporary Table-space views [DBA_Temp_Files, V$Tempfile]

CHAPTER 20 : Undo Tablespace

  • Create Undo Table-space and add data file to undo Table-space
  • Change the Undo Table-space on the Database level
  • Managing the Transaction & Undo Data
  • Configuring the Undo Table-space

CHAPTER 21 : Oracle Managed File

  • Oracle Managed File
  • File Naming Convention using OMF
  • Creating Table-space with OMF

CHAPTER 22 : User Management & Database Security

  • What is Oracle Database Users?
  • Types of Database Users on the basis of Authentication [Database & External (OS) User]
  • Database 12c Common (C##Username) User & Local User
  • Create the Database Common User & Local User
  • Alter the Database Common User &Local User
  • Types of Privileges [System Level & Object Level Privileges] & Roles
  • Grant and Revoke the Privileges from Database Users
  • What is profile?
  • Assign the Profile to Database User
  • Create & Alter the Profile
  • Killing the Session of the Connected User

CHAPTER 23 : Oracle Net Service Architecture

  • Overview of Oracle Net Services & It’s component
  • How Oracle Net Service works?
  • The Oracle Net Listener
  • Types of Listener & Oracle Listener configuration [Dynamic and Static Listeners]
  • Oracle NETCA (Network Configuration Assistant) utility to Create Listener
  • Oracle NETMGR (Network Manager) utility to Create & Configure the Listener
  • Oracle Dedicated Server Architecture & Oracle Shared Server Architecture
  • Oracle Listener Administration and TNS_ADMIN environment variable

CHAPTER 24 : Oracle Database Link

  • Overview about Oracle Database Link
  • Type of Database Link [Private & Public Database link]
  • How to create Oracle Database Link
  • How to Drop the Oracle Database Link

Module : 5 Database Backup Concept (Logical & Physical Backup)

CHAPTER 25 : Oracle Database Logical Backup (Oracle Data Pump)

  • Oracle Database Data Movement Utilities:
  • Data Pump Export (Export) expdp &  exp
  • Data Pump Import (Import) impdp & imp
  • Oracle Data Pump Components DBMS_DATAPUMP & DBMS_METADATA Package
  • Export & Import Table, Schema, Table-space, Database

CHAPTER 26 : Backup, Restore & Recovery using RMAN

  • Introduction Backup and Recovery
  • Introduction to RMAN (Recovery Manager) Architecture
  • Configuring the RMAN Environment
  • RMAN Backup Concepts like Backup Sets & Image Copy Backup
  • RMAN Control file & Parameter file backup
  • RMAN full database & Incremental Backup
  • RMAN Backup Retention Policy
  • List out the Archive log backup & Database Backups
  • RMAN related Views 
  • Concept of Repository Catalog Database
  • Benefit & Use of Repository Database
  • RMAN backup CDB & PDB Databases [Backup database root; Backup pluggable database hr_appcont;]

CHAPTER 27 : Oracle Database Flashback & Restore Point

  • Overview of Flashback Database, Restore Points and Guaranteed Restore Points
  • About Logging for Flashback Database and Guaranteed Restore Points
  • Prerequisites for Flashback Database and Guaranteed Restore Points
  • Using Normal and Guaranteed Restore Points
  • Using Flashback Database, Table-space, Table

CHAPTER 28 : Transporting Database & Transporting Table-space

  • Introduction to Full Transportable Export/Import
  • Transporting a Database Using an Export Dump File
  • Transporting a Database over the Network
  • Transporting Table-spaces between Databases

CHAPTER 29 : Oracle Database RMAN Duplicate Cloning

  • Cloning Concept & Consideration
  • Cloning Technologies
  • Cloning Oracle Home
  • RMAN Duplicate Database Cloning

CHAPTER 30 : Oracle Database Disaster Setup (Standby Database/ Data Guard)

  • Introduction Oracle Data Guard
  • Types of Standby Databases & Data Guard Services
  • Difference between Physical, Logical & Snapshot Standby databases
  • Oracle Data Guard Architecture
  • Processes related to Primary & Standby Databases
  • Creating Physical Standby Database using SQL & RMAN Duplicate command
  • Open The Physical Standby database to Real Time Apply
  • Oracle Data Guard Overview

CHAPTER 31 : Oracle Database Performance Tuning

  • How to handle performance issues in the real world
  • V$ dynamic views for performance monitoring and analysis
  • How to define size of Oracle database memory structures for optimal performance
  • Oracle database wait events
  • Explain Oracle temporary space internals and sizing.
  • How to trace database sessions using DBMS_MONITOR and DBMS_SESSION packages
  • How to format SQL trace files using the tkprof utility
  • Index Monitoring and internals of index maintenance by Oracle
  • Statistics data collection for Oracle database optimizer
  • What is Oracle automatic workload repository (AWR) and how to obtain AWR reports

CHAPTER 32 : Oracle database Patching & Upgrade

  • Introduction to Oracle versions and how to understand a version
  • How to upgrade a database from Oracle 12c R1 to Oracle 12c R2
  • How to upgrade from one patch-set to another patch-set within the same maintenance release
  • What are Oracle interim patches?
  • How to apply SPU patches (Security Patch Updates).
  • How to apply a Patch Set Update (PSU)
  • Learn about Oracle Interim Patch Installer (OPATCH)

*Above course curriculum applicable for registrations from April 20th, 2018

24x7 Support with Real-time Databases. Course includes Real-time Database Cases. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.

Oracle DBA Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
  • Detailed Oracle Architecture
  • Query Tuning, Cloning and ARMAN Tools
  • Oracle High Availability Tools
  • Routine DBA Activities, Emergency DBA Activities
  • Schema, File & Tablespace Managements
  • Tracing SQL Executions and Exec Plans

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T