Oracle cloud services

Oracle Cloud is a cloud computing service offered by Oracle Corporation providing servers, storage, network, applications and services through a global network of Oracle Corporation managed data centers. The company allows these services to be provisioned on demand over the Internet.

Oracle Cloud provides Infrastructure as a Service (IaaS), Platform as a Service (PaaS), Software as a Service (SaaS), and Data as a Service (DaaS). These services are used to build, deploy, integrate, and extend applications in the cloud. This platform supports numerous open standards (SQL, HTML5, REST, etc.), open-source solutions (Kubernetes, Hadoop, Kafka, etc.), and a variety of programming languages, databases, tools, and frameworks including Oracle-specific, Open Source, and third-party software and systems.

Overview of Cloud Services

  • Oracle Database Cloud Offerings
  • Oracle Cloud Data as a Service (DaaS)
  • Universal Credits & Bring Your Own License
  • Oracle Cloud Infrastructure as a Service (IaaS)
  • Oracle Database Cloud Offerings & Oracle Cloud Subscription Offerings
  • Oracle Cloud Services
  • Oracle Cloud Platform as a Service (PaaS)
  • Oracle Cloud Software as a Service (SaaS)

Creating a Database Deployment

  • Overview of a Database Deployment and a Database Instance & Database Cloud Service Architecture
  • Automated Database Provisioning, Features, and Tooling
  • Comparison: DBCS Deployment and an On-Premises Database
  • Software Editions: Included Capabilities, General Purpose Shapes, High Memory Shapes
  • How SSH Key Pairs are Used, Creating an SSH Key Pair
  • Additional Database Configuration Options
  • Using the Wizard to Create a Database Deployment, Creating a QuickStart Database Deployment
  • Storage Used for Database Files & File System Layout

Administering a Database Deployment

 

  • Oracle Cloud User Roles and Privileges & Administering Users, Roles, and Privileges
  • Configuring Connections to the Compute Node
  • Managing Compute Node Users
  • Using the Oracle Cloud My Services Dashboard
  • Managing Database Users and Privileges
  • Patching & Upgrading a Database Deployment
  • Scaling a Database Deployment
  • Viewing the Service Details & Using the Database Cloud Service Console

Backing Up and Recovering

 

  • Using Utilities to Back Up and Recover the Database Deployment
  • Performing Recovery by Using the dbaascli Utility
  • Backing Up and Recovering Database Deployments
  • Performing Recovery by Using the Console
  • Creating an On-Demand Backup
  • Changing the Backup Destination
  • Choosing a Backup Destination & Default Backup Configuration
  • Customizing the Backup Configuration

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

 

  • High-level Steps for Rapid Provisioning
  • Prerequisites for Restoring a Database Backup Using Backup Cloud Service
  • Creating a Database Deployment From a Production Database Backup

Overview of Oracle Cloud Security

  • User Authentication: Database Access

  • Enforcing Security in a Database Deployment

  • Physical and Operating System Security of the Compute Node

  • Cloud Security Guidelines

  • User Authentication: Services and Compute Node Access

Configuring Network Access to a Database Deployment

  • Accessing the Database Using Various Tools
  • Implementing Fine-Grained Control of Network Traffic
  • Describing Network Access to the Compute Node and Database
  • Controlling Network Traffic & Network Security
  • Creating Security Lists & Configuring Connections to the Compute Node
  • Defining Security Rules

Using Oracle DBaaS Monitor

  • Managing the Database
  • Managing and Monitoring the Listener
  • Monitoring the Operating System
  • Monitoring the Database


Implementing Database Deployment Security

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

Use Case: Configure Network Isolation

  • Achieving Network Isolation: Use Case
  • Creating Security IP Lists
  • Creating Security Lists
  • Adding Instances to Security Lists
  • Permitting Access to Oracle Cloud Service Instances

Overview of Migrating to Oracle Database Cloud Service

  • Choosing a Method: Unplug/Plug and Remote Cloning Considerations
  • Choosing a Migration Method: Considerations
  • Choosing a Migration Method: Information Gathering
  • Applicable Migration Methods
  • Choosing a Method: RMAN, SQL*Loader, and GoldenGate Considerations
  • Choosing a Method: Oracle Data Pump Considerations

Using SQL Developer to Migrate

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

Use Case: Automated Patching of Database Cloud Service

  • Applying Patches to Database Cloud Service Deployments

Overview of DBCS Performance Management

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

Tuning Performance Issues

  • Tools for Performance Management
  • Identifying Performance Issues by Using the DBaaS Monitor
  • Using ADDM to Diagnose Performance Issues
  • DBaaS Monitor: Database Information & Operating System Information
  • Identifying Performance Issues by Using SQL Developer
  • Using the Enterprise Manager Database Express Performance Hub
  • Using the SQL Tuning Advisor
  • Identifying Performance Issues by Using Enterprise Manager Database Express

Performance Management

  • Scaling Up CPU and Memory
  • Database Deployment Scaling: Overview
  • Database Resource Manager
  • Determining When to Scale Up the Database Deployment
  • Using Resource Manager to Control PDB Resource Usage
  • Controlling Resource Usage by Consumer Groups

Using REST APIs to Manage Oracle Database Cloud Service

  • ORDS and Database Cloud Service
  • What is Oracle REST Data Services (ORDS)?
  • Key Principles of Representational State Transfer (REST)
  • What Does ORDS Do?
  • Using cURL and REST APIs
  • Using REST APIs with Database Cloud Service

Reference: REST API HTTP Status Codes

  • Using REST APIs in Oracle Cloud
  • Deleting a Database Deployment
  • How Can You Delete a Database Deployment?
  • What Happens When You Delete a Database Deployment?
  • Use Case: Creating a Cloned Database Deployment from a Snapshot
  • Creating a Cloned Database Deployment from a Snapshot

 
 

Quick Enroll