SQL For AWS Athena [FULL COURSE IN 40mins]
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 🤘
Watch video SQL For AWS Athena [FULL COURSE IN 40mins] online without registration, duration hours minute second in high quality. This video was added by user Johnny Chivers 31 August 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 18,494 once and liked it 487 people.