menu

Databases on AWS for Windows

6 Labs · 47 Credits · 5h 55m

AWS for Windows Windows databases

This quest is designed to help you navigate through a sequence of related topics and AWS services as it relates to Databases on AWS for Windows, like Microsoft SQL Server and Amazon RDS for SQL.

Creating Amazon EC2 Instances with Microsoft Windows

This lab demonstrates how to launch and configure a Windows virtual machine (instance) in the Amazon cloud. It will cover the use of Windows Amazon Machine Images (AMI’s) to launch Amazon EC2 Instances, bootstrapping using Powershell, creating Key Pairs for authentication, securing network access to Amazon EC2 Instances with Security Groups and attaching Elastic IPs to Amazon EC2 Instances to provide static Internet addresses.

Icon  fundamental Fundamental 8 Credits 25 Minutes

AWS Tools for Windows PowerShell: Getting Started

This lab will take you through the steps to set up and use the AWS Tools for Windows PowerShell. This toolkit enables you to manage your AWS resources the same way you use Windows PowerShell to manage your on-premise Windows environment. You will examine the various authentication types that can be used with AWS Tools for Windows PowerShell. At the end of this lab, you will use AWS Tools for Windows PowerShell to write your own self-healing PowerShell scripts.

Icon  fundamental Fundamental 8 Credits 50 Minutes

Using Windows Server Storage Spaces with Amazon EBS

This lab leads you through the steps to launch an Amazon Elastic Compute Cloud (EC2) instance using an Amazon Machine Image (AMI), add multiple disks to the instance, and build a tiered storage pool with SSD and magnetic volumes. You will also create a virtual disk using the storage pool and perform a basic IOPS test operation on a mounted volume. At the end of this lab, you will understand how to build a virtual disk pool with different storage tiers using Amazon EBS and Windows Storage Spaces and see how to connect to Storage Spaces from another machine via iSCSI.

Icon  advanced advanced 10 Credits 1 Hour 5 Minutes

Introduction to Amazon Relational Database Service (RDS) (Windows)

This lab takes you through the steps of creating a MySQL database using the Amazon Relational Database Service using the AWS Management Console, and then connecting to the database in AWS using a SQL client running on a Microsoft Windows server, also provided in the lab environment. For a demonstration, go to: https://www.youtube.com/watch?v=Kz1zmyHw9G0
For the lab to function as written, please DO NOT change the auto assigned region.

Icon  intro introductory 1 Credit 25 Minutes

Administering Amazon RDS for Microsoft SQL Server

This lab leads you through the steps to launch and configure your first Microsoft SQL Server instance on Amazon Relational Database Service (RDS). You will scale database instances, access the Amazon RDS instance via Microsoft SQL Server Management Studio, and configure Amazon CloudWatch and Amazon Simple Notification Service (SNS). At the end of this lab, you will have created a database in Amazon RDS and performed administrative operations, such as migrating a large database to Amazon RDS and database backup (snapshot) and restore (recover) operations.

Icon  advanced advanced 10 Credits 1 Hour 30 Minutes

SQL Server in Amazon EC2: Getting Started

This lab leads you through the steps to launch a Windows Server 2012 R2 instance with Microsoft SQL Server, which is preinstalled using an Amazon Machine Image (AMI), and add that instance to an Active Directory domain. You will use Windows authentication with Active Directory to login to Microsoft SQL Server, and practice administrative operations such as importing data into the cloud. Prerequisites: To successfully complete this lab, you should be familiar with basic Windows Server and Microsoft SQL Server administration. You should have taken at least "Introduction to Amazon Elastic Compute Cloud (EC2) with Windows Server" or "Creating Amazon EC2 Instances with Microsoft Windows" before attempting this lab.

Icon  advanced advanced 10 Credits 1 Hour 30 Minutes