Đã Đóng

Aws setup and basic data filtering

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

Kĩ năng: Điện toán đám mây, Khoa học dữ liệu

Về Bên Thuê:
( 0 nhận xét ) Aligarh, India

ID dự án: #32703200

7 freelancer chào giá trung bình ₹1921/giờ cho công việc này

(34 Nhận xét)
5.8
(9 Nhận xét)
4.0
mohitcloudoserv

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.

₹7000 INR / giờ
(2 Nhận xét)
2.7
Appsdbatalha

I am Oracle certified DBA, AWS Certified Technical Architect and PostgreSQL DBA having 11 years of experience

₹1200 INR / giờ
(0 Nhận xét)
0.0
adminmaxonclouds

I can support you on this project requirements steps as i have great hands-on experience on AWS and devops automation

₹1250 INR / giờ
(0 Nhận xét)
0.0
prateekpsinghal

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 p Thêm

₹1000 INR / giờ
(0 Nhận xét)
0.0
hkhare25

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

₹1000 INR / giờ
(0 Nhận xét)
0.0