🎬 *SQL Full (30-Hours) Course* https://youtu.be/SSKVgrwhzus
From Zero to Data Warehouse Hero: A Full SQL Project Walkthrough and Real Industry Experience!
🎁 *Free Downloads & Materials:* https://datawithbaraa.substack.com
👉 *Support & Subscribe* to Channel: http://bit.ly/3GiCVUE
☕ *Stay Connected*
► Subscribe: http://bit.ly/3GiCVUE
► Newsletter: https://bit.ly/BaraaNewsletter
► LinkedIn: https://www.linkedin.com/in/baraa-khatib-salkini/
► Website: https://www.datawithbaraa.com
► PayPal: https://paypal.me/baraasalkini
► Join: https://www.youtube.com/channel/UC8_RSKwbU1OmZWNEoLV1tQg/join
📚 *Free Courses*
✅ *Tableau* : https://youtu.be/K3pXnbniUcM
✅ *SQL Playlist* : https://www.youtube.com/playlist?list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe
✅ *SQL Project1* : https://youtu.be/9GVqKuTVANE
✅ *SQL Project2* : https://youtu.be/2jGhQpbzHes
✅ *Tableau Project 1* : https://youtu.be/dahrmqT5GD4
✅ *Tableau Project 2* : https://youtu.be/UcGF09Awm4Y
✅ *MySQL* :https://youtu.be/NTgejLheGeU
🎓 *If You Need Certifications*
► Udemy SQL: https://bit.ly/4hH947P
► Udemy Tableau: https://bit.ly/3xFiDDk
⭐ My favorite books: https://kit.co/DataWithBaraa/my-favorite-books
💻 My gear: https://kit.co/DataWithBaraa/my-desktop-gear
⏱️ *Timestamp*
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
#sql #sqlserver #data #analytics
*Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!*
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*