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
Auf dieser Seite können Sie das Online-Video SQL Data Warehouse from Scratch | Full Hands-On Data Engineering Project mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data with Baraa 10 Februar 2025 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 593,895 Mal angesehen und es wurde von 16 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
