Moving To Managed Databases on AWS

Curriculum description

The lift-and-shift strategy is a common move for organizations making their first foray into the cloud. This lift-and-shift strategy may feel like the easiest way to move to the cloud. Your architecture map still looks similar, and your team’s responsibilities don’t change. But you're not getting the full benefits of the cloud.

In this eight-course curriculum, you will learn the value and process of moving from self-managed databases (on premises or in the cloud) into fully managed Amazon Web Services (AWS) database solutions. In this curriculum, AWS Hero Alex DeBrie explains how to move to a managed database service on AWS. You can either watch Alex explain the steps of the migration process or follow along using your own AWS account. By the end of the curriculum, you will have a realistic perspective on the entire database migration process.      • Course level: Fundamental      • Duration: 4 hours

Activities

This course includes presentations and video demonstrations.

Curriculum objectives

In this course, you will learn to:      • Explain the value of moving from a self-managed database into a fully managed database solution      • Identify the factors you need to consider when moving to a managed database      • Migrate from Microsoft SQL Server to Amazon RDS      • Migrate from Oracle to Amazon RDS      • Migrate from MySQL to Amazon RDS      • Migrate from PostgreSQL to Amazon RDS      • Migrate from MongoDB to Amazon DocumentDB      • Migrate from Apache Cassandra to Amazon Keyspaces (for Apache Cassandra)      • Migrate from Redis to Amazon ElastiCache

Intended audience

This curriculum 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      • AWS Planning and Designing Databases course

Curriculum outline

Course 1: Moving to Managed Databases on AWS      • Lesson 1. Introduction      • Lesson 2. Why move to managed      • Lesson 3. Factors to consider in choosing a managed database      • Lesson 4. Next steps

Course 2: Migrating from Microsoft SQL Server to Amazon RDS      • Lesson 1. Introduction      • Lesson 2. Create SQL Server database instance in Amazon RDS      • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)      • Lesson 4. Create source and target endpoints for your database migration      • Lesson 5. Create a replication task in AWS DMS      • Lesson 6. Complete the migration and clean up resources      • Lesson 7. Conclusion

Course 3: Migrating from Oracle to Amazon RDS      • Lesson 1. Introduction      • Lesson 2. Create an Oracle database instance in Amazon RDS      • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)      • Lesson 4. Create source and target endpoints for your database migration      • Lesson 5. Create a replication task in AWS DMS      • Lesson 6. Complete the migration and clean up resources      • Lesson 7. Conclusion

Course 4: Migrating from MySQL to Amazon RDS      • Lesson 1. Introduction      • Lesson 2. Create a MySQL database instance in Amazon RDS      • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)      • Lesson 4. Create source and target endpoints for your database migration      • Lesson 5. Create a replication task in AWS DMS      • Lesson 6. Complete the migration and clean up resources      • Lesson 7. Conclusion

Course 5: Migrating from PostgreSQL to Amazon RDS      • Lesson 1. Introduction      • Lesson 2. Create a PostgreSQL database instance in Amazon RDS      • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)      • Lesson 4. Create source and target endpoints for your database migration      • Lesson 5. Create a replication task in AWS DMS      • Lesson 6. Complete the migration and clean up resources      • Lesson 7. Conclusion

Course 6: Migrating from MongoDB to Amazon DocumentDB      • Lesson 1. Introduction      • Lesson 2. Create an Amazon DocumentDB database cluster      • Lesson 3. Create a replication instance in AWS Database Migration Service (AWS DMS)      • Lesson 4. Create source and target endpoints for your database migration      • Lesson 5. Create a replication task in AWS DMS      • Lesson 6. Complete the migration and clean up resources      • Lesson 7. Conclusion

Course 7: Migrating from Apache Cassandra to Amazon Keyspaces      • Lesson 1. Introduction      • Lesson 2. Create a source Cassandra cluster in Amazon EC2 (optional)      • Lesson 3. Create an Amazon Keyspaces table      • Lesson 4. Migrate your existing data from your source Cassandra instance to your Amazon Keyspaces table      • Lesson 5. Complete the migration and clean up resources      • Lesson 6. Conclusion

Course 8: Migrating from Redis to Amazon ElastiCache      • Lesson 1. Introduction      • Lesson 2. Create a source Redis instance in Amazon EC2 (optional)      • Lesson 3. Create a Redis cluster in ElastiCache      • Lesson 4. Perform an online migration from an existing Redis instance to your ElastiCache cluster      • Lesson 5. Complete the migration and clean up resources      • Lesson 6. Conclusion