Scribd
Upload
8 views14 pages

Module 4-Database - Assignment

The document outlines the steps for creating a MySQL database instance on AWS RDS and connecting it to an EC2 Linux server. It also details the process for creating a DynamoDB table and inserting data into it. The instructions include specific configurations and commands to execute for successful database setup and data management.

Uploaded by

psaran709
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views14 pages

Module 4-Database - Assignment

The document outlines the steps for creating a MySQL database instance on AWS RDS and connecting it to an EC2 Linux server. It also details the process for creating a DynamoDB table and inserting data into it. The instructions include specific configurations and commands to execute for successful database setup and data management.

Uploaded by

psaran709
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Assignment 1

 Creation of Database (Relational and No-SQL)

1. Create MySQL DB Instance and Connect MySQL DB instance.

Synopsis:
Create a RDS and an EC2 Linux Server Instance. Connect the EC2 Instance to the RDS
created. Create a Database and Table. Insert few records into the Table then read the
records inserted and verify.
2. How to create Dynamo DB table and Write Data in table.
Steps to create RDMS:
1. Search RDS in Search bar. Then Click on Create Database.
2. Select MYSQL Version Default and select Free tier.
3. Give Database name ExcelR-DB user name as admin and give
to password.

4. Select Don’t select EC2 instance. VPC Default. Select Public


access Yes.
5. Click on create DataBase.

6. Below image we can see the MYSQL Database.


7. Launch New EC2 Linux Ubuntu instance.

8. Below image we can see the Linux server EC2 instance.


9. Connect Linex server and install MYSQL-server.

10. Service start Mysql. And below image we can see the
status of Mysql.
11. Connect MYsql Database which we launch in AWS by
using End point ID.
12. Below image we can see the the MYSQL was connected.

13. Create a sample data base excelrbd by executing Query


Create database excelrbd;
14. Create a table Persons in excelrdb database.
15. Insert values into the Table.
16. Below image we can see the Table with values.
Steps to Create DynamoDB:
1. Search DynamoDB in Services. Click on Create Table.

2. The New page will appears.


3. Give Table name as Population.
4. PartionKey As Country with String.

5. Click on Create Table.


6. Click on Population Table.

7. This new page will appears.


8. In Action Click on Create Items.

9. Give the Infor,mation that should be stored in table. I have


Given some information which is shown in below image. Then
Click on Create items.
10. In below image we can see the table information.

11. In items referred in Action tab Download results to CSV.


By clicking this we can download the CSV file. Of table
information

You might also like