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
This course is part of AWS Cloud Technology Consultant Professional Certificate
Instructors: Oksana Hoeckele
Top Instructor
3,965 already enrolled
Included with 
(42 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
Details to know
Add to your LinkedIn profile
7 assignments
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
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 3 modules in this course
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
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
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 readings4 assignments3 app items1 plugin
Instructors
Offered by
Recommended if you're interested in Cloud Computing
Tableau Learning Partner
University of California, Irvine
DeepLearning.AI
Why people choose Coursera for their career
Learner reviews
42 reviews
- 5 stars
83.33%
- 4 stars
7.14%
- 3 stars
7.14%
- 2 stars
0%
- 1 star
2.38%
Showing 3 of 42
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
New to Cloud Computing? Start here.
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
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy
Frequently asked questions
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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. If you only want to read and view the course content, you can audit the course for free.
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.