SQL Data Warehouse from Scratch 🚀

From Zero to SQL Data Warehouse Hero (From Scratch) A Full SQL Project Walkthrough and Real Industry Experience! You will learn how I Do real world Data Engineering Projects.
👉 Subscribe, Like, and Comment If you want more FREE Courses ❤️https://www.youtube.com/@UC8_RSKwbU1OmZWNEoLV1tQg

━━━━━

*MY COURSES*
To get certified, better clean structure & progress, support me:
🏅SQL https://www.datawithbaraa.com/course/sql-full-course-for-beginners
🏅Tableau https://www.datawithbaraa.com/course/tableau-ultimate-full-course-for-beginners
🏅Udemy SQL: https://bit.ly/4hH947P
🏅Udemy Tableau: https://bit.ly/3xFiDDk

━━━━━

*CONNECT WITH ME*
📬 Newsletter https://www.blog.datawithbaraa.com/subscribe
👨‍💻 LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/
📸 Instagram https://www.instagram.com/datawithbaraa/
🎥 TikTok https://www.tiktok.com/@datawithbaraa
🌍 Website https://www.datawithbaraa.com/
💬 Discord https://discord.gg/gsVJbMxKcA
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.site/My-Favorite-Books-Gear-Apps-28334b251f1281e58a52cf7aa594e0e9?source=copy_link
📩 Sponsorships baraa@datawithbaraa.com

━━━━━

*Get 25%* OFF DataCamp's Here
https://www.datacamp.com/coupon/membership-2Fcheckout-3Fcoupon-DATAWITHBARAA25ALE25

━━━━━

*MY FREE COURSES*
*SQL* https://youtu.be/SSKVgrwhzus
*Python* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZGfFl2ANI_zISzNp257Lwn
*Tableau* https://youtu.be/UcGF09Awm4Y
*Real World Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7
*Data Career Roadmaps* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd

━━━━━

🎁 *FREE DOWNLOADS & MATERIALS*
https://www.datawithbaraa.com/wiki/sql#sql-welcome

⌚️ TIMESTAMPS
00:00 - Intro
01:27 - Types of SQL Projects
02:50 - What is Data Warehouse
09:41 - What is ETL
20:29 - Project Materials
23:14 - Project Plan Using Notion
30:54 - Analyzing Requirements
==============
34:10 - Design The Data Architecture
35:20 - Choose the Right Approach
40:43 - Design the Layers of DWH
47:37 - Draw the Architecture using Draw.io
==============
56:00 - Project Initialization
56:56 - Define Naming Conventions
01:03:26 - Prepare Your GIT Repository
01:07:54 - Create Database & Schemas
01:10:33 - Commit Code in Git Repo
==============
01:13:14 - Build Bronze Layer
01:14:36 - Analyze Source Systems
01:18:40 - Create DDL for Tables
01:24:21 - Develop SQL Load Scripts
01:32:18 - Create Stored Procedure
01:45:28 - Document: Data Flow
==============
01:50:31 - Build Silver Layer
01:52:08 - Explore & Understand The Data
02:03:05 - Create DDL for Tables
02:06:52 - Clean & Load crm_cust_info
02:22:03 - Clean & Load crm_prd_info
02:42:48 - Clean & Load crm_sales_details
02:59:38 - Clean & Load erp_cust_az12
03:08:38 - Clean & Load erp_loc_a101
03:14:16 - Clean & Load erp_px_cat_g1v2
03:18:38 - Create Stored Procedure
03:24:29 - Document: Data Flow
==============
03:28:09 - Build Gold Layer
03:29:39 - What is Data Modeling?
03:32:17 - Star Schema vs. Snowflake Schema
03:34:06 - Dimensions vs Facts
03:35:10 - Explore the Business Objects
03:39:04 - Create Dimension Customers
03:55:30 - Create Dimension Products
04:02:43 - Create Fact Sales
04:08:48 - Build The Star Schema Model
04:13:58 - Data Catalog
04:16:40 - Data Flow
==============
04:21:45 - End of Project

This project is perfect for data analysts, data engineers, data scientists, software developers, and students—covering everything from the basics to advanced SQL topics.
#sql #data #analytics #dataengineering #dataengineer