How to learn SQL for data science interview (the minimize effort maximize outcome way)

[@TinaHuang1]

Hi friends! I really hope you find this video helpful :D Let me know what you think about my SQL prep strategy!

[@mbabideric4259]

Where did u learn Sql

[@-kurdush]

@@mbabideric4259 yes i too need this ans

[@gauthamambethkar4483]

Hi Tina, It will be very helpful if you could provide us the topics that you learnt in SQL for interview. By the way your videos are awesome

[@Boss-gx6rz]

Thank you for everything you gave.. I only got 2 parts of the whole thing. I'm sorry when it's unsatisfactory hahaha🙏🙏🙏🙏🙏ขอบคุณมากจากใจ

[@DynaML-basic]

Amazing! Can u say the difference between Mode and Hackerrank? Thanks for share ur experience =D

[@whyroyywhy]

You're making great content.This is really useful for aspiring data scientists like me.Thanks a lot Tina and keep up the good work.

[@TinaHuang1]

Thank you so much! That means so much to me 😊

[@veronicasmemories]

I've noticed you mention learning SQL fast in a lot of your videos so I decided to watch this and wow there's been such a huge improvement in the quality of your videos over the last 4 years. Also, it's crazy how we literally are using AI to streamline a lot of our processes now. This was still a super helpful video (:

[@kwaylot]

Youre an actual genius and I love you so much, you've given me such an organized way to learn quicker. THANK YOU!

[@hiteshnagothu887]

Its Jan 2021, and still the best video on SQL prep. Thanks for the video!!

[@TinaHuang1]

❤️❤️ I’m so glad you liked it!!

[@hjkang0424]

I was struggling so much on how to self study SQL in effective way. This is super helpful. Thanks for this awesome content!

[@brendali5803]

Hi Tina, thanks a lot for sharing your cool strategy for minimizing efforts and maximizing output! The 5 steps for solving SQL questions are great too - it helps to grasp the key information of the question, arrange our thoughts before writing queries, double-check to correct mistakes, make further improvement if necessary.

[@redshadow_7]

Have my FAANG interview in 7 days and I'm starting to learn SQL now. Thanks and wish me luck!

[@TinaHuang1]

GOOD LUCK!!!

[@stevenpeterson2587]

How did it go?

[@redshadow_7]

@@stevenpeterson2587 interview wen't well, but they ended up hiring a more experienced developer for the position.

[@awhassan3754]

I usually get discouraged when I listen to someone teach me something that I can't make sense of, but something about you makes it exciting to learn I think it's your voice. It's calming, doesn't make me feel dumb and makes me feel hopeful without being "too good to be true" too much if that makes sense. Thanks you Tina Huang

[@DivyaanshDawar]

Okay m seriously registering everything you from your every video right into my mind ! 4 hrs to non stop execution !

[@Yinusa00]

learning sql rn and this seems really helpful . thanks tina

[@StudentOfLife-xf7ux]

Hi Tina, I am currently making the switch from HR Consultant to HR-Analist. Structuring the approach of a problem by writing down the query steps before you write and validate the actual query itself, wow!This was the key take away for me. Putting yourself through those steps first, not only shows you know what your doing for the interviewer. More importantly it helps and checks your implementational knowledge. Thanks for sharing this, this video just blew my mind :-)

[@TinaHuang1]

YAY I’m so glad that resonated with you so much! That is one of the major things I tried to emphasize in the video. Took me a while to figure out tbh but once I forced myself to do it that way things started to click together. If you haven’t already I also highly recommend checking out a few videos in my sql Sundays series. I do interview questions in that style too and the questions are full real questions as opposed to this demo that was just a quick demo :)

[@StudentOfLife-xf7ux]

Thanks for pointing out the SQL Sundays videos! I’m ready to work on more complex problems, so will definately check out those full on interview questions.

[@rachcastellino]

I just rewatched this video and pumped for my study grind the next 2 weeks

[@TinaHuang1]

💪💪💪

[@ramamuge3380]

I have a Credit Analyst interview on 10th May and it relies heavily on SQL and Excel, i'm certainly using your technique.

[@shefaliwaikar8730]

I haven't started sql yet..I guess found the right content at the right time!! ^_^ thank you soo much!!

[@joyceyam9976]

Thank you for making these videos, Tina! They helped me land my dream internship and I couldn't be more grateful :)

[@TinaHuang1]

Omg congrats!! 🎊🎉

[@priyadarshangupta]

Totally agree on the Mode tutorial being the best on the internet !!

[@ashwiniaraya]

1st time viewer on your channel and It is so amazing. Best SQL training videos on youtube. Helped me alot. Thank u Thank u Thank u :)

[@TinaHuang1]

Yay you’re very welcome!!

