Migrating Your Oracle Database to Autonomous Database Cloud

Migrating Your Oracle Database to Autonomous Database Cloud Certification Training Course Overview

Overview

This course teaches you how to migrate your data from On-Premises Oracle Database to Oracle Autonomous Database. It's ideal for DBAs who want to learn migration techniques to move data to cloud and to quickly create test or development database instances using Oracle Autonomous Database.

Target Audience

  • Cloud Administrator
  • Database Administrator

Learning Objectives

  • Identify the key features of Oracle Autonomous Database Cloud services
  • Identify the considerations for choosing a migration method
  • Identify the steps involved in moving existing data marts to Oracle Cloud
  • Analyze and choose a migration strategy
  • Prepare source and target database systems for migration
  • Migrate your data from On-Premises Oracle Database to Autonomous Database
  • Perform post-migration verification

Migrating Your Oracle Database to Autonomous Database Cloud (16 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training
02 - 03 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 07 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Course Overview
  • Describe the course objectives and prerequisites
  • Explore the course road map & use case
  • Identify course persona
  • Course Prerequisites
  • Identify the course environment and sample schema used in this course
Module 2: Migrating Your Oracle Database to Autonomous Database Overview
  • Oracle Autonomous Cloud Platform Overview
  • Autonomous Database: Overview
  • Autonomous Data Warehouse: Overview
  • Autonomous Transaction Processing: Overview
  • Migration: What, Why, and How
Module 3: Analyzing and Choosing Your Migration Strategy
  • Analyzing Source System: On-Premises Oracle Database
  • Identifying Database Objects to be Migrated
  • Identify the benefits of this migration
  • Choosing a Migration Strategy
Module 4: Preparing Source and Target Systems for Migration
  • Prepare the source database for migration
  • Create the target system: Autonomous Database instances
  • Prepare the target service instances
  • Create a storage bucket in Oracle Cloud Infrastructure Object Storage
Module 5: Migrating Using SQL Developer
  • Describe the methods and techniques to migrate database objects and segments by using SQL Developer
  • Migrate tables by using SQL Developer
  • Perform post-migration verification tasks
Module 6: Migrating On-Premises Database Schema Using Data Pump
  • Explore Data Pump migration methods
  • Use Oracle Data Pump Export to export database schemas
  • Upload Data Pump files to Oracle Cloud Infrastructure Object Storage
  • Use Oracle Data Pump Import to import data files into Autonomous Data Warehouse
Download Course Contents

Request More Information

Course Prerequisites
General understanding of cloud technology Experience in Oracle Database 11g/12c Administration Working knowledge of managing Oracle Multitenant Database Working knowledge of Oracle Database Backup & Recovery concepts and tools