Coursera
SubscriptionSQL Full Course for Beginners (30 Hours) – From Zero to Hero
No ratings yetBEGINNEREnglish
YouTubeYouTubePrice
This course is free to watch on its platform.
Watch free on YouTube →Mark your own learning status. Opening a course link does not establish enrollment.
Loading saved status…
This 30-hour video course takes the viewer from setup through to a data warehouse project. It is laid out in three levels, beginner, intermediate and advanced, followed by a block of projects, so you can follow it in order or jump to the section you need.
The opening covers the environment, SELECT queries and DDL and DML commands, then moves into filtering, the basic and advanced join types, set operators, and string, numeric, date and NULL functions. CASE statements and aggregate functions come before a run of window function lessons on aggregates, ranking and value functions.
The advanced section tackles subqueries, common table expressions, views, temporary tables, stored procedures, triggers, indexes, execution plans and partitions, with a tips section on performance. The projects build a data warehouse in bronze, silver and gold layers, then move into exploratory and advanced analysis.
A strong fit for people who want one continuous course from first query to project work. Be ready for a substantial time commitment.
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
Advertisement
No Korshub reviews yet.
