Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Training Logo

Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Training

Live Online & Classroom Enterprise Certification Training

Powered By

Oracle Logo

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.

ATP_Authorized Logo

Powered By

Oracle Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What is Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Certification Training about?

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.

You will benefit from interactive sessions that cover these areas:

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.

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.


What are the objectives of Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Certification Training ?

  • 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 is Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Certification Training for?

  • Database Administrators
  • Cloud Administrator
  • Cloud System Integrators
  • Cloud Application Developer
  • Cloud Database Administrators
  • Cloud Data Architects
  • Cloud Technical Consultants
  • Cloud Architect

What are the prerequisites for Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Certification Training?

Suggested Prerequisite

  • Experience in Oracle Database 11g/12c Administration
  • General understanding of cloud technology
  • Working knowledge of Oracle Database Backup & Recovery conce
  • Working knowledge of managing Oracle Multitenant Database

Available Training Modes

Live Online Training

16 Hours

Classroom Training

2 Days

Course Outline Expand All

Expand All

  • Course Environment
  • Overview of Course Objectives
  • Course Prerequisites
  • Oracle Autonomous Data Warehouse Cloud: Key Features
  • Basic Data Warehouse Architecture
  • Oracle Cloud Platform for Data Warehousing
  • Data Warehouse: Introduction & Definition
  • Easy Migration to Autonomous Data Warehouse Cloud
  • Why Provision Oracle Data Warehouse Cloud Services?
  • General Considerations for Choosing a Migration Method
  • Oracle Autonomous Cloud Platform
  • Choosing a Method
  • Migration Life Cycle of a Target Cloud Database
  • Migration Considerations
  • Migration Strategy: Selection Criteria
  • Benefits of Migration
  • Prepare the Target Service Instance
  • Prepare the Source Database for Migration
  • Create the Target System: Autonomous Data Warehouse Cloud Instance
  • Create Storage Bucket Using Oracle Cloud Infrastructure Object Storage
  • Post-Migration Verification: Checklist
  • Special Consideration
  • Migrating Objects by Using SQL Developer
  • SQL Developer Offerings for Migration
  • Oracle SQL Developer: Migration Consideration
  • External Tables
  • Migrating Schema from On-Premises 11g or 12c Non-CDB or CDB to ADWC Service Instance
  • Special Considerations
  • Oracle Data Pump: Overview & Key Features
  • How Does Data Pump Load and Unload Table Row Data?
  • Importing a Dump File into Oracle Autonomous Data Warehouse Cloud
  • Direct Path Loads and Unloads
  • Querying Data on the Oracle Object Store
  • Query Data with External Table
  • Conclusion
  • Validating External Data
  • Post-Migration Verification Checklist
  • Comparing the Source and Target
  • Running Test Queries

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

Migrating On-Prem Data Mart to Autonomous Data Warehouse Cloud NEW Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of Oracle.
  • The training fees is exclusive of exam cost.
  • For any queries; feel free to reach us at oracle@springpeople.com

Reviews