You're amazing and this is so well explained. I'm definitely bookmarking Mode to learn SQL. I was struggling on how to approach SQL and this was really helpful so thank you! :)

[@Seftehandle]

intermediate test crushed me - i keep getting 3/5

[@upamanyumum]

Loved how you applied in selecting the specifics of the content to be mastered like the interview questions and spent most time on it then moved on to the other parts

[@TinaHuang1]

Thanks! Yup I think it gave me the best chance to pass the interview :)

[@KaushikMahadevan]

"minimize effort, maximize outcome" You're an absolute beast

[@bajanasaichaitanyavarma5658]

Honestly this is most informative than any other videos on data science so far. Keep it up

[@TinaHuang1]

I’m so glad to hear that!! :)

[@sabrinazahir01]

Wow! I am glad that I found your channel. I am an aspiring dara scientist and hope to make it till the end one day . 😁

[@KenJee_ds]

Really enjoyed this video! Great info!

[@TinaHuang1]

Thank you!! I'm so glad you enjoyed it :D

[@beyzayurt5350]

I LOVE LOVE LOVE YOUR VIDEOS!!!!!! THANK YOU SO MUCH FOR MAKING THEM!

[@AngelRodriguez-pi7gx]

Thank you so much for this videos, Tina! These are very helpful!

[@peterstary928]

Hello Tina, I found out about your channel just yesterday and I absolutely love your videos. They are very informative, motivating and filmed in a great atmosphere/attitude. Please continue in what you are doing! :)

[@TinaHuang1]

Thanks so much for your kind words!

[@manishbolbanda9872]

Pretty well explained.it will be even better if you consider making a video where you solve 10-15 sql questions in one go.

[@lady-m30]

Hi Tina! Thank you very much for this comprehensive guide to learning SQL that I am currently following. I did not know about Mode website before watching your video and I have been going through the content, it is amazing! I was wondering if you knew a similar kind of resource for Statistics and Probability content that would be useful, to learn what's expected to know for a Data Science Interview ? I really value your opinion and would love to hear your recommendations. Thank you very much! Keep up the good work! 💪💪

[@faustopf-.]

Everything beautifully explained. Amazing video, bravo!

[@MahtabAlam-uf8db]

Great video, I'm learning SQL from Mode, just wanted your quick thought on their Python tutorial as well.

[@DITLwithRA]

I have about 48 hrs to brush up on my SQL for a technical assessment with a major sporting goods company.

[@finanzalex]

Thank you so much for sharing this very valuable information Tina. This is something I can really use. I will create several simulations on the board as practice. Thanks again Tina. I really value this video. it is a nugget of gold. Cheers.

[@kudaykumar1261]

Thank you so much Tina , I am a begineer to this world programming, your videos really help ful to start my programming carrer.

[@mehdinaghditam]

what if the 'event_time_stamp' is actually the time_stamp of when the flag is turned on or off? I think we need to get the max(event_time_stamp) and group by page_id, then use the where clause for flag = 'on'

[@brothermalcolm]

That's my interpretation of the question as well

[@KasamSe-e7r]

Yes that's the correct way to solve this and in reality probably the only way. Unless the database contains one record for every second since the beginning of the page.

[@MashiroRedo]

I am unsure why NOW() is being used. It's a database so the assumption is the data is in real time. Like by the second.

[@femitex4459]

If you max event_time_stamp and group by page_id, wouldn’t that that result in page counts for each of the current time stamp? We need the overall page counts if I am interpreting it correctly so maybe what you suggested should be the sub query then we count (*) from the sub query to get total pages on

[@Do2494]

You make data science so approacheable, without oversimplifying it to make it sound too easy (as in you need to do almost nothing)

[@hugodasilvadasilva]

I have long carrer as software developer, but on my first sql code test, I did not pass, cause it's for data analyst. At the end of the day, it has some specific questions that is not usual for developers. I think your tips about searching for commom question for data analyst interview will the key to my sucess. Thanks a lot.

[@siranxie844]

Great Tips in 2021! Smart and efficient! Learnt a lot from this video and from your channel!

[@TinaHuang1]

Thank you! I'm so glad to hear that :)

[@karinakarakulova9809]

Omg, bless you. This is sooooo great that I found you🥺♥️

[@YazminAbat]

Glad found your channel. So much rich content. Finally a female DS rolemodel !!

[@TinaHuang1]

I'm so glad!! Thank you ❤

[@kintarooe575]

Super helpful! I have Data & Product Analyst interviews soon so I will use your strategy effectively and efficiently as possible to prepare. Thanks so much!

[@TinaHuang1]

GOOD LUCK!! ❤️ and I would love to know how you feel about my strategy + any feedback 😊

[@john94139]

I will put in practice your suggestions. Ty :)

[@AhlamLamo]

Girl I subbed and liked your channel !! Amazing content.

[@brothermalcolm]

@3:37 you earned my like with mode - I recommended this to my newbie friend last week over any other paid course

[@tainahcostaungierowicz6084]

Absolutely amazing and super helpful!

[@hello-pd7tc]

Tina, your videos are so helpful! Thank you :)

[@TinaHuang1]

Yay I’m so glad! ❤️

[@nan4061]

Hi Tina, this is super helpful! Keep up the great work!

[@TinaHuang1]

So glad you found it helpful ❤️ Will do - more SQL videos coming!

[@boopmcbloop8648]

You are a queen! Thank you for sharing your learning methods, I have been watching your channel ever since I had the idea to give data science a try, and your advice has been so motivating.

[@aidanberry6311]

This is a very informative video. Just found you today from Ken’s channel. If you could do some practice white boarding questions in the future that would be awesome

[@TinaHuang1]

So glad you found it helpful! 😊 I just filmed a video of me going through a SQL interview question! Coming soon ❤️

[@shawnxu2739]

Thanks a lot, it is helpful for me, a noob, just start to learn SQL.

[@TheChiefPettyOfficer]

You went to a much better worst case scenario for what can happen with Linkedin than I did. My mind went to tell the company about what I'm doing and completely sabotage me

[@tagifts]

I know it is an old video but I will give it a shot. I have to learn it and learn it quick. It will be interesting.

[@Utube87madg]

OMG !!! .. just do more videos on whiteboard SQL, like one video with the most common whiteboard SQL questions .. we like to learn how you think

[@swarnabhkashyap5764]

Thank you for the video Tina! Can you please share some websites where I can practice SQL questions for Data Analyst interviews?

[@wendeloliveira4699]

Thank you, Tina. This video piqued my interest!

[@TinaHuang1]

So glad to hear that ❤️

[@franciscoflamenco]

I don't know if it's that I just don't understand the problem given, but I fail to see why you have to filter by timestamp. If a page is timestamped to some time in the past, but it's on, it's still on and should still be counted. Have I misunderstood the problem?

[@melat4400]

This is amazing! Thanks, Tina!

[@zyu1113]

Great contents!! Thanks for your suggestions Tina :)

[@rizdiramadhan1641]

Found another awesome vids this year!

[@TinaHuang1]

Aww I’m so happy to hear that 😊

[@cjporteo]

You're amazing, thanks for the content!

[@TinaHuang1]

Aww thank you for you kind words ❤️

[@ferdousadnan5814]

Liked and Subscribed. Your advises are solid.

[@thennarasuthen9179]

Very practical strategy....it really motivates me.. thanks tina

[@TinaHuang1]

I’m so happy to hear that! 😊

[@DMccloudy]

Liked and subscribed :) Thanks for these great videos!

[@palvipwar101]

i love you.... you motivate me to do work + study .. thank u

[@MabelCoelho]

Amazing! This video is a gem

[@TinaHuang1]

I’m so glad you enjoyed it ❤️

[@mosesojonuba416]

I Love your content Tina

[@anitachen8887]

Hi, great video! Already subscribed! Could you give me some advice on alternative resources to practice SQL or Python skills?

[@joey5069]

Great content, this helps a lot! Thank you~

[@deepfakevasmoy3477]

So, they ask this simple SQL questions on DS interview? I mean, I find it relatively easier. Maybe data scientist doesnt need that much skills on SQL... whats your thought on this?

[@TinaHuang1]

Thanks for asking! I chose to demo this simple question because I was more focused on demonstrating how to structure the solution. Also, I assumed that most people who watch this video are probably not yet proficient in SQL! This question was probably followed by a series of harder questions in the actual interview as some interviewers prefer to start with an easy question to kick things off.

[@johnwig285]

You are right in some sense, while SQL is still kinda necessary, alot of SQL related stuff are handled by Data Engineers. Thats the case for big companies like FANG. The focus will be more on machine learning models or forecasting etc. For startups, a Data Scientist usually covers the whole spectrum ie doing the job of a data engineer and data analyst too coz well it saves the company money.

[@ResilientFighter]

THIS IS GOLD!!!

[@TinaHuang1]

YAY! :D

[@helovesdata8483]

I use the white board method. It works for me.

[@SergioBriMa]

You’re awesome! Thank u

[@wagnermoreira786]

that's pretty cool! solid content great job! W hy don't you have your position at faang added to your linkedin?

[@TinaHuang1]

Good question haha. By not revealing where I work I have more freedom to talk about things :)

[@wagnermoreira786]

@@TinaHuang1 haha I see, smart move good idea!!

[@femi2873]

This was very useful. Thank you so much. May God bless you abundantly. I recently failed a Facebook interview because my interview strategy preparation was very poor, how I wish I had followed all the steps you highlighted in your video. Please how can I reach out to you?

[@mocool13]

TY very much fo this video. Really helpful!

