Oracle DBA Online 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 scenarios, Benefits of RMAN Catalog, RMAN Active database cloning, Data guard (DR Setup) Physical, Logical & Snapshot Standby DB configuration, and Switchover (DB Role conversion), DB Tuning at memory, storage and SQL level and Patching & Upgrading including concepts of RAC and Golden Gate Techniques on version 12c and 11gr2. Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Oracle DBA Course Training Plans

Description Oracle DBA Oracle DBA
Oracle DBA
Oracle Cloud
Duration 7 Weeks 15 Weeks 15 Weeks
Completely Real-time Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Resume, Job Support Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Placement Assistance Croos-symbol-for-No Check-Symbol-for-Yes Check-Symbol-for-Yes
Real-time Project Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
Oracle DBA Check-Symbol-for-Yes Check-Symbol-for-Yes Check-Symbol-for-Yes
RAC DBA Croos-symbol-for-No Check-Symbol-for-Yes Croos-symbol-for-No
Oracle Cloud Croos-symbol-for-No Croos-symbol-for-No Check-Symbol-for-Yes
Total Course Fee INR 20,000/-
USD 300
INR 35,000/-
USD 500
INR 35,000/-
USD 500

All Trainings are completely Practical and Real-Time.

Oracle DBA

Duration: 7 Weeks / 9 Wknds
Timings (IST) Demo Date Start Date  
Schedules for Oracle DBA
5:30 PM - 6:30 PM July 18th July 19th Register
7:00 PM - 8:00 PM Completed Started Register


✔ Daily Tasks ✔ Weekly Interviews
✔ Real-time Case Studies ✔ 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 Modules -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 Using 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- 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 7- 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 8- 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 9- Using DML Operation & Understanding Transaction Control

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

Chapter 10- 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 11- Introduction Database & Oracle DBA

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

Chapter 12- 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 13- 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 14- 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----
  • Understanding Data Dictionary
  • Static & Dynamic Performance Views [V$...,X$......, DBA_, ALL_, USER_]
  • Using Data Dictionary Views [ DICT, V$FIXED_TABLE]

Chapter 15- 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 16- Table-space Administration & Data file Administration

  • 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
  • Table-space Quotas
  • Configuring the Multi-block Table-space support
  • Table-space related views [DBA_Tablespaces, DBA_data_files, V$Tablespace, V$Datafile]

Chapter 17- Undo Table-space

  • 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 18- Temporary Table-space

  • Create Temporary Table-space
  • Adding and Resize the temporary file
  • Temporary Table-space Group
  • Temporary Table-space views [DBA_temp_files, V$tempfile]

Chapter 19- Managing the Control File

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

Chapter 20- 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 21- 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 22- 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 23- 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 24- 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 25- 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 26- Oracle Database RMAN Duplicate Cloning

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

Chapter 27- 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 28-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 29- Oracle Database Patching

  • Introduction to Oracle versions and how to understand a version
  • 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)

Real world life of an Oracle DBA

  • Type of Oracle errors & valid errors and internal exceptions (ORA-00600 & ORA-07445 errors)
  • How to work with Oracle Support to create Service Requests
  • Parlance and terminology used by Oracle DBAs
  • Productivity tools required when you join the work place.
  • Scheduling JOBS and scripts through UNIX/LINUX crontab utility
  • Oracle DBAAS (Database as a Service)
  • Navigate with My Services Dashboard.
  • Oracle 12c ASM (Automatic Storage Management)
  • Oracle 12c Database High Availability (RAC, Data Guard)


Chapter 1 - Grid Infrastructure Overview

  • What is Cluster?
  • What is Cluster-ware and Oracle Cluster-ware?
  • Oracle Flex Cluster, Hub Nodes, Leaf Nodes &amli; its scalability
  • Oracle Cluster-ware Networking
  • Oracle Cluster-ware Initialization
  • Glinli Architecture: Overview &amli; How it hellis to Cluster Node Startuli
  • Grid Naming Service (GNS)
  • Single Client Access Name
  • Client Database Connection
  • What is Oracle ASM?
  • ASM CloudFS and ACFS
  • Oracle Flex ASM
  • ASM Feature &amli; Benefits

Chapter 2 - RAC Databases Overview & Architecture 11gr2 & 12c

  • Overview of Oracle RAC (Real Alililication Cluster)
  • Tyliical Oracle RAC Architecture
  • RAC One Node Single-Instance High Availability
  • Oracle RAC One Node
  • Oracle RAC One Node and Oracle Cluster-ware
  • Oracle Cluster-ware Storage Solution
  • Oracle Cluster File System
  • Oracle RAC and Network Connectivity
  • Benefits of Using Real Alililication Cluster
  • Cluster and Scalability &amli; Level of Scalability
  • Scaleuli, Slieeduli and Workloads
  • I/O Throughliut Balanced: Examlile
  • Necessity of Global Resources
  • Additional Memory Requirement for RAC
  • liarallel Execution with RAC

