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
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
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
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 :)
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!
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
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
Thanks dear, missing your whistle...
This video is pure gold. Keep this content coming. Great thanks and cheers to you
no worries at all and thank you for watching !!!
Thanks for this video 🙌
glad it helped! :)
I really like your videos! Thank you! :)
Thanks Facundo!
Thank you for this!
No worries! Glad it helped :)
Your video is candidly beautiful as you are. Helps alot for a newbie like me. Keep sharing.
Thank you 💖 I hope to make an updated version of this soon!
@@candidlyvivian That would be great!
Good video Vivian! Gonna follow
thanks Tom!!
Great tips! Thx!
thank you! glad it helped :)
Good job!
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
ahh yes you understand the struggle with large subqueries!! never going back to those again :)
Sup Viv. You rock.
Thanks!
thanks Chris!! 🙂
SQL formatting per line looks good but is very difficult if the query is 10 pages long.
Haha I do it regardless - CTEs and one variable per line and will submit an 11 page PR 🤣💪
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
hey Jake, the nested select statement is fine as a CTE!
Can you make another one of these? pleaseeee! more tips and tricks. No matter how small 😊😊
yay I’m glad you enjoyed! watch my latest video (the SQL interview one - I do share a few tips there too)
Very cool!
Thank you!
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
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 :)
@@candidlyvivian
Data analyst jobs r mostly given to software engineers or I t engineers where I live
I am a mechie as I said
Thanking you!!!
thank you! :)
Such a helpful video….thanks for this
Most welcome 😊
No puedo creer lo increíble que son estos trucos, thank you so much!
omg yay thank you so much! I'm glad it helped :)
Thank you very much.
thanks for watching Landrex! :)
thank you so much love your dimples
thanks Surya!
THE CONTENT WAS GREAT ALSO YOU LOOK SO BEAUTIFUL😊
Thank you Aditya!!! 💖
Thanks for tips
no worries, thanks for watching !
hello Vivian, please teach me SQL
Hi Shang,
Sql is very simple one .If you intrested I will teach you free
Please do teach me. I am very interested and ready to start
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!
Hey can you recommend Coursera courses for statistics required for data science
deeplearning.ai has some great courses :)
Much needed video! Thanks.
Do data scientists use procedures, function all the other T- Sql, PL/SQL stuff as well?
Awaiting your response.
TIA
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
I passed an interview thanks to the with statement I learned from this video I watched 10 min before the interview lol
OMG congrats this made my day :D
Lets goooo
The CTE advice is not correct. If you reference it more than once SQL will in-line it and run it for each reference.
Just starting out...lord help me 😅
good luck Blake!
don't forget to blink girl
Hahaha omg I have noticed that - I’m still not great at talking to the camera 😅
@@candidlyvivian you did great, i saw that anxiety, but its ok, video was very great btw, thank you very much, keep up!
@@casualgamingz153 thank you! :)
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
thanks for the feedback, appreciate it!! good luck with your channel too
Less your face, more sql code
thanks for the feedback, noted for next time!