We may earn an affiliate commission when you visit our partners.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/brkshl/migrating
What's inside
Syllabus
Migrating from Microsoft SQL Server to Amazon RDS
Good to know
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
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
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.
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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
Show steps
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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.
For more career information including salaries, visit:
OpenCourser.com/course/brkshl/migrating
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.
Save
Provides a deep dive into the internal workings of relational database systems. Can be helpful for understanding the underlying concepts of Amazon RDS.
A guide to optimizing, backing up, and replicating MySQL databases. While not specific to Amazon RDS, the principles and techniques are applicable.
Provides a comprehensive overview of Amazon Web Services, including a chapter on 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.
Save
Provides a comprehensive guide to migrating databases to AWS, including a chapter on migrating from Microsoft SQL Server to Amazon RDS.
Provides a guide to optimizing the performance of Microsoft SQL Server databases, which can be helpful after migrating to Amazon RDS.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/brkshl/migrating
Share
Similar courses
Here are nine courses similar to
Migrating from Microsoft SQL Server to Amazon RDS.
Migrating from PostgreSQL to Amazon RDS
OpenCourser.com/course/pynn7q/migrating
Migrating from PostgreSQL to Amazon RDS
Most relevant
Migrating from Oracle to Amazon RDS
OpenCourser.com/course/codw3m/migrating
Migrating from Oracle to Amazon RDS
Most relevant
Migrating from Microsoft SQL Server to Amazon DynamoDB
OpenCourser.com/course/c4unaf/migrating
Migrating from Microsoft SQL Server to Amazon DynamoDB
Most relevant
Migrating from Oracle to Amazon Aurora
OpenCourser.com/course/wsvby0/migrating
Migrating from Oracle to Amazon Aurora
Most relevant
Migrating from MySQL to Amazon RDS
OpenCourser.com/course/nze24e/migrating
Migrating from MySQL to Amazon RDS
Most relevant
Migrating from Redis to Amazon ElastiCache
OpenCourser.com/course/1opf0l/migrating
Migrating from Redis to Amazon ElastiCache
Most relevant
Migrating from Apache Cassandra to Amazon Keyspaces
OpenCourser.com/course/tuug89/migrating
Migrating from Apache Cassandra to Amazon Keyspaces
Most relevant
Breaking Free from Legacy Databases
OpenCourser.com/course/h6i70u/breaking
Breaking Free from Legacy Databases
Most relevant
Amazon Aurora: Best Practices
OpenCourser.com/course/zt11u1/amazon
Amazon Aurora: Best Practices
Most relevant
Level
Introductory
Via
Coursera
Institution
Amazon Web Services
Instructor
AWS Instructor
Language
English
Good to know
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
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