SQL Data Warehouse Portfolio Project - SQL Data Warehouse from Scratch | Full Hands-On Data Engineering Project

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. Want More? 👇 - *Free Download Materials* https://www.datawithbaraa.com/wiki/sql#sql-welcome - *Free SQL Course* https://youtu.be/SSKVgrwhzus - *Full Package* (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *Subscribe* for more Free Data content: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg?sub_confirmation=1 *🏆 DATA ACADEMY* - *SQL* https://www.datawithbaraa.com/course/sql-full-course-for-beginners - *Python* https://www.datawithbaraa.com/course/the-ultimate-python-mastery - *Python Handbook* (sketches, notes, code) 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 ━━━━━ *CONNECT WITH ME* 📬 Newsletter https://www.blog.datawithbaraa.com 👨‍💻 LinkedIn https://www.linkedin.com/in/baraa-khatib-salkini/ 📸 Instagram https://www.instagram.com/datawithbaraa/ 🎥 TikTok https://www.tiktok.com/@datawithbaraa 🌍 Website https://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 [email protected] ━━━━━ *Get 25%* OFF DataCamp's Here https://datacamp.pxf.io/bOEe66 ━━━━━ *MY FREE COURSES* - *SQL* https://youtu.be/SSKVgrwhzus - *Python* https://youtu.be/Rq5gJVxz55Q - *Tableau* https://youtu.be/UcGF09Awm4Y - *Databricks* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZoxVkw-KPhcmgLWjHWVUc9 - *Power BI* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZge4KDGqGtqgiuVuhVZWzu - *Data Projects* https://www.youtube.com/playlist?list=PLNcg_FV9n7qZ4Ym8ZriYT6WF8TaC2e_R7 - *Data Careers* https://www.youtube.com/playlist?list=PLNcg_FV9n7qah95jp-aPtysu7kFCbg7hd ━━━━━ ⌚️ 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