Understanding SQL Query Execution - What Happens When You Run A SQL Command

Here is something school probably didn't teach you about SQL

Or at the very least you likely forgot.

When you write a query, hit submit, and then run the query or that little triangle in DBBeaver…

…what exactly happens?

Sure, you likely understand that data is pulled from multiple tables, data is filtered, and aggregations occur.

But behind the scenes, what is going on?

Read The Full Article Here

If you enjoyed this video, check out some of my other top videos.

Top Courses To Become A Data Engineer

What Is The Modern Data Stack - Intro To Data Infrastructure

If you would like to learn more about data engineering, then check out Googles GCP certificate

If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.

Or check out my blog

And if you want to support the channel, then you can become a paid member of my newsletter

Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio

_____________________________________________________________
_____________________________________________________________
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.

[RLWade]

SDG's Data Academy.... food for thought.

[matthewhoang]

Really enjoyed the back to basic video! Probably need to add at least 20 more to that spongebob list lol

[natashawilson]

This was a helpful video! A great length as well. Thanks!

[piyushagarwal]

Hi Ben, thanks for putting up the video. Really appreciate it!

[sajithjames]

Hi Ben, just a question. In DE do you use a lot if python or is it mostly SQL. I would think SQL, but some job post indicate intermediate to advanced python knowledge. If you do use python, to what extent do you use it - is it creating snippets of code or do you need to go OOP with various classes.

[DannyB-hd]

Why will SQL sometimes pick a really terrible query plan even when the query text hasn't changed and parameters are pretty similar? E.g. > date - 1. Is it almost always due to stale statistics?

[adamsaraya]

not video related but i'v got a question. is there entry level data engineering jobs, or should i become a data analyst first?

[jay_wright_thats_right]

Schools do teach you this but in more detail. This is too basic and it may be great for interviewing purposes.