YoVDO

Migrating from Microsoft SQL Server to Amazon DynamoDB

Offered By: Amazon Web Services via AWS Skill Builder

Tags

Amazon Web Services (AWS) Courses Cloud Computing Courses Microsoft SQL Server Courses Amazon DynamoDB Courses NoSQL Databases Courses Database Administration Courses Database Migration Courses Data Platform Engineering Courses AWS Database Migration Service Courses

Course Description

Overview

  • Amazon DynamoDB is a cloud-native NoSQL database offering from Amazon Web Services (AWS). Its scale and performance characteristics have made DynamoDB one of the fastest growing services in AWS history. In this third course from the Breaking Free from Legacy Databases curriculum, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating a Microsoft SQL Server database to DynamoDB. You can watch Alex explain the steps of the migration process or follow along using your own AWS account.
    Course level: Intermediate
  • Duration: 40 minutes


Activities

This course includes presentations and video demonstrations.


Course objectives

In this course, you will learn to:

  • Migrate from a legacy Microsoft SQL Server database to a cloud-native NoSQL database with Amazon DynamoDB


This course 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
  • Completed the AWS Planning and Designing Databases courseā€ƒ


Course outline

Course 3: Migrating from Microsoft SQL Server to Amazon DynamoDB

  • Lesson 1. Introduction
  • Lesson 2. Create a SQL Server database
  • Lesson 3. Load your SQL Server database with sample data
  • Lesson 4. Create a DynamoDB table
  • Lesson 5. Create a replication instance in AWS Database Migration Service (AWS DMS)
  • Lesson 6. Create endpoints in AWS DMS
  • Lesson 7. Create a replication task in AWS DMS
  • Lesson 8. Complete the migration and clean up resources
  • Lesson 9. Conclusion

Tags

Related Courses

Introduction to Data Science
University of Washington via Coursera
Web Engineering II: Developing Mobile HTML5 Apps
Technische Hochschule Mittelhessen via iversity
Cloud Computing Concepts, Part 1
University of Illinois at Urbana-Champaign via Coursera
Cloud Computing Concepts: Part 2
University of Illinois at Urbana-Champaign via Coursera
Fundamentals of database systems
Indian Institute of Technology Kanpur via Swayam