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/sq...
Free SQL Course • SQL Full Course for Beginners (30 Hours) –...
Full Package (projects, quizzes, structure, certificate) https://www.datawithbaraa.com/course/...
Subscribe for more Free Data content: / @datawithbaraa
🏆 DATA ACADEMY
SQL https://www.datawithbaraa.com/course/...
Python https://www.datawithbaraa.com/course/...
Python Handbook (sketches, notes, code) 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...
━━━━━
CONNECT WITH ME
📬 Newsletter https://www.blog.datawithbaraa.com
👨💻 LinkedIn / baraa-khatib-salkini
📸 Instagram / datawithbaraa
🎥 TikTok / datawithbaraa
🌍 Website https://datawithbaraa.com/
💬 Discord / discord
🧭 Notion Roadmaps https://www.notion.com/@datawithbaraa
⭐ Favorite Books/Gear https://candle-gosling-511.notion.sit...
📩 Sponsorships baraa@datawithbaraa.com
━━━━━
Get 25% OFF DataCamp's Here https://datacamp.pxf.io/bOEe66
━━━━━
MY FREE COURSES
SQL • SQL Full Course for Beginners (30 Hours) –...
Python • Python Full Course for Beginners (13 Hours...
Tableau • Complete HR Tableau Project End-to-End | L...
Databricks • Databricks 2 Days Bootcamp
Power BI • Power BI Ultimate Course
Data Projects • Data Analyst Portfolio Projects
Data Careers • Data Career Roadmaps
━━━━━
⌚️ 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
On this page of the site you can watch the video online SQL Data Warehouse from Scratch | Full Hands-On Data Engineering Project with a duration of hours minute second in good quality, which was uploaded by the user Data with Baraa 10 February 2025, share the link with friends and acquaintances, this video has already been watched 834,125 times on youtube and it was liked by 20 thousand viewers. Enjoy your viewing!
