Introduction to Amazon Aurora

This lab will give you a basic understanding of using Amazon Aurora. You will be shown the basic steps to create an Amazon Aurora instance and then connect to the Amazon Aurora instance. To successfully complete this lab, you should have experience connecting to Microsoft Windows instances using RDP and have a basic knowledge of AWS.

Level

Fundamental

Duration

Course Objectives

In this course, you will learn how to:

• Create an Amazon Aurora instance
• Connect to a pre-created Amazon RDS for MySQL instance
• Connect to a pre-created Amazon EC2 instance that has MySQL Workbench installed
• Load data into the Amazon RDS for MySQL instance from a dump file
• Load data into the Amazon Aurora instance from the same dump file
• Query the data in the Amazon Aurora instance
• Query the data in the Amazon RDS for MySQL instance and compare the results

Intended Audience

This course is intended for:

• Data Engineers
• Developers

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Basic knowledge of AWS.

Course Outline

• Task 1: Create an Amazon Aurora instance
• Task 2: Connect to the Windows instance using Apache Guacamole
• Task 3: Connect to your Amazon RDS instance
• Task 4: Import a SQL dump file into your databases
• Task 5: Query the databases