Learning Amazon Athena

Learning Amazon Athena

1h 53mBeginner2023-07-13

Authors

Uduak Sonuyi

Uduak Sonuyi

Information Security | AWS | MBA

Course details

Do you need to perform queries on terabytes of data? Would you like to leverage the power of the cloud to get insight on your data faster? In this course, join cloud security professional Uduak Sonuyi to explore Amazon Athena, a data management service, and how you can use it to analyze logs and CSV data files. Get an introduction to Amazon Athena and learn how to determine when it is the right tool for your task at hand. Go through the full process of analyzing logs with Amazon Athena. Learn about AWS Glue, as well as how to create an AWS Glue Crawler and use it with Athena. Plus, find out how to visualize data in Amazon Athena and design cost-effective queries. Uduak has worked with Amazon Web Services and SQL for over seven years and trained thousands of individuals to do the same. If you’re ready to leverage your SQL on the cloud, then get started here!

Skills covered

Amazon Web Services (AWS)AmazonCloud ServicesCloud PlatformsLearningCloud Computing

Concepts

Introduction

  • What is Amazon Athena
  • Skills and prerequisites

Introduction to Amazon Athena

  • Introduction to Amazon Athena
  • When to use Amazon Athena

Analyze Logs with Amazon Athena

  • Exploring AWS CloudTrail
  • View events in CloudTrail
  • Amazon Simple Storage Service (S3)
  • Create your first S3 bucket in S3
  • Connect Amazon CloudTrail to Amazon Athena
  • Use Amazon Athena queries to filter through CloudTrail logs

Analyzing CSV with Amazon Athena

  • What is AWS Glue
  • Create an AWS Glue Crawler to organize CSV data
  • Use Amazon Athena with an AWS Glue Crawler
  • Use Amazon Athena queries to filter through CSV data
  • Challenge - Analyze a CSV with Athena
  • Solution - Analyze a CSV with Athena

Visualizing Data in Amazon Athena and Designing Cost-Effective Queries

  • Power BI and Amazon Athena
  • Amazon QuickSight and Amazon Athena
  • Amazon Athena pricing and query optimization tips

Conclusion

  • Next steps
40,000 Toman