[@veenavipeesh143]

I love all your videos

[@neelpatel3844]

Great video, thank you!

[@ans9611]

Thank you for sharing the awesome video! :)

[@TinaHuang1]

You’re welcome!! So glad you enjoyed it! :D

[@Adi-vh7xf]

Really helpful!!🔥 Please make a video on python.

[@TinaHuang1]

I'm so glad you found it helpful! 😊 What kind of python video would you be interested in?

[@Adi-vh7xf]

@@TinaHuang1 like what topics of python are the most important for data science, and questions asked in your interview, related to python. It would be really helpful. Thank you!!

[@darshilshah560]

Love your content. BTW, My mom's name is Tina too!

[@anktrj]

really great insight!

[@debdattachatterjee1395]

Love your videos. 💯

[@linna2006love]

Hi Tina, your video is helpful to me. Thanks. I would like to get your some advice how to become a data scientist with a bio-statistician background using SAS/SQL and R language on daily job. I had a master of statistics and work as bio-statistician now. I would like to see whether I could get close to a DS role in future.

[@froopi2]

Thanks for this!

[@Ledesma184th]

Thank you for this!

[@TinaHuang1]

Thanks so much for watching ❤️ hope it was helpful!

[@abduvosidmalikov]

Hi, thanks for the video! You mentioned to have more than 20 rehearsals. I want to know how many questions to practice in each rehearsal by difficulty. I mean, to have 3 questions in each rehearsal: 1 from basics, 1 intermediate and 1 from advanced?

[@TinaHuang1]

Do a couple basic and a couple mid but try to do as many advanced as possible because that would be closer to your interview :)

[@abduvosidmalikov]

@@TinaHuang1 got it. Thank you

[@vidyasurbhi3084]

do you know, you are the best.

[@huiyeelau8714]

Thank you Tina :) It's really helpful for a beginner to start learning SQL in a minimized effort way

[@keifer7813]

Damn, how'd you get a data scientist interview especially at a FAANG if you had no SQL listed on your resume?

[@utkarshchoudhary724]

Awesome stuff!

[@Eastmaniac]

One of the questions I was asked, was to find the winning % for a given baseball team throughout its existence (18 years of data). Case statements can be amazing for anytime you need to do an if-else-if etc type sql question.

[@kachiakwara]

I found this video really helpful and went on to try using mode.com but some how I can’t figure it out. When I click on the sql and python tutorials it takes me to a hole different page. Can you help me out here?

[@TinaHuang1]

Hi! Hmm I'm not sure what you mean? It's this link that has all the lessons: mode.com/sql-tutorial/sql-in-mode/

[@kachiakwara]

@@TinaHuang1 Thank you. For some reason i could not navigate the site. thank you.

[@kachiakwara]

Hi, what would you do if you are asked to analyze a data set that has a lot of null values?

[@kalmkrew]

Don't understand how mode works at all. Seeing request demo and try for free and it's asking me go set dates?

[@Seftehandle]

Tina hi, I woul ask you for help in sql mode intermediate, i do not know how to separate name to first name in mode as left(charindex) is not accepted any help, please?

[@sanyogsharma2195]

Nice video.... expecting hard questions in upcoming videos

[@TinaHuang1]

Definitely future video idea! What do you think about pulling some harder questions on glassdoors and white-boarding them from beginning to end?

[@sanyogsharma2195]

@@TinaHuang1 seems like a great idea. I have a compilation of interview questions that I generally ask candidates for business analyst/ data science interviews. Happy to share those questions with you...👍

[@TinaHuang1]

Oh sure! Thanks! Feel free to email me at [e-mail] 😊

[@nadiaz4769]

Do you think achieving your PCPP certification is an efficient idea in getting a job or what do you think are the best certifications for becoming a data scientist?

[@rodfloripa10]

You didn't study sql during your masters? Nice vídeo, very helpful!!

[@TinaHuang1]

Haha here's the funny thing. I learned SQL for my databases class the semester after. A little too late :(

[@rodfloripa10]

@@TinaHuang1 So you did this Interview for an internship?

[@TinaHuang1]

@@rodfloripa10 nope full time!

[@raichu315]

Tina ur so funny & smart & informative & sagacious

[@TinaHuang1]

Awww thank you ❤️❤️

[@trivagravia4837]

sTarted learning python in January...got burnt out arnd March and had covered some abt 50% of beginner topics....thinking of resuming ..tell me do l have to master everything and go through all those topics like classes and dictionaries before l can begin a project,...yooh its an uphill journey l tell you...

[@rachcastellino]

Nice background change :)))

[@TinaHuang1]

hahahah are you proud of me?? I bought a plant and strategically placed a brightly coloured cup to show that I do not literally live among the amazon boxes.

[@rachcastellino]

@@TinaHuang1 very proud!!