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

This is a step by step guide for how I learned SQL for my FANG data science interview. I had never touched SQL before and only had 2 weeks to prepare for my interview. So I made a scientifically-backed study plan to learn SQL most efficiently with the least amount of time and effort. By the end of the 11 days, I felt super confident and prepared. I went on to pass my FANG data science interviews and got the job!

My motto: Minimize effort and maximize outcome!!

Btw apologies about audio quality from about 2 - 3.5 min mark. Something weird happened to my mic :(
______________________________________________________________________
Timestamps:
00:00 Overview
01:01 Study Plan
06:00 SQL Interview Demo
08:47 End of Demo
09:36 Final Thoughts
______________________________________________________________________
Contact:
______________________________________________________________________
Music Credit:
Potato Deal - Craig MacArthur
Smile - Slynk
______________________________________________________________________
relevant topics: mysql, postgresql, postgresql tutorial ,postgresql tutorial for beginners

[TinaHuang]

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

[hiteshnagothu]

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

[hjkang]

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

[brendali]

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.

[kwaylot]

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

[DITLwithRA]

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

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

[awhassan]

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

[rachcastellino]

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

[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 (:

[ramamuge]

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

[redshadow_]

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

[Yinusa]

learning sql rn and this seems really helpful . thanks tina

[priyadarshangupta]

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

[StudentOfLife-xfux]

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

[DivyaanshDawar]

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

[shefaliwaikar]

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

[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

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

[KenJee_ds]

Really enjoyed this video! Great info!