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: https://github.com/johnny-chivers/sql...

SUPPORT THE CHANNEL:
☕ Buy Me A Coffee: https://www.buymeacoffee.com/johnnych...
🖥️ My VPN: https://go.nordvpn.net/aff_c?offer_id...

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:    • AWS Glue Tutorial for Beginners [FULL...  
ℹ️ My Website: https://johnnychivers.co.uk
🔗 Linkedin:   / johnny-chivers  

😎 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 🤘