AWS for Data Science: Mastering Data Storage & Querying with S3, Athena, RDS & Redshift (V2/4)
This comprehensive video lecture series guides data scientists through the essential AWS services for managing and querying large-scale datasets. We begin by exploring the fundamentals of data management on AWS, covering a range of storage and database solutions. You'll get a deep dive into Amazon S3, learning how to organize data with folders, manage object versions, and optimize costs with lifecycle policies.
Next, we'll demonstrate how to query data directly from S3 using Amazon Athena and standard SQL, eliminating the need for complex ETL pipelines. We'll also cover the role of AWS Glue f…
Watch on YouTube ↗
(saves to browser)
Chapters (18)
Introduction to the Video
1:08
Managing Data on AWS: Storage and Databases
5:51
Understanding Storage Types: Object vs. File vs. Block
12:30
Introduction to Databases on AWS
19:55
Deep Dive into S3 for Data Science Workflows
23:05
Exploring S3 Bucket Types
27:34
Organizing Data with S3 Folders (Prefixes)
30:04
Managing S3 Objects and Lifecycle Policies
38:00
S3 Bucket Versioning Explained
43:53
Managing Bucket Policies and Public Access
57:05
Creating S3 Lifecycle Rules in Detail
1:01:46
Querying Data Directly with Athena SQL on S3
1:05:27
Hands-On Demo: Querying CSV Data in S3 with Athena
1:22:21
Automating Schema Creation with AWS Glue Crawlers
1:36:43
Programmatically Generating Athena Table Schemas with Python
1:49:03
Using RDS and Redshift for Structured Data
1:52:34
Hands-On Demo: Creating and Connecting to an Amazon RDS Instance
2:09:51
Hands-On
Playlist
Uploads from Analytics Vidhya · Analytics Vidhya · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Future of Self Driving Autonomous Vehicles ⚡️
Analytics Vidhya
Hyperparameter Tuning for Improving Model Accuracy #ai #datascience #learnwithav #hyperparameter
Analytics Vidhya
Gaurav Agarwal’s Blueprint for Success with RagaAI | Leading With Data 45
Analytics Vidhya
Google Search vs Perplexity AI #EpicBattle #AI #Shorts
Analytics Vidhya
AI Bubble Is Imploding ❓
Analytics Vidhya
Elon Musk on AI Training Data ⚡️ #elonmusk #ai #shorts
Analytics Vidhya
Google Gemini AI goes wrong twice #google #gemini
Analytics Vidhya
Enhancing Cybersecurity with Machine Learning #ai #machinelearning #cybersecurity
Analytics Vidhya
Google Pixel Add Me Is Crazy Good 🟢
Analytics Vidhya
OpenAI In Trouble Before GPT 5 Launch ⚡
Analytics Vidhya
Tesla Optimus Enginnering ⚡️ #elonmusk #ai #shorts
Analytics Vidhya
How Google Makes Money ❓️ #ai #shorts #google
Analytics Vidhya
Google Pixel 9 Screen AI 🟢 #ai #google
Analytics Vidhya
Facebook Wanted to Buy DeepMind, But.. ⚡
Analytics Vidhya
Reality of AI vs Compute 🔺 #ai #shorts #google
Analytics Vidhya
NVIDIA Stealing Netflix Videos ❓ #ai #shorts
Analytics Vidhya
Elon Musk's Grok 2 Went Viral, OpenAI GPT 4o Fine-tuning, Gemini x Pixel | Daily AI News
Analytics Vidhya
Human Brain Is 25 Watt 🟢 #ai #shorts
Analytics Vidhya
Too Good to Release -Says OpenAI ❓ #ai #shorts #chatgpt
Analytics Vidhya
Google Ending WFH ❓ #ai #google #shorts
Analytics Vidhya
How Big Data is Revolutionizing Your Shopping Experience! 🛒✨
Analytics Vidhya
Free Astrology - ChatGPT 🍎 #ai #openai #chatgpt
Analytics Vidhya
Microsoft releases Phi-3.5 Models 🍎
Analytics Vidhya
ChatGPT Runs for Mayor ⚡
Analytics Vidhya
Walmart, Zomato & AI ⚡
Analytics Vidhya
LLMs vs NLP | Large Language Models vs Natural Language Processing #llms #nlp #genai
Analytics Vidhya
AI News in 60 Seconds
Analytics Vidhya
Developers Won’t Code Anymore ❓
Analytics Vidhya
DeepMind Employees Challenge Google ❓
Analytics Vidhya
Cerebras, a new challenger in the AI chip market, Apple’s new iOS 18.1 | AI News in 60 Seconds
Analytics Vidhya
AI Assistants: Beyond Siri and Alexa 🚀 #openaichatbotgpt #technology #siri #alexa
Analytics Vidhya
OpenAI's Project Strawberry: The Next Big AI Leap 🍓
Analytics Vidhya
Optimizing Email Marketing with GenAI Agents! #ai #aiagents #genai
Analytics Vidhya
Nations Building Own AI Models ⚡
Analytics Vidhya
Reflection 70B: Most Powerful Open-Source AI 🤖
Analytics Vidhya
"Apple Event 2024: Unleashing Next-Gen AI Features! 🚀"
Analytics Vidhya
Apple Intelligence x iPhone 16 ⚡️
Analytics Vidhya
Amazon Alexa x Anthropic Claude AI 🤖
Analytics Vidhya
OpenAI o1: 'Strawberry' Reasoning Model 🔥
Analytics Vidhya
OpenAI o1 x Playing Code Game ⚡️
Analytics Vidhya
OpenAI o1 Strawberry X Counting Problem ⚡️
Analytics Vidhya
OpenAI Releases o1: Advanced Reasoning 'Strawberry' Model
Analytics Vidhya
OpenAI o1 Solving Logic Puzzle ⚡️
Analytics Vidhya
OpenAI Strawberry o1 is here ⚡️
Analytics Vidhya
OpenAI o1 x Cognition AI Devin ⚡️
Analytics Vidhya
OpenAI o1: Where is the Strawberry? 🍓
Analytics Vidhya
OpenAI Strawberry o1 x Quantum Physics ⚡️
Analytics Vidhya
OpenAI Strawberry o1 x Snake Game
Analytics Vidhya
OpenAI Strawberry o1 X Transformers Explained ⚡️
Analytics Vidhya
OpenAI Strawberry o1 x Genetics
Analytics Vidhya
OpenAI Strawberry o1 x Reasoning Model ⚡️
Analytics Vidhya
OpenAI o1 Reasoning x Translation ⚡️
Analytics Vidhya
Ilya’s SSI Raises $1B
Analytics Vidhya
The Deepfake Dilemma: What’s Real and What’s Not?
Analytics Vidhya
World’s Fastest AI Inference Service 🔥
Analytics Vidhya
Rohan Rao's Framework for Selecting the Right LLMs for Business Needs!
Analytics Vidhya
AI MythBusters: Can AI Really Read Your Mind? Let’s Bust That Myth!
Analytics Vidhya
OpenAI To Turn For-profit ⚡️
Analytics Vidhya
Building a Generative AI Agentic System for Email Marketing #aiagents
Analytics Vidhya
OpenAI rolling out Strawberry o1-mini on ChatGPT
Analytics Vidhya
DeepCamp AI