Solving SQL Interview Queries | Tricky SQL Interview Queries

Подписаться 299 тыс.

Просмотров 265 тыс.

50% 1

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

Опубликовано:

15 мар 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 457

@darshpancholi4919 Год назад

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!

@vlog.444 Месяц назад

அருமையான எஸ் பி எல் வினாவல் அருமையான எஸ் பி எல் லாங்குவேஜ் சொல்லி கொடுத்ததற்கு நன்றி

@karthikvenkataram4790 10 месяцев назад

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.

@ManuelrPM24 Год назад

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!

@klokeswarreddy3205 2 года назад

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?

@srushtiOm 9 дней назад

I could come up with this - select comment from (select * from comments_and_translations where translation is null) x union select translation from (select * from comments_and_translations where translation is not null) x

@bmanikanndan 2 года назад

Awesome Explanation on Third Query... Thank You so much.

@harsohrabsingh8020 Год назад

The best channel to learn sql topics as well as solve questions.

@Sunny-ok7dl Год назад

Amazing explanation, these 37 minutes were totally productive

@debasismohanty1311 3 месяца назад

Really you are born to teach .just loved your way of explaining Thank you so much

@2011var Год назад

God bless you. Taking your precious time and helping others.

@gyanprakashmishra9132 Год назад

you are best educator ever for sql 🙏

@lakshmipriya8416 Год назад

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

@vinodhkumar4660 Год назад

Miss likshma how to apply interview

@vinodhkumar4660 Год назад

Plz tellme

@happyji2624 9 месяцев назад

I wanna ask too

@mohan_kannadiga 9 месяцев назад

Brilliant Query approach

@ruheequreshi9741 Год назад

you have excellent way of explaining the query and how system works.. really great videos.. good work

@infamismworldwild6248 8 дней назад

Thank you this was powerful and expanded my understanding on the application of SQL

@ctnrandhawa7019 Год назад

great your way of explaining problem and solving them adds fun for them also who thinks sql very tough .great job sir.

@anish_k Год назад

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.

@maidelfigueredo4596 Год назад

Thanks for your videos, very helpful for me when I started to find a job. Thanks a lot

@madhusudhanreddyt2838 Год назад

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

@techTFQ Год назад

Thanks a lot bro

@Hsalz 3 месяца назад

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!

@zishan53 2 года назад

Nice one I feel very relax to solve them Thanku very much

@bedaprakash9609 8 месяцев назад

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 🥰

@XxLenasXx Год назад

This guys explanation is perfect and amazing

@zacharyrohrback 2 месяца назад

Thank tou for serving us the knowledge we need!

@rajasekharareddyb668 Год назад

Really good explanation.. easy to understand even the problem is very complex.. thank you so much for your time

@souvikmaitra6653 Год назад

We want more n more videos like this... excellent work...keep it up ...

@srinubathina7191 Год назад

the way you explained is next level Sir Thank You so much

@siddheshaddarkar4074 Месяц назад

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

@nishapandit5131 7 месяцев назад

Wonderful expiations, especially the last question has a newer nuance..

@traumegaz 8 месяцев назад

thanks teacher, im learning alot your a great teacher

@alirehman4041 9 месяцев назад

Very informative and easy to absorb. Thanks mate.

@rhythmix9138 2 года назад

Nice boss. Simple explanation especially the third query using less than really intrigued me. You deserve my humble subscribe

@bhanuchandarpr1122 2 года назад

Ur way of explanation is super, Keep go like this sir

@darshanwala5561 Год назад

very helpful all the sql queries examples thanks brother please share more the complex sql queries real life examples

@prasadankulwar6050 Год назад

Really appreciate your efforts on this sir..🙏

@benlong1062 8 месяцев назад

This video was really interesting. Your explanations are great! Thank you

@jitendrashelar4123 11 месяцев назад

Excellent! Thank you very much. Such a hard concept to understand, you made so easy sir.

@shivashankargopal1678 2 года назад

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.

@techTFQ 2 года назад

Thank you for the kind words bro 🙏🏼🙏🏼

@naveensinghrajput6903 Год назад

its great to learn this query

@jean-baptistezirimba2504 4 месяца назад

Great job

@solahope6474 Год назад

Thank you very much , very helpful

@HotThupka Год назад

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

@techTFQ Год назад

Glad you liked my contents :) thank you

@HotThupka Год назад

@@techTFQ My Pleasure, its for my benefit

@tinurathi5210 Год назад

Thank you .. for the great explanation!

@ganeshv791 2 года назад

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.

@techTFQ 2 года назад

Thank you bro and noted on the request

@anduamlaktadesse9284 Год назад

Well presented and solved ! Mnay thanks TFQ !

@sathishkumar-yd3pk 2 года назад

Very smart query. Thanks for sharing this query

