What is AWS Glue1:06
Explore AWS Glue, a fully managed serverless ETL service that catalogs, cleans, enriches, and moves data, featuring the data catalog, crawlers, ETL engine, triggers, and workflows.
AWS Glue Crawlers - Theory8:30
Glue crawlers scan data from S3, DynamoDB, and relational sources to build tables in the Glue data catalog in a single run, enabling queries with Athena, Redshift Spectrum, or Hive.
AWS Glue Crawlers - Hands on8:04
Create and run an AWS Glue crawler to scan an S3 bucket, infer schema, and populate the data catalog with orders DB and tables using on demand runs.

Overview of Athena and Hands on Lab for Querying S3 Data26:07
Athena Partitioning Concept with LAB9:12
Learn how the Athena partitioning system improves query performance and cuts data scanned by partitioning S3 data with country, year, and month, and mapping partitions with alter table.
Automatic Partitioning with AWS Lambda10:23
Automatically load Athena partitions with AWS Lambda triggered by S3 put object events, using a Python Athena client to run load partitions and write results to S3.
Execute Athena Queries from AWS Lambda10:57
In this lecture, I have covered query execution from AWS Lambda. You can trigger this Lambda from any of the below sources -
S3 file upload
API Gateway
Glue Crawler status
Glue Job
Scheduled Lambda - Generate BI reports from Athena Queries
Athena JDBC Example - Query from Java Workspace14:04
Learn to connect to Athena from Java with the Simba JDBC driver in a Maven project, set S3 output and AWS credentials, and run a query for Tableau or Excel.

Introduction - Why we need SQL Clients2:33
Installing Squirrel SQL Client2:28
Install the Squirrel SQL client, ensure Java is installed (1.8–14), run the downloaded jar via administrator command, choose standard installation, then set up the Athena driver to run queries.
Reference Data0:20
Querying Athena from Squirrel SQL Client6:52
Learn how to connect AWS Athena to the Squirrel SQL client, configure the Athena JDBC driver, specify the S3 query output, and run SQL queries against Athena data sources.
Querying Athena from JetBrains DataGrip5:43

Requirements

AWS basics such as S3, IAM, AWS management console

Description

In this Udemy course, you will learn about AWS Athena in depth. This is most suitable course if you are starting with AWS Athena. I will cover following topics in Athena:

Introduction
Use cases and data lake querying
Table creation and queries
Certification Exam questions
Complete hands on Lab on Athena, S3 and Glue
Partitioning concept and how to create partitions
Querying Athena from Local workspace
Automatically loading partitions from AWS Lambda functions

This list would be updated based on the new features and releases. Also you can message me personally and comment if you want to see a video on specific topic on Athena.

Who this course is for:

Beginners of Amazon Web Services
Big data developers and cloud computing enthusiasts
Professionals targeting AWS Data Analytics Specialty
Developers who are using Athena for querying Data Lakes
Data Pipeline Developers

AWS Athena Tutorial with Hands on LAB | Serverless Querying

What you'll learn

Explore related topics

Course content

Course Introduction1 lecture • 4min

Pre-Requisites4 lectures • 7min

AWS Glue3 lectures • 18min

Athena - Important Topics5 lectures • 1hr 11min

Querying Athena from SQL Clients5 lectures • 18min

Athena + QuickSight for Visualizations4 lectures • 19min

Requirements

Description

Who this course is for: