The Complete AWS SQL Server RDS Bootcamp: Beginner To Expert
4.0 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,489 students enrolled

The Complete AWS SQL Server RDS Bootcamp: Beginner To Expert

Everything you need to know about SQL Server RDS
4.0 (12 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,489 students enrolled
Created by Gary Cowan
Last updated 6/2020
English
Current price: $14.99 Original price: $24.99 Discount: 40% off
3 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn the benefits on Amazon RDS
  • Administrating, backing up and restoring and SQL Server RDS Database to S3
  • Design RDS Databases using best practice ideas
Requirements
  • You Will Need An AWS Account.
  • Some experience of SQL Server
  • A Basic Understanding Of Amazon's AWS Service.
Description

If you are looking to find out vital information with SQL Server RDS  then this is the course for you.

You will learn

  • How to create and delete SQL Server RDS instances

  • How to create a SQL Server RDS instance from your computers operating system

  • How to administrate an SQL Server RDS instance

  • How to backup and restore a SQL Server RDS instance to S3

  • Best practices when using Amazon RDS

After this course, you will be able to administrate SQL Server RDS environments on AWS

Who this course is for:
  • SQL Server DBA students who want to learn how to use Amazon Web Services
  • SQL Students who want to learn more about RDS
  • If you need to move your SQL Server Databases to RDS
  • AWS Cloud Architects
Course content
Expand all 18 lectures 53:28
+ Introduction
4 lectures 03:07

In this introduction, you will find out what you will learn and what you will need to complete the course.

Preview 01:59
Before you begin
00:11
Leave a review and win FREE access to courses
00:44
+ Creating a SQL Server Instance on RDS
5 lectures 21:55

In this lecture, you will learn how to create a RDS SQL Server Instance on AWS

Preview 07:38

You will learn to how install AWS CLI software on a windows environment

Installing AWS CLI for using SQL Server RDS from the command prompt.
01:42

You will learn how to configure the AWS CLI software on a windows operating system.

Configuring AWS CLI for using SQL Server RDS from the command prompt.
06:19

You will learn how to connects to a RDS instance with SQL Server Management Studio

Creating a SQL Server Database on RDS using AWS CLI
05:17

You will learn how to delete a RDS Instance

Delete RDS Instance using AWS CLI
00:59
For this assignment, create a 2 new SQL Server RDS Express Edition Instances using a instance name of your choice. Create 1 instance using the Console Create 1 instance using AWS CLI Once you have done this, delete both instances.
Create yourself an RDS Instance
1 question
+ Common DBA Tasks to do on RDS
2 lectures 04:37
Creating a snapshot of a SQL Server RDS Database
01:55
To test your knowledge, create another database in RDS, then backup then restore the database without looking back at this lecture. Once you can backup and restore a database from your own scripts, then proceed to the next lecture.
Backup and restore from a snapshot
1 question
+ Migrate, backup and restore a native SQL Server RDS Database to S3
1 lecture 10:35
Migrate, backup and restore native SQL Server RDS Database to S3
10:35
+ Conclusion
3 lectures 02:04
What to learn next
00:57
Discount codes and latest course news
00:45
Conclusion
00:22