SkillGild
Serverless Analytics with Amazon Athena
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Enroll course

Course sections

Section 1
Your First Query
1
Athena – What is Amazon Athena?
2
Athena – Obtaining and preparing sample data
3
Athena – Running your first query
Section 2
Your First Query
1
Athena – What is Amazon Athena?
2
Athena – Obtaining and preparing sample data
3
Athena – Running your first query
Section 3
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 – Metering and billing
6
Athena – Connecting and securing
7
Athena – Connecting and securing
8
Athena – Determining when to use Amazon Athena
9
Athena – Determining when to use Amazon Athena
Section 4
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
Section 5
Key Features | Query Types and Functions
1
Athena – Running ETL queries
2
Athena – Running ETL queries
3
Athena – Running approximate queries
4
Athena – Organizing workloads with WorkGroups and saved queries
5
Athena – Using Athena’s APIs
Section 6
Securing Your Data
1
Athena – General best practices to protect your data on AWS
2
Athena – General best practices to protect your data on AWS
3
Athena – Encrypting your data and metadata in Glue Data Catalog
4
Athena – Encrypting your data and metadata in Glue Data Catalog
5
Athena – Enabling coarse-grained access controls with IAM resource policies for data on S3
6
Athena – Enabling coarse-grained access controls with IAM resource policies for data on S3
7
Athena – Enabling FGACs with Lake Formation for data on S3
8
Athena – Enabling FGACs with Lake Formation for data on S3
9
Athena – Auditing with CloudTrail and S3 access logs
10
Athena – Auditing with CloudTrail and S3 access logs
Section 7
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
Section 8
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
Section 9
AWS Glue and AWS Lake Formation
1
Athena – What AWS Glue and AWS Lake Formation can do for you
2
Athena – What AWS Glue and AWS Lake Formation can do for you
Section 10
Querying Unstructured and Semi-Structured Data
1
Athena – Why isn’t all data structured to begin with?
2
Athena – Why isn’t all data structured to begin with?
3
Athena – Querying JSON data
4
Athena – Querying JSON data
5
Athena – Querying arbitrary log data
6
Athena – Querying arbitrary log data
Section 11
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
Section 12
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
Section 13
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
Section 14
Operational Excellence – Monitoring | Optimization | Troubleshooting
1
Athena – Monitoring Athena to ensure queries run smoothly
2
Athena – Monitoring Athena to ensure queries run smoothly
Section 15
Building Applications with Amazon Athena
1
Athena - Connecting to Athena
2
Athena - Connecting to Athena
3
Athena – Best practices for connecting to Athena
4
Athena – Best practices for connecting to Athena
5
Athena – Securing your application
6
Athena – Securing your application
7
Athena – Optimizing for performance and cost
8
Athena – Optimizing for performance and cost
Section 16
Athena UDFs and ML
1
Athena – What are UDFs?
2
Athena – What are UDFs?
3
Athena – Writing a new UDF
4
Athena – Writing a new UDF
5
Athena – Using built-in ML UDFs
6
Athena – Using built-in ML UDFs
Section 17
Athena Query Federation
1
Athena – What is Query Federation?
2
Athena – What is Query Federation?
3
Athena – How Athena Connectors work
4
Athena – How Athena Connectors work
5
Athena – Using pre-built Connectors
6
Athena – Using pre-built Connectors
7
Athena – Building a custom connector
8
Athena – Building a custom connector
Section 18
Lake Formation – Advanced Topics
1
Athena – Reinforcing your data perimeter with Lake Formation
2
Athena – Reinforcing your data perimeter with Lake Formation
3
Athena – Understanding the benefits of governed tables
4
Athena – Understanding the benefits of governed tables

C Program to list all files and sub-directories in a directory

Lesson is locked. Please Buy course to proceed.