Oracle Cloud DBA

Oracle Database Cloud Service offers autonomous and user-managed Oracle Database solutions. User-managed solutions are Bare Metal, Virtual Machine, and Exadata DB systems that you can customize with the resources and settings that meet your needs.

This training is your first step in getting started with Virtual Machine and Bare Metal DB Systems. You also get to learn the essential skills required for a DBA to create and manage Oracle Cloud Infrastructure resources such as network and storage.

Course Overview

What will you learn?

  • Tune a database deployment by using DBaaS Monitor utility
  • Use the Oracle Cloud services consoles
  • Create and manage a database deployment
  • Grant privileges and roles to users at all levels, Oracle Cloud Service, compute node and database
  • Manage encryption of data at rest and in transit
  • Manage database deployment security access at the compute node and the database
  • Describe various migration methods
  • Monitor the database deployment by using the DBaaS Monitor utility
  • Perform on-demand backups and recovery of the database deployment
  • Scale the database deployment to get more CPU and RAM resources
  • Audit operations performed on the database deployment
  • Access Enterprise Manager Database Express
  • Add storage for the database deployment
  • Configure network security rules

Who should go for this training?
The following professionals can go for this course:

Suggested Prerequisite

Oracle Database 12c R2: Managing Multitenant Architecture Ed 2

Required Prerequisite

  • Oracle Database 12c R2: Administration Workshop Ed 3
  • Experience in Oracle Database 11g and/or 12c Administration

Who can attend

  • Administrator
  • Cloud Administrator
  • Database Administrator
  • End-User

What are the pre-requisites for this Course?

  • Oracle DBA

Course Content

  • Course goals
  • Course schedule
  • The history of Linux
  • Linux distributions
  • Oracle Linux
  • UEK
  • What is IaaS
  • IaaS concepts
  • IaaS benefits
  • How is IaaS used
  • Oracle IaaS services
  • What is storage
  • Types of storage – local storage and cloud storage
  • Types of cloud storage – public, personal, hybrid
  • Types of storage – block storage, object storage, ephemeral storage
  • What is a VM
  • What can I do with a VM
  • How do I use Oracle Compute Cloud Service (introduction to the web console)
  • What do I need to do to create a VM
  • What is an SSH Key
  • How do I use an SSH Key
  • How do I generate an SSH key pair
  • Saving the private key and public key on your local host
  • What is a bootable storage volume
  • What is a machine image
  • Creating a bootable block storage volume
  • Creating a VM with a bootable storage volume (using the web console)
  • Logging in to the VM to access the storage volume
  • What is an orchestration
  • Why should I use orchestrations
  • Structure of an orchestration
  • What objects can I create using an orchestration
  • What is JSON
  • JSON syntax
  • JSON editing and syntax checker tools
  • How do I create an instance using an orchestration – steps
  • About accessing Oracle Storage Cloud Service
  • Understanding authentication tokens and time limits
  • Constructing the authentication URL
  • Finding your account information
  • Storing an object using an authentication token
  • Using access control lists
  • Cloud Services
  • Oracle Database Cloud Offerings
  • Subscribe to an Oracle Cloud Service
  • Using the Oracle Cloud My Services Dashboard
  • Viewing the Service Details & Using the Database Cloud Service Console
  • Configuring Connections to the Compute Node
  • Oracle Cloud User Roles and Privileges & Administering Users, Roles, and Privileges
  • Managing Compute Node Users
  • Managing Database Users and Privileges
  • Scaling a Database Deployment
  • Patching & Upgrading a Database Deployment
  • Cloud Security Guidelines
  • Enforcing Security in a Database Deployment
  • Physical and Operating System Security of the Compute Node
  • User Authentication: Services and Compute Node Access
  • User Authentication: Database Access
  • Managing the Database
  • Monitoring the Database
  • Managing and Monitoring the Listener
  • Monitoring the Operating System
  • Choosing a Migration Method: Considerations
  • Choosing a Migration Method: Information Gathering
  • Choosing a Method: Oracle Data Pump Considerations
  • Choosing a Method: Unplug/Plug and Remote Cloning Considerations
  • Choosing a Method: RMAN, SQL*Loader, and GoldenGate Considerations
  • Applicable Migration Methods
  • 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
  • Database Deployment Scaling: Overview
  • Database Resource Manager
  • Using Resource Manager to Control PDB Resource Usage
  • Controlling Resource Usage by Consumer Groups
  • Determining When to Scale Up the Database Deployment
  • Scaling Up CPU and Memory
  • What Happens When You Delete a Database Deployment
  • How Can You Delete a Database Deployment
  • Use Case: Creating a Cloned Database Deployment from a Snapshot
  • What is virtualization
  • Virtualization concepts
  • Benefits of virtualization
  • Overview of Oracle Compute Cloud Service
  • Oracle Compute Cloud Service features
  • How is Oracle Compute Cloud Service used
  • Overview of object storage on the cloud
  • How does object storage work
  • Benefits of object storage
  • About Oracle Storage Cloud Service
  • Accessing Oracle Storage Cloud Service
  • Installing Cygwin and cURL
  • Workflow for using a block storage volume
  • Creating a block storage volume
  • Adding a block storage volume to your existing VM
  • Identifying the new storage volume
  • About file systems
  • Creating a file system on your storage volume
  • About Mount Points
  • Mounting the storage volume on your VM
  • Networking concepts
  • How do network settings work
  • About security lists
  • About security rules
  • How does SSH access work
  • Reserving a public IP address
  • Associating a public IP address with an existing VM
  • Creating a security list
  • What is HTTP
  • How does HTTP work
  • HTTP headers
  • HTTP methods
  • What is a URL
  • What is REST
  • About JSON
  • About containers
  • Creating containers
  • Setting container metadata
  • List containers
  • Deleting containers
  • About objects
  • Listing objects in a container
  • Comparing a Database Deployment and a Database Instance
  • Database Cloud Service Architecture
  • Features and Tooling
  • Automated Database Provisioning
  • Comparison: Database Deployment and an On-Premises Database
  • Using the Wizard to Create a Database Deployment
  • How SSH Key Pairs are Used & Creating an SSH Key Pair
  • Storage Used for Database Files & File System Layout
  • Backing Up and Recovering Database Deployments
  • Using Utilities to Back Up and Recover the Database Deployment
  • Choosing a Backup Destination & Default Backup Configuration
  • Creating an On-Demand Backup
  • Changing the Backup Destination
  • Customizing the Backup Configuration
  • Performing Recovery by Using the Console
  • Performing Recovery by Using the dbaascli Utility

