How To Write Better SQL: Advanced SQL Episode 3 - Denormalization Vs. Normalization Part 1

Welcome to episode 3 of Writing Better SQL

I wanted to take a step back and focus on something different today.

I wanted to talk about the key ingredient to writing SQL

The data.

See something that doesn’t get said enough is how you structure your data changes how you query your data.

Let me say that again.

How you structure your data changes how you query it.

This is an important concept to understand especially as modern data warehouses can seem to implicitly imply that you no longer need classic data warehouse structures

Everything is denormalized

Which we will talk about shortly

Along with a few other concepts.

But let’s talk about data and queries.

See you in the video!

Also, if you have questions or your company needs help with their data warehouses or automation reach out to us below.
https://www.theseattledataguy.com/

Видео How To Write Better SQL: Advanced SQL Episode 3 - Denormalization Vs. Normalization Part 1 канала Seattle Data Guy