[ FreeCourseWeb.com ] AWS Big Data - Athena
Download More Latest Courses Visit -->> https://FreeCourseWeb.com
Duration: 32m | Intermediate | Video: 1920x1080, 44kHz | 405 MB
Genre: eLearning | Language: English
Description
In this course, we will perform an in-depth review of the Amazon Athena service. We will review and explain fundamental AWS Athena storage and querying concepts. We will highlight suitable use cases in which Athena can be applied effectively. You will be introduced to the basic underlying technology that Athena has been built on. We spend time discussing the process of creating and setting up Athena databases, tables, and partitions. We examine the process in which Athena SQL queries are authored and how they are managed. We review current Athena limitations and pricing. Finally, we will provide a nstration in which we publish CloudTrail logs into an S3 bucket. We make some ad-hoc security group changes to generate a few CloudTrail events - and finally we’ll use Athena to search and find the captured security group API update calls.
Transcript
- [Jeremy] Hello and welcome to the Cloud Academy course on Amazon Athena. Before we start I'd like to introduce myself. My name is Jeremy Cook. I'm one of the trainers here at Cloud Academy specializing in AWS. Feel free to connect with either myself or the wider team here at Cloud Academy regarding anything about this course. You can email us at [email protected] Alternatively our online community forum is available for your feedback. In this training course you'll be introduced to Amazon Athena. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Let's quickly review the Amazon Athena offering. It allows you to quickly query unstructured, semi-structured, and structured data stored in S3. It's a server-less based service. You only pay for the data scanned. Built on Presto technology and open source distributed SQL query engine. Provides and SQL like dialect for data querying. Designed to provide fast performance for large data set scanning. The agenda for the remainder of this course is as follows. We'll review and explain fundamental AWS Athena storage and querying concepts. We'll highlight suitable use cases in which Athena can be applied effectively. We'll review the basic underlying technology that Athena has been built on. We'll discuss and illustrate the process of creating and setting up Athena tables, formats, and partitions. We'll examine the process in which Athena SQL queries are offered. We'll review current Athena limitations and pricing. Finally we'll provide a nstration in which we publish CloudTrail logs into an S3 bucket. We'll make some ad-hoc security group changes to generate a few CloudTrail events. Finally, we'll use Athena to search and find the captured security group API update calls. The following prerequisites will be both useful and helpful for this course. General big data and analytical concepts; Amazon Simple Storage Service, S3; SQL, Structured Query Language. Furthermore if you require an introduction to S3 then please consider taking the free S3 lab hosted here on Cloud Academy.
About the Author
Jeremy Cook
Use Winrar to Extract. And use a shorter path when extracting, such as C: drive
ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)
Download More Latest Courses Visit -->> https://FreeCourseWeb.com
Get Latest Apps Tips and Tricks -->> https://AppWikia.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
