Serverless Analytics with Amazon Athena

Your First Query

1
Athena – What is Amazon Athena?
2
Athena – Obtaining and preparing sample data
3
Athena – Running your first query

Introduction to Amazon Athena

1
Athena – Getting to know Amazon Athena
2
Athena – What is Presto?
3
Athena – Understanding scale and latency
4
Athena – Metering and billing
5
Athena – Connecting and securing
6
Athena – Determining when to use Amazon Athena

Key Features | Query Types and Functions

1
Athena – Running ETL queries
2
Athena – Running approximate queries
3
Athena – Organizing workloads with WorkGroups and saved queries
4
Athena – Using Athena’s APIs

Metastores | Data Sources and Data Lakes

1
Athena – What is a metastore?
2
Athena – What is a data source?
3
Athena – Registering S3 datasets in your metastore
4
Athena – Discovering your datasets on S3 using AWS Glue Crawlers
5
Athena – Designing a data lake architecture

Securing Your Data

1
Athena – General best practices to protect your data on AWS
2
Athena – Encrypting your data and metadata in Glue Data Catalog
3
Athena – Enabling coarse-grained access controls with IAM resource policies for data on S3
4
Athena – Enabling FGACs with Lake Formation for data on S3
5
Athena – Auditing with CloudTrail and S3 access logs

AWS Glue and AWS Lake Formation

1
Athena – What AWS Glue and AWS Lake Formation can do for you

Ad Hoc Analytics

1
Athena – Understanding the ad hoc analytics hype
2
Athena – Building an ad hoc analytics strategy
3
Athena – Using QuickSight with Athena
4
Athena – Using Jupyter Notebooks with Athena

Querying Unstructured and Semi-Structured Data

1
Athena – Why isn’t all data structured to begin with?
2
Athena – Querying JSON data
3
Athena – Querying arbitrary log data

Serverless ETL Pipelines

1
Athena – Understanding the uses of ETL
2
Athena – Deciding whether to ETL or query in place
3
Athena – Designing ETL queries for Athena
4
Athena – Using Lambda as an orchestrator
5
Athena – Triggering ETL queries with S3 notifications

Building Applications with Amazon Athena

1
Athena – Connecting to Athena
2
Athena – Best practices for connecting to Athena
3
Athena – Securing your application
4
Athena – Optimizing for performance and cost

Operational Excellence – Monitoring | Optimization | Troubleshooting

1
Athena – Monitoring Athena to ensure queries run smoothly

Athena Query Federation

1
Athena – What is Query Federation?
2
Athena – How Athena Connectors work
3
Athena – Using pre-built Connectors
4
Athena – Building a custom connector

Athena UDFs and ML

1
Athena – What are UDFs?
2
Athena – Writing a new UDF
3
Athena – Using built-in ML UDFs

Lake Formation – Advanced Topics

1
Athena – Reinforcing your data perimeter with Lake Formation
2
Athena – Understanding the benefits of governed tables

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Enrolled: 0 students
Lectures: 50

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Serverless Analytics with Amazon Athena
Price:
Free