Databases on AWS for Windows

6 ラボ · 40 クレジット · 6時 14分

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.

Introduction to Amazon EC2

This lab provides you with a basic overview of launching, resizing, managing, and monitoring an Amazon EC2 instance. Please DO NOT change the auto assigned region.

Icon  intro introductory 1クレジット 40 分

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クレジット 50 分

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クレジット 1 時間 5 分

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:
For the lab to function as written, please DO NOT change the auto assigned region.

Icon  intro introductory 1クレジット 25 分

Administering Amazon RDS for SQL Server (日本語版)

"このラボでは、Amazon Relational Database Service (RDS) で初めて Microsoft SQL Server インスタンスを作成、設定するための各ステップを説明します。データベースインスタンスをスケーリングし、Microsoft SQL Server Management Studio から Amazon RDS インスタンスにアクセスして、Amazon CloudWatch と Amazon Simple Notification Service (SNS) を設定します。このラボの終わりには、Amazon RDS にデータベースを作成して、大規模データベースの Amazon RDS への移行、データベースのバックアップ (スナップショット)、復元 (復旧) オペレーションなどの管理オペレーションを実行します。

Icon  advanced advanced 10クレジット 1 時間 30 分

SQL Server in Amazon EC2: Getting Started

This lab leads you through the steps to migrate a Microsoft SQL Server database from a pretend (on-premises) SQL server to a SQL Server in your AWS account. In this lab you will launch a Windows Server 2016 with SQL Server 2017 Express instance into a RemoteVPC. This instance will act as your on-premises SQL Server. You will Install Active Directory Services on your DC instance in your AWS LabVPC and promote it to be a Domain Controller. You will join your AWS SQL Server to your Domain. You will configure remote administrator access to your AWS SQL Server. This will allow you to migrate a database to it. You will install the AdventureWorks database to your Remote SQL Server. You will then migrate the AdventureWorks database from your Remote SQL Server to your AWS SQL Server. Finally, you will verify that the database migrated to the other SQL server by querying the database.

Icon  advanced advanced 10クレジット 1 時間 30 分