Tina Huang

SQL Data Science Interview Question Walkthrough | SQL Sundays #6 | Tina Huang

9 min · I gÄr
episode SQL Data Science Interview Question Walkthrough | SQL Sundays #6 | Tina Huang cover

Beskrivelse

SQL Data Science Interview Question Walkthrough | SQL Sundays #6 Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough. This is another data science SQL interview question and answer done from beginning to end in a real interview style. 🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training) Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina đŸ“ČSocials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX đŸ€ŻStudy with Tina ======================== Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw How to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrI Scoreboard website: scoreboardswithtina.com livestreaming google calendar: https://bit.ly/3wvPzHB đŸŽ„Other videos you might be interested in ======================== SQL Sundays Playlist: https://www.youtube.com/playlist?list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dA How I learned SQL from Scratch in 11 Days to Pass my FANNG SQL Interview: https://www.youtube.com/watch?v=vaD3ZFFNwhM How I consistently study with a full-time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈‍⬛🐈‍⬛About me ======================== Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) 📧Contact ======================== youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: hellotinah@gmail.com ======================== Some links are affiliate links and I may receive a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :) Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. ------------ Keywords: ai learning, programming, artificial intelligence, llm comparison, ai podcast, tech insights, ai development Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

Kommentarer

0

VĂŠr den fĂžrste til Ă„ kommentere

Registrer deg nÄ og bli medlem av Tina Huang sitt community!

PrĂžv gratis

PrĂžv gratis i 14 dager

99 kr / MÄned etter prÞveperioden. · Avslutt nÄr som helst.

  • Eksklusive podkaster
  • 20 timer lydbĂžker i mĂ„neden
  • Gratis podkaster

Alle episoder

232 Episoder

episode Why you can’t find your passion | Tina Huang cover

Why you can’t find your passion | Tina Huang

Why you can’t find your passion In this video, I basically break your heart and tell you there's no dream job but heal it again (hopefully) by telling you that you can design your own dream career! And it'll actually be your dream career because you designed it yourself c: Timestamps 00:00 intro 01:27 there's no dream job 03:31 but you CAN design your dream career! 03:50 job vs. Career 04:32 most people's misconception 05:34 employee AND entrepreneur 09:48 ideas to start 11:10 practical guide (my approach) 🔗Affiliates **365 Data Science: https://bit.ly/3tIUBCY (link for 57% discount for their complete data science training) **Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina đŸ“ČSocials instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX đŸ€ŻStudy with Tina Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw How to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrI Scoreboard website: scoreboardswithtina.com livestreaming google calendar: https://bit.ly/3wvPzHB đŸŽ„Other videos you might be interested in How I consistently study with a full time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈‍⬛🐈‍⬛About me Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) 📧Contact youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: hellotinah@gmail.com ______________________________________________________________________ Links marked with ** are affiliate links and I may receive a small portion of sales price at no cost to you. I really appreciate your support in helping improve this channel! :) #dreamjob #idontdreamoflabour #idontdreamoflabor #tinahuang Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. ------------- Keywords: artificial intelligence, ai fundamentals, ai projects Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

2. juli 202618 min
episode Internship that made me rethink my career...(technology summer analyst at Goldman Sachs) | Tina Huang cover

Internship that made me rethink my career...(technology summer analyst at Goldman Sachs) | Tina Huang

Internship that made me rethink my career...(technology summer analyst at Goldman Sachs) I worked on data science although I interviewed as a software engineer. This is my experience as a technology summer analyst at Goldman Sachs. Spoiler: I did not really like it tbh 🔗Affiliates ======================== 365 Data Science: https://bit.ly/3tIUBCY (link for 57% discount for their complete data science training) Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina Google Data Analytics Certificate on Coursera: https://bit.ly/33tYQYA đŸŽ„ My Filming Setup ======================== đŸ“· camera: https://amzn.to/3LHbi7N đŸŽ€ mic: https://amzn.to/3LqoFJb 🔭 tripod: https://amzn.to/3DkjGHe 💡 lights: https://amzn.to/3LmOhqk ⏰Timestamps ======================== 00:00 Intro 00:17 How I asked to work in data science 01:20 Orientation 01:52 Real orientation schedule 02:25 Start of uh oh 04:32 Start of work 05:08 My project (data retrieval + ML) 07:20 More uh oh 08:32 ML details 10:00 Presentations 10:15 Why did I not come back 12:10 Reflections đŸ“ČSocials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX đŸ€ŻStudy with Tina ======================== Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw How to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrI Scoreboard website: scoreboardswithtina.com livestreaming google calendar: https://bit.ly/3wvPzHB đŸŽ„Other videos you might be interested in ======================== How I consistently study with a full time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈‍⬛🐈‍⬛About me ======================== Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) 📧Contact ======================== youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: hellotinah@gmail.com ======================== Some links are affiliate links and I may receive a small portion of sales price at no cost to you. I really appreciate your support in helping improve this channel! :) #GoldmanSachs #TechnologySummerAnalyst #DataScience #TinaHuang Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. -------------- Keywords: ai apps, ai projects, tech insights, data science Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

