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

 

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

 

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

 

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

 

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

 

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