ASSIGNMENT: AWS Database - RDS

 

Exercise:

Step 1: Search for RDS service or go to Database-->RDS
Step 2: Click on Create Database button.
Step 3: Chose option Standard Create
Step 4: Database Instance MySql
Step 5: Templates: Free tier
Step 6: Provide admin user password and confirm password.
Step 7: Storage Autoscaling : Max autoscaling 21 GB
Step 8: Select Default VPC
Step 9: Public Access Yes
Step 10: Select Security Group make sure port number 3306 is opened for the Inbound rule.
Step 11: Click on Create Database
Step 12 : It takes around 10 mins to create the database.
Step 13: Once the Database get created then select it.
Step 14: Copy the Endpoint and connect it from the remote system. (needs mysql workbench)

ASSIGNMENT: AWS Management - IAM

The developer is developing index.html file , implementer is hosting that file on S3 and Tester is testing that file

1. Create groups called Developer  and Tester and implementer

Ans: Ok

2. create some users in Developer and Tester groups

Ans: Ok

3. Developers and Tester has readonly access to S3 buckets and Implementer has full access to S3 buckets

Ans: Developers - AmazonS3ReadOnly, Testers - AmazonS3FullAccess

4. Developers can access the S3 buckets using programs.

Ans: Developers - Programmatic Only (Share only Username and Password)

5. Testers can not access the S3 buckets using progs but there are some dedicated machines allocated to tester for Testing purpose so that they can access S3 buckets. 

Ans: Testers - Console only (Share only Access Key and Secret Key)

ASSIGNMENT: AWS Database - DynamoDB

 

Lab:- Create a DynamoDB Student Table with some records, then scan the table and query on the table.

Step 1: Search DynamoDB service

Step 2: Select Table and Click on Create Table and Provide below information

           Table Name: Student

          Partition key: Id   Data type: Number

          Sort Key: Name         Data type: String

          Settings: Default Settings

   Click on Create table button.

Step 3: The table should be created and in Active State.

Step 4: Click on Student Table

Step 5: Go to Action---> Create item

Step 6: You can create item using Form or Writing JSON

Step 7: Repeat Step 5 and 6 to add more items

Step 8: After adding multiple records click on Explore items

Step 9: Select Scan Tab and Click on the Run button it will show all the records.

Step 10: Select Query Tab and Search on the basis of Partition key and other attribute values.