Data Analytics and Databases on AWS

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Data Analytics and Databases on AWS

This course is part of AWS Cloud Technology Consultant Professional Certificate

Instructors: Rafael Lopes

7,682 already enrolled

Included with

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

58 reviews

Beginner level

No prior experience required

9 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

58 reviews

Beginner level

No prior experience required

9 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Key data types and structures
AWS services for the ETL process
Hands-on skills for Amazon API Gateway and Amazon QuickSight

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your Cloud Computing expertise

This course is part of the AWS Cloud Technology Consultant Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Amazon Web Services

There are 3 modules in this course

Data is everywhere. If you or your company don't know what data you have and what insights you can uncover through your data, you are at a competitive disadvantage. In this course, you'll get introduced to data analytics and the upside of data-driven decisions. You'll learn about the omnipresence of data in today's world and what it takes to start thinking and acting like a data analyst. Week 1 concludes by comparing and contrasting ETL (Extract, Transform, Load) and ELT(Extract, Load, Transform) and where data is transformed and how data warehouses retain data. Week 2 kicks off with an overview of data workflow and database foundations. The four vs (volume, velocity, variety and veracity) of data are explained along with walk-throughs of collecting, processing, and storing data. In the course's final week, you'll get briefed on some of the AWS services that can be leveraged for ETL. You'll extract data with Amazon API Gateway, process data with AWS Lambda, load data with Amazon RDS, and visualize data with Amazon QuickSight. There's the right tool for each unique data analysis task.

Welcome to the first module of the course. This module introduces fundamental concepts in data analysis. You begin the module with how to assess use cases for data analysis in the cloud. Then, you explore some of the main data types and structures, and learn how metadata can help you manage datasets. Lastly, you complete the module by contrasting two data-processing approaches for analytics: extract, transform, and load (ETL) and extract, load, and transform (ELT).

What's included

8 videos7 readings2 assignments2 plugins

8 videos Total 29 minutes

Welcome to the Course 3 minutes
Module 1 Introduction 1 minute
Why Data Analytics? 4 minutes
Thinking Like a Data Analyst 5 minutes
Data Types and Structures 4 minutes
Understanding Metadata 3 minutes
ETL Hello World! 5 minutes
Module 1 Closing 3 minutes

7 readings Total 44 minutes

Welcome to the Course 2 minutes
Course Roadmap 5 minutes
Pre-Course Survey 1 minute
How Data Analysis is Present in Your Lives 10 minutes
ELT: Another Data Architecture Approach 20 minutes
Data Analytics 5 minutes
Mid-Course Survey 1 minute

2 assignments Total 20 minutes

ETL Process 10 minutes
Module 1 Quiz 10 minutes

2 plugins Total 30 minutes

Pre-Course Survey 15 minutes
Mid-Course Survey 15 minutes

In this module, you start learning about the ETL pipeline, with an emphasis on the real-world scenario. Through each step, you learn how to gather data, ensure data quality, locate the appropriate storage or database, and evaluate insights. After you examine the ETL process, you assess SQL and NoSQL databases, and interact with a hands-on activity to practice your skills.

What's included

7 videos2 readings1 assignment1 ungraded lab

7 videos Total 35 minutes

Module 2 Introduction 3 minutes
The “E” in ETL - Extract 6 minutes
The “T” in ETL - Transform 7 minutes
The “L” in ETL - Load 5 minutes
SQL and NoSQL Databases: What’s the difference? 5 minutes
SQL Query Examples 6 minutes
Module 2 Closing 2 minutes

2 readings Total 25 minutes

ETL, but with a V after: ETLv 20 minutes
SQL Queries Cheatsheet 5 minutes

1 assignment Total 20 minutes

Module 2 Quiz 20 minutes

1 ungraded lab Total 60 minutes

Let’s practice SQL! 60 minutes

In this module, you review AWS services for data analysis, and reinforce your learning through practical labs. These services include Amazon API Gateway, Amazon Relational Database Service (Amazon RDS), Amazon DynamoDB, and Amazon QuickSight. You review these services in the AWS Management Console, and evaluate how you can use each service in the ETL process. Then, you gain practical experience by working with some of these service in a preconfigured environment.

What's included

9 videos2 readings1 assignment3 app items1 plugin

9 videos Total 58 minutes

Module 3 Introduction 3 minutes
Why Do Data Analytics in the Cloud? 4 minutes
Extracting Data with Amazon API Gateway 9 minutes
Processing Data with AWS Lambda 8 minutes
Loading Data with Amazon RDS - Relational Database Service 8 minutes
Loading Data with DynamoDB - Non-Relational Database Service 10 minutes
Visualizing Data with Amazon QuickSight 5 minutes
Choosing the Right Tool for the Job 8 minutes
Course Wrap-Up 2 minutes

2 readings Total 21 minutes

Additional AWS Services for Data Analysis 20 minutes
Post-Course Survey 1 minute

1 assignment Total 10 minutes

Final Assessment 10 minutes

3 app items Total 180 minutes

Lab 1: Introduction to Amazon API Gateway 60 minutes
Lab 2: Introduction to Amazon Relational Database Service (RDS) 60 minutes
Lab 3: Introduction to Amazon QuickSight 60 minutes

1 plugin Total 15 minutes

Post-Course Survey 15 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructors

Instructor ratings

(11 ratings)

Rafael Lopes

Amazon Web Services

22 Courses 255,147 learners

Offered by

Amazon Web Services

Explore more from Cloud Computing

Status: Preview
Amazon Web Services
Getting Started with Data Analytics on AWS
Course
Status: Free Trial
Whizlabs
AWS: Data Analytics
Course
Status: Free Trial
Packt
Advanced Data Processing and Analytics with AWS
Course
Status: Free
Amazon Web Services
Fundamentals of Analytics on AWS
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
84.48%
4 stars
6.89%
3 stars
5.17%
2 stars
1.72%
1 star
1.72%

Showing 3 of 58

Reviewed on Jan 9, 2024

The instructors Rafael and Oksana made complex concepts like ETLv and data analytics easier to understand. I loved this course!

Reviewed on Sep 18, 2024

Data Analytics and Databases on AWS was an excellent course! I highly recommend this course to anyone looking to build their skills in data analytics

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.