This course teaches you migration techniques to move data to cloud and to quickly create test or
development database instances using Oracle Autonomous Database Cloud service. You will reinforce your learning with the hands-on labs as part of this course.
Learn To:
Analyze and compare your source and target environments
Choose your migration strategy
Preparing Source and Target Systems for Migration
Migrate data using SQL Developer to Autonomous Database
Migrate On-Premises Oracle Database Schema Using Data Pump
Perform Post Migration Verification
Benefits to You
You will benefit from interactive sessions that cover these areas:
Oracle Autonomous Database
Expert Oracle University instructors will provide an overview of Oracle Autonomous Cloud Platform for
Database Services. Learn how to quickly spin up an Autonomous Database instance and load data into it.
Migration
Develop a deeper understanding of the benefits of migrating data from on-premises database to Oracle Autonomous Database. Review the SQL Developer and Data Pump migration methods. With this you can plan your cloud migration strategy and also create secure and reliable departmental Data Marts that can support quick query response time for complex queries.
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
Audience
Cloud Administrator
Database Administrator
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
Topics
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
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
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
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
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
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