This lab shows you how to manage access and permissions to your AWS services using AWS Identity and Access Management (IAM). Practice the steps to add users to groups, manage passwords, log in with IAM-created users, and see the effects of IAM policies on access to specific services.
This lab provides a basic understanding and hands-on experience of AWS Key Management Service. It will demonstrate the basic steps required to get started with Key Management Service, creating keys, assigning management and usage permissions for the keys, encrypting data and monitoring the access and usage of keys. For the lab to function as written, please DO NOT change the auto assigned region.
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.