Summer-Ready Savings: Find the Training Course You Need at a Price You'll Love

closeClose

Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud

Course Details
Code: D105123GC10
Tuition (USD): $1,544.00 • Virtual (2 days)

This course teaches you how to migrate your On-Premises Data Mart to Oracle Autonomous Data Warehouse Cloud.

It's ideal for DBAs working in a Data Warehousing environment who want to learn migration techniques to move data to cloud and to quickly create departmental Data Marts using Oracle Autonomous Data Warehouse Cloud service.

Learn To:

  • Analyze and compare your source and target environments
  • Choose your migration strategy
  • Preparing Source and Target Systems for Migration
  • Migrate the Database Table Using SQL Developer to an Autonomous Data Warehouse
  • Export On-Premises Oracle Database Schema Using Data Pump
  • Import a Data Dump File into Oracle Autonomous Data Warehouse Cloud 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 the basics of Data Warehousing and to quickly spin up an Autonomous Data Warehouse Cloud service instance and load data into it.

Migration

Develop a deeper understanding of the benefits of migrating an on-premises Data Mart to Oracle Autonomous Data Warehouse Cloud. Review migration methods, including SQL Developer and Data Pump. 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.

Skills Gained

  • Describe Oracle Cloud Platform for Data Warehousing
  • 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 a database table by using SQL Developer
  • Migrate an On-Premises Oracle Database schema by using Oracle Data Pump
  • Perform post-migration verification

Who Can Benefit

  • Cloud Administrator
  • Database Administrator

Course Details

Topics

Course Overview

  • Overview of Course Objectives
  • Course Prerequisites
  • Course Environment

Migrating On-Premises Data Mart to Autonomous Data Warehouse: Overview

  • Data Warehouse: Introduction & Definition
  • Basic Data Warehouse Architecture
  • Oracle Cloud Platform for Data Warehousing
  • Why Provision Oracle Data Warehouse Cloud Services?
  • Oracle Autonomous Cloud Platform
  • Oracle Autonomous Data Warehouse Cloud: Key Features
  • Easy Migration to Autonomous Data Warehouse Cloud
  • General Considerations for Choosing a Migration Method

Analyzing and Choosing Your Migration Strategy

  • Migration Life Cycle of a Target Cloud Database
  • Benefits of Migration
  • Migration Strategy: Selection Criteria
  • Choosing a Method
  • Migration Considerations

Preparing Source and Target Systems for Migration

  • Prepare the Source Database for Migration
  • Create the Target System: Autonomous Data Warehouse Cloud Instance
  • Prepare the Target Service Instance
  • Create Storage Bucket Using Oracle Cloud Infrastructure Object Storage

Migrating Using SQL Developer

  • SQL Developer Offerings for Migration
  • Oracle SQL Developer: Migration Consideration
  • Special Consideration
  • Migrating Objects by Using SQL Developer
  • Post-Migration Verification: Checklist

Migrating On-Premises Database Schema by Using Data Pump

  • Oracle Data Pump: Overview & Key Features
  • How Does Data Pump Load and Unload Table Row Data?
  • Direct Path Loads and Unloads
  • External Tables
  • Migrating Schema from On-Premises 11g or 12c Non-CDB or CDB to ADWC Service Instance
  • Special Considerations
  • Importing a Dump File into Oracle Autonomous Data Warehouse Cloud

Post-Migration Verification

  • Post-Migration Verification Checklist
  • Comparing the Source and Target
  • Querying Data on the Oracle Object Store
  • Query Data with External Table
  • Validating External Data
  • Running Test Queries
  • Conclusion
  • Overview of Course Objectives
  • Course Prerequisites
  • Course Environment

Migrating On-Premises Data Mart to Autonomous Data Warehouse: Overview

  • Data Warehouse: Introduction Definition
  • Basic Data Warehouse Architecture
  • Oracle Cloud Platform for Data Warehousing
  • Why Provision Oracle Data Warehouse Cloud Services
  • Oracle Autonomous Cloud Platform
  • Oracle Autonomous Data Warehouse Cloud: Key Features
  • Easy Migration to Autonomous Data Warehouse Cloud
  • General Considerations for Choosing a Migration Method

Analyzing and Choosing Your Migration Strategy

  • Migration Life Cycle of a Target Cloud Database
  • Benefits of Migration
  • Migration Strategy: Selection Criteria
  • Choosing a Method
  • Migration Considerations

Preparing Source and Target Systems for Migration

  • Prepare the Source Database for Migration
  • Create the Target System: Autonomous Data Warehouse Cloud Instance
  • Prepare the Target Service Instance
  • Create Storage Bucket Using Oracle Cloud Infrastructure Object Storage

Migrating Using SQL Developer

  • SQL Developer Offerings for Migration
  • Oracle SQL Developer: Migration Consideration
  • Special Consideration
  • Migrating Objects by Using SQL Developer
  • Post-Migration Verification: Checklist

Migrating On-Premises Database Schema by Using Data Pump

  • Oracle Data Pump: Overview Key Features
  • How Does Data Pump Load and Unload Table Row Data
  • Direct Path Loads and Unloads
  • External Tables
  • Migrating Schema from On-Premises 11g or 12c Non-CDB or CDB to ADWC Service Instance
  • Special Considerations
  • Importing a Dump File into Oracle Autonomous Data Warehouse Cloud

Post-Migration Verification

  • Post-Migration Verification Checklist
  • Comparing the Source and Target
  • Querying Data on the Oracle Object Store
  • Query Data with External Table
  • Validating External Data
  • Running Test Queries
  • Conclusion
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward