Uploaded February 2023 | Updated September 2026, 2 hours ago
In this advanced SQL tutorial, we explore the regex_split_to_table() function, which separates a string by a limiter and returns a table with each element in a separate row. We'll show how this function can be useful for complex manipulations. This video is perfect for those looking to level up their SQL string manipulation skills.
Watch the full tutorial:
📌 Solving a Tricky Google SQL Question with String Manipulation: youtu.be/BgN5hpl3WKc
______________________________________________________________________
👉 Subscribe to my channel: bit.ly/2GsFxmA
👉 Playlist for more data science interview questions and answers: bit.ly/3jifw81
👉 Playlist for data science interview tips: bit.ly/2G5hNoJ
👉 Practice more real data science interview questions: platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation
______________________________________________________________________
About The Platform:
I'm using StrataScratch (platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation), a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
______________________________________________________________________
#SQLStringsManipulation #GoogleInterviewQuestion #Regex
In this advanced SQL tutorial, we explore the regex_split_to_table() function, which separates a string by a limiter and returns a table with each element in a separate row. We'll show how this function can be useful for complex manipulations. This video is perfect for those looking to level up their SQL string manipulation skills.
Watch the full tutorial:
📌 Solving a Tricky Google SQL Question with String Manipulation: youtu.be/BgN5hpl3WKc
______________________________________________________________________
👉 Subscribe to my channel: bit.ly/2GsFxmA
👉 Playlist for more data science interview questions and answers: bit.ly/3jifw81
👉 Playlist for data science interview tips: bit.ly/2G5hNoJ
👉 Practice more real data science interview questions: platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation
______________________________________________________________________
About The Platform:
I'm using StrataScratch (platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation), a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+google+sql+question+string+manipulation. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
______________________________________________________________________
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
______________________________________________________________________
#SQLStringsManipulation #GoogleInterviewQuestion #Regex
![Collinearity and Removing Redundancies [DoorDash Data Science Project]](https://i.ytimg.com/vi/m3zEV10qvE8/mqdefault.jpg "Collinearity and Removing Redundancies [DoorDash Data Science Project]
In this video, were going to learn how to use the corr() method to create data showing correlation. In the first part of this tutorial, we discussed how to prepare the data for modeling. In this part, well get acquainted with collinear features and the importance of removing redundancy in our data. By removing redundancy, well be able to improve our datas overall accuracy and make it easier to understand. This is an essential step in data analysis, and youll want to pay attention to it when working with data!
Watch our previous video:
📌 Part 1: Data Preparation for Modeling: https://youtu.be/Sf6jn8QZHhc
🧑💻 Go to the project through the link below and follow along with me: https://platform.stratascratch.com/data-projects/delivery-duration-prediction?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link&utm_content=collinearity+%26+removing+redundancies
👉 Subscribe to my channel: https://bit.ly/2GsFxmA
👉 Playlist for more data science interview questions and answers: https://bit.ly/3jifw81
👉 Playlist for data science interview tips: https://bit.ly/2G5hNoJ
👉 Practice more real data science interview questions: https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
Timeline:
Intro: (0:00)
Data project: (0:25 )
The approach: (1:51)
Creating a mask: (2:40)
Functions to test the correlations: (4:00)
Feature engineering: (7:15)
Conclusion: (8:00)
About The Platform:
Im using StrataScratch (https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link), a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.
So, if you want more interview practice with real data science interview questions, visit https://platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link. All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.
Contact:
If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
#StrataScratch #DoordashDataProject #DataModeling")
