Learn to create your Amazon Aurora Serverless database

Learn to create your Amazon Aurora Serverless database.

Objectives:

1. Learn to create your Amazon Aurora Serverless database.

2. Learn use of Query Editor to run SQL queries in RDS Console.

3. Learn to create Data API for Aurora Serverless.

Step 1: In AWS Management Console go to RDS service.

Click on Create Database. Provide the following configuration.

Engine Options

Engine type: Amazon Arora

Edition: Amazon Aurora PostgreSQL-Compatible Edition

Engine version:

Available versions: Aurora PostgreSQL ( Compatible with PostgreSQL 10.18)

Settings

DB Cluster Identifier: mycppdatabase

Master Username: postgres

Auto generate a password: Uncheck

Master Password: mypass123

Confirm password: mypass123

Instance configuration

DB instance class: Serverless

Capacity range: Min:2, Max:2

Connectivity

Select your required VPC or select the default VPC. Likewise, for Subnet.

VPC Security Group: Create New.

New VPC security group name: CPP-Aurora

Additional Configuration:

Enable the Data API checkbox

Additional Configurations

Initial database name: mycpplab

Backup retention period: 1 day

Uncheck Copy tags to snapshots

Uncheck Enable deletion protection

Click on Create database.

Wait till the database is Available.

Step 2: Go back to RDS dashboard-> Query Editor.

Configure as follows and Connect to database.

In the Query editor, Run the sample query. The table will be populated.

Clear the Query Editor to remove existing commands.

Run the following query to create a new database:

create database mycpptutorial;

Check the output:

To switch to newly created database, click on Change database:

Select the postgres from drop down of Database username:

Change the database instance name and provide the new database “mycpptutorial” in last section and Connect to database:

Clear the Query Editor to remove existing commands.

Run the each of the following queries one by one in editor. Clear the editor after each query:

create table employee (firstname text, lastname text, phone text);

insert into employee VALUES ('Harry', 'Potter', '123-4567');

insert into employee VALUES ('Virat', 'Kohli', '987-6543');

select * from employee;

Thus we have successfully created Amazon Aurora Serverless Database Cluster. We have created 2 databases, switched to the new database and operated queries through the Query Editor.

Note: Aurora is a chargeable database. Make sure you delete the database from RDS console if you no longer need it.

Was this document helpful? How can we make this document better. Please provide your insights. You can download PDF version for reference.

Aurora with SQL

.pdf

Download PDF • 376KB

We provide best AWS trainings from Pune, India.

For aws certification contact us now.