Course description

  • 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
    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

    • Lesson 00 - Overview

      04:16
      • 0.1 Overview
        04:16
    • Lesson 01 - Overview of AWS DMS

      27:37
      • 1.1 Overview of AWS DMS
        00:48
      • 1.2 Introduction to AWS DMS
        02:31
      • 1.3 Knowledge check
      • 1.4 Difficulty of DMS
        05:03
      • 1.5 Knowledge check
      • 1.6 Overview of AWS database migration service
        01:25
      • 1.7 Knowledge check
      • 1.8 Overview of AWS Schema Conversion Tool
        01:17
      • 1.9 Knowledge check
      • 1.10 Why AWS DMS is Different from Other Tools and Services
        04:05
      • 1.11 Knowledge check
      • 1.12 Overview of AWS DMS Key Features and Benefits
        06:56
      • 1.13 Knowledge check
      • 1.14 Demo Environment Overview
        02:46
      • 1.15 Quiz
      • 1.16 Key Takeaways
        02:46
    • Lesson 02 - Schema Conversion Tool

      34:14
      • 2.1 Schema Conversion tool
        00:40
      • 2.2 Learn the actions AWS Schema Conversion Tool can perform
        02:15
      • 2.3 Knowledge check
      • 2.4 Overview of steps in heterogeneous OLTP database migrations
        10:06
      • 2.5 Knowledge check
      • 2.6 OLTP database conversion from SQL Server to MySQL
        05:57
      • 2.7 Overview of steps in heterogeneous warehouse database migrations
        03:01
      • 2.8 Knowledge check
      • 2.9 Overview of how to deal with unmapped objects
        02:19
      • 2.10 Knowledge check
      • 2.11 Manually repair objects that cannot be converted automatically
        08:08
      • 2.12 Quiz
      • 2.13 Key Takeaways
        01:48
    • Lesson 03 - Database Migration Service

      37:49
      • 3.1 Database Migration Service
        00:49
      • 3.2 Homogenous Migration Restriction
        01:17
      • 3.3 Knowledge check
      • 3.4 Database Consolidation Overview
        01:25
      • 3.5 Knowledge check
      • 3.6 Continuous Data Replication Overview
        01:13
      • 3.7 Knowledge check
      • 3.8 Configuring an AWS DMS Task
        21:57
      • 3.9 Knowledge check
      • 3.10 Demo Migrate data using AWS DMS
        09:57
      • 3.11 Quiz
      • 3.12 Key Takeaways
        01:11
    • Lesson 04 - AWS Database Migration Service Review

      12:41
      • 4.1 Database Migration Service
        00:37
      • 4.2 AWS DMS Data Types
        01:18
      • 4.3 Knowledge check
      • 4.4 Monitoring a Database Migration Task
        02:41
      • 4.5 Knowledge check
      • 4.6 AWS DMS Best Practices
        05:26
      • 4.7 Knowledge check
      • 4.8 AWS Database Migration Service Information
        01:33
      • 4.9 Key Takeaways
        01:06
    • Course Feedback

      • Course Feedback
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Course advisor

Marc Weaver
Marc Weaver AWS Solutions Architect & DB Expert, Author and Founder - Databasable

Marc is an AWS solutions architect and Database Expert. He has over 15+ years of experience working with investments banks across the globe. He has authored courses on AWS solutions architecture and Database migration.

    FAQs

    • How do I enroll in this program?

      You enroll in the program on the Simplilearn website, and make an online payment using any of the following options. You will be emailed a receipt after the payment is made.
      • Visa Credit or Debit card
      • MasterCard
      • American Express
      • Diner’s Club
      • PayPal

    • Will the access period be extended?

      Yes, you can extend the access period by paying an additional fee. Contact Customer Service through our Help and Support portal.

    • I have trouble accessing the online course whom should I contact?

      If you have trouble accessing the course at any time, use the Help & Support link to contact our Support team. You can also use the Live Chat link to chat in real-time with one of our Support team members.

    • I’d like to learn more about this training program. Who should I contact?

      Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

    Contact Us

    +1-844-532-7688

    (Toll Free)

    • Disclaimer
    • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.