Training
Oracle
Data Management
Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

Oracle Database Cloud for DBAs on Oracle Cloud Infrastructure

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

$2,700 USD

Course Code D105581GC10

Duration 2 days

Available Formats Classroom

View Schedule Ask a Question Need Group Training?

7368 Reviews star_rate star_rate star_rate star_rate star_half

Enter your Email to Download Full Course Details

Overview

Schedule

FAQ

Reviews

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.

This course is ideal for DBAs and Data Management Professionals who are looking to enhance their cloud database administration skills. Taking this hands-on training will prepare DBAs for Cloud DBA certification exams.

Learn To:

Describe Oracle Cloud Platform for Database in the Cloud
Understand key terms such as Regions, Availability Domains, VCN, Shapes
Identify the features of Virtual Machine (VM) DB Systems
Identify the features of Bare Metal (BM) DB Systems
Create Virtual Cloud Network (VCN) for DB System
Describe the steps involved in creating and managing VM & BM DB Systems
Connect to a DB System on OCI
Update, Configure, and Patch DB Systems
Monitor a Database on OCI
Backup and Recover a Database on OCI
Identify OCI Security Features
Identify the process involved in migrating a database to OCI

Skills Gained

Describe what Oracle Cloud Platform has to offer for database deployments in the cloud
Identify the building blocks of Oracle Cloud Infrastructure (OCI)
Describe the essentials of Oracle Cloud Infrastructure
Get familiar with OCI terminology such as tenant, region, availability domain, shapes
Describe the steps involved in launching Bare Metal and Virtual Machine DB Systems
Create and manage a Virtual Machine (VM) DB System
Describe the administrative tasks involved in managing a VM DB System
Explain how security in implemented in each layer of Oracle Cloud Infrastructure
Describe what you can do to secure your DB system
Get an overview of migrating database to Oracle Cloud Infrastructure

Who Can Benefit

Administrator
Cloud Administrator
Database Administrator

Course Details

Topics

Oracle Cloud Platform for Database in the Cloud
- Oracle Database Cloud Services
- Journey to Autonomous Database
- Subscribe to an Oracle Cloud Service
Getting Started with Oracle Cloud Infrastructure
- Regions, Availability Domains, and Backbone Network
- Comprehensive Virtual Network with Off-box Virtualization
- Oracle Cloud Infrastructure Services
Oracle Cloud Infrastructure Essentials
- Virtual Cloud Network (VCN) Service
- Compute Service & Shapes
- Object Storage Service & Block Volume Service
- Load Balancing Service
- DNS Service
Oracle Cloud Infrastructure: Database Service
- Virtual Machine DB Systems
- Bare Metal DB Systems
- Exadata DB Systems
Bare Metal and Virtual Machine DB Systems
- Compute
- Shapes
- Storage Options
- DB Systems Storage Architecture
Creating and Managing Bare Metal and Virtual Machine DB Systems
- Prerequisites to Launch DB System
- Creating Virtual Cloud Network (VCN) for DB System
- Using the Console to Launch DB System
- Using Console to Start, Stop, Reboot, and Terminate DB System
- Using the Console to Manage BYOL Database Licenses
- Using the API Operations & Setting Up DNS for a DB System
Connecting to a DB System on OCI
- Create TNS Entry for PDBs
- Connecting to a DB System with SSH
- Connecting to a Database with Oracle SQL Developer
- Connecting to a Database on 1-Node & Multi-Node DB System
Updating and Configuring a DB System on OCI
- Update a DB System
- Important Guidelines for OS Updates
- Configure a DB System
- Transparent Data Encryption
- Scaling CPU & Storage
Patching a DB System on OCI
- Performing Patch Operations on DB System & on Database Using Console
- Viewing Patch History of a DB System & of a Database
- Performing Patching Using CLI
- Check the Installed Patches & Patch Server Components
- Patch Database Home Components
- Applying Interim Patches
- Identify the Root Cause of the Patching Operation Failure
Configuring and Monitoring a Database on OCI
- Monitoring a Database
- Opening Ports on the DB System
- Updating the Security List for the DB System
- Special Considerations to Create and Configure a New PDB
- Creating and Activating a Master Encryption Key for a New PDB
Backing Up and Recovering a Database on OCI
- Object Storage, Local Storage & Swift Object Storage
- Backing Up to Oracle Cloud Infrastructure Object Storage Using Console & RMAN
- Enable or Disable Automatic Backups for a Database
- Create an On-Demand Full Backup of a Database & Delete a Full Backup from Object Storage
- Installing the Backup Module on the DB System & Configuring RMAN
- Backing Up to Local Storage Using the Database CLI
- Recovering a Database Using Console, RMAN & from a CLI Backup
- Recovering a Database from the Oracle Cloud Infrastructure Classic Object Store
Oracle Cloud Infrastructure Security
- Identity and Access Management Service
- Principals, Authentication, Authorization
- User Authentication
- Instance Isolation
- Network Security
- User Authorization: OCI IAM
- Data Encryption
Migrating Oracle Databases to OCI: Overview
- Considerations for Choosing a Migration Method
- Information Gathering, Analysis and Planning
- Data Transfer Options (Online and Sync, Offline)
- Security Considerations
- Migration Options

Course Objectives
Target Audience
Prerequisites
Course Roadmap
Course Practices

Oracle Cloud Platform for Database in the Cloud