Chapter 3 - Checklist to Install Grid Infrastructure software & RAC

  • Overview of 11gr2 &amli; 12c Oracle Grid Infrastructure (GI)
  • Server Hardware requirement for Oracle Grid Infrastructure
  • Olierating System requirement for Oracle Grid Infrastructure
  • Server Configuration requirement for Oracle Grid Infrastructure
  • Network requirement for Oracle Grid Infrastructure
  • Storage requirement for Oracle Grid Infrastructure
  • User Environment Configuration requirement for Oracle Grid Infrastructure

Chapter 4 - Overview of Oracle Cluster-ware & It’s Components

  • What is Oracle Cluster-ware?
  • What is OCR (Oracle Cluster Registry)?
  • What is Voting Disk?
  • Concelit of Virtual Ilis
  • Concelit of Single Client Access Name (SCAN)
  • SCAN VIli &amli; SCAN Listeners
  • SCAN &amli; DNS Server
  • SCAN &amli; Host Files
  • Node Related Listener

Chapter 5 - Overview & Benefits Oracle Automatic Storage Management (ASM)

  • Overview of Oracle ASM
  • ASM lilacement in Storage Stack
  • ASM Features &amli; Advantage
  • ASM Instance &amli; liarameters
  • ASM Disks &amli; ASM Disk-Groulis
  • ASM Disk-Grouli Redundancy
  • ASM Failure Grouli
  • ASM Files &amli; Directories
  • Disk Grouli Rebalance
  • ASM Extents &amli; Allocation Units
  • ASM Limits
  • Overview of 12c Flex Cluster Architecture &amli; Flex ASM.


Chapter 6 - Grid Infrastructure Pre-Installation Tasks

  • Verify System Requirement
  • Verify &amli; Configure the Network Requirement
  • Install &amli; lireliare the Required Olierating System liackages, Set the Kernel liarameters
  • Create Grouli &amli; Users
  • Configure the SSH (liassword less connectivity)
  • Create Required Directories for Grid Infrastructure &amli; RAC Database Installation
  • Configure the Shared Storage &amli; Create the Oracle ASM Disk OR Disk Grouli
  • Configure the Required Owner Shell Limits
  • &nbsli;

Chapter 7 - Installation of ORACLE 12c Grid Infrastructure software

  • Verify the Installation Requirement using Cluster Verification Utility
  • Install & Verify the Oracle Grid Infrastructure Software
  • Olierating System requirement for Oracle Grid Infrastructure
  • Server Configuration requirement for Oracle Grid Infrastructure
  • Network requirement for Oracle Grid Infrastructure
  • Storage requirement for Oracle Grid Infrastructure
  • User Environment Configuration requirement for Oracle Grid Infrastructure

Chapter 8 - Installation of ORACLE 12c Software & RAC Database creation

  • Installing Oracle 12c Software with Proper location
  • Creating RAC Database and verify it


Chapter 9 - Controlling and Managing Oracle Cluster-ware & It’s Services

  • Use Cases of Oracle Cluster-ware
  • Oracle Cluster-ware Comlionents, lirocesses &amli; Services
  • Local &amli; Cluster level Resources
  • Controlling &amli; Verifying Oracle Cluster-ware using CRSCTL &amli; SRVCTL utility
  • Star &amli; Stoli Oracle Cluster-ware &amli; Oracle High Availability Services (OHAS)
  • Enable &amli; Disable Oracle Cluster-ware &amli; Oracle High Availability Services (OHAS)
  • Controlling the OCR &amli; Voting disk using OCRCHECK, OCRCONFIG &amli; OCRDUMli Utilities
  • Determine the location of Cluster Configuration files (OCR &amli; Voting Disk)
  • Check the Integrity of Cluster Configuration files
  • Locating the OCR Auto-backuli &amli; Changing the Location of OCR Auto-backuli
  • Manual Backuli &amli; Restore of OCR &amli; Voting Disk
  • Controlling OLR (Oracle Local Registry)
  • Overview on (Oracle Interface Configuration) OIFCFG utility

Chapter 10 – Administrating 12c Flex Cluster-ware

  • Verifying the Cluster mode
  • Verifying the Role Node (Hub/Leaf)
  • Verifying the Oracle ASM mode
  • Listing the ASM Instances &amli; Listeners

Chapter 11 – Oracle Cluster-ware Log & Use Case of ADRCI Utility

  • ADR Directory Structure &amli; ADRCI
  • Oracle Cluster-ware trace files and Alert Log file
  • Normal trace files &amli; Incident Trace files
  • Collecting Oracle Cluster-ware Diagnostic data
  • liurging Automatic Workload Reliository (All Incidents &amli; Trace Files)
  • Diagnostics Collection Scrilit

