Data Analytics and Databases on AWS

Data Analytics and Databases on AWS

This course is part of AWS Cloud Technology Consultant Professional Certificate

Instructors: Rafael Lopes

Access provided by Bosch

7,668 already enrolled

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

Module 1 Quiz 10 minutes
ETL Process 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.