Data Analytics and Databases on AWS
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Analytics and Databases on AWS
This course is part of AWS Cloud Technology Consultant Professional Certificate
Instructors: Rafael Lopes
8,365 already enrolled
Included with
Ask Coursera
59 reviews
59 reviews
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
See how employees at top companies are mastering in-demand skills
Build your Cloud Computing expertise
- 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.
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
Offered by
Explore more from Cloud Computing
- Status: PreviewA
Amazon Web Services
Course
- Status: Free TrialW
Whizlabs
Course
- Status: Free Trial
Course
- Status: FreeA
Amazon Web Services
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
83.05%
- 4 stars
8.47%
- 3 stars
5.08%
- 2 stars
1.69%
- 1 star
1.69%
Showing 3 of 59
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
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.
More questions
Financial aid available,