Introduction to Amazon Relational Database Service (RDS) - SQL Server

This lab provides an overview of using Amazon Relational Database Service (Amazon RDS) for SQL Server.

Level

Fundamental

Duration

Course Objectives

In this course, you will learn how to:

• Create an Amazon Relational Database Service (Amazon RDS) SQL Server instance
• Connect to the RDS instance using Microsoft SQL Server Management Studio

• Export data from a local database to an Amazon RDS SQL Server database

Intended Audience

This course is intended for:

• Developers
  
  

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• None
  
  

Course Outline

• Task 1: Launch an Amazon RDS instance

• Task 2: Login to your Amazon EC2 instance

• Task 3: Access your local database via Microsoft SQL Server Management Studio

• Task 4: Access the RDS instance via Microsoft SQL Server Management Studio

• Task 5: Export AdventureWorks from SQL Server on Amazon EC2 to Amazon RDS