How To Write Better SQL In 7 Minutes

SQL is one of the most popular tools when it comes to working with data.

Whether you're an analyst, a data engineer or data scientist.

We all use it heavily to work with data.

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

Top Courses To Become A Data Engineer In 2022

What Is The Modern Data Stack - Intro To Data Infrastructure Part 1

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.

[andrelsjunior]

Bad SQL creates hard time
Hard time creates good SQL
Good SQL creates easy time
Easy time creates bad SQL

[Davidkiania]

For those of us who deal with timeseries. This is the best thing I have in my toolkit. Instead of casting dates DATE_TRUNC() into days, month, quarter, business days etc I have been using a dates dimension table.

And create joins to the date fields of my tables. It’s super fast and yes I know joins can create performance issues but for speed and ease of use this works perfectly. Also reduces bugs. Also helps creating indices for the mostly used dates ..

Thanks for this video great amazing work.

[nicky_rads]

Solid tips, thanks for sharing !
SQL is really important in the data world, every little bit helps.

[malcorub]

I've started aligning all my "meaningful" field aliases in a single column because that's what my new team does. Good idea on their part that I've recently adopted.

[Enzo-jjte]

Thanks for the super content ! Sounds like you teased this video during your live exchange with Zach, when you mentioned "SQL undefeated" :)

[sangitatonger]

loved the clip you inserted at 2:10. thanks for making this video! all this sounds like common best practices but as we know "common" is not so common.

[sharu]

Thank you so much for your time in making this video, very insightful!

[Agx]

A discussion when using tab is if comma comes before the statement or after, I use it before as it is easier to comment it.

[Mahmoudai]

Great video, I suggest you write points of your video in the description or do moments so it will be much easier for us to jump between points. thank u

[MirasBlackbox]

Great tips, thank you! By the way have you made a video about how to make an effective documentation for tables/views/each fields, or how to effectively transfer these knowledge across the team, esp new team member? Coz I know ppl wont read documents or documentation. And one can easily lost in the sea of tables, views, databases and their ambiguous definition. So maybe any insight on this?

[SoCassiElle]

I'm learning a lot from your channel. Thanks 👍

[go]

Thanks a lot for this video! I wonder if you can talk about testing in sql in the future. Is there a standard way to do testing in sql? What is the best practice in term of testing your sql code

[ladhkay]

Lol love the gordon meme and great tips! subbed!

[atherisu]

Big SQL queries are so hard for me to read and understand, do you have any tips for that?. In Python I'm used to using a notebook and going over piece by piece to understand the logic but for SQL it seems like it's one massive thing with all the logic and 3 pages long that I don't know how to dissect and understand

[vivekpatidar]

4:42 EMINEM LOSE YOURSELF 🔥🔥

His palms are sweaty, knees weak, arms are heavy
There's vomit on his sweater already, mom's spaghetti
He's nervous, but on the surface he looks calm and ready to drop bombs
But he keeps on forgetting what he wrote down, the whole crowd goes so loud
He opens his mouth, but the words won't come out
He's choking how, everybody's joking now
The clock's run out, time's up, over, blaow!
Snap back to reality

Mind Blowing 🤯🤯

[cmarquay]

CTRL + SHIFT + K
Ugly but definitively a solution.

[MisterBozo]

Add comments ! Meaningful comments, that explain the GOAL of the query. If I can read a query just by reading the comments that's a win for me.

[emanueol]

friendly suggestion: on a tech/dev videos please show more code than filming you talking..

[__toby__]

Should've taken the title more literally.. how to make your sql look better in 7 minutes is more appropriate.