menu

Databases on AWS for Windows

6 Labs · 32 Credits · 7h 25m

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 积分 30 Minutes

AWS Tools for Windows PowerShell:入门

本实验室将向您介绍设置和使用 AWS Tools for Windows PowerShell 的逐个步骤。借助此工具包,您能够像用 Windows PowerShell 管理本地 Windows 环境一样管理您的 AWS 资源。您将对可与 AWS Tools for Windows PowerShell 搭配使用的各种身份验证类型进行检查。在本次实验室课程结束时,您将使用 AWS Tools for Windows PowerShell 编写自己的可自我修复的 PowerShell 脚本。

Icon  fundamental fundamental 免费 50 Minutes

结合使用 Windows Server Storage Spaces 和 Amazon EBS

本实验室将逐步指导您如何使用 Amazon 系统映像 (AMI) 启动 Amazon Elastic Compute Cloud (EC2) 实例、向该实例添加多个磁盘以及构建具有 SSD 和磁性介质卷的分层存储池。您还将使用该存储池创建虚拟磁盘,并在已挂载的卷上执行基本的 IOPS 测试操作。在本实验室结束时,您将了解如何结合使用 Amazon EBS 和 Windows Storage Spaces 构建具有多个存储层的虚拟磁盘池,以及如何通过 iSCSI 从其他机器连接至 Storage Spaces。

Icon  advanced advanced 10 积分 1 Hour 57 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

Icon  intro introductory 1 积分 25 Minutes

管理 Amazon RDS for Microsoft SQL Server

本实验室将向您介绍在 Amazon Relational Database Service (RDS) 上启动和配置您的第一个 Microsoft SQL Server 实例的各个步骤。您将通过启用多个可用区执行 SQL 监控、扩展数据库实例、通过 Microsoft SQL Server Management Studio 访问 Amazon RDS 实例,以及配置 Amazon CloudWatch 和 Amazon Simple Notification Service (SNS)。在本次实验课程结束时,您将已在 Amazon RDS 中创建了数据库,并执行了管理操作,例如,将大型数据库迁移至 Amazon RDS 以及数据库备份(快照)和还原(恢复)操作等。

Icon  advanced advanced 10 积分 1 Hour 30 Minutes

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 Hour 57 Minutes

view_comfy
Catalog
menu
More
More