How To Write Better SQL In 7 Minutes

Подписаться 100 тыс.

Просмотров 15 тыс.

50% 1

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
• Top Courses To Become ...
What Is The Modern Data Stack - Intro To Data Infrastructure Part 1
• What Is The Modern Dat...
If you would like to learn more about data engineering, then check out Googles GCP certificate
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.
seattledataguy...
Or check out my blog
www.theseattle...
And if you want to support the channel, then you can become a paid member of my newsletter
seattledataguy...
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.

Опубликовано:

18 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 45

@SeattleDataGuy 2 года назад

If you guys want to learn more about data engineering, then sign up for my newsletter here seattledataguy.substack.com/ or join the discord here discord.gg/2yRJq7Eg3k

@andrelsjunior 2 года назад

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

@SeattleDataGuy 2 года назад

This is deep wisdom

@andrelsjunior 2 года назад

@@SeattleDataGuy needed to change a few words haahha

@rodi2641 2 года назад

@@andrelsjunior next time don't write the second comment ...leave it ...be cooler

@andrelsjunior 2 года назад

@@rodi2641 sorry hehe

@TheyCalledMeT 2 года назад

Hard time creates good SQL haha nice analogy ^^ but .. you clearly wheren't ever in a prolonged stressful situation if you assume that creates good sql :D

@nicky_rads 2 года назад

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

@SeattleDataGuy 2 года назад

It really is still the core for much of our data work

@Davidkiania 2 года назад

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.

@malcorub 2 года назад

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.

@SeattleDataGuy 2 года назад

Any other tips! Are there other things you have picked up from your new team?

@Enzo-jj5te 2 года назад

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

@SeattleDataGuy 2 года назад

Thanks for watching the live! A little bit. I have made that joke a few times more just poking fun. I think data frames has set up a solid niche as well.

@sangitatonger3628 2 года назад

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.

@SeattleDataGuy 2 года назад

Common is not so common and sometimes we need a reminder

@sharu164 2 года назад

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

@SeattleDataGuy 2 года назад

Glad you found it insightful!

@brothermalcolm 2 года назад

Love your original video titles!

@SeattleDataGuy 2 года назад

Is it original haha..it feels like your traditional "Build a neural network in 3 minutes"...those were the days

@Agx21111 2 года назад

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.

@SeattleDataGuy 2 года назад

Yes this is a constant battle. Where does the comma go. Similar to where does the curly bracket go if you used a language like Java. I actually ran a poll on my linkedin seeing where people thought commas should go.

@SoCassiElle 2 года назад

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

@SeattleDataGuy 2 года назад

I am so glad to hear that!

@MirasBlackbox 2 года назад

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?

@SeattleDataGuy 2 года назад

I might have to consider putting together this video!

@ladhkay 2 года назад

Lol love the gordon meme and great tips! subbed!

@SeattleDataGuy 2 года назад

Glad oyu enjoyed it!

@Mahmoudai 2 года назад

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

@vivekpatidar3177 Год назад

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 🤯🤯

@go556 2 года назад

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

@atherisu4842 2 года назад

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

@SeattleDataGuy 2 года назад

Generally sql queries can be broken up into staging tables or with CTEs. This should help break up the logic.

@Davidkiania 2 года назад

Also sqlalchemy has been working wonders for me. And esp core has the ability to refactor queries. For instance select and group by can be made into a single field and reused.