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

Here are my favourite SQL Tips & Tricks that every data scientist, data analyst or data engineer should know. Check out learnsql.com/?ref=candidlyvivian to get started with LearnSQL.com today!
contact me ✨
✉️ e-mail | [e-mail]
📷 Instagram | @violetharmonyx
commonly searched tags ✨
data scientist, learning sql, how to learn sql for data science, data science interview questions and problems, best resources to learn sql, acing the data science interview, analytics, w3schools, sql tutorial, sql interview questions and answers, data analyst, candidlyvivian, what is SQL, structured query language, learnsql.com, learning sql 2022, sql tips and tricks, sql tips, advanced sql tips
disclaimer ✨
FTC: this video is sponsored by LearnSQL.com
all opinions expressed in this video and all videos on my UA-cam channel are solely my own, and do not express or reflect the views or opinions of my employer. they also do not reflect the views of any of the brands that I may mention.
1817

[@divina.glitch]

I really like your videos! Thank you! :)

[@candidlyvivian]

Thanks Facundo!

[@pinggong2471]

Good job!

[@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 :)

[@TheCanihavaname]

Thank you for this!

[@candidlyvivian]

No worries! Glad it helped :)

[@stopthink9000]

Great tips! Thx!

[@candidlyvivian]

thank you! glad it helped :)

[@chriskeo392]

Sup Viv. You rock.
Thanks!

[@candidlyvivian]

thanks Chris!! 🙂

[@twigglee]

Thanks for this video 🙌

[@candidlyvivian]

glad it helped! :)

[@TomsDataWorld]

Good video Vivian! Gonna follow

[@candidlyvivian]

thanks Tom!!

[@rado_paradoks]

Very cool!

[@candidlyvivian]

Thank you!

[@astrallaneskincare]

Such a helpful video….thanks for this

[@candidlyvivian]

Most welcome 😊

[@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 :)

[@terryshang9776]

Lets goooo

[@petridishlife]

Thanking you!!!

[@candidlyvivian]

thank you! :)

[@Abdullah_Al_Saud]

Thanks dear, missing your whistle...

[@landrexrebuera5881]

Thank you very much.

[@candidlyvivian]

thanks for watching Landrex! :)

[@suryavoid2488]

thank you so much love your dimples

[@candidlyvivian]

thanks Surya!

[@surendrareddy1949]

Thanks for tips

[@candidlyvivian]

no worries, thanks for watching !

[@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)

[@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!

[@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

[@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

[@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!!! 💖

[@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!