@techTFQ 2 года назад

Your welcome buddy

@smritikumari1009 Год назад

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

@rahuljoshi7238 Год назад

great work

@VibeQueen24 8 дней назад

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.

@Be-Inspired7 2 года назад

Love the query solving videos

@akhilreddy5208 Год назад

You are really explaining the complex queries which will be very helpful for professionals as well

@techTFQ Год назад

Glad you liked it

@AmitSingh-er3lk Год назад

Great one... 👍

@pranavkmishra 2 года назад

awesome. would like more such videos

@joysqaudteam3043 Год назад

Excellent explanation bro...

@utubemovies1 Год назад

The 3rd question is very good.

@dushyantbhagwani Год назад

superb video

@satyashivmodi6945 Год назад

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.

@dineshgandhi3169 2 года назад

Thanks, for the clear explanation brother. Can you also share therory part of each sql concepts please...

@mushiburrahamanmallick3372 2 года назад

excellent sir

@westgot2 Год назад

I wouldn't ever hire the one who solves the second task like you did. This is the clear task for the FULL JOIN

@misterihorror1993 Год назад

there's many way to do the second query.. it's pretty easy.. the third one now that is challenging!

@cococnk388 7 месяцев назад

Thanks TFQ the last question was everything, I was blocked on how to remove mirror effect records from my query.

@flyhigh225 Год назад

thank you for the explanation!

@kunalkumar-hl6gv 10 месяцев назад

thanku so much for this video

@sharanchuraky6356 2 года назад

Very useful

@shaikusman536 Год назад

Just loved the way you teach....thanks a ton brother....Respect from INDIA.

@bedaprakash9609 8 месяцев назад

I just got to know He is from Malesiya , such really amazing contents not finding anywhere in youtube.

@archana-sv1hh 3 месяца назад

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?

@tanuchaudhary6651 Год назад

Your vedios are really helpful. Please keep it up 👍 🙏

@enefiokjames205 2 года назад

Wow! Thanks for this detailed explanation.👏

@techTFQ 2 года назад

Glad you liked it

@shahulhameed3257 Год назад

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.

@sumitbarde3677 Год назад

hi taufiq, the approach for 3rd problem was out of the world. thanks for such a mind-blowing approach.

@techTFQ Год назад

Thank you Sumit :)

@srujanjajala 2 года назад

very helpful tutorial with realistic examples..

@techTFQ 2 года назад

Thank you buddy

@venkateswararaodevisetti8684 9 месяцев назад

Nice question and answers However the third question can be solved without rownumber() as the < can be directly applied on team code

@odaya9946 Год назад

Your exemples with the excel really helped understand the logics, thanks!

@techTFQ Год назад

Glad you liked it

@rajkumarrajan8059 8 месяцев назад

Brilliant !!!

@meandherforeternity 2 года назад

Mashallah beautifully explained. Keep up the good work❤

@techTFQ 2 года назад

Thank you Fouzia :)

@pratyakshaparashar5306 2 года назад

Thanks. Thanks a lot. Your concepts are easily understandable.

@techTFQ 2 года назад

Glad to hear that bro

@SACHINKUMAR-px8kq Год назад

Thankyou So much Sir 😃

@nakulbarot 10 месяцев назад

wonderful💯

@lakshmipriya8416 Год назад

Really thank you 😊

@guzmanerpr 6 месяцев назад

Thank you for taking your time to explain this.

@techTFQ 5 месяцев назад

Glad you liked

@parvanekhemati1015 Год назад

Absolutely perfect

@nikhilreddy4582 2 года назад

Totally different , easy to understand 👌

@techTFQ 2 года назад

Thank you 🙏🏼

@satyabadiraut1191 2 года назад

Excellent explanation...thank u so much for such kind of sessions.

@techTFQ 2 года назад

Most welcome bro!

@Kabboch 2 года назад

For question 1 I would use Select isnull(translation, comment) from table

@jameses4413 2 года назад

Me too, much easier…

@prabhatgupta6415 Год назад

@@jameses4413 yes

@unnatijaswani4832 2 года назад

Awesome video!! Loved it!!

@deathtrick Год назад

The last one was really tricky.

@patelmayank9034 2 года назад

nice

@maheshreddykaanala94 2 года назад

Excellent sir....worth watching....tqsm ❤️❤️

@techTFQ 2 года назад

Thank you Mahesh :)

@ShivamGupta-io7en Год назад

please add more such videos.

@arvindpillai2587 Год назад

Thanks for the great set of questions it really helps in intuition building also of possible can u show how do you create tables in my sql of one of these 3 questions it would be lot helpful thanks❤

@bhavanib8107 Год назад

great effort

@techTFQ Год назад

Thanks a lot

@amit.pawase007 2 года назад

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?