How I consistently study with a full time job (9 months in and still going strong) | Tina Huang

Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions | Tina Huang

Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions 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: llm comparison, chatbots, tech career Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

How I use Notion in 4 different ways | Tina Huang

How I use Notion in 4 different ways Sign up for Notion here: *https://ntn.so/tinahuang In this video, I show y'all 4 different ways that I use Notion in team settings and personally for trading and planning my workouts. Timestamps 00:00 intro 01:41 My team 07:18 Propel 10:56 Trading 12:08 Workout _____________________________________________________________________ Links mentioned in video Propel: https://www.notion.so/propelprojects/Propel-Projects-Season-4-Infohub-dbd4a42c517a4902b345a7fb7287cedf Trading template: https://www.notion.so/3ddfcc51c983411299cdbf3efb9c1c21?v=1836152b18274a508697d1d64c950730 (I think it was recently made private tho :c) 🔗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! :) #notion #howiusenotion #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, artificial intelligence, machine learning, chatbots, vibe coding, career development, tech tutorials, tech career Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

My career changing computer science masters degree in 15 minutes (Upenn MCIT) | Tina Huang

My career changing computer science masters degree in 15 minutes (Upenn MCIT) I did a pharmacology undergraduate and then a masters in computer science. This is my whole career changing computer science masters degree in 15 minutes. The program is called masters in computer and information technology at the University of Pennsylvania (Upenn MCIT). I hope this video is useful for those of you looking to transition into computer science, data science, software engineering etc. From a non-technical background :) computer science degree in 15 minutes - let's go! ______________________________________________________________________ Timestamps 00:00 Intro 01:00 semester 1 (core classes) 04:36 internship 06:33 semester 2 (core classes) 10:02 more internship stuff 10:45 data science electives 13:16 nlp & databases electives ______________________________________________________________________ Other videos you might be interested in Interview with director of MCIT (lots of info about the program, how to apply etc.) : https://www.youtube.com/watch?v=rd1HKwJT6GM 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 ______________________________________________________________________ Discord: https://discord.gg/uaGFKueJvf 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 :) I have accepted that I will forever be a lazy person so have since decided to embrace that. My motto is to always minimize effort and maximize outcome! ______________________________________________________________________ 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! :) about: #computersciencedegreein #upennmcit #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 tools, tech career, tech insights, programming Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

How I consistently study with a full time job (9 months in and still going strong) | Tina Huang

How I consistently study with a full time job (9 months in and still going strong) ✉️ NEWSLETTER: https://tinahuang.substack.com/ It's about learning, coding, and generally how to get your sh*t together c: I explain how I consistently studied for the past 9 months with a full time job. The first 1,000 people to use this link will get a 1 month free trial of Skillshare: https://skl.sh/tinahuang09211 In this video, I go in detail about how I developed a habit to study consistently in addition to having a full time job, trading, doing youtube, and teaching online courses. I also explain what I believe are the 5 crucial ingredients that allowed me to succeed and how you can too. Also Naruto. 🔗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 - how I do it 01:33 The formula 02:12 How Naruto does it 08:09 How you can do it 13:56 The scoreboard system 📲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! :) #howtostudy #study #studywithme #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 trends, artificial intelligence, gpt models, tech interview, ai development Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]

How I'm figuring out what to do with my life | Tina Huang

How I'm figuring out what to do with my life How I'm figuring out what to do with my life In this video I talk about the 3 quotes that helped me figure out what to do with my life, motivates me, and inspire me to keep working towards my goals, even when I don't feel like it. Enjoy: How I'm figuring out what to do with my life Timestamps 00:00 intro 00:46 the meaning of Man 05:12 the way that you spend your days 07:34 systems not goals ______________________________________________________________________ Links mentioned in video Emily Hayward's channel: https://www.youtube.com/channel/UCa6sLJCWdaRF2yS-gd_NkeQ ______________________________________________________________________ SQL for tech and data science interviews course with 10 mock interviews: https://bit.ly/2TSqGsG **365 Data Science: https://bit.ly/3d7rOPE (link for 57% discount for their complete data science training) **Check out StrataScratch for SQL interview prep: https://stratascratch.com/?via=tina Real SQL interview question walkthrough series: https://www.youtube.com/watch?v=Td-cmLfQ7uU&list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dA _____________________________________________________________________ instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw livestreaming google calendar: https://bit.ly/3wvPzHB _____________________________________________________________________ Other videos you might be interested in The habits that changed my life (and how I built them): https://www.youtube.com/watch?v=ZI1b8YHR6M4 How I take notes - Tips for efficient note taking that speeds up learning: https://www.youtube.com/watch?v=q6_9mdCkQhE&t=1s ______________________________________________________________________ Subscribe: https://www.youtube.com/channel/UC2UXDak6o7rBm23k3Vv5dww/?sub_confirmation=1 ______________________________________________________________________ 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 :) ______________________________________________________________________ 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! :) #whattodowithlife #career #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. ---- Keywords: tech tutorials, career development, tech productivity, vibe coding, tech career, gemini ai, machine learning Learn more about your ad choices. Visit megaphone.fm/adchoices [https://megaphone.fm/adchoices]