SQL Full Course for Beginners (30 Hours) – From Zero to Hero
Data with Baraa
0:00 / 0:00
SQL Full Course for Beginners (30 Hours) – From Zero to Hero
5 151 589 просмотров · 1 год назад
Data with Baraa
471 тыс. подписчиков
5 151 589 просмотров · 1 год назад
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
Want More? 👇
Free Download Materials https://www.datawithbaraa.com/wiki/sq...
Full Package (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/...
Subscribe for more Free Data content: / @datawithbaraa
🏆 DATA ACADEMY
SQL https://www.datawithbaraa.com/course/...
Python https://www.datawithbaraa.com/course/...
Python Handbook (sketches, notes, code) https://academy.datawithbaraa.com/l/d...
Tableau https://www.datawithbaraa.com/course/...
🎓UDEMY
SQL https://www.udemy.com/course/the-comp...
Python https://www.udemy.com/course/the-comp...
Tableau https://www.udemy.com/course/the-tabl...
━━━━━
CONNECT WITH ME
📬 Newsletter https://www.blog.datawithbaraa.com
👨💻 LinkedIn / baraa-khatib-salkini
📸 Instagram / datawithbaraa
🎥 TikTok / datawithbaraa
🌍 Website https://datawithbaraa.com/
💬 Discord / discord
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.sit...
📩 Sponsorships baraa@datawithbaraa.com
━━━━━
Get 25% OFF DataCamp's Here https://datacamp.pxf.io/bOEe66
━━━━━
MY FREE COURSES
SQL • SQL Full Course for Beginners (30 Hours) –...
Python • Python Full Course for Beginners (13 Hours...
Tableau • Complete HR Tableau Project End-to-End | L...
Databricks • Databricks 2 Days Bootcamp
Power BI • Power BI Ultimate Course
Data Projects • Data Analyst Portfolio Projects
Data Careers • Data Career Roadmaps
━━━━━
📖 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 #dataanalysis #datascience