SQL Tips & Tricks Every Data Professional Should Know | Best Coding Practices 2022 | LearnSQL

[@Abdullah_Al_Saud]

Thanks dear, missing your whistle...

[@sasstemir]

I came to the same conclusion about CTEs just based on my own experience. I had so much frustration with big complex queries more than 100 lines long. Couple of days later I couldn't understand my own query. CTEs make this problem so much easier to handle. Totally agree

[@candidlyvivian]

ahh yes you understand the struggle with large subqueries!! never going back to those again :)

[@twigglee]

Thanks for this video 🙌

[@candidlyvivian]

glad it helped! :)

[@brenmichflan]

This video is pure gold. Keep this content coming. Great thanks and cheers to you

[@candidlyvivian]

no worries at all and thank you for watching !!!

[@divina.glitch]

I really like your videos! Thank you! :)

[@candidlyvivian]

Thanks Facundo!

[@TheCanihavaname]

Thank you for this!

[@candidlyvivian]

No worries! Glad it helped :)

[@gospelmoto2833]

Your video is candidly beautiful as you are. Helps alot for a newbie like me. Keep sharing.

[@candidlyvivian]

Thank you 💖 I hope to make an updated version of this soon!

[@gospelmoto2833]

@@candidlyvivian That would be great!

[@azulbahia8766]

No puedo creer lo increíble que son estos trucos, thank you so much!

[@candidlyvivian]

omg yay thank you so much! I'm glad it helped :)

[@jakemurphy9121]

You mentioned CTEs only need to be run once. Does that mean they're more for static data that doesn't change in that case? I have a nested select statement I would like to optimize, but the data changes frequently

[@candidlyvivian]

hey Jake, the nested select statement is fine as a CTE!

[@TomsDataWorld]

Good video Vivian! Gonna follow

[@candidlyvivian]

thanks Tom!!

[@stopthink9000]

Great tips! Thx!

[@candidlyvivian]

thank you! glad it helped :)

[@andracoisbored]

Can you make another one of these? pleaseeee! more tips and tricks. No matter how small 😊😊

[@candidlyvivian]

yay I’m glad you enjoyed! watch my latest video (the SQL interview one - I do share a few tips there too)

[@pinggong2471]

Good job!

[@chriskeo392]

Sup Viv. You rock. Thanks!

[@candidlyvivian]

thanks Chris!! 🙂

[@Traumatised311]

Vivian I took some lesson of statistic on Coursera for data science M from a mechanical background I found stats for data science very hard n it made me cry What would u suggest I have given up on idea of being a data science

[@candidlyvivian]

hi there! nooo don't give up! if that's the case I would recommend trying to pick up SQL / do a machine learning course and see if you enjoy that aspect (don't focus too much on the theory behind it!) you can also pursue data analyst path and then transition into data science :)

[@Traumatised311]

@@candidlyvivian Data analyst jobs r mostly given to software engineers or I t engineers where I live I am a mechie as I said

[@astrallaneskincare]

Such a helpful video….thanks for this

[@candidlyvivian]

Most welcome 😊

[@rado_paradoks]

Very cool!

[@candidlyvivian]

Thank you!

[@petridishlife]

Thanking you!!!

[@candidlyvivian]

thank you! :)

[@nsrchndshkh]

SQL formatting per line looks good but is very difficult if the query is 10 pages long.

[@candidlyvivian]

Haha I do it regardless - CTEs and one variable per line and will submit an 11 page PR 🤣💪

[@suryavoid2488]

thank you so much love your dimples

[@candidlyvivian]

thanks Surya!

[@landrexrebuera5881]

Thank you very much.

[@candidlyvivian]

thanks for watching Landrex! :)

[@surendrareddy1949]

Thanks for tips

[@candidlyvivian]

no worries, thanks for watching !

[@Traumatised311]

Hey can you recommend Coursera courses for statistics required for data science

[@candidlyvivian]

deeplearning.ai has some great courses :)

[@adityasharma8807]

THE CONTENT WAS GREAT ALSO YOU LOOK SO BEAUTIFUL😊

[@candidlyvivian]

Thank you Aditya!!! 💖

[@reshmisiva593]

Much needed video! Thanks. Do data scientists use procedures, function all the other T- Sql, PL/SQL stuff as well? Awaiting your response. TIA

[@candidlyvivian]

hi reshmi! thank you :) glad it helped. i've only briefly dabbled in PL/SQL oracle but have never used T-SQL. what I've realised is that most companies have their own SQL servers and "language" whether that's SparkSQL / postgresSQL and all are relatively similar in syntax

[@terryshang9776]

Lets goooo

[@BarDots315]

I passed an interview thanks to the with statement I learned from this video I watched 10 min before the interview lol

[@candidlyvivian]

OMG congrats this made my day :D

[@JBS439]

hello Vivian, please teach me SQL

[@90skidindailykaruthu13]

Hi Shang, Sql is very simple one .If you intrested I will teach you free

[@JBS439]

Please do teach me. I am very interested and ready to start

[@candidlyvivian]

hi Shang, good luck!! please check out my other SQL videos on my channel ☺️ I have one on resources I like to use as well as basic SQL commands to get started!

[@MiningForPies]

The CTE advice is not correct. If you reference it more than once SQL will in-line it and run it for each reference.

[@blakemoore3858]

Just starting out...lord help me 😅

[@candidlyvivian]

good luck Blake!

[@casualgamingz153]

don't forget to blink girl

[@candidlyvivian]

Hahaha omg I have noticed that - I’m still not great at talking to the camera 😅

[@casualgamingz153]

@@candidlyvivian you did great, i saw that anxiety, but its ok, video was very great btw, thank you very much, keep up!

[@candidlyvivian]

@@casualgamingz153 thank you! :)

[@ardaburakcobankent1950]

Hello, your thumbnails are too crowded I cant even read in desktop so you may try using a single/simple background image only instead of collage, also I think you can try cutting some words, 4-5 words would be enough for the content I guess. quick tips from another youtuber, I hope you can stay steady please dont burnout :p

[@candidlyvivian]

thanks for the feedback, appreciate it!! good luck with your channel too

[@baloney_sandwich]

Less your face, more sql code

[@candidlyvivian]

thanks for the feedback, noted for next time!