Building The Gold Layer: Star Schema Modeling | Data Engineer Portfolio Project | #SQL Project 9

Build a real Star Schema for the Gold Layer using SQL. Learn step-by-step data modeling for Data Engineering and create a strong portfolio project. SQL Full Package https://www.datawithbaraa.com/course/... SQL Handbook https://academy.datawithbaraa.com/l/d... Free SQL materials https://www.datawithbaraa.com/wiki/sql Full free SQL course    • SQL Full Course for Beginners (30 Hours) –...   ━━━━━━━━━━━━━━━━━━━━ 🏆 My Academy (recommended) Python https://www.datawithbaraa.com/course/... Python Handbook 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... 💼 LinkedIn Learning Databricks for Data Analysts   / databricks-for-data-analysts   Claude Code for Data Analysis   / claude-code-for-data-analysis-build-repeat...   📬 Newsletter for data friends https://www.blog.datawithbaraa.com Get 25% OFF DataCamp's Here https://datacamp.pxf.io/bOEe66 ━━━━━━━━━━━━━━━━━━━━ 📖 Table of Content 00:00 - Intro 01:26 - What is Data Modeling? 04:04 - Star Schema vs. Snowflake Schema 05:52 - Dimensions vs Facts 06:57 - Explore the Business Objects 10:50 - Create Dimension Customers 27:17 - Create Dimension Products 34:30 - Create Fact Sales 40:36 - Build The Star Schema Model 45:45 - Data Catalog 48:27 - Data Flow 50:49 - Commit Code in Git Repo ━━━━━━━━━━━━━━━━━━━━ CONNECT WITH ME 💬 Discord   / discord   👨‍💻 LinkedIn   / baraa-khatib-salkini   📸 Instagram   / datawithbaraa   🎥 TikTok   / 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 #data #analytics #dataengineering #dataengineer