Sorry, this page is no longer available

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

Migrating from Microsoft SQL Server to Amazon RDS

AWS Instructor

In this course, AWS Hero Alex DeBrie demonstrates the step-by-step process of migrating a Microsoft SQL Server database to Amazon Relational Database Service (Amazon RDS). You can either watch Alex explain the steps of the migration process or follow along using your own Amazon Web Services (AWS) account or the AWS Free Tier.

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

Appropriate for IT professionals with experience in Microsoft SQL Server and/or Amazon Web Services

Also appropriate for IT professionals wanting to enhance their skills in cloud database migration

Taught by AWS Hero Alex DeBrie, who is known for expertise in AWS database technologies

Save this course

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

Save

Reviews summary

Practical guide to sql server to rds migration

According to students, this course offers a largely positive and highly practical approach to migrating from Microsoft SQL Server to Amazon RDS. Learners consistently praise the clear, step-by-step explanations and the invaluable hands-on labs and demonstrations, which help solidify understanding. The instructor's expertise and clear communication are frequently highlighted. While the course provides a solid foundation and is excellent for those new to AWS RDS, some experienced professionals suggest it could benefit from more advanced topics or deeper dives into edge cases and troubleshooting. A few learners also noted that some content could be updated to reflect the latest AWS features.

Ideal for those new to AWS RDS or cloud database migration.

"As someone relatively new to AWS RDS, I found the explanations of database compatibility and migration tools extremely clear."

"It seems more geared towards beginners in the cloud/RDS space rather than experienced DBAs looking for advanced techniques."

"I had some basic SQL Server knowledge but was new to AWS RDS. The course walked me through the process step-by-step."

Instructor's knowledge and clarity enhance the learning experience.

"The instructor explained complex migration strategies for SQL Server to RDS with such clarity."

"The instructor's expertise shines through, and the hands-on practice cemented my understanding."

"The instructor was clear, and the labs were very useful."

Features essential labs and demos for real-world skill application.

"The hands-on labs were invaluable, making me feel confident about applying these skills in a real-world scenario."

"I appreciated the step-by-step approach and the practical demonstrations."

"The demos were easy to follow and the pace was just right. I especially liked the section on DMS."

"The hands-on parts are crucial."

Provides a systematic, easy-to-follow guide for database migration.

"The instructor explained complex migration strategies for SQL Server to RDS with such clarity."

"I found the explanations of database compatibility and migration tools extremely clear."

"This course provided me with the clear roadmap I needed for a project at work."

Some tools and features could benefit from recent updates.

"Also, some of the tools discussed were slightly outdated."

"My only minor gripe is that the content could be updated to reflect the latest AWS features..."

Could offer more advanced topics or detailed troubleshooting.

"It could benefit from more advanced topics, like dealing with large-scale migrations or specific edge cases."

"I was hoping for more deep dives into performance tuning post-migration or complex schema conversions."

"My main suggestion would be to add more troubleshooting tips for common migration issues, as I faced a few that weren't covered."

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 Migrating from Microsoft SQL Server to Amazon RDS with these activities:

Build a simple Microsoft SQL Server database

Show steps

Build a basic Microsoft SQL Server database to familiarize yourself with the platform and its features.

Browse courses on Microsoft SQL Server

Show steps

Install Microsoft SQL Server on your local machine.
Create a new database.
Add tables, columns, and data.
Write and execute queries to retrieve and manipulate data.

Review SQL Database Concepts

Show steps

Review the basics of SQL databases to ensure a strong foundation before migrating to Amazon RDS.

Browse courses on Microsoft SQL Server

Show steps

Read articles or tutorials on SQL database concepts.
Practice writing SQL queries to perform basic operations.

Follow a tutorial on migrating a Microsoft SQL Server database to Amazon RDS

Show steps

Follow a step-by-step tutorial to gain hands-on experience with the migration process.

Browse courses on Amazon RDS

Show steps

Find a reputable tutorial on Amazon RDS migration.
Gather the necessary prerequisites, such as an AWS account and a Microsoft SQL Server database.
Follow the tutorial instructions carefully.
Experiment with different migration options and settings.

Three other activities

Expand to see all activities and additional details

Show all six activities

Follow Amazon RDS Migration Tutorial

Show steps

Follow a step-by-step tutorial provided by Amazon to gain practical experience in migrating an SQL Server database to RDS.

Browse courses on Amazon RDS

Show steps

Find the Amazon RDS Migration Tutorial.
Set up the necessary AWS resources.
Follow the tutorial instructions to migrate the database.

