Udemyallen

Migrate on-prem Oracle 12c Database to AWS RDS 19c instance

Migrate Oracle 12c to AWS RDS 19c. Learn Data Pump export/import for a smooth database migration. Step-by-step guide.

4.4(10)
927students
1h 10m
Hamid Ozair
Hamid OzairOracle, SQL server, PostgreSQL, MySQL, AWS

Course Content

Migrate on-prem Oracle 12c Database to AWS RDS 19c instance is an all-levels Udemy course taught by Hamid Ozair. It runs 1h 10m and is taught in English. Learners rate it 4.4 out of 5 from 10 reviews, with 927 students enrolled. It is free to enroll, first published May 2025.

Looking to migrate your Oracle 12c database to AWS RDS 19c? This comprehensive, hands-on course provides a step-by-step guide to a successful cloud migration using Oracle Data Pump (expdp/impdp). Whether you're a DBA, Cloud Engineer, or IT professional exploring AWS, this course delves into the practical details and best practices for cloud migration with real-world examples.

We'll cover the entire process, from setting up your AWS RDS instance to exporting and importing data, including schema-level migration and post-migration validation. No prior AWS experience is required, but a basic understanding of Oracle databases and the Linux command line is recommended.

By the end of this course, you'll be able to confidently migrate Oracle databases to AWS RDS using Data Pump, setting you up for future migrations.

Here's what you will learn:

  • Key differences between Oracle 12c (on-premise) and Oracle 19c in AWS RDS: Understand the crucial distinctions for a smooth transition.
  • Setting up AWS RDS for Oracle 19c: A detailed walkthrough of configuring your target environment.
  • Preparing Oracle 12c for migration: Essential pre-migration steps to ensure data integrity.
  • Exporting data using Oracle Data Pump (expdp): Master the process of data extraction.
  • Importing data into AWS RDS 19c (impdp): Learn how to efficiently load data into your new instance.
  • Perform an AWS RDS setup and configure the target Oracle 19c instance: Hands-on configuration for optimal performance.
  • Handling pre- and post-migration validation: Ensure data accuracy and completeness.
  • Monitoring, troubleshooting, and performance tuning: Optimize your migrated database for peak performance.
  • Creating a par file from the Data export: Learn to create par files for efficient data transfer.
  • Creating a par file for the Data Pump import: Master par file creation for faster import speeds.
$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.