What you'll learn
How to Setup AWS Athena
Why use AWS Athena
How to integrate Athena with AWS Glue
Use Athena to query S3 data
How other companies use Athena
Monitor Athena Queries and Results using CloudWatch
Syntax of Queries in Athena
How to use Lambda Functions with Athena
Data Partitioning in Athena
Costing of Athena and AWS
Assign permissions for Athena
Create dashboards using queries from Athena
Description
AWS Athena is a powerful yet easy to use server-less query service. Amazon Athena is an interactive data analysis tool used to process complex queries from S3 in relatively less time using standard SQL. It is server-less hence, there is no hassle of setting up and doesn't require managing the infrastructure.. Athena contains a user friendly interface to write your queries.
Athena has auto scaling, so even when you're dealing with complex queries and large data sets, you can execute your queries in parallel and quickly generate the results. You just pay for what you use, consequently making the service a conveniently cost-effective option for organizations leveraging Amazon S3. You just point your data in S3, define the schema required and with a standard SQL you are good to go.
We will learn about the main use cases of Athena -
Ease of Working with Quick Queries- Athena doesn't require installation. It can be accessed directly from the AWS Console. It integrates easily with other AWS services.
Cost Effectiveness - The cost effectiveness comes in many parts. First the benefits of the cloud and AWS and scalability. But also you don't need to setup servers for heavy databases and complex SQL tools.
Speed- With the assurance of AWS, Athena is highly available and the user can execute queries round the clock. As AWS is 99.999% available, so is Athena. Along with that you can write complex parallel running queries in no time and leverage the power of the cloud. Results come faster than you expect.
We will understand why AWS Athena is the perfect serverless query tool. We will learn about its features & capabilities.
As a service that runs its queries using standard SQL, AWS Athena is widely accessible to anyone - not just developers and engineers. Even business analysts and other data professionals can adopt it.
Everything is well documented and separated, so you can find what you need. Assignments and Quizzes will make sure you stay on track and test your knowledge. The course will have a combination of theory and practical examples.
Who this course is for:
Software Developers who want to understand how to query data efficiently using a serverless tool like AWS Athena
DevOps Engineers
System Reliability Engineers
Anyone interested in how to use an interactive lightweight server-less query tool

Homepage

https://www.udemy.com/course/introduction-to-aws-athena-for-developers/