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

  PLAN A PLAN B PLAN C
Description Oracle DBA Oracle DBA
RAC 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: 6 Weeks / 9 Wknds
Timings (IST) Demo Date Start Date  
Schedules for Oracle DBA
7:30 AM - 8:30 AM May 1st May 1st Register
10 AM - 11 AM Apr 23rd Apr 24th Register
7:30 AM - 9:30 AM (Wkn) May 4th May 4th Register

TRAINING HIGHLIGHTS

✔ 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

Module – 2 ORACLE SQL COMMANDS

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
  • SAVEPOINT
  • 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

Module – 3 ORACLE DATABASE ARCHITECTURE & INSTALLATION

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 Startup modes [STARTUP, STARTUP NOMOUNT, STARTUP MOUNT, OPEN, FORCE]
  • Oracle Database Open Read Only & Restricted Modes
  • Oracle Database Shutdown modes [SHUTDOWN NORMAL, TRANSACTIONL, IMMEDIATE, ABORT]
  • ----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

Module – 4 ORACLE DATABASE ADMINISTRATIONS

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
  • Views related Log [V$LOG, V$LOG_FILE, V$LOGSTDBY, V$LOG_HISTORY, V$RECOVERY_LOG, V$STANDBY_LOG]

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 https://support.oracle.com 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)

12c RAC DBA for ORACLE DBA

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.

Module - 2 INSTALLATION & CONFIGURATION

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

Module - 3 CONTROLLING & ADMINISTERING GRID INFRASTRUCTURE

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

Module - 4 CONTROLLING & ADMINISTERING ORACLE RAC DBs

Chapter 18 – Oracle RAC Database Overview & Architecture

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

12c ORACLE CLOUD for ORACLE DBA

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