We may earn an affiliate commission when you visit our partners.

Introduction to Database Migration

Most applications need to store data in some form of database. Amazon Web Services (AWS) provides several tools to help you migrate your databases, and the applications that use them, to the cloud. You can change their database management system (DBMS) or even their architecture from SQL to NoSQL, as appropriate.

It is fairly simple to migrate data from one server to another when both are using the same database engine, known as homogeneous migration. Going to a different engine, or heterogeneous migration, is harder and may require changes in your application.

In this course, you will learn about two database tools: AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS).

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.

All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

Valid until August 30

Google AI App Builder

Learn how to use Gemini API and API Studio with a three-course series from Google DeepMind

What's inside

Syllabus

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Covers real-world concepts, methods, and skills necessary for homogeneous and heterogeneous database migrations

Provides practical demonstrations with recommended tools and services to make the implementation of these changes easier

Offers comprehensive insights into database migration strategies, both homogeneous and heterogeneous

Taught by experienced AWS instructors, ensuring high-quality content and practical knowledge

Covers a range of relevant tools and services, including AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS)

Suitable for individuals seeking guidance to migrate their databases to the cloud

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.

Save

Reviews summary

Aws database migration fundamentals

According to learners, this course provides a solid and practical introduction to database migration on AWS, primarily focusing on AWS SCT and AWS DMS. Many found the hands-on labs and demonstrations particularly beneficial for understanding complex concepts. While it offers a strong foundation for homogeneous and heterogeneous migrations, some students noted that the course might lack the depth required for more advanced or complex real-world scenarios. Reviewers appreciate the clear explanations, though a few recent comments suggest certain sections could benefit from updates to reflect the latest AWS console changes or best practices. Overall, it's considered a valuable starting point for professionals.

Instructors explain concepts clearly and effectively.

"The instructor explained the concepts very clearly, making it easy to follow along even for complex topics."

"I found the lecturer's pace and articulation excellent; they made potentially dry material engaging."

"They did a great job of breaking down technical jargon into understandable terms."

Provides a clear introduction to database migration.

"This course gave me a really strong foundational understanding of homogeneous and heterogeneous database migrations to AWS."

"I appreciated how it broke down complex ideas into manageable parts, making the initial learning curve smooth."

"It's a great starting point if you're new to database migration or AWS cloud services."

Excellent demos and labs for tool understanding.

"The hands-on labs and practical demonstrations were the most valuable part, really helping me grasp AWS SCT and DMS."

"I found the exercises incredibly useful for applying the concepts taught. It wasn't just theory, but real application."

"The walkthroughs of setting up DMS tasks and using SCT for schema conversion were very clear and easy to follow."

Some sections reflect outdated AWS console UI.

"The AWS console screenshots and UI have changed significantly, which made following along a bit confusing at times."

"I noticed some of the lab instructions didn't quite match the current AWS interface, requiring me to figure out workarounds."

"It would be really helpful if the course material was updated to reflect the most recent AWS interface changes."

Too basic for experienced users, lacks complex scenarios.

"While good for beginners, I found myself wishing for more in-depth coverage on complex migration strategies and troubleshooting."

"For someone with prior experience, the content felt a bit superficial. It didn't dive into advanced optimization or large-scale migrations."

"I was hoping for more specific use cases or challenges related to heterogeneous migrations beyond the basics."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Introduction to Database Migration with these activities:

Review SQL and NoSQL

Show steps

Refresh your knowledge of SQL and NoSQL to strengthen your understanding of database migration concepts and techniques.

Browse courses on SQL

Show steps

Review basic SQL syntax and commands.
Practice writing SQL queries to retrieve, insert, update, and delete data.
Explore different NoSQL database types, such as document, key-value, and graph databases.

Organize and Review Course Materials

Show steps

Regularly organize and review course materials to strengthen your understanding, identify knowledge gaps, and prepare for assessments.

Show steps

Establish a system for organizing notes, assignments, and other materials.
Review course materials regularly, taking note of key concepts and ideas.
Identify areas where you need further clarification or support.
Prepare for assessments by revisiting materials and practicing exercises.

