AWS - Data Analytics and Databases on AWS
- Offered byCoursera
Data Analytics and Databases on AWS at Coursera Overview
Duration | 9 hours |
Start from | Start Now |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course |
Credential | Certificate |
Data Analytics and Databases on AWS at Coursera Highlights
- Earn a certificate of completion
- Add to your LinkedIn profile
Data Analytics and Databases on AWS at Coursera Course details
- 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
- 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.
Data Analytics and Databases on AWS at Coursera Curriculum
Module 1: Foundations of Data Analysis
Welcome to the Course
Module 1 Introduction
Why Data Analytics?
Thinking Like a Data Analyst
Data Types and Structures
Understanding Metadata
ETL Hello World!
Module 1 Closing
Welcome to the Course
Course Roadmap
Pre-Course Survey
How Data Analysis is Present in Your Lives
ELT: Another Data Architecture Approach
Data Analytics
Mid-Course Survey
ETL Process
Module 1 Quiz
Pre-Course Survey
Mid-Course Survey
Module 2: ETL Pipeline and Database Foundations
Module 2 Introduction
The “E” in ETL - Extract
The “T” in ETL - Transform
The “L” in ETL - Load
SQL and NoSQL Databases: What’s the difference?
SQL Query Examples
Module 2 Closing
ETL, but with a V after: ETLv
SQL Queries Cheatsheet
Module 2 Quiz
Let’s practice SQL!
Module 3: AWS Services for ETL
Module 3 Introduction
Why Do Data Analytics in the Cloud?
Extracting Data with Amazon API Gateway
Processing Data with AWS Lambda
Loading Data with Amazon RDS - Relational Database Service
Loading Data with DynamoDB - Non-Relational Database Service
Visualizing Data with Amazon QuickSight
Choosing the Right Tool for the Job
Course Wrap-Up
Additional AWS Services for Data Analysis
Post-Course Survey
Ready for the lab?
Ready for the lab?
Ready for the lab?
Final Assessment
Lab 1: Introduction to Amazon API Gateway
Lab 2: Introduction to Amazon Relational Database Service (RDS)
Lab 3: Introduction to Amazon QuickSight
Post-Course Survey