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