Practice Database Migration Exercises

Show steps

Engage in hands-on exercises to apply your knowledge of AWS Schema Conversion Tool and AWS Database Migration Service, improving your proficiency in database migration.

Browse courses on Database Migration

Show steps

Set up a test environment for database migration.
Use AWS Schema Conversion Tool to convert database schemas from one format to another.
Use AWS Database Migration Service to migrate data from one database to another.

Five other activities

Expand to see all activities and additional details

Show all eight activities

Follow Guided Tutorials on Database Migration Tools

Show steps

Enhance your understanding of database migration tools by following step-by-step tutorials, solidifying your knowledge and skills.

Browse courses on Database Migration

Show steps

Identify relevant tutorials on AWS Schema Conversion Tool and AWS Database Migration Service.
Follow the tutorials carefully, completing the exercises and examples provided.
Document your learnings and insights from the tutorials.

Develop a Database Migration Plan

Show steps

Create a comprehensive database migration plan to demonstrate your understanding of the principles and best practices involved in database migration.

Browse courses on Database Migration

Show steps

Determine the scope and objectives of the database migration.
Assess the current database environment and identify potential challenges.
Select appropriate migration tools and strategies.
Develop a detailed migration plan, including timelines and risk mitigation measures.

Migrate a Sample Database Using AWS Tools

Show steps

Undertake a practical project to migrate a sample database using AWS Schema Conversion Tool and AWS Database Migration Service, solidifying your skills and gaining hands-on experience.

Browse courses on Database Migration

Show steps

Set up a test environment for database migration.
Select a sample database for migration.
Use AWS Schema Conversion Tool to convert the database schema.
Use AWS Database Migration Service to migrate the data.
Test the migrated database and ensure its integrity.

Attend an AWS Database Migration Workshop

Show steps

Engage in an immersive learning experience at an AWS Database Migration Workshop, where you can interact with experts, network with peers, and gain practical insights.

Browse courses on Database Migration

Show steps

Register and attend the workshop.
Research and identify relevant AWS Database Migration Workshops.
Actively participate in sessions and discussions.
Network with other attendees and speakers.

Contribute to Open Source Database Migration Projects

Show steps

Make meaningful contributions to open source database migration projects, gaining valuable experience and demonstrating your expertise in the field.

Browse courses on Database Migration

Show steps

Identify open source database migration projects that align with your interests and skills.
Review the project documentation and codebase.
Propose and implement improvements or new features.
Collaborate with other contributors and maintainers.
Document your contributions and share your experiences.

Career center

Learners who complete Introduction to Database Migration will develop knowledge and skills that may be useful to these careers:

Database Administrator

Database Administrators (DBAs) are responsible for designing, implementing, and maintaining databases. They ensure that data is accurate, secure, and accessible. This course can help aspiring DBAs prepare for a career in database management. It provides an overview of database migration techniques and tools, which are essential for DBAs who need to migrate data between different database systems.

See salaries and explore the career path for Database Administrator

Data Architect

Data Architects design and manage data systems. They work with business stakeholders to understand data requirements and translate them into technical specifications. This course can help aspiring Data Architects build a foundation in database migration. It provides an overview of different database migration techniques and tools, which can help Data Architects make informed decisions when migrating data between different database systems.

See salaries and explore the career path for Data Architect

Database Developer

Database Developers design, develop, and maintain database applications. They work with users to gather requirements and translate them into database designs. This course can help aspiring Database Developers learn about database migration techniques and tools. This knowledge can be helpful when developing database applications that need to migrate data between different database systems.

See salaries and explore the career path for Database Developer

Data Engineer

Data Engineers build and maintain data pipelines. They collect, clean, and transform data from various sources into a usable format. This course can help aspiring Data Engineers learn about database migration techniques and tools. This knowledge can be helpful when building data pipelines that need to migrate data between different database systems.

See salaries and explore the career path for Data Engineer

Software Engineer

Software Engineers design, develop, and maintain software applications. They work with users to gather requirements and translate them into software designs. This course may be useful for aspiring Software Engineers who need to learn about database migration techniques and tools. This knowledge can be helpful when developing software applications that need to migrate data between different database systems.

