Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This lab guides you through the process of setting up Amazon Athena to query and analyze sales data stored in Amazon S3. You learn how to configure Athena, work with S3 data, use AWS Glue to create table schemas, and write SQL queries to extract insights from the data.
Objectives
- Set up and configure Amazon Athena within the AWS Management Console.
- Upload datasets to Amazon S3 and create corresponding database tables in Athena.
- Use AWS Glue Crawler to automatically create table schemas in the AWS Glue Data Catalog.
- Write and execute SQL queries in Athena to analyze sales data.
- Analyze query editor features.
Prerequisites
- Basic familiarity with AWS Management Console.
- Understanding of fundamental SQL concepts.
- Basic knowledge of data storage and analysis concepts.
Outline
Task 1: Set up and configure Amazon Athena
Task 2: Upload sales data to S3
Task 3: Create and configure an AWS Glue crawler
Task 4: Create database tables using Athena and Glue Crawler
Task 5: Write and Execute SQL Queries
Task 6: Explore query editor Features
