Hurtownia danych - omówienie podstaw w 25 minut

✅Are you curious about what a data warehouse is? Or perhaps you want to know the difference between ETL and ELT, data lake and data warehouse, the Kimball model and Data Vault 2.0, and on-premises data warehouses and cloud-based ones like Snowflake, Google BigQuery, and Amazon Redshift? In this video, I'll answer all these and many other interesting questions. 🎁 GET GIFTS/SUBSCRIBE TO THE NEWSLETTER: 1) SQL Roadmap in PDF: https://promo.mistrzsql.pl/ 2) A book on how to become a database developer: https://promo.podstawybazdanych.pl/ 3) List of the most common PL/SQL programmer mistakes: https://promo.plsql.pl/ == ⏱️ Episode schedule:== 00:00 episode introduction 01:12 what is a database? 03:43 What is a data warehouse and how does it differ from a database? 07:17 What is reverse ETL? 09:18 What is the CDC (change data capture) process? 13:36 Inmon data warehouse model 13:44 Kimball data warehouse model 14:30 Data Vault 2.0 data warehouse model 14:56 OBT (one big table) data warehouse model 16:44 Classic vs. modern data warehouse 18:13 How does the ETL process work? 20:11 How the ELT process works, i.e., ETL vs. ELT 22:08 Batch ETL vs. Stream ETL 22:49 What is a data lakehouse? (data lake + data warehouse) 23:19 Job requirements for a data warehouse developer 27:12 Episode summary == 🔗 Useful links from the recording:== 🏷️Database normalization:    • Normalizacja Baz Danych Dla Początkujących...   🏷️PL/SQL trigger:    • Trigger sql (after insert) w Oracle, czyli...   == 👌 I recommend watch:== Database index:    • Indeks w bazie danych   co to jest i jak d...   SQL scripts:    • Co to jest skrypt sql? Tworzenie skryptów ...   #bazodanowiec == 👨‍💻 Get to know less better:== My website: https://www.nieinformatyk.pl/ Facebook:   / nieinformatyk   LinkedIn:   / darekbutkiewicz   Instagram:   / nieinformatyk   Twitter:   / nieinformatyk   Subscribe to my channel: https://www.youtube.com/nieinformatyk... 🏁 Welcome to my channel :) I've been a database programmer and data warehouse developer (ETL/ELT) for over 7 years. On this channel, I share my knowledge of relational databases (RDBMS), SQL query language, and data warehouse-related topics in a simple and understandable way. If you're looking to gain practical knowledge in this area, you've come to the right place. 🚨 More information about databases can be found at [https://www.nieinformatyk.pl](https://www.nieinformatyk.pl/) 📧 Have a question, request, or suggestion? Feel free to contact me at [[email protected]](mailto:[email protected])