1. Create a free account in AWS account, create S3 service (Cloud Object Storage – Amazon S3
– Amazon Web Services )and store the data in a bucket (name the bucket as
yourname_demo).
2. Create AWS Postgres RDS database service (Amazon RDS | Cloud Relational Database |
Amazon Web Services), name it yourname_demo_rds and load the data from the S3 bucket
Activity -2
1. Download pgadmin4 ( Download ([login to view URL])) to your local machine
2. Connect the postgres db you have created - yourname_demo_rds
3. Run the sql query to retrieve following information from the db:
a. How many unique ProductID are available
b. How many unique ProductType are available
c. Filter the db for OutletSize = Small and create a child table and name it outlet_small
d. Filter the db for OutletSize = Medium and create a child table name it
outlet_medium
e. Filter the db for OutletSize = High and create a child table name it outlet_high
Hello,
I'm an expert. I have more than 7+ years of exp as a Linux System Admin.
I have excellent knowledge and exp with AWS.
I can help you right away!
Ping me for more discussion.
Thanks.
Strategy Consultant and Data Scientist with 5+ years of international experience in Customer 360° management and analytics product development across US and European Markets. Fast thinker, quick learner and keen team player known for providing valuable insights.
Hello i am harsh khare . I am already worked on aws ec2 , route 53 rds and other server since 4 year
I am 4 experience as a cloud Engineer
feel very much that you give me this work