Migrating from Oracle to Amazon Aurora

Go to class
Write Review

Migrating from Oracle to Amazon Aurora provided by AWS Skill Builder is a comprehensive online course, which lasts for 1-2 hours worth of material. Upon completion of the course, you can receive an e-certificate from AWS Skill Builder. The course is taught in Englishand is Free Certificate. Visit the course page at AWS Skill Builder for detailed price information.

Overview
  • Amazon Aurora is a cloud-native relational database offered by Amazon Web Services (AWS). Its performance characteristics, ease of use, and compatibility with existing database engines have made it the fastest growing service in AWS history. In this second course from the Breaking Free from Legacy Databases curriculum, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating an Oracle database to Aurora. You can watch Alex explain the steps of the migration process or follow along using your own AWS account.

    Course level: Intermediate

    Duration: 40 minutes


    Activities

    This course includes presentations and video demonstrations.

    Course objectives

    In this course, you will learn to:

    • Migrate from a legacy Oracle database to a cloud-native relational database with Amazon Aurora


    This course is intended for:

    • Customers, Amazonians, and AWS Partners who have experience with AWS, including a background in database administration and design
    • Data platform engineers
    • Database developers
    • Solutions architects


    Prerequisites

    We recommend that attendees of this course have:

    • Basic understanding of databases, including maintenance and support
    • Completed the AWS Planning and Designing Databases course 


    Course outline

    Course 2: Migrating from Oracle to Amazon Aurora

    • Lesson 1. Introduction
    • Lesson 2. Create an Oracle database
    • Lesson 3. Load your Oracle database with sample data
    • Lesson 4. Create a PostgreSQL-compatible database in Aurora
    • Lesson 5. Migrate your schema with AWS Schema Conversion Tool (AWS SCT)
    • Lesson 6. Create a replication instance in AWS Database Migration Service (AWS DMS)
    • Lesson 7. Create endpoints in AWS DMS
    • Lesson 8. Create a replication task in AWS DMS
    • Lesson 9. Complete the migration and clean up resources
    • Lesson 10. Conclusion