Cloud Database Concepts

Welcome to the Cloud Database Concepts lab. In this lab, you will be provided with the instructions and devices needed to develop your hands-on skills.

Amazon Web Services (AWS) provides a range of database services. These services include relational databases like Amazon Relational Database Service (RDS), which supports popular database engines such as My Structured Query Language (MySQL), PostgreSQL, and Structured Query Language (SQL) Server, as well as non-relational databases like Amazon DynamoDB, a fully managed NoSQL database. Additionally, AWS provides database migration tools and services to facilitate the migration of on-premises databases to the AWS cloud.

In this lab, you will explore the various database types and migration options that AWS offers.

Overview

Learning Outcomes

In this module, you will complete the following exercises:

  • Exercise 1 – AWS Databases
  • Exercise 2 – MSSQL Server Database
  • Exercise 3 – Database Migration

After completing this module, you should be able to:

  • Compare database types.
  • Create MSSQL server database.
  • Install SSMS.
  • Connect to the MSSQL database.
  • Explore database migration options.
  • Discover database schema conversion.

Exam Objectives

The following exam objectives are covered in this module:

  • 1.9 Explain the importance of database concepts.
Courses