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

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.
👉 Subscribe, Like, and Comment If you want more FREE Courses ❤️   / @datawithbaraa  

━━━━━

MY COURSES
To get certified, better clean structure & progress, support me:
🏅SQL https://www.datawithbaraa.com/course/...
🏅Tableau https://www.datawithbaraa.com/course/...
🏅Udemy SQL: https://bit.ly/4hH947P
🏅Udemy Tableau: https://bit.ly/3xFiDDk

━━━━━

CONNECT WITH ME
📬 Newsletter https://www.blog.datawithbaraa.com/su...
👨‍💻 LinkedIn   / baraa-khatib-salkini  
📸 Instagram   / datawithbaraa  
🎥 TikTok   / datawithbaraa  
🌍 Website https://www.datawithbaraa.com/
💬 Discord   / discord  
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.sit...
📩 Sponsorships [email protected]

━━━━━

Get 25% OFF DataCamp's Here
https://www.datacamp.com/coupon/membe...

━━━━━

MY FREE COURSES
SQL    • SQL Full Course for Beginners (30 Hours) –...  
Python    • Python Bootcamp Playlist (2025) - Zero to ...  
Tableau    • Complete HR Tableau Project End-to-End | L...  
Real World Data Projects    • Data Analyst Portfolio Projects  
Data Career Roadmaps    • Data Career Roadmaps  

━━━━━

🎁 FREE DOWNLOADS & MATERIALS
https://www.datawithbaraa.com/wiki/sq...

⌚️ TIMESTAMPS
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

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