In this three-course curriculum, you will learn about the value and process of moving from legacy databases into cloud-native databases. In the first course, you will learn why you would want to break free from legacy databases and the key factors to consider in choosing a cloud-native database. Then in the next two courses, you can either follow along, or view walk-through tutorial examples of moving to a cloud-native relational database, such as Amazon Aurora, or a cloud-native NoSQL database, such as Amazon DynamoDB.
- Course level: Intermediate
- Duration: 1 hour and 45 minutes
Activities
- This curriculum includes courses with presentations and video demonstrations.
Curriculum objectives
In this curriculum, you will learn to:
- Explain the value of using cloud-native databases to meet specific application needs
- Explain the value of moving from a legacy database into a cloud-native database solution
- Identify the factors you need to consider when moving to a cloud-native database
- Migrate from a legacy Oracle database to a cloud-native relational database with Amazon Aurora
- Migrate from a legacy Microsoft SQL Server database to a cloud-native NoSQL database with Amazon DynamoDB
This curriculum is intended for:
- Customers, Amazonians, and AWS Partners who have experience with Amazon Web Services (AWS), including a background in database administration and design
- Data platform engineers
- Database developers
- Solutions architects
Prerequisites
We recommend that attendees of this curriculum have:
- Basic understanding of databases, including maintenance and support
- Completed the AWS Planning and Designing Databases course 
Curriculum outline
Course 1: Breaking Free from Legacy Databases
- Lesson 1. Introduction
- Lesson 2. Why break free from legacy databases?
- Save money on licenses and operating expenses
- Better performance with cloud-native design
- Faster development speed
- Lesson 3. Factors to consider in choosing a cloud-native database
- Choose a cloud-native database type
- Choose a migration process
- Lesson 4. Next steps
- Complete one or more of the hands-on migration courses within this curriculum based on your database situation
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
Course 3: Migrating from Microsoft SQL Server to Amazon DynamoDB
- Lesson 1. Introduction
- Lesson 2. Create a SQL Server database
- Lesson 3. Load your SQL Server database with sample data
- Lesson 4. Create a DynamoDB table
- Lesson 5. Create a replication instance in AWS DMS
- Lesson 6. Create endpoints in AWS DMS
- Lesson 7. Create a replication task in AWS DMS
- Lesson 8. Complete the migration and clean up resources
- Lesson 9. Conclusion
