REGEX in SQL to find Valid Email Ids - SQL Interview Query 24 | SQL Problem Level "EASY"
Vložit
- čas přidán 2. 07. 2024
- 30DaySQLQueryChallenge is a series of 30 videos covering 30 SQL Interview Queries. This is the 24th video in this series. This video series aims to provide 30 SQL Queries that can be asked during SQL Interviews. I will explain how to solve and address such SQL queries during interviews in these videos.
Learn and Practice SQL on LearnSQL platform below(Checkout the free postgresql-window-functions course only during March 2024):
learnsql.com/?ref=thoufiqmoha...
Let's follow the below routine to make the best use of it:
1. Watch the CZcams video (first half) to understand the problem statement.
2. Go to my discord server (link below), download the dataset for each problem, and try solving it yourself.
3. Share your solution on Discord and discuss different solutions and issues on my Discord server.
4. Watch the second half of my CZcams video to find my solution to the problem.
5. Share it with your contacts and spread the knowledge.
DOWNLOAD the Dataset from below:
Discord server: / discord
Blog website: techtfq.com/blog/30daysqlquer...
Timeline:
00:00 Intro
00:10 Understanding Problem Statement
02:28 Solution to the SQL Problem
Thanks for participating in this challenge!
Good luck and Happy Learning!
Checkout the free Window function (in PostgreSQL) course on LearnSQL (FREE only during March 2024)
learnsql.com/?ref=thoufiqmohammed
Hi Thoufiq, we are not able to enroll this course for free. They are asking to buy the course even after using the link shared by you. I believe it is not with me only.
Only the window function course in Postgres is free .. u need to search for that specific course ..
Awesome! Find new concepts with great explaination. Thank you.
Brilliant! I'm loving this series. It's sending me into areas of SQL I never thought about.
So cool! This is the first time I've heard about regular expressions and they seem super useful. Thanks for sharing!
Commendable. Thanks for putting this much effort.
Good explanation w.r.to regex. Thank you
superb explanation
Great 🤩🤩🤩
Great sir 💯
Hi, good Job, it's nice that you place the task / content in file with the data now, so that we know what's the task of the lesson
Your videos are great.
Do you think you can also do a small tutorial video on REGEX with a couple more problems? I tried searching in your channel but could not find. It would be really helpful.
What if I want to create a new column in an existing table with a REGEX formula to get the Invoice number from a column in that table.
PySpark 30 Days Challenge of these problems :
czcams.com/play/PLqGLh1jt697xzk9LCLL_wFPDZi_xa0xR0.html
select * from feedback
where email like '[a-zA-Z]%@[a-zA-Z]%.[a-zA-Z]%'
and email not like '%[@#]%@[a-zA-Z]%.[a-zA-Z]%'
and charindex('.',REVERSE(email)) between 3 and 4;