Practice writing SQL queries in Amazon RDS

Show steps

Reinforce your understanding of SQL syntax and querying techniques by practicing in Amazon RDS.

Browse courses on Amazon RDS

Show steps

Set up a practice environment in Amazon RDS.
Write queries to create tables, insert data, and retrieve data.
Experiment with different query types, such as SELECT, INSERT, UPDATE, and DELETE.
Optimize your queries for performance.

Practice Migrating Sample Databases

Show steps

Reinforce your understanding by practicing the migration process with different sample databases.

Browse courses on Database Migration

Show steps

Find sample databases that are compatible with SQL Server.
Create an AWS RDS instance.
Migrate the sample databases to the RDS instance.
Verify the successful migration of the databases.

Career center

Learners who complete Migrating from Microsoft SQL Server to Amazon RDS will develop knowledge and skills that may be useful to these careers:

Data Engineer

Data Engineers help build, maintain, and develop an organization's big data systems. The information from this course will help teach foundational skills for the tools and software Data Engineers use on the job.

See salaries and explore the career path for Data Engineer

Database Administrator

Database Administrators are responsible for the performance, integrity, and security of an organization's databases. This course will help prepare individuals for the tools DBA's use on the job.

See salaries and explore the career path for Database Administrator

Systems Architect

Systems Architects design and build an organization's computer systems. This course will help individuals to improve their ability to integrate various systems with database tools.

See salaries and explore the career path for Systems Architect

Software Engineer

Software Engineers develop and maintain software programs. The tools and techniques taught in this course may be useful in developing database-integrated software.

See salaries and explore the career path for Software Engineer

Data Analyst

Data Analysts gather, analyze, and interpret data. This course may be useful in improving one's ability to analyze large datasets.

See salaries and explore the career path for Data Analyst

Cloud Architect

Cloud Architects design, build, and manage cloud computing systems. This course will help individuals build a foundation in cloud computing systems from a relational database perspective.

See salaries and explore the career path for Cloud Architect

DevOps Engineer

DevOps Engineers work to bridge the gap between development and operations teams. This course may be useful for understanding the work that databases play in operations and deployment.

See salaries and explore the career path for DevOps Engineer

Data Scientist

Data Scientists use scientific methods and processes to extract knowledge and insights from data. This course may be useful in helping Data Scientists to understand how to integrate various data sources.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts work with business stakeholders to analyze and solve business problems. This course may be useful for understanding data analysis from a business perspective.

See salaries and explore the career path for Business Analyst

Information Security Analyst

Information Security Analysts plan and implement security measures to protect an organization's IT systems and data. This course may be useful for understanding the data-related security issues related to relational database management systems.

See salaries and explore the career path for Information Security Analyst

Computer Scientist

Computer Scientists conduct research and develop new computing technologies. This course may be useful for understanding the research behind database migration from MS SQL to RDS.

See salaries and explore the career path for Computer Scientist

Computer Engineer

Computer Engineers design, develop, and test computer hardware and software. This course may be useful for developing an understanding of how infrastructure can affect the migration of databases from MS SQL to RDS.

See salaries and explore the career path for Computer Engineer

Database Designer

Database Designers create and maintain the structure and organization of databases. This course could help individuals learn about designing databases in the context of a cloud environment.

See salaries and explore the career path for Database Designer

Cloud Engineer

Cloud Engineers design, build, and manage cloud computing systems. This course may be useful for understanding the role of relational databases in cloud systems.

See salaries and explore the career path for Cloud Engineer

Software Developer

Software Developers design, code, test, and maintain systems and software programs. This course may be useful for understanding how databases play a roll in the software development lifecycle.

See salaries and explore the career path for Software Developer

Reading list

We've selected nine 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 Migrating from Microsoft SQL Server to Amazon RDS.

Designing Data-Intensive Applications

Save

A comprehensive guide to designing data-intensive applications. Provides insights into scalable and reliable database architectures.

Designing Data-Intensive Applications: The Big...

Paperback

Designing Data-Intensive Applications: The Big...

Kindle Edition

SQL Performance Explained

Save

A guide to understanding and improving the performance of SQL queries. Can be helpful for optimizing database queries in Amazon RDS.

SQL Performance Explained Everything Developers...

Paperback

Database Internals

Save

Provides a deep dive into the internal workings of relational database systems. Can be helpful for understanding the underlying concepts of Amazon RDS.

Database Internals: A Deep Dive into How...

Paperback

Database Internals: A Deep Dive into How...

Kindle Edition