Tina Huang

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

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

Description

Data Science SQL Interview Question Walkthrough | SQL Sundays #9 Hi friends! Here's a SQL Sunday as part of the SQL Sundays series in celebration of the launch of my SQL for tech and data science interviews course! I know I know it's Tuesday :x Can we let this one slide? SQL for tech and data science interviews course with 10 mock interviews: https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=DF947818F15A561AE84E ($12.99 promotion until July 18th, 2021!) [expired] https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=A92E9C5BFB043A8FF039 ($9.99 promotion until June 6th, 2021!) discord: https://discord.gg/5mMAtprshX livestreaming google calendar: https://calendar.google.com/calendar/u/1?cid=cDBtOGgxOG1waW92bTJxYzdpZmkzNmgwODhAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ ______________________________________________________________________ Timestamps 00:00 intro 00:08 question 01:51 assumptions 02:47 answer 10:43 check answer 11:53 announcement ______________________________________________________________________ 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 ______________________________________________________________________ SQL for tech and data science interviews course with 10 mock interviews: https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=A92E9C5BFB043A8FF039 ($9.99 promotion until June 6th, 2021!) 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! :) #SQLSundays #DataScience #SQL #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. ---- Keywords: ai safety, tina huang, ai agents, programming, coding tips, ai development Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

Comments

0

Be the first to comment

Sign up now and become a member of the Tina Huang community!

Get Started

1 month for 9 kr.

Then 99 kr. / month · Cancel anytime.

  • Podcasts kun på Podimo
  • 20 lydbogstimer pr. måned
  • Gratis podcasts

All episodes

229 episodes

episode 10 Principles To Learn Anything | Tina Huang artwork

10 Principles To Learn Anything | Tina Huang

10 Principles To Learn Anything Check out the free tool that automatically turns documentation into video guides: https://www.guidde.com/?ref=tinahuang The book Ultralearning by Scott Young taught me how to learn anything. Here are the prompts: https://docs.google.com/document/d/142bZ8CXQN7Qr4QKLY2qWf4vc2_gIqmLCg2UhTSXd4oU/edit?usp=sharing ✉️ NEWSLETTER: https://tinahuang.substack.com/ It's about learning, coding, and generally how to get your sh*t together c: 🤖 AI Lunch & Learn series: https://www.lonelyoctopus.com/email-signup It's a FREE weekly 1hr livestream about AI & tech topics eg. How to build a GPT, how to build AI products, jobs in the era of AI etc. 🐙 Lonely Octopus: https://www.lonelyoctopus.com/ Check it out if you're interested in learning AI & data skill, then applying them to real freelance projects! 🤝 Business Inquiries: https://tally.so/r/mRDV99 🖱️Links mentioned in video ======================== 🔗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 🎥 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 📲Socials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX 🎥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 an ex-Meta data scientist turned internet person! 📧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! :) 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: llm comparison, programming, ai podcast, ai learning, vibe coding, open source ai Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

13. juli 202625 min
episode How to choose between software engineering and data science | 5 Key Considerations | Tina Huang artwork

How to choose between software engineering and data science | 5 Key Considerations | Tina Huang

How to choose between software engineering and data science | 5 Key Considerations Software Engineering vs Data Science? Last year, I made a choice between a software engineering and a data science position. In this video, I outline 5 key considerations that helped me choose between software engineering and data science. Hopefully it helps you make the choice as well! 🔗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 📲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! :) 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: coding tutorials, data science, ai trends, self study, llm comparison, ai agents, chatbots, machine learning Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

13. juli 202611 min
episode Ranking Vibe Coding Tools from Beginner to Advanced | Tina Huang artwork

Ranking Vibe Coding Tools from Beginner to Advanced | Tina Huang

Ranking Vibe Coding Tools from Beginner to Advanced 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: ai projects, tech career, ai safety, chatbots, tech insights, coding tutorials Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

13. juli 20262 min
episode 101 Ways To Use AI In Your Daily Life | Tina Huang artwork

101 Ways To Use AI In Your Daily Life | Tina Huang

101 Ways To Use AI In Your Daily Life 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: ai learning, ai projects, coding tutorials, ai apps, gpt models, ai agents, career development Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

13. juli 202619 min
episode how to PROPERLY make a vision board | law of attraction in 2022 | Tina Huang artwork

how to PROPERLY make a vision board | law of attraction in 2022 | Tina Huang

how to PROPERLY make a vision board | law of attraction in 2022 In this video I explain how to make a vision board (or vision book in my case) and set goals so that they actually come true. Check out Psych2go's channel - how to tell you are burn out, not lazy: bit.ly/3mySM7o Timestamps 00:00 Intro 00:52 current state of affairs 03:02 different categories 05:35 vision of idea life 07:35 create visuals 08:33 showing some example visions 09:38 psych2go 13:52 laying out next few years 14:19 SMART goals 🔗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! :) #visionboard #lawofattraction #planwithme #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: gpt models, programming, open source ai, chatbots, ai trends, tech interview, llm comparison Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

13. juli 202620 min