2. juli 202616 min
episode the 5 books that changed my life | Tina Huang cover

the 5 books that changed my life | Tina Huang

the 5 books that changed my life The first 1000 visitors to https://www.shortform.com/tinahuang will receive a 5 days of unlimited access and a 20% discounted annual subscription. In this video, I talk through the 5 books that changed my life the most, falling into the general categories of worldview, productivity & learning, and personal finance. Timestamps 00:00 intro 00:26 category - worldview 00:41 a million miles in a thousand years 03:07 man's search for meaning 06:48 category - productivity and learning 07:00 ultralearning 07:44 the four disciplines of execution 08:58 category - personal finance 09:14 the richest man in babylon 🔗Affiliates **365 Data Science: https://bit.ly/3tIUBCY (link for 57% discount for their complete data science training) **Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina đŸ“ČSocials instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX đŸ€ŻStudy with Tina Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw How to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrI Scoreboard website: scoreboardswithtina.com livestreaming google calendar: https://bit.ly/3wvPzHB đŸŽ„Other videos you might be interested in How I consistently study with a full time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈‍⬛🐈‍⬛About me Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) 📧Contact youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: hellotinah@gmail.com ______________________________________________________________________ Links marked with ** are affiliate links and I may receive a small portion of sales price at no cost to you. I really appreciate your support in helping improve this channel! :) Links marked with * are tracking links that track traffic that comes from my channel. Links marked with ** are affiliate links where I receive a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :) #books #nonfiction #tinahuang Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. ---------- Keywords: self study, ai agents, data science, tina huang, chatbots Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

2. juli 202616 min
episode 60k cooking and Q&A (ft. Uncle Roger fried rice) | Tina Huang cover

60k cooking and Q&A (ft. Uncle Roger fried rice) | Tina Huang

60k cooking and Q&A (ft. Uncle Roger fried rice) Hi friends, here's to 60k!! ❀ As a token of my love and appreciation, I will be cooking the original Uncle Roger's fried rice as dictated by the almighty poll. I will specially buy a colander just to use it to drain the ruined rice. 😱 Let's also make it a Q&A so pls submit your questions here: https://www.youtube.com/post/Ugx-c6yftNrrCW-xeE94AaABCQ (or comment below on this video) Thanks again for being a part of this community! I'm so incredibly happy and grateful than you're here! Talk to you soon (with beepbeep and boop 🐈🐈) discord: https://discord.gg/5mMAtprshX livestreaming google calendar: https://calendar.google.com/calendar/u/1?cid=cDBtOGgxOG1waW92bTJxYzdpZmkzNmgwODhAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ ______________________________________________________________________ Other videos you might be interested in How to learn data science in 2021: https://www.youtube.com/watch?v=Axu4tJl8gbM The resume that got me into FAANG as a data scientist: https://www.youtube.com/watch?v=vx-x-yXXE9I ______________________________________________________________________ Subscribe: https://www.youtube.com/channel/UC2UXDak6o7rBm23k3Vv5dww/?sub_confirmation=1 ______________________________________________________________________ Real SQL interview question walkthrough series: https://www.youtube.com/watch?v=Td-cmLfQ7uU&list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dA Check out StrataScratch for SQL interview prep: https://stratascratch.com/?via=tina ______________________________________________________________________ About me Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) ______________________________________________________________________ Contact youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: hellotinah@gmail.com *If you're reaching out through linkedin, please leave a youtube comment just letting me know that you reached out :) ______________________________________________________________________ *The StrataScratch affiliate program give me a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :) #TinaHuang #uncleroger #friedrice Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. ----------- Keywords: ai safety, programming, tech tutorials, open source ai, ai agents, artificial intelligence, gemini ai Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

2. juli 20262 h 53 min
episode After testing hundreds of AI tools, here’s what I wish more people knew | Tina Huang cover

After testing hundreds of AI tools, here’s what I wish more people knew | Tina Huang

After testing hundreds of AI tools, here’s what I wish more people knew Tina is a former data scientist at Meta. Her channel focuses on AI, coding, tech, career development, and self-study. Always striving to minimize effort while maximizing outcomes. In fact, she firmly avoids doing extra work to reach her goals - one of the many reasons she loves AI. Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. If you represent Tina and would like to discuss this project, please don’t hesitate to get in touch. ---- -------- Keywords: tech interview, gemini ai, vibe coding, ai fundamentals, coding tutorials, llm comparison Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

2. juli 20262 min