We may earn an affiliate commission when you visit our partners.
Course image
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

What's inside

Syllabus

Migrating from Microsoft SQL Server to Amazon RDS

Good to know

Know what's good
, what to watch for
, 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

Save Migrating from Microsoft SQL Server to Amazon RDS to your list so you can find it easily later:
Save

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
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
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
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
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
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
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.
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.
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.
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.
Data Analyst
Data Analysts gather, analyze, and interpret data. This course may be useful in improving one's ability to analyze large datasets.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

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.
A comprehensive guide to designing data-intensive applications. Provides insights into scalable and reliable database architectures.
A guide to understanding and improving the performance of SQL queries. Can be helpful for optimizing database queries in Amazon RDS.
Provides a deep dive into the internal workings of relational database systems. Can be helpful for understanding the underlying concepts of Amazon RDS.
Provides a practical guide to the internal workings of SQL Server, which can be helpful for understanding the migration process.
Provides a comprehensive guide to administering Microsoft SQL Server, including information on migration.
Provides a guide to optimizing the performance of Microsoft SQL Server databases, which can be helpful after migrating to Amazon RDS.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Migrating from Microsoft SQL Server to Amazon RDS.
Migrating from PostgreSQL to Amazon RDS
Most relevant
Migrating from Oracle to Amazon RDS
Most relevant
Migrating from Microsoft SQL Server to Amazon DynamoDB
Most relevant
Migrating from Oracle to Amazon Aurora
Most relevant
Migrating from MySQL to Amazon RDS
Most relevant
Migrating from Redis to Amazon ElastiCache
Most relevant
Migrating from Apache Cassandra to Amazon Keyspaces
Most relevant
Breaking Free from Legacy Databases
Most relevant
Amazon Aurora: Best Practices
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser