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.
Skills Covered
- 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
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.
Target Audience
- Cloud Administrator
- Database Administrator
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
Dates & Locations
Exam & Certification
Exam 1Z0-1094-21
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
