Getting Started with AWS Athena

AWS Athena is a new, serverless technology enabling users to query S3 data interactively. This course teaches you everything you need to use Athena, including access configuration, schema definition, querying, and performance and cost optimization.
Course info
Rating
(52)
Level
Beginner
Updated
Aug 23, 2017
Duration
2h 14m
Table of contents
Description
Course info
Rating
(52)
Level
Beginner
Updated
Aug 23, 2017
Duration
2h 14m
Description

Ever wish you could query data without needing to provision, manage, and configure infrastructure and software? Enter AWS Athena, a scalable, serverless, and interactive query service newly provided by Amazon Web Services. In this course, Getting Started with AWS Athena, you'll learn how to utilize Athena and perform ad-hoc analysis of data in the Amazon Cloud. First, you'll explore how to setup user access, and define schemas which point to your S3 data. Next, you'll discover how to query information using SQL in a few simple steps. Finally, you'll delve into how Athena works from behind the scenes and understand the best practices that drive Athena cost and performance optimization. By the end of this course, you'll have the skills and knowledge necessary to start implementing solutions with AWS Athena on your own datasets in your own AWS environments.

About the author
About the author

Aaron is an independent cloud architect and software developer, specializing in solutions on Amazon Web Services (AWS). He holds several certifications encompassing development, architecture, and operations within the AWS cloud service suite. Aaron has contributed to companies offering services in the healthcare, training, and e-commerce sectors of business. His interests in the cloud space include automation, serverless computing, data, and security. When he isn't working on his next project, Aaron can be found gaming with friends, or at the local poker tables.

More from the author
Administering Amazon Aurora on Amazon RDS
Intermediate
3h 26m
Dec 10, 2018
Visualizing Data with Amazon QuickSight
Intermediate
3h 3m
Jan 19, 2018
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hey everyone, my name is Aaron Medacco, and welcome to my course, Getting Started with AWS Athena. I'm a software developer, and cloud architect specialized in Amazon Web Services. Have you ever wanted to query data without configuring and managing infrastructure? What about without requiring ETL jobs? Then you've come to the right place. Athena allows you to query data directly in S3, and without managing instances or clusters, and there's no need to transform data. In this course, I'll show you everything you need to use Athena, and perform ad hoc analysis of data in the Amazon cloud. The major topics we'll cover include uploading files to S3, configuring user access to Athena in an AWS account, defining schemas we can use to query our S3 data from Athena, querying our data using standard SQL, and cost and performance optimization using best practices. By the end of this course, you'll have mastered the skills required to perform and implement ad hoc analysis of data using Athena. Before beginning the course, you should be comfortable with using Amazon Web Services at a basic level, and familiar with writing SQL. I hope you'll join me on this journey to learn how to implement solutions using Athena, with the Getting Started with AWS Athena course, here at Pluralsight.