See salaries and explore the career path for Software Engineer

Cloud Architect

Cloud Architects design and manage cloud computing solutions. They work with clients to understand their business needs and translate them into cloud architectures. This course may be useful for aspiring Cloud Architects who need to learn about database migration techniques and tools. This knowledge can be helpful when designing and managing cloud computing solutions that need to migrate data between different database systems.

See salaries and explore the career path for Cloud Architect

Data Scientist

Data Scientists use data to solve business problems. They collect, clean, and analyze data to identify trends and patterns. This course may be useful for aspiring Data Scientists who need to learn about database migration techniques and tools. This knowledge can be helpful when collecting and analyzing data from different database systems.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts gather and analyze business requirements. They work with stakeholders to understand their needs and translate them into business solutions. This course may be useful for aspiring Business Analysts who need to learn about database migration techniques and tools. This knowledge can be helpful when gathering and analyzing business requirements for data migration projects.

See salaries and explore the career path for Business Analyst

Project Manager

Project Managers plan and execute projects. They work with stakeholders to define project goals and timelines. This course may be useful for aspiring Project Managers who need to learn about database migration techniques and tools. This knowledge can be helpful when planning and executing data migration projects.

See salaries and explore the career path for Project Manager

Data Analyst

Data Analysts collect, clean, and analyze data. They use data to identify trends and patterns. This course may be useful for aspiring Data Analysts who need to learn about database migration techniques and tools. This knowledge can be helpful when collecting and analyzing data from different database systems.

See salaries and explore the career path for Data Analyst

IT Manager

IT Managers plan and manage IT systems. They work with users to identify their needs and translate them into IT solutions. This course may be useful for aspiring IT Managers who need to learn about database migration techniques and tools. This knowledge can be helpful when planning and managing IT systems that need to migrate data between different database systems.

See salaries and explore the career path for IT Manager

Technical Writer

Technical Writers create and maintain technical documentation. They work with subject matter experts to gather information and translate it into written form. This course may be useful for aspiring Technical Writers who need to learn about database migration techniques and tools. This knowledge can be helpful when creating and maintaining technical documentation for data migration projects.

See salaries and explore the career path for Technical Writer

Quality Assurance Analyst

Quality Assurance Analysts test software and systems to ensure they meet quality standards. They work with developers to identify and fix defects. This course may be useful for aspiring Quality Assurance Analysts who need to learn about database migration techniques and tools. This knowledge can be helpful when testing data migration projects to ensure they meet quality standards.

See salaries and explore the career path for Quality Assurance Analyst

Database Security Analyst

Database Security Analysts protect databases from unauthorized access and use. They work with database administrators to implement security measures and monitor database activity. This course may be useful for aspiring Database Security Analysts who need to learn about database migration techniques and tools. This knowledge can be helpful when implementing security measures for data migration projects.

See salaries and explore the career path for Database Security Analyst

Network Administrator

Network Administrators plan and manage computer networks. They work with users to identify their needs and translate them into network solutions. This course may be useful for aspiring Network Administrators who need to learn about database migration techniques and tools. This knowledge can be helpful when planning and managing networks that need to support data migration projects.

See salaries and explore the career path for Network Administrator

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Introduction to Database Migration.

PostgreSQL: Up and Running

Save

Provides a comprehensive guide to PostgreSQL, which can be helpful for those working with this database engine or considering migrating to it.

PostgreSQL: Up and Running: A Practical Guide to...

Kindle Edition

High Performance MySQL

Save

Provides detailed insights into MySQL performance optimization, backups, replication, and scaling, which can be valuable for those working with MySQL databases.

High Performance MySQL: Optimization, Backups, and...

Paperback

High Performance MySQL: Optimization, Backups,...

Paperback

(中文) High Performance MySQL ( 3rd Edition ) (MySQL...

Paperback

MongoDB: The Definitive Guide

Save

While specific to MongoDB, it provides a comprehensive overview of this NoSQL database, which may be relevant for those considering migrating to AWS NoSQL services.

MongoDB: The Definitive Guide

Paperback