The future of IBM Maximo: Work Centers and Inspections Can Transform Your Business

closeClose

Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud

  • Tuition USD $1,544
  • Reviews star_rate star_rate star_rate star_rate star_half 486 Ratings
  • Course Code D105123GC10
  • Duration 2 days
  • Available Formats Virtual

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

How do I enroll?

A comprehensive listing of ExitCertified courses can be found here. You can register directly for the required course/location when you select "register". If you have any questions or prefer to speak with an ExitCertified education consultant directly, please submit your query here. A representative will contact you shortly.

How do I pay for a class?

You can pay at the time of registration using credit card (Mastercard/Visa/American Express) cheque or PO.

What if I have training credits?

ExitCertified honors all savings programs from the partners we work with. ExitCertified also offers training credits across multiple partners through our FLEX Account.

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Lunchtime?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

This is my second class with this Tech Data ExitCertified Personnel. I learned so much in BigFix Foundations and BigFix Inventory. Very well organized training instructors and well organized course contents and labs. I am glad I have attended.

Tech Data provided me with all the resources required to familiarize myself with the TRIRIGA Lease module. The facilitator was very knowledgeable and provided comprehensive exercises and support to aid in my understanding of the application.

Tommy was a great instructor. We relied on this class to develop our understanding, and we were very happy with the result.

I really enjoy the subject matter presented in this course. The instructor was very well verse and presented the material in a easy to understand and professional way... Great job!

Lab infraestructure is very suitable and works pretty good help to understand better the concepts exposed during the training.

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward