AWS Cloud for Data and Database Migration

This course is part of Mastering Cloud: Security, Optimization & Migration on AWS Specialization

Instructor: Edureka

Access provided by Mojatu Foundation

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Identify the features and use cases of AWS Database Services like RDS, DynamoDB, and Redshift.
Explain the concepts and benefits of AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT)
Compare homogeneous and heterogeneous migration methods and choose the best strategy.
Design a comprehensive database migration plan using AWS services, ensuring scalability and cost-efficiency.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

16 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Mastering Cloud: Security, Optimization & Migration on AWS Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

Welcome to the AWS Cloud for Data and Database Migration course. In this comprehensive program, you will explore key AWS database services, including Amazon RDS, DynamoDB, and Amazon Redshift. Discover their core features and learn to design scalable, secure, and cost-efficient cloud database architectures.

Delve into database migration strategies, leveraging tools like AWS Database Migration Service (DMS) and the AWS Schema Conversion Tool (SCT) to overcome migration challenges and accelerate your journey to the cloud. The course also covers essential AWS migration tools and services such as Storage Gateway, AWS Snowball, and AWS Direct Connect, empowering you to manage seamless data and database migration projects. By the end of this course, you will be able to: - Identify core AWS Database Services and their distinguishing features. - Assess and apply AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for migration scenarios. - Demonstrate hands-on database migration using AWS DMS. - Compare homogeneous and heterogeneous migration methods and select appropriate tools. - Design robust, scalable, and cost-optimized cloud database architectures tailored to business needs. This course is designed for cloud professionals, engineers, architects, and IT practitioners seeking advanced knowledge and practical skills in AWS data and database migrations. Prior experience with Cloud Computing and core AWS services is recommended. Join us and master AWS-powered data and database migration, building expertise that will help drive successful cloud transformation in your organization.

In this module, you will explore the core AWS Database Services, including Amazon RDS, DynamoDB, and Amazon Redshift, to understand their features and use cases. You will learn how to choose the right database solution for different workloads and design highly scalable and cost-efficient architectures.

What's included

22 videos4 readings4 assignments3 discussion prompts

22 videos Total 112 minutes

Course Introduction: AWS Cloud for Data and Database Migration 3 minutes
Overview of AWS Database Services 7 minutes
Amazon RDS 5 minutes
RDS Database Instance 7 minutes
Identity and Access Management in Amazon RDS 6 minutes
Storing Application Data in MySQL DB using Amazon RDS - WampServer Installation 4 minutes
Storing Application Data in MySQL DB using Amazon RDS - Database Creation 5 minutes
Storing Application Data in MySQL DB using Amazon RDS - Executing CRUD Operations 4 minutes
Storing Application Data in MySQL DB using Amazon RDS - Connecting to Database 2 minutes
Amazon DynamoDB 7 minutes
Perform CRUD operations on No-SQL Database 5 minutes
Amazon ElastiCache - Introduction 5 minutes
Amazon ElastiCache - Use Cases 4 minutes
Creating an ElastiCache for Redis - Redis Creation 5 minutes
Creating an ElastiCache for Redis - Command Execution 4 minutes
Introduction to Data Warehouse 6 minutes
Amazon RedShift - Features and Architecture 6 minutes
Amazon RedShift - Data Processing Flow 3 minutes
Querying Data from S3 with Redshift - Bucket and Role Creation 5 minutes
Querying Data from S3 with Redshift - Redshift Query Editor 5 minutes
Introduction to Amazon Aurora 6 minutes
Overview of Amazon Keyspaces 6 minutes

4 readings Total 30 minutes

Welcome to AWS Cloud for Data and Database Migration 10 minutes
How to use Discussion Prompt 5 minutes
Introduction to Amazon Neptune 10 minutes
Summary: AWS Database Services 5 minutes

4 assignments Total 38 minutes

Practice Quiz: Relational Database Services (RDS) 6 minutes
Practice Quiz: Amazon DynamoDB and ElastiCache 6 minutes
Practice Quiz: Advanced AWS Database Solutions 6 minutes
Knowledge Check: AWS Database Services 20 minutes

3 discussion prompts Total 15 minutes

Introduce Yourself 5 minutes
RDS Engine Selection 5 minutes
Redis and Memcached 5 minutes

This module focuses on AWS Database Migration Service (DMS), providing insights into overcoming database migration challenges and effective planning strategies. Learners will discover how to integrate DMS with services like Amazon RDS, DynamoDB, and Redshift and explore the AWS Schema Conversion Tool (SCT) for database conversions.

What's included

12 videos2 readings4 assignments2 discussion prompts

12 videos Total 48 minutes

