Oracle Cloud DBA Online Training

Oracle Cloud DBA Training program with 100% COMPLETE PRACTICAL and REAL-TIME subject. Course starts from the Basics, Architecture, Automated Patching of Database Cloud Service and Tuning Performance Issues . Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Oracle Cloud Course Training Plans

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

All Trainings are completely Practical and Real-Time.

Oracle DBA

Duration: 6 Weeks / 9 Wknds


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 Cloud DBA Training Course Contents:


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

*Above course curriculum applicable for registrations from Sep 13TH, 2017

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

Oracle Cloud 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 SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

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