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
*Subscribe* https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1
🎁 *Free Downloads & Materials:* https://www.blog.datawithbaraa.com/
👉 Support & Subscribe to Channel: http://bit.ly/3GiCVUE
🎓 *If You Need Certifications & Structured Course*
🏅Udemy SQL: https://bit.ly/4hH947P
🏅Udemy Tableau: https://bit.ly/3xFiDDk
⭐ My favorite books, gear, apps: https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link
☕ *Stay Connected*
► Subscribe: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► TikTok: https://www.tiktok.com/@datawithbaraa
► Website: https://www.datawithbaraa.com
► Newsletter: https://bit.ly/BaraaNewsletter
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join
► My favorite stuff: https://bit.ly/baraastuff
📚 *Free Courses*
✅ *Python* : https://www.youtube.com/playlist?list=PLNcg_FV9n7qZGfFl2ANI_zISzNp257Lwn
✅ *SQL* : https://youtu.be/SSKVgrwhzus
✅ *Tableau* : https://youtu.be/UcGF09Awm4Y
✅ *Tableau Project 1* : https://youtu.be/dahrmqT5GD4
✅ *Tableau Project 2* : https://youtu.be/UcGF09Awm4Y
✅ *SQL Project1* : https://youtu.be/9GVqKuTVANE
✅ *SQL Project2* : https://youtu.be/2jGhQpbzHes
✅ *MySQL* :https://youtu.be/NTgejLheGeU
Date & Time Script can be found here: https://github.com/DataWithBaraa/sql-ultimate-course/blob/main/scripts/10_Date_Time_Formats.sql
📖 *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
This course is perfect for data analysts, data engineers, data scientists, software developers, and students—covering everything from the basics to advanced SQL topics.
#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Skip Sponsors
Transcript
English (auto-generated)Auto-generated
363984 words
1847696 chars
1820 min read
Hello and welcome to this unique course to master SQL. My name is Barzalini and I lead big data projects at Mercedes-Benz over a decade of experience in SQL data engineering, building data warehouses and data analytics. Now, of course, the first question is what makes this course so special. Well, not only you will learn how to write SQL codes, but more important than that, you will learn how exactly SQL works behind the scenes. So I'm going to break complex concept in SQL using hundreds of animated visuals. This makes it really easier to understand SQL and as well it is more fun than just sharing my screen and I just show you code. Right. The second reason is this course is taught by me. I have industrial experience and I will be sharing with you everything that I know about SQL and how I use it in my real projects. So I will be sharing with you hundreds of best practices, tips and tricks and I'm going to show you my decision-m process in SQL. So by the end of this course, you will be ready to solve any complex task like I do using SQL. So now I designed this course to cover the basics like writing your first SQL query and then we're going to keep progressing in the course by covering advanced techniques in SQL like the window functions, stored procedures, indexes and even at the end we're going to build a data warehouse using SQL. And this course is suitable for anyone data engineers, data analyst, data scientist and even for students. And by the way the good news everything is for free from the start until the ends I will be sharing with you as well a lot of materials code presentations and animations and there are no hidden costs. So you don't have to pay for anything. But my friends in return I really appreciate it if you support the channel in order to grow. All right my friends I'm really excited about it. I don't know about you. If you are motivated join me learning SQL. This is going to be amazing. So let's go. All right....
More YouTube Tools
YouTube Video Tools
Free tools for YouTube video analysis
Get Another Transcript
Extract transcripts from any YouTube video
💡 Pro Tips for YouTube Transcripts
- • Use transcripts to create study notes from educational videos
- • Extract quotes for social media or research
- • Convert video content to searchable text
- • Create subtitles for accessibility