Use Case: Create a Database Deployment by Using a Production Database Backup

  • Describing Network Access to the Compute Node and Database
  • Creating Security Lists & Configuring Connections to the Compute Node
  • Implementing Fine-Grained Control of Network Traffic
  • Controlling Network Traffic & Network Security
  • Defining Security Rules
  • Accessing the Database Using Various Tools
  • Secure Access to Configuration Files on the Compute Node
  • Backing Up Operating System and Database Configuration Files
  • Restricting Access to the Database
  • Protecting Data in the Database Deployment
  • Tablespace Encryption by Default
  • Transparent Data Encryption (TDE): Overview
  • Auditing: Compute Node Connections and Actions
  • Auditing: Database

Use Case: Configure Network Isolation

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

Use Case: Automated Patching of Database Cloud Service

  • Tools for Performance Management
  • DBaaS Monitor: Database Information & Operating System Information
  • Identifying Performance Issues by Using the DBaaS Monitor
  • Using the Enterprise Manager Database Express Performance Hub
  • Identifying Performance Issues by Using Enterprise Manager Database Express
  • Identifying Performance Issues by Using SQL Developer
  • Using ADDM to Diagnose Performance Issues
  • Using the SQL Tuning Advisor
  • What is Oracle REST Data Services (ORDS)
  • Key Principles of Representational State Transfer (REST)
  • What Does ORDS Do
  • ORDS and Database Cloud Service
  • Using REST APIs in Oracle Cloud
  • Using REST APIs with Database Cloud Service
  • Using cURL and REST APIs
  • Reference: REST API HTTP Status Codes

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over the internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts at your own pace and timing.

Frequently Asked Questions

Our trainer is an OCP & OCM certified consultant and has a significant amount of experience in working with the technology, having 18yrs of experience.

Once you get registered, our back-end team will share you the details to join the session live over an online portal which can be accessed through a browser.

Each of our live sessions is recorded. In case if you miss any, you can request us to share the link to that particular session.

For practical execution, our trainer/technical team will provide server access details to the student

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have a live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen, and learn anytime at ur feasible place. For doubts in the videos, you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to help@sarinfotechindia.com with your queries.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discounts offers from time to time. However, we provide a discount for single participants & special discounts for 2 or more participants.

* If the request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If the request made after 2 days, then Refund is made after deduction of the administration fee.