Oracle Database Cloud for Oracle DBAs

Course Fees: $3066.00 excl. GST
Printed Manual: $95.00 excl. GST
Course Duration: 3 days
Course Manual

Wellington

24 Apr - 26 Apr

This Database Cloud Administration training teaches you how to administer the Oracle Database Cloud Service. It's ideal for existing DBAs who want to learn how to deploy and administer an Oracle Database 18c environment in the cloud.

Learn To:

Benefits to You

You will benefit from interactive instruction that covers these three areas:

Database Deployment

Expert Oracle University instructors will provide an overview of what the Oracle Public Cloud offers in terms of services. Learn how to sign in to an Oracle Public Cloud account, create a database deployment and learn how to delete, stop, restart, patch and upgrade a database deployment.

Furthermore, you'll develop the knowledge and skills to add storage for the database deployment, containers, and perform on-demand backup and recovery operations. Instructors will deep-dive into security information, which includes configuring network access rules from tools and other database deployments, managing database deployment security at the compute node and the database levels, managing encryption of data at rest and in transit, and auditing the operations performed on the database deployment. You will also get an overview of various migration methods available for migrating Oracle Database to Oracle Cloud.

Finally, you'll learn what can be tuned in a database deployment, along with how to use the DBaaS Monitor. Instructors will focus on the Waits, Sessions, and Alerts section, as well as how to access Enterprise Manager Database Express and use the Performance Hub and Tuning Advisor. You'll also walk away with the ability to scale the database deployment to get more CPU and RAM resources.

Ideal for DBAs

This course is ideal for existing DBAs who are looking to enhance their skills to become cloud DBAs. Taking this hands-on training will prepare DBAs for Cloud DBA certification exams.

    • Sign in to Oracle Database Cloud Service.
    • Deploy an Oracle Database 18c environment.
    • Manage different areas of database administration such as storage, backups, recovery, security, performance and monitoring through the Oracle Database Cloud Service consoles and Cloud tooling.
    • Create, delete, stop, restart, patch and upgrade a database deployment.
    • Monitor the database deployment by using the DBaaS Monitor utility.
    • Manage users at all levels (Oracle Cloud Service, compute node and database).
  • Security Administrators
  • Cloud Administrator
  • Cloud User
  • Cloud Database Administrators
  • Cloud Data Architects
  • Cloud Technical Consultants
  • Cloud Architect
  • Database Administrators
  • Database Administrators
Database Admin training - 11g, 12c or 18c
  • 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

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 an 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