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 Martin Luther Christian University

7,877 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

59 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.

59 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 videosTotal 29 minutes

Welcome to the Course3 minutes
Module 1 Introduction1 minute
Why Data Analytics?4 minutes
Thinking Like a Data Analyst5 minutes
Data Types and Structures4 minutes
Understanding Metadata 3 minutes
ETL Hello World!5 minutes
Module 1 Closing3 minutes

7 readingsTotal 44 minutes

Welcome to the Course2 minutes
Course Roadmap5 minutes
Pre-Course Survey1 minute
How Data Analysis is Present in Your Lives10 minutes
ELT: Another Data Architecture Approach20 minutes
Data Analytics5 minutes
Mid-Course Survey1 minute

2 assignmentsTotal 20 minutes

ETL Process10 minutes
Module 1 Quiz10 minutes

2 pluginsTotal 30 minutes

Pre-Course Survey15 minutes
Mid-Course Survey15 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 videosTotal 35 minutes

Module 2 Introduction3 minutes
The “E” in ETL - Extract6 minutes
The “T” in ETL - Transform7 minutes
The “L” in ETL - Load5 minutes
SQL and NoSQL Databases: What’s the difference?5 minutes
SQL Query Examples6 minutes
Module 2 Closing2 minutes

2 readingsTotal 25 minutes

ETL, but with a V after: ETLv20 minutes
SQL Queries Cheatsheet5 minutes

1 assignmentTotal 20 minutes

Module 2 Quiz20 minutes

1 ungraded labTotal 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.