Solving SQL Interview Queries | Tricky SQL Interview Queries
Вставка
- Опубліковано 15 бер 2022
- In this video, I will explain and solve 3 tricky SQL Interview Queries. These are the SQL Queries which can be expected during SQL Interviews for both beginners and experience level interviews.
Many times, SQL Queries given during SQL Interviews are more tricky than complex. The solution to the SQL question may be simple but understanding the question and dataset and analyzing the data will play the most important role when solving such SQL queries. Hence mentioning the tricky SQL queries which you may expect during SQL interviews.
My email id: techtfq@gmail.com
All the Dataset, SQL scripts and queries written in this video can be found in my blog.
Link to my blog: techtfq.com/blog/solving-3-tr...
My recommended platform to practice SQL queries: www.stratascratch.com/?via=te...
My recommended platform for SQL Course: learnsql.com/?ref=thoufiqmoha...
Consider SUBSCRIBING to my channel if you wish to learn SQL, Python and Data Analytics concepts.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq
Thanks a lot TFQ. Your videos is not just a video it is a service for many techs like me. Beautiful explanation that too for tricky questions. More than that the SQL commands to execute and practice in our IDE's that you share get me more to my fullest satisfaction. A special thanks for that too buddy.
Please keep up the good work.
Please add this video to the SQL playlist! Started watching the joins video and I have never seen a better explanation before. Love the content!
For the second one in oracle this query also does the trick in one single query
SELECT NVL(A.ID,B.ID) AS ID,
CASE WHEN B.NAME IS NULL THEN 'New in Source'
WHEN A.NAME IS NULL THEN 'New in Target'
ELSE 'Mismatch'
END as Comment1
FROM source A
FULL JOIN target B ON A.ID = B.ID
WHERE NVL(A.NAME,'$') NVL(B.NAME,'$');
I used full join and excluded the names that matched then is just added the Case.
Great Video!
Sir, can you explain about what exactly a sql/ plsql developer do in software industry and what are the career growth options in future for sql developers in IT industry. Is it better to go through in that domain?
அருமையான எஸ் பி எல் வினாவல் அருமையான எஸ் பி எல் லாங்குவேஜ் சொல்லி கொடுத்ததற்கு நன்றி
I am really thankful to you .. few months ago I was not so confident on myself to give interviews.. after started learning from your videos given around 4-5 interviews confidently. Thank you😊..
Miss likshma how to apply interview
Plz tellme
I wanna ask too
The way you explained and the pain you have taken to make such wonderful videos is way beyond saying thanks...you are a rockstar man....keep posting such kind of tricky queries...will help someone get a job...all the best bro...
Thanks a lot bro
The best channel to learn sql topics as well as solve questions.
Awesome Explanation on Third Query... Thank You so much.
Amazing explanation, these 37 minutes were totally productive
Hi, Your videos are very unique and easy to learn
Can you please make videos related to Grouping sets, Rollup, Within group.
And also please make related to dynamic sql
Thanks for your time.
Thank you bro and noted on the request
He is a savior. I am lucky that I came across his videos. Such a lucid explanation. Thank You. Please upload more of SQL Queries needed for Data Science Folks !!
Glad you liked my contents :) thank you
@@techTFQ My Pleasure, its for my benefit
Really you are born to teach .just loved your way of explaining Thank you so much
You are simply amazing, Thoufiq! I took your SQL Bootcamp last year and often come back to your content for additional practice and learning. Stay blessed!
God bless you. Taking your precious time and helping others.
Brilliant Query approach
Hi, these kind of videos really helps, and the way you teach is very good. You are helping us in a great way possible. Keep up the good work.
Thanks a lot TFQ for giving such wonderful explanation for all these questions.
I started watching your YT channel a month back your teaching style and your logical explanation for each concepts MINDBLOWING.
Thank you again for sharing your knowledge.
Thank you for the kind words bro 🙏🏼🙏🏼
I just got to know He is from Malesiya , such really amazing contents not finding anywhere in youtube , please keep posting more videos like this 🙏🏻🙏🏻, really feeling like big brother is helping to understand such complex things in a simpler way 😇, Love from India 🥰
you are best educator ever for sql 🙏
you have excellent way of explaining the query and how system works.. really great videos.. good work
great your way of explaining problem and solving them adds fun for them also who thinks sql very tough .great job sir.
We want more n more videos like this... excellent work...keep it up ...
Very informative and easy to absorb. Thanks mate.
You are really explaining the complex queries which will be very helpful for professionals as well
Glad you liked it
Nice boss. Simple explanation especially the third query using less than really intrigued me. You deserve my humble subscribe
Thanks for your videos, very helpful for me when I started to find a job. Thanks a lot
Really good explanation.. easy to understand even the problem is very complex.. thank you so much for your time
Wonderful expiations, especially the last question has a newer nuance..
Ur way of explanation is super,
Keep go like this sir
Nice one I feel very relax to solve them
Thanku very much
Thank you this was powerful and expanded my understanding on the application of SQL
Really appreciate your efforts on this sir..🙏
This video was really interesting. Your explanations are great! Thank you
Thank tou for serving us the knowledge we need!
Great job
Excellent! Thank you very much. Such a hard concept to understand, you made so easy sir.
Love the query solving videos
Hi Thoufeeq bro, your videos are very useful. In oracle 11g seems like column names are not accepted in when then condition, only string values are getting accepted. is there any other option.
Thank you .. for the great explanation!
hi taufiq, the approach for 3rd problem was out of the world. thanks for such a mind-blowing approach.
Thank you Sumit :)
Well presented and solved ! Mnay thanks TFQ !
This guys explanation is perfect and amazing
very helpful all the sql queries examples thanks brother please share more the complex sql queries real life examples
its great to learn this query
awesome. would like more such videos
thanks teacher, im learning alot your a great teacher
the way you explained is next level Sir Thank You so much
Sahi video, sahi samay par!
Hope this helps 👍
Thank you so much for the video.. It was really helpful and the way you explain makes learning easier.. Thanks a ton.. Would also request you to please make some video on normalization database migration and database optimization.. Thanks in advance
great work
Very Well Explained.
Wow! Thanks for this detailed explanation.👏
Glad you liked it
Thank you so much for the thoughtful explanation. 😊
One thing came into mind, 2nd query with union of 3, instead, can we use full join with case statement to print the desire output?
He said yes - see his blog
Excellent explanation bro...
Logic is correct... In second query you have used union operators and same table is scanned 3 times which may not be suitable for big tables... We can use cte for the same
The video is quite informative, and way of teaching is great.
Thank you very much , very helpful
Mashallah beautifully explained. Keep up the good work❤
Thank you Fouzia :)
thank you for the explanation!
Hi, i have attended interview recently and they asked question about which command is used to find error? Could you please help this? Thanks in advance.
Write any wrong query and u will get the error!
@@unawarenoob2968 😂
@unawarenoob 🙏🏻🙏🏻🙏🏻🤣🤣🤣
Where r u now? Placed? If yes... where
Begin catch
Very smart query. Thanks for sharing this query
Your welcome buddy
Great one... 👍
Loved you. Amazing session and videos. Love you more. Thanks a ton. You get lot of fame and money and you are amazing. God bless you.
Just Awesome Brother ! SQL is an ocean and you're helping others to voyage !!
Thank you buddy
Very useful
very helpful tutorial with realistic examples..
Thank you buddy
Brilliant !!!
excellent work sir !! please come with more practical example like this ,,
Thank you Das and will do
Totally different , easy to understand 👌
Thank you 🙏🏼
thanku so much for this video
Just loved the way you teach....thanks a ton brother....Respect from INDIA.
I just got to know He is from Malesiya , such really amazing contents not finding anywhere in youtube.
I am always eagerly waiting for your next vedio.. to learn new things.. keep going..
Thank you for the support Prajakta 🙏🏼
Appreciate it ☺️
Your exemples with the excel really helped understand the logics, thanks!
Glad you liked it
superb video
Excellent explanation...thank u so much for such kind of sessions.
Most welcome bro!
This is really wonderful video. Thank you so much. Please do come up with such wonderful contents.
Thank you bro
excellent sir
Great Explanation..It’s very useful 👍
Glad this helped
Your vedios are really helpful. Please keep it up 👍 🙏
Thank you sir, for making such informative videos. it's really helping me practice for my upcoming interviews. One request is to please make videos on puzzles and guesstimates for full practice for the role of data analyst.
Thanks, for the clear explanation brother. Can you also share therory part of each sql concepts please...
wonderful💯
really, very appreciative video and the channel itself fro learning sql.
Thanks a lot sir for providing this.
Thanks you Wagh :)
Great video, thank you
Glad you liked it!
Really thank you 😊
Awesome video!! Loved it!!
Thanks. Thanks a lot. Your concepts are easily understandable.
Glad to hear that bro
Absolutely perfect
thank you so much. superb video
Glad you liked it
I really like it.
And I've interested on more like this.
keep doing.
appreciate ur hard work.
Thank you Husain and noted
Thankyou So much Sir 😃
Thank you for taking your time to explain this.
Glad you liked
Excellent sir....worth watching....tqsm ❤️❤️
Thank you Mahesh :)
Hey Taufiq, Could you please make a video on indexing .You explain very well. Want to understand SQL indexing thoroughly but couldn't find any video on your channel. If you already have made video on it, could you please share the link here?
Kindly come up with real life Day to day activity a SQL Developer or a data analyst does in the industry or the company. Like please explain when we join any company how are these Query useful there with some kind of live examples. For instance how a data analyst uses SQL in his day to day work at the office. Also please continue providing such videos and please come up with full tutorial videos in a sincere format like a course
Noted on the request bro, let me think about it
Hi TFQ, Thanks for the video. How come the result output is not in the order of those three queries joined by the union? it should be like: 4-Mismatch then; 3-New in Source then; 5-New in target right?
I wouldn't ever hire the one who solves the second task like you did.
This is the clear task for the FULL JOIN
Great explanation. Looks like for the third query you had already solved the second part first using not equal on team names.
I did but I wanted to provide a more meaningful and easier to understand solution at the end hence used row number concept
your videos helps me a lot to solve complex queries...
I am glad to hear that buddy