What is the focus of this course?

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.

What are the course objectives?

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

Who should take this course?

• AWS absolute beginners
• Developers
• SysOps professionals

What project will you be working on?

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
• Install AWS Schema Conversion Tool
• Use AWS Schema Conversion Tool to verify migration efforts
• Fix migration issues
• Verify that the Database Assessment report is clean
• Use AWS Schema Conversion Tool to apply converted schema to MySQL
• Configure AWS DMS for the database migration
• Run the SQL Server to MySQL database migration
• Verify the migration was successful

Course preview

• Lesson 00 - Overview 
  • 0.1 Overview 
• Lesson 01 - Overview of AWS DMS 
  • 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
• Lesson 02 - Schema Conversion Tool 
  • 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
• Lesson 03 - Database Migration Service
  • 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
• Lesson 04 - AWS Database Migration Service Review
  • 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 Practies 
  • 4.7 Knowledge check
  • 4.8 AWS Database Migration Service Information 
  • 4.9 Key Takeaways
• Corse Feedback