AWS Database Migration Challenges 3 minutes
Planning of Database Migration 6 minutes
What is AWS Database Migration Service (DMS)? 5 minutes
AWS DMS Related Services 4 minutes
Amazon RDS with AWS DMS 4 minutes
DynamoDB and AWS DMS Integration 4 minutes
Integrating AWS DMS with Amazon Redshift 3 minutes
AWS CloudFormation with AWS DMS 7 minutes
What is the AWS Schema Conversion Tool? 4 minutes
DB Conversions Supported By SCT 3 minutes
Working of DMS and SCT 4 minutes
AWS DMS Components 3 minutes

2 readings Total 10 minutes

Integrating AWS Database Migration Service with AWS Schema Conversion Tool 5 minutes
Summary: AWS Database Migration Service 5 minutes

4 assignments Total 38 minutes

Practice Quiz: AWS Database Migration 6 minutes
Practice Quiz: AWS Database Migration Service Related Services 6 minutes
Practice Quiz: AWS Schema Conversion Tool and AWS DMS 6 minutes
Knowledge Check: AWS Database Migration Service 20 minutes

2 discussion prompts Total 10 minutes

Migration Approach using AWS DMS 5 minutes
Best Practices of AWS DMS 5 minutes

Throughout this module, learners will explore various strategies for migrating databases to AWS. They will learn about the stages of database migration, the differences between homogeneous and heterogeneous migrations, and how to leverage AWS Database Migration Service (DMS) and AWS Schema Conversion Tool (SCT).

What's included

10 videos1 reading3 assignments1 discussion prompt

10 videos Total 46 minutes

AWS DB Migration Stages 3 minutes
Database Migration With AWS DMS 3 minutes
Database Migration Types - Homogeneous 4 minutes
Database Migration Types - Heterogenous 4 minutes
Database Migration With AWS SCT 4 minutes
Data Migration using AWS Database Migration Service - Replication Instance 7 minutes
Data Migration using AWS Database Migration Service - CRUD Operations 5 minutes
Data Migration using AWS Database Migration Service - Database Migration Task 5 minutes
Migrating from SQL Server to Amazon DynamoDB using AWS Database Migration Service - Replication Instance and Endpoints 6 minutes
Migrating from SQL Server to Amazon DynamoDB using AWS Database Migration Service - Database Migration Task 6 minutes

1 reading Total 5 minutes

Summary: Database Migration Strategies to AWS 5 minutes

3 assignments Total 32 minutes

Practice Quiz: Database Migration To AWS 6 minutes
Practice Quiz: Homogeneous and Heterogenous Database Migration 6 minutes
Knowledge Check: Database Migration Strategies to AWS 20 minutes

1 discussion prompt Total 5 minutes

Advantages and Challenges of Homogeneous Database Migrations 5 minutes

In this module, you will explore various strategies and services for migrating data to AWS, including the advantages, challenges, and different transfer methods. You will learn about key AWS services such as Storage Gateway, Snowball, and Direct Connect to facilitate both online and offline data transfers.

What's included

16 videos2 readings4 assignments3 discussion prompts

16 videos Total 83 minutes

What is Data Migration to AWS 6 minutes
Advantages of Data Migration 3 minutes
Data Migration Challenges 4 minutes
AWS Storage Gateway 6 minutes
AWS Storage Gateway - Demonstration 5 minutes
AWS Snowball 4 minutes
AWS Snowball Edge 5 minutes
AWS Direct Connect 7 minutes
Amazon S3 Transfer Acceleration 5 minutes
Amazon Data Firehose 5 minutes
AWS DataSync 7 minutes
AWS Transfer Family 4 minutes
Enable File Share For SMB Using AWS Storage Gateway - Create Gateway 7 minutes
Enable File Share For SMB Using AWS Storage Gateway - File Share 6 minutes
Enable S3 Transfer Acceleration on a Bucket to Accelerate the Copy of Files - Identity and Authentication 6 minutes
Enable S3 Transfer Acceleration on a Bucket to Accelerate the Copy of Files - Data Transfer 5 minutes

2 readings Total 15 minutes

AWS Outposts 10 minutes
Summary: AWS Data Migration 5 minutes

4 assignments Total 38 minutes

Practice Quiz: Migrating Data to AWS 6 minutes
Practice Quiz: Data Migration-Related Services 6 minutes
Practice Quiz: Storage Gateway and S3 Transfer Acceleration 6 minutes
Knowledge Check: AWS Data Migration 20 minutes

3 discussion prompts Total 30 minutes

The Role of Planning in AWS Data Migration 10 minutes
Choosing the Right Data Transfer Service 10 minutes
Optimizing File Sharing with AWS Storage Gateway 10 minutes

This module is designed to assess an individual on the various concepts and teachings covered in this course. Evaluate your knowledge with a comprehensive graded quiz on the AWS Database Migration and Data Migration Strategies on AWS.