Break Free of Legacy Databases

Curriculum description 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