Hi friends! I really hope you find this video helpful :D Let me know what you think about my SQL prep strategy!
@mbabideric42593 жыл бұрын
Where did u learn Sql
@-kurdush3 жыл бұрын
@@mbabideric4259 yes i too need this ans
@gauthamambethkar44833 жыл бұрын
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-gx6rz3 жыл бұрын
Thank you for everything you gave.. I only got 2 parts of the whole thing. I'm sorry when it's unsatisfactory hahaha🙏🙏🙏🙏🙏ขอบคุณมากจากใจ
@DynaML-basic2 жыл бұрын
Amazing! Can u say the difference between Mode and Hackerrank? Thanks for share ur experience =D
@whyroyywhy4 жыл бұрын
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.
@TinaHuang14 жыл бұрын
Thank you so much! That means so much to me 😊
@veronicasmemories20 күн бұрын
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 (:
@kwaylot2 жыл бұрын
Youre an actual genius and I love you so much, you've given me such an organized way to learn quicker. THANK YOU!
@hiteshnagothu8873 жыл бұрын
Its Jan 2021, and still the best video on SQL prep. Thanks for the video!!
@TinaHuang13 жыл бұрын
❤️❤️ I’m so glad you liked it!!
@hjkang04243 жыл бұрын
I was struggling so much on how to self study SQL in effective way. This is super helpful. Thanks for this awesome content!
@brendali58033 жыл бұрын
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_73 жыл бұрын
Have my FAANG interview in 7 days and I'm starting to learn SQL now. Thanks and wish me luck!
@TinaHuang13 жыл бұрын
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.
@awhassan37543 жыл бұрын
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
@DivyaanshDawar2 жыл бұрын
Okay m seriously registering everything you from your every video right into my mind ! 4 hrs to non stop execution !
@Yinusa002 жыл бұрын
learning sql rn and this seems really helpful . thanks tina
@StudentOfLife-xf7ux4 жыл бұрын
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 :-)
@TinaHuang14 жыл бұрын
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-xf7ux4 жыл бұрын
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.
@rachcastellino4 жыл бұрын
I just rewatched this video and pumped for my study grind the next 2 weeks
@TinaHuang14 жыл бұрын
💪💪💪
@ramamuge33803 жыл бұрын
I have a Credit Analyst interview on 10th May and it relies heavily on SQL and Excel, i'm certainly using your technique.
@shefaliwaikar87303 жыл бұрын
I haven't started sql yet..I guess found the right content at the right time!! ^_^ thank you soo much!!
@joyceyam99763 жыл бұрын
Thank you for making these videos, Tina! They helped me land my dream internship and I couldn't be more grateful :)
@TinaHuang13 жыл бұрын
Omg congrats!! 🎊🎉
@priyadarshangupta3 жыл бұрын
Totally agree on the Mode tutorial being the best on the internet !!
@ashwiniaraya3 жыл бұрын
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 :)
@TinaHuang13 жыл бұрын
Yay you’re very welcome!!
3 жыл бұрын
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
@upamanyumum3 жыл бұрын
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
@TinaHuang13 жыл бұрын
Thanks! Yup I think it gave me the best chance to pass the interview :)
@KaushikMahadevan2 жыл бұрын
"minimize effort, maximize outcome" You're an absolute beast
@bajanasaichaitanyavarma56583 жыл бұрын
Honestly this is most informative than any other videos on data science so far. Keep it up
@TinaHuang13 жыл бұрын
I’m so glad to hear that!! :)
@sabrinazahir013 жыл бұрын
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_ds4 жыл бұрын
Really enjoyed this video! Great info!
@TinaHuang14 жыл бұрын
Thank you!! I'm so glad you enjoyed it :D
@beyzayurt53503 жыл бұрын
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!
@peterstary9283 жыл бұрын
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! :)
@TinaHuang13 жыл бұрын
Thanks so much for your kind words!
@manishbolbanda98723 жыл бұрын
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-m303 жыл бұрын
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! 💪💪
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.
@finanzalex2 жыл бұрын
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.
@kudaykumar12613 жыл бұрын
Thank you so much Tina , I am a begineer to this world programming, your videos really help ful to start my programming carrer.
@mehdinaghditam3 жыл бұрын
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'
@brothermalcolm3 жыл бұрын
That's my interpretation of the question as well
@KasamSe-e7r3 жыл бұрын
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.
@MashiroRedo3 жыл бұрын
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.
@femitex44593 жыл бұрын
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
@Do24943 жыл бұрын
You make data science so approacheable, without oversimplifying it to make it sound too easy (as in you need to do almost nothing)
@hugodasilvadasilva2 жыл бұрын
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.
@siranxie8443 жыл бұрын
Great Tips in 2021! Smart and efficient! Learnt a lot from this video and from your channel!
@TinaHuang13 жыл бұрын
Thank you! I'm so glad to hear that :)
@karinakarakulova98093 жыл бұрын
Omg, bless you. This is sooooo great that I found you🥺♥️
@YazminAbat3 жыл бұрын
Glad found your channel. So much rich content. Finally a female DS rolemodel !!
@TinaHuang13 жыл бұрын
I'm so glad!! Thank you ❤
@kintarooe5754 жыл бұрын
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!
@TinaHuang14 жыл бұрын
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 :)
@AhlamLamo3 жыл бұрын
Girl I subbed and liked your channel !! Amazing content.
@brothermalcolm3 жыл бұрын
@3:37 you earned my like with mode - I recommended this to my newbie friend last week over any other paid course
@tainahcostaungierowicz60842 жыл бұрын
Absolutely amazing and super helpful!
@hello-pd7tc4 жыл бұрын
Tina, your videos are so helpful! Thank you :)
@TinaHuang14 жыл бұрын
Yay I’m so glad! ❤️
@nan40614 жыл бұрын
Hi Tina, this is super helpful! Keep up the great work!
@TinaHuang14 жыл бұрын
So glad you found it helpful ❤️ Will do - more SQL videos coming!
@boopmcbloop86482 жыл бұрын
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.
@aidanberry63114 жыл бұрын
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
@TinaHuang14 жыл бұрын
So glad you found it helpful! 😊 I just filmed a video of me going through a SQL interview question! Coming soon ❤️
@shawnxu27393 жыл бұрын
Thanks a lot, it is helpful for me, a noob, just start to learn SQL.
@TheChiefPettyOfficer2 жыл бұрын
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
@tagifts3 жыл бұрын
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.
@Utube87madg3 жыл бұрын
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
@swarnabhkashyap57642 жыл бұрын
Thank you for the video Tina! Can you please share some websites where I can practice SQL questions for Data Analyst interviews?
@wendeloliveira46993 жыл бұрын
Thank you, Tina. This video piqued my interest!
@TinaHuang13 жыл бұрын
So glad to hear that ❤️
@franciscoflamenco2 жыл бұрын
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?
@melat44003 жыл бұрын
This is amazing! Thanks, Tina!
@zyu11133 жыл бұрын
Great contents!! Thanks for your suggestions Tina :)
@rizdiramadhan16413 жыл бұрын
Found another awesome vids this year!
@TinaHuang13 жыл бұрын
Aww I’m so happy to hear that 😊
@cjporteo3 жыл бұрын
You're amazing, thanks for the content!
@TinaHuang13 жыл бұрын
Aww thank you for you kind words ❤️
@ferdousadnan58143 жыл бұрын
Liked and Subscribed. Your advises are solid.
@thennarasuthen91794 жыл бұрын
Very practical strategy....it really motivates me.. thanks tina
@TinaHuang14 жыл бұрын
I’m so happy to hear that! 😊
@DMccloudy3 жыл бұрын
Liked and subscribed :) Thanks for these great videos!
@palvipwar1013 жыл бұрын
i love you.... you motivate me to do work + study .. thank u
@MabelCoelho3 жыл бұрын
Amazing! This video is a gem
@TinaHuang13 жыл бұрын
I’m so glad you enjoyed it ❤️
@mosesojonuba4162 жыл бұрын
I Love your content Tina
@anitachen88873 жыл бұрын
Hi, great video! Already subscribed! Could you give me some advice on alternative resources to practice SQL or Python skills?
@joey50693 жыл бұрын
Great content, this helps a lot! Thank you~
@deepfakevasmoy34774 жыл бұрын
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?
@TinaHuang14 жыл бұрын
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.
@johnwig2854 жыл бұрын
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.
@ResilientFighter4 жыл бұрын
THIS IS GOLD!!!
@TinaHuang14 жыл бұрын
YAY! :D
@helovesdata84833 жыл бұрын
I use the white board method. It works for me.
@SergioBriMa3 жыл бұрын
You’re awesome! Thank u
@wagnermoreira7863 жыл бұрын
that's pretty cool! solid content great job! W hy don't you have your position at faang added to your linkedin?
@TinaHuang13 жыл бұрын
Good question haha. By not revealing where I work I have more freedom to talk about things :)
@wagnermoreira7863 жыл бұрын
@@TinaHuang1 haha I see, smart move good idea!!
@femi28732 жыл бұрын
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?
@mocool133 жыл бұрын
TY very much fo this video. Really helpful!
@veenavipeesh1432 жыл бұрын
I love all your videos
@neelpatel38443 жыл бұрын
Great video, thank you!
@ans96113 жыл бұрын
Thank you for sharing the awesome video! :)
@TinaHuang13 жыл бұрын
You’re welcome!! So glad you enjoyed it! :D
@Adi-vh7xf4 жыл бұрын
Really helpful!!🔥 Please make a video on python.
@TinaHuang14 жыл бұрын
I'm so glad you found it helpful! 😊 What kind of python video would you be interested in?
@Adi-vh7xf4 жыл бұрын
@@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!!
@darshilshah5603 жыл бұрын
Love your content. BTW, My mom's name is Tina too!
@anktrj3 жыл бұрын
really great insight!
@debdattachatterjee13953 жыл бұрын
Love your videos. 💯
@linna2006love3 жыл бұрын
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.
@froopi23 жыл бұрын
Thanks for this!
@Ledesma184th4 жыл бұрын
Thank you for this!
@TinaHuang14 жыл бұрын
Thanks so much for watching ❤️ hope it was helpful!
@abduvosidmalikov3 жыл бұрын
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?
@TinaHuang13 жыл бұрын
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 :)
@abduvosidmalikov3 жыл бұрын
@@TinaHuang1 got it. Thank you
@vidyasurbhi3084 Жыл бұрын
do you know, you are the best.
@huiyeelau87143 жыл бұрын
Thank you Tina :) It's really helpful for a beginner to start learning SQL in a minimized effort way
@keifer78132 жыл бұрын
Damn, how'd you get a data scientist interview especially at a FAANG if you had no SQL listed on your resume?
@utkarshchoudhary7243 жыл бұрын
Awesome stuff!
@Eastmaniac2 жыл бұрын
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.
@kachiakwara3 жыл бұрын
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?
@TinaHuang13 жыл бұрын
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/
@kachiakwara3 жыл бұрын
@@TinaHuang1 Thank you. For some reason i could not navigate the site. thank you.
@kachiakwara3 жыл бұрын
Hi, what would you do if you are asked to analyze a data set that has a lot of null values?
@kalmkrew3 жыл бұрын
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?
@sanyogsharma21954 жыл бұрын
Nice video.... expecting hard questions in upcoming videos
@TinaHuang14 жыл бұрын
Definitely future video idea! What do you think about pulling some harder questions on glassdoors and white-boarding them from beginning to end?
@sanyogsharma21954 жыл бұрын
@@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...👍
@TinaHuang14 жыл бұрын
Oh sure! Thanks! Feel free to email me at hellotinah@gmail.com 😊
@nadiaz47693 жыл бұрын
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?
@rodfloripa104 жыл бұрын
You didn't study sql during your masters? Nice vídeo, very helpful!!
@TinaHuang14 жыл бұрын
Haha here's the funny thing. I learned SQL for my databases class the semester after. A little too late :(
@rodfloripa104 жыл бұрын
@@TinaHuang1 So you did this Interview for an internship?
@TinaHuang14 жыл бұрын
@@rodfloripa10 nope full time!
@raichu3153 жыл бұрын
Tina ur so funny & smart & informative & sagacious
@TinaHuang13 жыл бұрын
Awww thank you ❤️❤️
@trivagravia48373 жыл бұрын
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...
@rachcastellino4 жыл бұрын
Nice background change :)))
@TinaHuang14 жыл бұрын
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.