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
In questa pagina del sito puoi guardare il video online SQL Data Warehouse from Scratch | Full Hands-On Data Engineering Project della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Data with Baraa 10 febbraio 2025, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 593,895 volte e gli è piaciuto 16 mille spettatori. Buona visione!
