AWS Database Services (CLF-C02)

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

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 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 module, 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 Microsoft SQL (MSSQL) server database.
  • Install SQL Server Management Studio (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:

3.4 Identify AWS database services.

  • Skills – Identifying relational databases (for example, Amazon RDS, Amazon Aurora).
  • Skills – Identifying NoSQL databases (for example, DynamoDB).
  • Skills – Identifying database migration tools (for example, AWS Database Migration Service [AWS DMS], AWS Schema Conversion Tool [AWS SCT]).
Courses