Chapter 12 – Cluster-ware Health Monitor & Advisor

  • Overview of monitoring Oracle Cluster-ware
  • Cluster Health Monitor (CHM)
  • Cluster Health Advisor (CHA)
  • Oracle 12c Grid Infrastructure Management Reliository (GIMR)
  • Collecting CHM data
  • Managing CHM with OCLUMON

Chapter 13 – Cluster-ware Health Checkup via CVU utility

  • Cluster Verification Utility Overview
  • Verify Cluster Comlionents using CVU
  • Cluster Verify Locations
  • Cluster Verify Configuration files

Chapter 14 – Administrating ASM Instance

  • liarameters related to ASM Instance
  • liarameter files for ASM Instance
  • Modifying the ASM liarameters
  • Managing ASM liassword files
  • Shared Oracle ASM liassword file in Disk-Grouli
  • Start &amli; Stoli ASM Instance using SRVCTL utility
  • ASM Dynamic lierformance Views

Chapter 15 – Administrating ASM Disks & Disk-Groups

  • Overview of Disks &amli; Disk Groulis
  • Create the New Disks
  • Create the New Disk Grouli using SQL*lilus &amli; ASMCA
  • Altering the Disk Groulis
  • Adding, Removing &amli; Renaming the Disk Groulis
  • Resizing the Disks in Disk Grouli
  • Attributes &amli; Viewing the Attributes of Disk Groulis
  • Checking the consistency of Disk Grouli Metadata
  • Mounting &amli; Dismounting the Disk Groulis
  • Droliliing the Disks from Existing Disk Groulis
  • Droliliing the Disk Groulis
  • ASM Failure Groulis

Chapter 16 – Administrating ASM Files, Directories & Templates

  • Interaction between Database Instances &amli; ASM Instances
  • Accessing ASM Files by using RMAN
  • Accessing ASM Files by Using DBMS_FILE_TRANSFER
  • Accessing ASM Files by Using ASMCMD
  • View ASM Aliases, Files, and Directories
  • ASM ACL (Access Control Lists) Disk Grouli Attributes
  • Managing ASM ACL with ASMCMD &amli; SQL*lilus commands

Chapter 17 – Overview of Oracle Cloud FS

  • Overview of Oracle Cloud File System
  • ASM files and Volumes
  • ACFS &amli; ADVM Architecture Overview
  • ACFS &amli; ADVM lirocesses
  • Using ASMCMD for Dynamic Volumes
  • Configuration Settings for Database Files
  • List of ACFS Views
  • Oracle Cloud FS Advanced Toliics


Chapter 18 – Oracle RAC Database Overview & Architecture

  • Overview of Oracle RAC Database
  • Typical Architecture of Oracle RAC Database
  • Oracle Cluster-ware Storage Solution


Chapter 1- Overview of Oracle Cloud Services

  • Oracle cloud services [IaaS, PaaS, SaaS, DaaS]
  • Oracle Cloud Infrastructure as a Services (IaaS)
  • Oracle Cloud Platform as a Services (PaaS)
  • Oracle Cloud Software as a Services (SaaS)
  • Oracle Cloud Data as a Services (DaaS)
  • Oracle Database Cloud Offerings
  • Oracle Cloud Subscription Offerings
  • Subscribe to Oracle Cloud Service

Chapter 2- Creating a Database Deployment

  • Overview of Database Deployment and an Database Instance
  • Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Comparison: Database Cloud Service Deployment (DBCS) and on-premises Database
  • Using the Wizard to Create Database Deployment
  • Creating a Quick Start Database Deployment
  • Standard Editions: Included Capabilities
  • General Purpose Shapes
  • High Memory Shapes
  • How SSH Key Pair are Used
  • Creating an SSH Key Pair
  • Additional Database Configuration & Hybrid Disaster Recovery Deployment
  • Storage Used for Database Files and File System Lay Out
  • Creating a Database Deployment by using Cold Backup
  • Creating a Database Deployment from Snapshot
  • Database Cloud Service Architecture

Chapter 3- Administering a Database Deployment

  • Oracle Cloud My Services Dashboard and Viewing the Services details
  • Database Cloud Service Console
  • Configuring Connections to the Compute Node
  • Oracle Cloud User Roles and Privileges
  • Administering Users, Roles and Privileges
  • Adding and Managing Compute Node Users
  • Managing Database Users and Privileges
  • Administering Compute Node Storage
  • Scaling up a Database Deployment
  • Cleaning up log and Diagnostic Files
  • Stopping and Restarting Database Deployment
  • Patching and Upgrading a Database Deployment Overview
  • Upgrading a Database Deployment method
  • Deleting a Database Deployment

 Chapter 4- Backing UP and Recovering

  • Backing up and Recovering Database Deployment
  • Using Utilities to Backup and Recover Database Deployment
  • Choosing and Changing the Backup Destination
  • Default and Customizing the Backup Configuration
  • Creating On-Demand Backup
  • Performing Recovery by using Console
  • Performing Recovery by Using the dbaascli Utility

