Tina Huang

SQL Data Science Interview Questions and Answers (interview style walk-through) | SQL Sundays #4Hi 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

Learn more about your ad choices. Visit megaphone.fm/adchoices

How To Unlock Your Hidden Potential (pareto principle 🧠)

Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop




📊 365 Data Science 100% Free: https://bit.ly/3S8IXO3
Entire platform free for 2 weeks from November 6th - 20th 7am PST!

✉️ NEWSLETTER: https://tinahuang.substack.com/
It's about learning, coding, and generally how to get your sh*t together c:

🐙 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!

🖱️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

🤯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 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: [email protected]

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

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.

Learn more about your ad choices. Visit megaphone.fm/adchoices

Which LLM Is The Best?

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.

--------------------------------

Learn more about your ad choices. Visit megaphone.fm/adchoices

How To Reach Your Full Potential (alter ego effect 👯)

Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop

❤️ Your Move: https://www.yourmove.ai/

✉️ NEWSLETTER: https://tinahuang.substack.com/

🐙 Lonely Octopus: https://www.lonelyoctopus.com/

🔗Affiliates

365 Data Science:

Check out StrataScratch for data science interview prep:

🎥 My filming setup

📲Socials

🤯Study with Tina

How to make a studying scoreboard:

🎥Other videos you might be interested in

How I would learn to code (if I could start over):

🐈‍⬛🐈‍⬛About me

📧Contact

========================

Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go.

---

Learn more about your ad choices. Visit megaphone.fm/adchoices

Watch this video before applying to Georgia Tech OMSCS

Georgia Tech OMSCS is not for everyone.

Btw sorry about audio quality, I have no idea what happened :( maybe turn on subs?
____________________________________________________________________
Timestamps

00:00 Intro
00:52 Program overview
02:14 Pros
03:15 My concerns + who should not take this program
08:32 Who this program is for
09:32 Who else this program is not for

_____________________________________________________________________
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: [email protected]

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

#Computer Science #OMSCS #TinaHuang

Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go.

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.

Learn more about your ad choices. Visit megaphone.fm/adchoices

Best ChatGPT Prompts to Learn Coding (the ULTIMATE method!)

Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop




Get the prompts! 👉 https://forms.gle/KZ1S5Qq2vWzMbsf16

✉️ NEWSLETTER: https://tinahuang.substack.com/
It's about learning, coding, and generally how to get your sh*t together c:

🐙 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!

🔗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
01:02 make into a game!
03:17 use as stack overflow
04:04 alternatives
05:07 make unique projects
06:47 comment code
08:58 code debugger
10:04 translate
11:23 explain
13:39 read documentation
15:37 the ULTIMATE method! 🤯

📲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 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: [email protected]

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

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.

Learn more about your ad choices. Visit megaphone.fm/adchoices

How to Completely Transform Your Life in 6 Months (the butterfly effect 🦋)

Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop




Visit https://365datascience.pxf.io/WD0za3 to join millions of students and start studying with 365 Data Science today. Btw there's a promotion right now to save 60% off an annual plan!

✉️ NEWSLETTER: https://tinahuang.substack.com/
It's about learning, coding, and generally how to get your sh*t together c:

🔗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

📲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: [email protected]

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

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.

Learn more about your ad choices. Visit megaphone.fm/adchoices

How I trick myself to be self-disciplined

Start building your ideal daily routine! The first 100 people who click on the link will get 25% OFF on Fabulous Premium: http://thefab.co/tinahuang2

✉️ NEWSLETTER: https://tinahuang.substack.com/
It's about learning, coding, and generally how to get your sh*t together c:

In this video, I talk about all the ways I trick myself to be self-disciplined to study and just get things done in general.

🖱️Links mentioned in video
========================
lockbox: https://amzn.to/3G4oMsz

🔗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

📲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: [email protected]

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

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.

Learn more about your ad choices. Visit megaphone.fm/adchoices

5 Unique AI Projects (beginner to intermediate) | Python, LangChain, RAG, OpenAI, ChatGPT, ChatBotCheck out this free resource to help you use AI to be more productive: https://clickhubspot.com/7knIn this video I walk through 5 unique AI projects from beginner to intermediate to advanced. We'll be using python as the coding language and use technologies such as LangChain, RAG, GPT4o, DALL-E, Whisper, Claude, and other open source models.Resources & Code: https://bit.ly/3WLXMXv✉️ NEWSLETTER: https://tinahuang.substack.com/

Learn more about your ad choices. Visit megaphone.fm/adchoices

🐙 Lunch & Learn: How to use AI to 10x Learning Things

Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop

🤝 Business Inquiries: https://tally.so/r/mRDV99

🖱️Links mentioned in video

🔗Affiliates

365 Data Science:

Check out StrataScratch for data science interview prep:

🎥 My filming setup

⏰Timestamps

📲Socials

🎥Other videos you might be interested in

How I would learn to code (if I could start over):

🐈‍⬛🐈‍⬛About me

📧Contact

========================

Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go.

------------------------------

Learn more about your ad choices. Visit megaphone.fm/adchoices