In this video I cover how to use SQL with AWSAthena. Using the resources I have uploaded to GitHub we carryout a full tutorial on how to manipulate data and carry out data analytics tasks within the AWS Athena Ecosystem. Don't worry if you are new to SQL, AWS, or Athena I guide you through everything step by step.

LINK TO GITHUB TUTORIAL RESOURCES:
💾 Code Repo: [ Ссылка ]

SUPPORT THE CHANNEL:
☕ Buy Me A Coffee: [ Ссылка ]
🖥️ My VPN: [ Ссылка ]

00:00 - Intro
00:43 - Setup Work
06:28 - Theory of Athena And Presto
10:04 - Create Database
14:20 - Select Data
16:21 - Column Alais
17:12 - Concat Two Columns
18:07 - Where Clause For Filtering
19:03 - And Clause
19:31 - Or Clause For Filtering
20:13 - In Clause For Filtering
21:25 - Wild Cards And Like Clause
23:08 - Union
26:15 - Insert Data
28:13 - Distinct
30:03 - Count
30:33 - Count Distinct
30:58 - Group By
33:05 - Nested Queries
34:09 - Common Table Expressions (cte)
35:23 - Joins
39:47 - Outro

OTHER USEFUL LINKS:
📹 Glue Tutorial: [ Ссылка ]
ℹ️ My Website: [ Ссылка ]
🔗 Linkedin: [ Ссылка ]

😎 About me
I have spent the last decade being immersed in the world of big data working as a consultant for some the globe's biggest companies.My journey into the world of data was not the most conventional. I started my career working as performance analyst in professional sport at the top level's of both rugby and football. I then transitioned into a career in data and computing. This journey culminated in the study of a Masters degree in Software

Enjoy 🤘

свернуть