Visit Our Website: https://interviewpen.com/?utm_campaig...
Join Our Discord (24/7 help):   / discord  
Like & Subscribe:    / @interviewpen  

Many large companies wind up with several sources of data and want to use all of them together to make business decisions. This video dives into the low-level details of designing a data warehousing system to bring in these data sources, transform them, and analyze them in aggregate.

If you liked this video and want to learn more about fundamental systems and how they can be used to solve problems, check out our full course on https://interviewpen.com/?utm_campaig... !

Table of Contents:
0:00 - Introduction
0:35 - Requirements
1:33 - Data Sources
2:28 - Batch Ingestion System
4:40 - Batch Ingestion Strategies
7:31 - Streaming Ingestion
8:16 - Third-Party Services
9:40 - Transformation
11:09 - SQL Analysis
11:30 - Overview
12:22 - Overview using Snowflake
13:44 - interviewpen.com

Socials:
Twitter:   / interviewpen  
LinkedIn:   / interviewpen  
Website: https://interviewpen.com/?utm_campaig...