Learn How to Solve SQL Interview Problem for Data Science
In today's video, we are going to be solving SQL problems with medium difficulty. And you are going to watch me make some silly mistake 😬 If you are planning to follow along, I would suggest to pause at each problem and try solving it yourself before seeing my approach and solution in this video. This would be the most optimal way to learn from this video. All the best! Let me know in comments if I should do more of these.
StrataScratch: https://www.stratascratch.com/?via=su...
Questions (Medium difficulty):
1. Top 10 Ranked Songs (Spotify)
2: Top Cool Votes (Yelp)
This video is not sponsored but the link is affiliate, which means I earn a small commission at no cost to you. I would appreciate if you would sign up using this link.
Watch rest of Learn SQL Playlist to keep learning: • Learn SQL
My Self-Taught Data Science Journey: • My Data Science Journey with Non-Tech...
How I Would Learn Data Science in 2022: • How I Would Learn Data Science in 202...
Why is Data Science Job Search Hard? • Why is it Hard to Find a Job as a Dat...
~~~ CERTIFICATES & COURSES ~~~
DATA SCIENTIST
📊 Data Science Certificate 👉🏼 https://imp.i384100.net/DataScienceCert
🏅 Data Science Bootcamp 👉🏼 https://bit.ly/data-scientist-bootcamp
DATA ANALYTICS
🏅 Google Data Analytics Certificate 👉🏼 https://imp.i384100.net/GoogleDataCert
PYTHON
🐍 Python for Everybody 👉🏼 https://imp.i384100.net/PythonSpec
⚡ Python for Data Science 👉🏼 https://bit.ly/python-data-science-ml
📑 Python for Data Visualization 👉🏼 https://bit.ly/python-data-viz
🏅 Python Pandas 👉🏼 https://bit.ly/python-pandas-data-ana...
SQL
⚡ SQL Basics for Data Science 👉🏼 https://imp.i384100.net/SQLforDS
🏅 SQL Bootcamp 👉🏼 https://bit.ly/sql-bootcamps
MACHINE LEARNING
🏅 Machine Learning Bootcamp 👉🏼 https://bit.ly/machine-learning-atoz
⚙️ Machine Learning Specialization 👉🏼 https://imp.i384100.net/ML
STATISTICS
⚙️ Statistics for Data Analysis 👉🏼 https://bit.ly/statistics-data-science
📑 Intro to Statistics 👉🏼 https://imp.i384100.net/Stats
Excel
🎨 Excel for Data Analysis 👉🏼https://imp.i384100.net/Excel
🎨 Excel Advanced 👉🏼 https://bit.ly/data-scientist-bootcamp
Interviews
🏅 Practice Coding Interviews 👉🏼 https://stratascratch.com/?via=sundas
🌍 ALL COURSES 👉🏼 https://kit.co/SundasKhalid
~~~~~~~~~~~~~~~~~~~~~~~~~~~
MY FAVORITE GEAR
🎥 My YouTube Camera Gear - https://kit.co/SundasKhalid
⌨️ My Desk Setup - https://kit.co/SundasKhalid
MY FAVORITE SOFTWARE
📚 The best summaries of books (Shortform) - https://www.shortform.com/sundas
✍️ Where I take tech courses (Coursera Plus free trial) - https://imp.i384100.net/CourseraPlus
LET'S BE FRIENDS
🌍 My website - https://sundaskhalid.com
📸 Instagram - / sundaskhalidd
🐦 Twitter - / sundaskhalid6
SUBSCRIBE FOR MORE VIDEOS
https://www.youtube.com/sundaskhalid?...
0:00 Intro
1:11 Question 1
5:10 Question 2
15:46 Outro
BINGE THESE PLAYLISTS NEXT
Starting in Data Science: • Starting in Data Science
Learn SQL: • Learn SQL
The Tech Lounge: • The Tech Lounge
ABOUT ME
I'm Sundas. I'm a self-taught data scientist from a non-tech background, currently at a FAANG company. I have been in the industry for over 8 years spread across two big tech companies. On this channel, I share tips for people interested in entering data science with the goal to democratize knowledge and make complicated topics digestible for everyone. All opinions are mine!
PS. Some of the links included are affiliate links and help me keep this channel going. Thanks for the support.
Business inquiries: [email protected]
