Advanced Operations with Amazon Athena

Focused View

Sadequl Hussain

2:18:34

20 View

01 - Course Overview

01 - Course Overview.mp4

02:01

02 - Amazon Athena and Amazon Glue

02 - Introduction to the Course.mp4

05:13

03 - Whats Amazon Glue.mp4

03:31

04 - Introducing Glue Crawler.mp4

03:29

05 - Introducing the Dataset.mp4

02:34

06 - Glue Crawler Demo.mp4

05:08

07 - Scheduling a Glue Crawler.mp4

02:44

08 - Using Crawler Exclusion Patterns.mp4

04:13

09 - Configuring Crawler Output.mp4

04:51

10 - Summary.mp4

01:13

03 - Complex Data Types - Beyond CSV Files

11 - Introducing Complex Data Types.mp4

01:42

12 - Athena Complex Data Types.mp4

03:48

13 - Introducing the Dataset and Exercise Files.mp4

02:59

14 - Array Operators and Functions.mp4

06:03

15 - Querying JSON Data.mp4

02:02

16 - JSON Functions.mp4

05:44

17 - Test Your Knowledge.mp4

02:47

18 - Summary.mp4

00:46

04 - Making Athena Secure

19 - Introducing Athena Security.mp4

03:15

20 - Creating Athena IAM Policies.mp4

03:31

21 - Creating S3 Bucket Policies.mp4

01:50

22 - Introducing Encryption with Athena.mp4

01:37

23 - Querying Encrypted Data.mp4

04:15

24 - Encrypting Query Results and Glue Catalog.mp4

03:34

25 - Accessing Athena with JDBC Clients.mp4

06:16

26 - Auditing Athena Usage with CloudTrail.mp4

04:12

05 - Automating Athena

27 - Introducing Athena Automation.mp4

01:45

28 - Introducing the Dataset and Use Case.mp4

05:19

29 - High-level Design Walkthrough.mp4

02:19

30 - Lambda Function Walkthrough.mp4

05:59

31 - Creating an IAM Role.mp4

02:19

32 - Creating the Lambda Function.mp4

02:51

33 - Testing the Lambda Function.mp4

03:42

34 - Summary.mp4

01:19

06 - Data Visualization with Athena

35 - Introducing Visual Data Analytics.mp4

02:08

36 - Introducing the Dataset.mp4

01:48

37 - Creating a View.mp4

02:34

38 - Understanding Tableau Prerequisites.mp4

02:11

39 - Creating a Tableau Chart.mp4

07:36

40 - Publishing the Tableau Chart.mp4

06:17

41 - Summary.mp4

01:09

Description

If you're working with Amazon Athena, or thinking of using it to query your data lake, you can see how to take Amazon's serverless big data query tool to a whole new level. Learn all the important things to make the most of your Athena setup.

What You'll Learn?

Enterprises often face a formidable challenge when choosing a tool for analyzing terabytes or even petabytes of business-critical data stored in Amazon S3. Fortunately, there's Athena, a low-cost, easy-to-use, serverless query tool with a powerful Hive backend and a Presto query engine that allows you to run SQL queries on S3 data.

Learning the basics of Athena is simple, but how do you make it secure? How do you make it automated? How do you run dashboards off it?

In this course, Advanced Operations with Amazon Athena, you will learn the necessary skills to make your Athena setup more efficient and production-ready. First, you will learn how to use Amazon Glue to create Athena tables from unknown data sources. You will see how to run queries on complex data structures. Next, you will make your Athena applications more secure with policies and encryptions. Going even further, you will learn how to automate Athena data processing with other serverless tools like Lambda. Finally, you will build Tableau charts from Athena views and publish those charts to a Tableau server.

When you’re finished with this course, you will be equipped with advanced skills and knowledge to run a robust Athena setup. You will also get your hands dirty working with other technologies.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Big Data

Amazon AWS

Sadequl Hussain

Instructor's Courses

Sadequl Hussain is an information technologist and digital content producer from Sydney, Australia. He has more than twenty years of experience in development, infrastructure engineering, database management, training, and technical authoring. Over the years, Sadequl has worked with many different technologies and has written about topics ranging from databases to cloud to security to serverless. His technical articles have been published in blog sites of some of the well-known names in the industry. His main interest though is about anything related data and analytics. He also runs his own technical content marketing agency, ProDataSkills. When not writing or making videos, Sadequl can be found spending time with his young family or reading books on history.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.