The Complete AWS SQL Server RDS Bootcamp: Beginner To Expert
0.0 (0 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.
23 students enrolled

The Complete AWS SQL Server RDS Bootcamp: Beginner To Expert

Everything you need to know about SQL Server RDS
New
0.0 (0 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.
23 students enrolled
Created by Gary Cowan
Last updated 4/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $19.99 Discount: 40% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 3 articles
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ 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 16 lectures 51:06
+ Introduction
3 lectures 02:23

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:12
+ 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
3 lectures 15:12
Creating a snapshot of a SQL Server RDS Database
01:55
Backing and restore native SQL Server RDS Database to S3
10:35
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
1 question
+ Conclusion
2 lectures 00:27
Conclusion
00:22
Extra help
00:05