Oracle Database Cloud Services
Oracle Cloud Infrastructure (OCI): Specifically Architected for Oracle Databases
OCI Security Features: Overview for Database Service
Journey to Autonomous Database
Autonomous or User Managed
Subscribe to an Oracle Cloud Service
Universal Credits
Bring Your Own License

Getting Started with Oracle Cloud Infrastructure

Regions, Availability Domains, and Backbone Network
Inside a Region – High Availability Building Blocks
Inside an AD – High Scale, High Performance Network
Comprehensive Virtual Network with Off-box Virtualization
Oracle Cloud Infrastructure – Innovation at Its Core
Oracle Cloud Infrastructure Services
Key Differentiators

Oracle Cloud Infrastructure Essentials

Virtual Cloud Network (VCN) Service
OCI VPN: Overview
Compute Service: Bare Metal and Virtual Machines
Available Shapes: Processor and Memory Resources
Local NVMe SSD Devices
Object Storage Service and Block Volume Service
Load Balancing Service
DNS Service

Oracle Cloud Infrastructure: Database Service

Database Service: Use Cases
Virtual Machine DB Systems VM DB Systems Storage Architecture
Bare Metal DB Systems BM DB Systems Storage Architecture
Exadata DB Systems Storage Architecture
Scaling Exadata DB Systems
Database Editions, Versions, and Options
DB Systems: Managing, Patching, Automatic backups, Backup / Restore
High Availability and Scalability

Bare Metal and Virtual Machine DB Systems

Compute: Bare Metal and Virtual Machines
Database Editions, Versions, and Options
Shapes for Virtual Machine Bare Metal DB Systems
Storage Options for Virtual Machine Bare Metal DB Systems
Virtual Machine DB Systems Storage Architecture
Bare Metal DB Systems Storage Architecture

Creating and Managing Bare Metal and Virtual Machine DB Systems

Managing the Database Systems Overview
Prerequisites to Launch DB System
Creating Virtual Cloud Network (VCN) for DB System
Using the Console to Launch DB System
Using Console to Check the Status of DB System
Using Console to Start, Stop, Reboot, and Terminate DB System
Using the Console to Manage BYOL Database Licenses
Using the API Operations Setting Up DNS for a DB System

Connecting to a DB System on OCI

Create TNS Entry for PDBs
Prerequisites for SSH Access to the DB System
Connecting to a DB System with SSH
Connecting to a Database with Oracle SQL Developer
Connecting to a Database on 1-Node Multi-Node DB System
Troubleshooting Connection Issues

Updating and Configuring a DB System on OCI

Update a DB System
Bash Profile Essential Firewall Rules
Important Guidelines for OS Updates
Configure a DB System
Network Time Protocol (NTP)
Transparent Data Encryption
Scaling CPU Storage

Patching a DB System on OCI

Patching Prerequisites Patching DB Systems
Performing Patch Operations on DB System on Database Using Console
Viewing Patch History of a DB System of a Database
Performing Patching Using CLI
Check the Installed Patches Patch Server Components
Patch Database Home Components
Applying Interim Patches
Identify the Root Cause of the Patching Operation Failure

Configuring and Monitoring a Database on OCI

Monitoring a Database
Connect to EM Express Console
Connect to EM Database Control Console
Opening Ports on the DB System
Updating the Security List for the DB System
Update an Existing Security List
Special Considerations to Create and Configure a New PDB
Creating and Activating a Master Encryption Key for a New PDB

Backing Up and Recovering a Database on OCI

Object Storage, Local Storage Swift Object Storage
Backing Up to Oracle Cloud Infrastructure Object Storage Using Console RMAN
Enable or Disable Automatic Backups for a Database
Create an On-Demand Full Backup of a Database Delete a Full Backup from Object Storage
Installing the Backup Module on the DB System Configuring RMAN
Backing Up to Local Storage Using the Database CLI
Recovering a Database Using Console, RMAN from a CLI Backup
Recovering a Database from the Oracle Cloud Infrastructure Classic Object Store

Oracle Cloud Infrastructure Security

OCI Security Features: Overview for Database Service
Identity and Access Management Service
Principals, Authentication, Authorization
User Authentication: OCI Security Credentials
Instance Isolation: OCI Database Bare Metal (BM) Instance
Network Security: Virtual Cloud Network (VCN)
User Authorization: OCI IAM
Data Encryption

Migrating Oracle Databases to OCI: Overview

Why Migrate to Oracle Cloud Infrastructure
Managing Oracle Database: On-Premises Versus Oracle Cloud Infrastructure
What Can You Migrate to Oracle Database Cloud
Considerations for Choosing a Migration Method
Migration: Information Gathering, Analysis and Planning
Migration: Data Transfer Options (Online and Sync, Offline)
Migration: Security Considerations
Migration Options

Read Less

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Request Other Date Request On-site Course

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

I found this course informative. It was easy to follow and provided some good information.

ExitCertified Student

ExitCertified

ExitCertified was a great. They gave me all the materials and information I needed ahead of time to prepare for the course.

ExitCertified Student

ExitCertified

The training was good but needed the basic skills of maximo before getting deep in the configuration of it.

Manish Patel

ExitCertified

Great class I learned a great deal from the material. There would seem to a large amount that I need to learn about.

William Driver

ExitCertified

Class was very informative, although one lab didnt but will try again later

ExitCertified Student

ExitCertified