Databases Vs Data Warehouses Vs Data Lakes - What Is The Difference And Why Should You Care?

Recently I was helping a client with a project because their MongoDB instance wasn't able to handle the queries they needed. I explained that one of the major issues is that MongoDB wasn't built for complex analytical queries. Both in terms of its structure and its query language. So I suggested they look into OLAP. But they weren't sure what that was, so I decided to make a video about databases vs data warehouses vs data lakes. If you enjoyed this video, check out some of my other top videos. Top Courses To Become A Data Engineer In 2022    • Top Courses To Become A Data Engineer In 2022   What Is The Modern Data Stack - Intro To Data Infrastructure Part 1    • What Is The Modern Data Stack - Intro To D...   If you would like to learn more about data engineering, then check out Googles GCP certificate https://bit.ly/3NQVn7V If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here. https://seattledataguy.substack.com/​​ Or check out my blog https://www.theseattledataguy.com/ And if you want to support the channel, then you can become a paid member of my newsletter https://seattledataguy.substack.com/s... Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio _____________________________________________________________ Subscribe:    / @seattledataguy   _____________________________________________________________ About me: I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data. *I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.

Data Warehouse vs Data Lake vs Data Lakehouse | ETL, OLAP vs OLTP
▶︎

Data Warehouse vs Data Lake vs Data Lakehouse | ETL, OLAP vs OLTP

What is Databricks? The Story Behind the Modern Data Platform (Visual Explanation)
▶︎

What is Databricks? The Story Behind the Modern Data Platform (Visual Explanation)

Data Modeling - Walking Through How To Data Model As A Data Engineer - Dimensional Modeling 101
▶︎

Data Modeling - Walking Through How To Data Model As A Data Engineer - Dimensional Modeling 101

Learn Snowflake in 2 Hours| High Paying Skills | Step by Step For Beginners
▶︎

Learn Snowflake in 2 Hours| High Paying Skills | Step by Step For Beginners

Databricks vs Snowflake vs dbt: Built for which Data Teams? Finally Understand the Difference
▶︎

Databricks vs Snowflake vs dbt: Built for which Data Teams? Finally Understand the Difference

Vocabulary for Data Engineers - Data Engineering 101
▶︎

Vocabulary for Data Engineers - Data Engineering 101

Data Lake vs. Data Warehouse vs. Data Lakehouse: Which One to Choose?
▶︎

Data Lake vs. Data Warehouse vs. Data Lakehouse: Which One to Choose?

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

Designing Data-Intensive Applications: Chapters 1 and 2
▶︎

Designing Data-Intensive Applications: Chapters 1 and 2

Snowflake Vs Databricks - 🏃‍♂️ A Race To Build THE Cloud Data Platform 🏃‍♂️
▶︎

Snowflake Vs Databricks - 🏃‍♂️ A Race To Build THE Cloud Data Platform 🏃‍♂️

Data Lakehouses Explained for Beginners! Complete Guide to Data Lakehouses!
▶︎

Data Lakehouses Explained for Beginners! Complete Guide to Data Lakehouses!

What Tools Should Data Engineers Know - 100 Days Of Data Engineering
▶︎

What Tools Should Data Engineers Know - 100 Days Of Data Engineering

Data Warehouse vs Data Lake vs Data Lakehouse
▶︎

Data Warehouse vs Data Lake vs Data Lakehouse

Data Modeling - Why Data Engineers Need To Understand It - An Introduction To Data Engineering
▶︎

Data Modeling - Why Data Engineers Need To Understand It - An Introduction To Data Engineering

Why so many companies use dbt - data build tool explained
▶︎

Why so many companies use dbt - data build tool explained

Data Lakehouses Explained
▶︎

Data Lakehouses Explained

What It Actually Takes to Build a Data Pipeline System From Scratch - And Why You Probably Shouldn't
▶︎

What It Actually Takes to Build a Data Pipeline System From Scratch - And Why You Probably Shouldn't

Learn DBT(databuildtool) in 10 Minutes
▶︎

Learn DBT(databuildtool) in 10 Minutes

Data Engineering Vocabulary - Becoming A Data Engineer
▶︎

Data Engineering Vocabulary - Becoming A Data Engineer

99% of Developers Don't Get PostgreSQL
▶︎

99% of Developers Don't Get PostgreSQL