Data Analytics and Databases on AWS
Develop essential data analysis skills focusing on SQL, NoSQL databases, and the ETL process using AWS services like API Gateway, RDS, DynamoDB, and QuickSight.
Develop essential data analysis skills focusing on SQL, NoSQL databases, and the ETL process using AWS services like API Gateway, RDS, DynamoDB, and QuickSight.
This practical course develops the fundamental skills needed to think like a data analyst while working with AWS cloud services. Students begin by exploring essential concepts in data analysis, learning how to assess various use cases for cloud-based analytics solutions. The curriculum provides comprehensive coverage of key data types and structures, followed by an in-depth comparison of data processing approaches: extract, transform, and load (ETL) versus extract, load, and transform (ELT). With this foundation established, the course transitions to detailed instruction on the ETL pipeline, covering each component in sequence. Students gain both theoretical knowledge and hands-on experience with critical AWS services for data analysis, including Amazon API Gateway, Amazon Relational Database Service (RDS), Amazon DynamoDB, and Amazon QuickSight. The program includes practical lab exercises where participants directly interact with these services in the AWS Management Console and work within preconfigured environments. Throughout the course, students learn how to handle data effectively, ensure data quality, manage databases, and integrate data seamlessly - preparing them with practical skills for real-world data analysis scenarios in cloud environments.
Instructors:
English
English
Powered by
What you'll learn
Master key data types and structures for effective data analysis Understand the foundations of both SQL and NoSQL databases and their applications Write common SQL queries for data manipulation and analysis Learn the complete ETL (Extract, Transform, Load) process for data processing Gain hands-on experience with AWS services for the ETL pipeline Develop practical skills using Amazon API Gateway, Amazon RDS, and Amazon QuickSight Compare ETL and ELT approaches and determine appropriate use cases for each Implement data-driven decision making processes using AWS analytics tools
Skills you'll gain
This course includes:
PreRecorded video
Quizzes, Hands-on lab exercises
Access on Mobile, Tablet, Desktop
Limited Access access
Shareable certificate
Closed caption
Get a Completion Certificate
Share your certificate with prospective employers and your professional network on LinkedIn.
Created by
Provided by
Top companies offer this course to their employees
Top companies provide this course to enhance their employees' skills, ensuring they excel in handling complex projects and drive organizational success.
There are 3 modules in this course
This comprehensive course provides a practical introduction to data analytics and database management within AWS environments. The curriculum is organized into three interconnected modules that progressively build data analysis capabilities. The first module establishes foundational knowledge by introducing key concepts in data analysis, exploring various data types and structures, and comparing data processing methodologies (ETL vs. ELT) for different analytical scenarios. In the second module, students delve into database fundamentals and the extract, transform, load, and visualize (ETLv) process, gaining proficiency in SQL query basics for data manipulation and analysis. The course emphasizes both relational and NoSQL database concepts, providing a balanced understanding of different database paradigms. The final module focuses specifically on AWS services that support the ETL process, offering hands-on experience with tools like Amazon API Gateway for data extraction, Amazon RDS and DynamoDB for data storage, and Amazon QuickSight for visualization. Throughout the course, practical labs reinforce theoretical concepts, allowing students to directly apply their knowledge in preconfigured environments. By completion, participants will have developed a comprehensive skill set for implementing effective data analysis solutions on the AWS platform.
Week 1: Foundations of data analysis
Module 1 · 2 Hours to complete
Week 2: ETL and database foundations
Module 2 · 2 Hours to complete
Week 3: AWS Services for ETL
Module 3 · 2 Hours to complete
Fee Structure
Payment options
Financial Aid
Instructors
Cloud Technologist
Oksana Hoeckele is a Cloud Technologist based in the US. Oksana’s passion for learning led her to pursue a Bachelors and dual Master’s Degrees. Oksana taught at several higher education institutions, and while searching for opportunities to enhance her classes, she became interested in tech. Oksana completed a coding bootcamp, participated in hackathons, and wrote technical documentation for a tech company. Oksana finds herself always drawn to new experiences, cultures, and people. Outside of AWS, Oksana enjoys traveling, exploring the tech sector, gaining new skills, and sharing her knowledge with students.
Principal Cloud Technologist
Rafael “Raf” Lopes is a Brazilian Senior Cloud Technologist based out of New York, and has been determined to share as much knowledge as possible around the world to everyone with Internet access! Outside of AWS, you can find him taking street photographies around big cities, playing Pink Floyd solos on the guitar, cooking for his family, or enjoying videogames with his friends. He also loves to connect with customers and students on his Twitter at @DeployToProd.
Testimonials
Testimonials and success stories are a testament to the quality of this program and its impact on your career and learning journey. Be the first to help others make an informed decision by sharing your review of the course.
Frequently asked questions
Below are some of the most commonly asked questions about this course. We aim to provide clear and concise answers to help you better understand the course content, structure, and any other relevant information. If you have any additional questions or if your question is not listed here, please don't hesitate to reach out to our support team for further assistance.