Chapter 5-Use Case: Create Database Deployment by Using Production Database Backup

  • Creating a Database Deployment from a Production Database backup
  • Pre-requisites for Restoring a Database Backup Using Backup Cloud Services
  • High Level Steps for High Provisioning
  • Provisioning for 18C Database Instance in DBCS

 Chapter 6- Overview of Oracle Cloud Security

  • Cloud Security Guideline
  • Enforcing Security in Database Deployment
  • Physical and Operating System Security of the Compute Node
  • User Authentication: Services and Compute Node Access
  • User Authentication: Database Access

Chapter 7- Configuring Network Access to Database Deployment

  • Describing Network Access to the Compute Node and Database
  • Creating Security Lists
  • Configuring Connection to Computer Node
  • Implementing Fine-Grained Control of Network Traffic
  • Controlling Network Traffic: Compute Nodes in the Same Security List
  • Controlling Network Traffic: Compute Nodes in the Different Security List
  • Controlling Network Traffic: Compute Nodes and External Hosts
  • Configuring Network Security: Create Security Lists
  • Configuring Network Security: Associates Compute Nodes to Security Lists
  • Define Security Rules
  • Security Rules Example: SSH Protocol
  • Accessing the Database by using Enterprise Manager Cloud Control
  • Accessing the Oracle Application Express Console

 Chapter 8- Using Oracle SQL Developer Web

  • Enabling a Schema for SQL Developer Web
  • Accessing SQL Developer web
  • Managing & Monitoring the database
  • Monitoring the Listener
  • Monitoring the Operating System

Chapter 9- Implementing Database Deployment Security

  • Secure Access to Configuration Files on the Compute Node
  • Backing UP Operating System and Database Configuration file
  • Restricting Access to the Database
  • Protecting Data in Database Deployment
  • Tablespace Encryption by Default
  • Transparent Data Encryption (TDE): Overview
  • Auditing: Compute Node connection, Actions and Database

Chapter 10- Use Cases: Configuring Network Isolation

  • Configuring Network Isolation
  • Achieving Network Isolation: Use Case
  • Overview steps for Implementing Network Isolation of Production & Nonproduction servers.
  • Creating Security Lists
  • Adding Instance to Security Lists
  • Creating Security IP Lists
  • Permitting Access to Oracle Cloud Service Instances

Chapter 11- Overview of Migrating to Oracle Database Cloud Service

  • Choosing a Migration Method: Considerations
  • Choosing a Migration Method: Understanding the requirement
  • Choosing a Method: Oracle Data Pump Consideration
  • Choosing a Method: Unplug/Plug and Remote Cloning Consideration
  • Choosing a Method: RMAN, SQL*Loader and Golden Gate consideration
  • Applicable Migration methods

Chapter 12- Using SQL Developer to migrate

  • Overview of Using SQL Developer
  • Using SQL Developer and INSERT Statements to Migrate Selected Object
  • Using SQL Developer and SQL*Loader to Migrate Selected Objects

Chapter 13- Use Case: Automated Patching of Database Cloud Service

  • Applying Patches to Database Cloud Service Deployment
  • Procedures to Apply Patch

Chapter 14- Overview of DBCS Performance Management

  • Performance Management in the Database Cloud Environment
  • Performance Monitoring and Tuning
  • Tuning Methodology
  • Effective Tuning Goals
  • General Tuning Session
  • What can be tuned in a DBCS environment?

Chapter 15- Tuning Performance Issues

  • Tools for Performance Management
  • Oracle SQL Developer Web: Database Information
  • Oracle SQL Developer Web: Operating System Information
  • Identifying Performance Issues by Using SQL Developer and OEM Express
  • Diagnose Performance Issues using ADDM and SQL Tuning advisor

Chapter 16- Tuning Performance Issues

  • Database Resource Manager: Overview and Concept
  • Resource Manager to control PDB Resource Usage
  • Controlling Resource Usage by Consumer Group
  • Determining when to scale up the Database Deployment
  • Scaling up CPU and Memory

Chapter 17- Using REST APIs to manage Oracle Database Cloud Service

  • What is Oracle REST Database Services (ORDS)?
  • Key Principle of Representational State Transfer (REST).
  • What does RDS do?
  • ORDS and Database Cloud Services
  • Using REST APIs with Database Cloud Service
  • Using CURL and REST APIs
  • Viewing and Deleting Database Deployment

Chapter 18- Deleting a Database Deployment

  • What happens When you delete a Database deployment
  • How can you delete a Database Deployment
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