MCP-youtube

Currently Playing: SQL Full Course for Beginners (30 Hours) – From Zero to Hero

I’ve spent 2 years creating this *high-quality SQL course* so you can master SQL for data analysis & data engineering. The best part? It’s 100% free - *SQL Full Package* https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *SQL Handbook* https://academy.datawithbaraa.com/l/digital_download/1087406/the-sql-handbook - *Free SQL materials* https://www.datawithbaraa.com/wiki/sql - *SQL course playlist* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe ━━━━━━━━━━━━━━━━━━━━ *🏆 My Academy (recommended)* - *Python* https://www.datawithbaraa.com/course/the-ultimate-python-mastery - *Python Handbook* https://academy.datawithbaraa.com/l/digital_download/998313/the-python-handbook - *Tableau* https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners *🎓 Udemy* - *SQL* https://www.udemy.com/course/the-complete-sql-bootcamp-30-hours-go-from-zero-to-hero/?referralCode=D20781228C2EB8B98339 - *Python* https://www.udemy.com/course/the-complete-python-bootcamp-13hours-go-from-zero-to-hero/?referralCode=776491A4119FF8AF41CA - *Tableau* https://www.udemy.com/course/the-tableau-ultimate-course-from-zero-to-hero/?referralCode=6544726FDC491A6B25EC *💼 LinkedIn Learning* - *Databricks for Data Analysts* https://www.linkedin.com/learning/databricks-for-data-analysts - *Claude Code for Data Analysis* https://www.linkedin.com/learning/claude-code-for-data-analysis-build-repeatable-reliable-workflows 📬 *Newsletter for data friends* https://www.blog.datawithbaraa.com *Get 25% OFF DataCamp's Here* https://datacamp.pxf.io/bOEe66 ━━━━━━━━━━━━━━━━━━━━ 📖 *Table of Content* ___🟢Beginner Level___ 00:00 Intro 07:38 Introduction to SQL 22:33 Setup Your Environment 34:01 Query Data (SELECT) 01:32:31 DDL Commands 01:43:44 DML Commands ___🟡Intermediate Level___ 02:08:03 Filtering Data 02:47:57 SQL Joins (Basics) 03:27:29 SQL Joins (Advanced) 04:02:09 Set Operators 04:47:41 SQL Functions 04:52:58 String Functions 05:18:44 Numeric Functions 05:22:48 Date and Time Functions 06:59:06 NULL Functions 08:07:50 Case Statement 08:43:36 Aggregate Functions 08:50:11 Window Functions Basics 09:47:00 Window Aggregate 10:53:09 Window Ranking 11:56:05 Window Value ___🔴Advanced Level___ 12:40:34 Advanced SQL Techniques 12:58:04 Subqueries 14:18:08 Common Table Expressions (CTE) 15:35:02 Views 16:36:40 CTAS and Temp Tables 17:17:31 Compare Advanced Techniques 17:27:04 Stored Procedures 18:12:58 Triggers 18:23:42 Indexes 20:20:31 Execution Plan 21:11:03 Partitions 21:43:39 30x Performance Tips 22:24:25 AI and SQL ___🧪Projects___ 23:21:04 Project: SQL Data Warehouse 24:32:54 Project DWH | Bronze 25:10:09 Project DWH | Silver 26:47:46 Project DWH | Gold 27:41:51 Project: Exploratory Data Analysis (EDA) 28:30:38 Project: Advanced Data Analytics 29:47:24 Thank You ━━━━━━━━━━━━━━━━━━━━ *CONNECT WITH ME* 💬 Discord https://discord.gg/gsVJbMxKcA 👨‍💻 LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/ 📸 Instagram https://www.instagram.com/datawithbaraa/ 🎥 TikTok https://www.tiktok.com/@datawithbaraa 🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa Note: some links above are affiliates. I may earn a small commission if you enroll. Thank you for supporting the channel. #sql #sqlserver #data #analytics #dataanalysis #datascience