AWS Database Migration Service Course:

Key features

  • 3 hours of self-paced learning
  • 5 live demos
  • 1 hands-on practice project

Exam & certification

Contact Us

GET IN TOUCH. WE LOVE TO HEAR FROM YOU.

Course Details

Course description

AWS Database Migration Service is an innovative service that helps you easily migrate your databases to the AWS cloud.



This course will demonstrate the key functionality of AWS Database Migration Service and will help you understand how to easily and securely move databases into the AWS cloud platform to take advantage of the cost savings and scalability of AWS.



You will also learn how the AWS Database Migration Service supports both homogenous and heterogeneous migrations and will see a demonstration of a SQL Server to MySQL database migration.

The main objectives of this course are:



  • Get an overview of AWS DMS

  • Understand how the AWS Schema Conversion tool works

  • Understand the three types of AWS Database Migration Service

  • Review the AWS Database Migration Service


  • AWS absolute beginners

  • Developers

  • SysOps professionals

As part of the coursework, you will complete the following project based on the industry use case.



Project #1: Migrate SQL Server database to MySQL using AWS DMS



Domain: Development



  1. Install AWS Schema Conversion Tool

  2. Use AWS Schema Conversion Tool to verify migration efforts

  3. Fix migration issues

  4. Verify that the Database Assessment report is clean

  5. Use AWS Schema Conversion Tool to apply converted schema to MySQL

  6. Configure AWS DMS for the database migration

  7. Run the SQL Server to MySQL database migration

  8. Verify the migration was successful

Course Preview

  • 1.1 Overview of AWS DMS
  • 1.2 Introduction to AWS DMS
  • 1.3 Knowledge check
  • 1.4 Difficulty of DMS
  • 1.5 Knowledge check
  • 1.6 Overview of AWS database migration service
  • 1.7 Knowledge check
  • 1.8 Overview of AWS Schema Conversion Tool
  • 1.9 Knowledge check
  • 1.10 Why AWS DMS is Different from Other Tools and Services
  • 1.11 Knowledge check
  • 1.12 Overview of AWS DMS Key Features and Benefits
  • 1.13 Knowledge check
  • 1.14 Demo Environment Overview
  • 1.15 Quiz
  • 1.16 Key Takeaways
  • 2.1 Schema Conversion tool
  • 2.2 Learn the actions AWS Schema Conversion Tool can perform
  • 2.3 Knowledge check
  • 2.4 Overview of steps in heterogeneous OLTP database migrations
  • 2.5 Knowledge check
  • 2.6 OLTP database conversion from SQL Server to MySQL
  • 2.7 Overview of steps in heterogeneous warehouse database migrations
  • 2.8 Knowledge check
  • 2.9 Overview of how to deal with unmapped objects
  • 2.10 Knowledge check
  • 2.11 Manually repair objects that cannot be converted automatically
  • 2.12 Quiz
  • 2.13 Key Takeaways
  • 3.1 Database Migration Service
  • 3.2 Homogenous Migration Restriction
  • 3.3 Knowledge check
  • 3.4 Database Consolidation Overview
  • 3.5 Knowledge check
  • 3.6 Continuous Data Replication Overview
  • 3.7 Knowledge check
  • 3.8 Configuring an AWS DMS Task
  • 3.9 Knowledge check
  • 3.10 Demo Migrate data using AWS DMS
  • 3.11 Quiz
  • 3.12 Key Takeaways
  • 4.1 Database Migration Service
  • 4.2 AWS DMS Data Types
  • 4.3 Knowledge check
  • 4.4 Monitoring a Database Migration Task
  • 4.5 Knowledge check
  • 4.6 AWS DMS Best Practices
  • 4.7 Knowledge check
  • 4.8 AWS Database Migration Service Information
  • 4.9 Key Takeaways
  • Course Feedback