Migrating Your Existing SQL Server Estate to Amazon's RDS
3.6 (51 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
758 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Migrating Your Existing SQL Server Estate to Amazon's RDS to your Wishlist.

Add to Wishlist

Migrating Your Existing SQL Server Estate to Amazon's RDS

Learn Real World Techniques For Moving Your Production SQL Servers To Amazon Web Services (AWS) RDS
3.6 (51 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
758 students enrolled
Last updated 6/2015
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 12 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Move Your Existing SQL Server Databases To Amazon's Relational Database Service.
  • Learn The Benefits To Amazon's Relational Database Service
  • Design Real World Solutions For Moving SQL Server To RDS
View Curriculum
  • Every Student Will Need An AWS Account. We Will Walk Through Setting One Up At The Start Of The Course
  • A Solid Foundation With SQL Server Would Be Very Beneficial.
  • A Basic Understanding Of Amazon's AWS Service Would Also Help.

This course focuses on moving SQL Server Databases to Amazon's RDS SERVICE. Amazon's cloud is called AWS which stands for Amazon Web Services and their database offering is called RDS or Relational Database Service.

Before WE get started I would like to share MY excitement on co-authoring my first course. I will be working with noted cloud expert Ryan Kroonenburg. This is the first course I'm co-authoring and couldn't be more excited about working with author and AWS Could Architect Ryan Kroonenburg. Ryan's been teaching AWS centric courses on Udemy for quite some time and his courses are the most highly rated AWS courses available.

HOW is this course different from my course titled How To Become a SQL Server Cloud Architect on AWS? This course is more focused on MIGRATING your on premise databases to RDS. We will be solely focused on RDS and walk through several migration and post migration STRATEGIES.

This course is NOT for any of the current AWS certifications. Currently, there are NO database specific certifications for Amazon's RDS platform.

This course WILL give you the skills necessary to move SQL Server Database to Amazon's cloud. The course will provide YOU with REAL WORLD examples on how to MOVE your existing database to the cloud.

Amazon's control 58% of the cloud market and is spending approximately a BILLION a year on cementing that lead over it's closest competition, which is Microsoft Azure. Currently, Azure comes in second at 12%.

As a SQL Server Consultant I can tell you that many of my customers are MOVING to Amazon's various cloud offerings.

There are still many LIMITATIONS and nuances to moving SQL Server Databases to the cloud. We will discuss many of these in the course.

The code, applications, and TOOLS (like Management Studio) you already use today with your existing databases can be used with Amazon RDS. Amazon RDS AUTOMATICALLY patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery.

Amazon RDS makes it easy to use replication to enhance availability and reliability for production workloads. Using the Multi-AZ deployment option you can run MISSION CRITICAL workloads with high availability and built-in automated fail-over from your primary database to a synchronously replicated secondary database in case of a failure.

Availability zone replication is very much like having a built in SQL Server Cluster with the click of a button. This course will set up SQL Server Availability Zones for our HIGH AVAILABILITY needs.

ENROLL NOW!!. Let's Get Started

Who is the target audience?
  • If You Are Responsible For Moving Databases To RDS This Course Is For You.
  • Any SQL Server DBA or Windows Administrator Who Wants To Learn How To Maximize RDS Should Take This Course.
  • Any AWS Could Architect Who Is Responsible For Managing Their AWS Estate.
Compare to Other SQL Server Courses
Curriculum For This Course
34 Lectures
An Introduction To SQL Server on RDS. Amazon's AWS Is The "New Normal"
10 Lectures 14:00

Welcome to Migrating You Existing SQL Server Estate to RDS. Let's talk about what's in the course, who should take it and what you'll take away when you've finished.

All of our courses are real world approaches to working with AWS. This one is no different. You'll be able to take what you've learned and immediately apply to real world environments.

Let's Get Started!!

Preview 02:00

A little about Mike, the new RDS guy.

Preview 01:49

Ryan talks about the certification process and some applications to further the learning process.

Preview 02:36

Please head over and sign up. This is a great place for questions specific to the course and questions that may be outside of the scope of the current course but you simply have to know.

Preview 02:45

We make every attempt to ensure the course is up to date and without error as possible. However, some changes may be out of our control. We are constantly monitoring AWS for changes to their services.

Errata. AWS Is in A Constant State Of Change. We Are Constantly Engaged with AWS

This lecture is specific to Amazon's cloud offering. Each cloud service provider has their own unique nuances and we talk about Amazon's here.

AWS stands for Amazon Web Services and we overview it here.

Preview 01:56

AWS stands for Amazon Web Services. It's a vast offering of services you can mix and match to suite your needs. This course will focus mostly on RDS or the "Relational Database Service."

We are going to focus much of this course on how we can move our on-premise database to RDS. There are a lot more limitations and variables with cloud architecture and we will cover them here.

What is RDS? How Does It Fit Into AWS? Let's Take a Look.

Location of scripts and all of the course content. Please take minute to download the course content and save it to a folder you'll be able to easily access. The downloadable is included as a zip file.

Download All Course Content Here. Not a Lot But You Need It.

Every IT sector has its own vernacular. The could is no different. In this section we'll cover a few terms that are used often.

Amazon Nomenclature. We Need To Be Comfortable Using.

Let's wrap up what we've covered in this section. The basics will often build the foundation we need to understand the nuances later.

Section 1 Summary. Let's Take A Look At What We've Covered.

Section 1 Quiz
10 questions
Let's Talk About What We Will Need For This Course.
3 Lectures 03:18

You won't need many items to take this course. Even better, all the items you do need are free.

Getting Started. What You'll Need To Take This Course.

Script libraries allow us easy access to important files we need to troubleshoot critical issues.

They are also good for performance tuning. All the tier one SQL Server DBAs I know use a script library. I've included some tips and tricks on creating one.

Your Script Library For RDS. It Can Be The Same One But I Like To Separate Them

A look at what we've covered in this section.

Summary. Let's Take A Look At What We've Covered.

Section 2 Quiz
10 questions
RDS - An Overview
5 Lectures 24:34

How SQL Server and RDS behave. Amazon's OLTP service was designed specifically for relational databases like SQL Server.

RDS & SQL Server Overview

This is how we benchmark the computing power we need. Recall the big three? (IO, Memory and CPU) These instances classes cover two of them. (memory and CPU)

Instance Classes Explained on RDS for SQL Server

This is easily one of the most confusing areas in moving anything to the cloud. Ryan discusses an approach to benchmarking your costs.

Different Billing Approaches to SQL Server

When we provision an instance we create an instance. Another term is to spin up an instance. In this lecture we create our first instance.

Let's Provision Our First Instance

Let's wrap up what we've covered in this course.

Summary. Let's Wrap This Section Up.

Section 3 Quiz.
10 questions
Migrations - The Complete Guide
9 Lectures 35:00

In this lecture we highlight a few important items we need to take into account before we dive head first into moving our estate to the cloud.

These are easily committed to memory once you've migrated your first instance to the RDS.

A Few Thoughts Before We Dive In. Things We Need to Keep In Mind.

I'm using the term native here to mean that we need no third party tools to move schema and cloud to RDS. This approach will serve you well for small databases.

Moving A Very Simple Database To RDS Using The Native Approach

We have the option to script data and schema together or separately. Some DBAs like to see the schema alone prior to scripting or moving the data.

Scripting Out The Schema and The Data. The Native Approach.

In this lecture we are moving a larger more complex database to RDS. It's only complex compared to our initial example but it does add keys and other objects that need to be scripted.

Using SQL Server Azure Migration Tool on Slightly Larger Database

In this lecture we script our the schema separately and then use a component of SSIS to push our data to RDS.

Moving The Schema Natively Then Using SSIS To Import Our Data.

I'm with you. This course is focused on AWS why would we use a tool for Azure? Well, it might have been written for Azure but it works flawlessly with RDS.

Let's take a look at how this tool brute forces our databases to RDS. This might not always be the best choice but it's a great first swipe at testing what we can move to RDS without major complications.

Moving Our Databases To AWS With The SQL Server Azure Toolkit. Say What?

Most database will have objects that aren't cloud compatible and we will have to sift through them before the application goes live in RDS.

Using SQL Server Azure Tool On Unsupported Cloud Objects.

A quick review of what we covered in the section.

Summary. Let's Highlight What We've Covered.

Questions and Answers. *Audio*

Section 4 Quiz
10 questions
Post Migration Strategies
5 Lectures 12:13

Logins and permission are *NOT* moved automatically. You must move them manually. Thankful, this script provided by Microsoft will easily move the logins.

Moving Logins From Our On Premise Environment To Our RDS Instance

The performance monitor in the cloud. Another component of RDS you'll be using often. It's really well integreated into the instance.

Using Cloudwatch To Monitor Our RDS Instances.

You run out of cpu or memory and you have to scale up. It's very easy to do but it does incurr an outage.

Vertically Scaling Our RDS Instance. A Complex Task No Longer.

SQL Server Agent is included with every version except for express. Let's walk through a simple example and add a stats rebuild job.

Working With SQL Server Agent on RDS. Setting Up A Job In RDS.

Let's wrap up what we've covered.

Summary. Let's Wrap Up What We've Learned.

Section 5 Quiz
10 questions
SQL Server Courses Coming Soon
2 Lectures 02:34

Let's wrap up this course. Thanks for taking it.

Let's Wrap Up The Course. With No Backup and Restore We Still Have Options.

SQL Server RDS Master Classes On The Horizon.
About the Instructor
Mike West
4.2 Average rating
2,968 Reviews
49,406 Students
42 Courses
SQL Server and Machine Learning Evangelist

I've been a production SQL Server DBA most of my career.

I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.

Experience, education and passion

I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.


Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).


Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.

Ryan Kroonenburg
4.5 Average rating
64,466 Reviews
202,177 Students
15 Courses
Solutions Architect

I am the founder of A Cloud Guru and an Amazon Web Services community hero. I hold every associate certification and I am a certified AWS Solutions Architect Professional. I am ex-Rackspace, ex-Sungard & ex-Smart421. I have been working in the Cloud space since it's very inception.

I am not just another I.T. trainer. I teach Cloud because I know it. Inside and out. I've worked as a systems administrator, developer, solutions architect & managing director/general manager for some of the biggest companies in cloud. My courses are not just some other IT training course, delivered by some IT trainer. My background is very hands on. I live eat and breath cloud. I will teach you everything that I know. If you want some boring, high level and theoretical cloud training platform, then my courses are not for you! You will love my courses because of my explain it like I'm 5 approach.

I have 17 years experience in IT in total and I am fluent across both Windows and Linux platforms. My courses are all cloud based and will be aimed to accommodate both absolute beginners, as well professionals. I always start with the basics and by the end of my courses you will be proficient as a Cloud Guru. Please add me on Linkedin or follow me on Twitter!

Get ready to become A Cloud Guru!

Samuel Kroonenburg
4.5 Average rating
51 Reviews
758 Students
1 Course
Startup Founder & Software Engineer

Sam Kroonenburg is the co-founder of Appfail - a web startup with thousands of customers worldwide, including some of the biggest brands in the world. Sam has also built some of the largest software products in the world, having worked extensively as an engineer across the world (USA, UK, Norway and Australia) at companies like Microsoft. Sam helped to build Windows Vista and Windows 7.