SOLVE 5 SQL QUERIES IN 5 MINUTES (PART 1) | MASTER IN SQL | SQL INTERVIEW QUESTIONS

[@crackconcepts]

✨Link to my SQL e-book: imojo.in/rkajq9 ✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[@raghavsharma879]

It feels like when a friend of urs is explaining all this to you just before 5mins and boom you rock that exam.... Explanation with such an ease..... Woww....

[@babayaga4354]

simp spotted

[@arrigune]

XD

[@tech_tm3874]

Exactly

[@nagaraju2962]

Query 4,select * from employees where first_name like '%A' and LENGTH(first_name) =6;

[@sajani6609]

Yes thank you!

[@shayamjyotisarkar317]

Concepts explained with such simplicity. Truly awesome.

[@MohanGonnabathula]

1. UPDATE emp SET salary = salary * 1.05; --This approach is easier to remember.

[@adityarajbhandare5166]

Right

[@stormboy87]

I'm watching after 4 years , still it is so helpfull and i will always be helpfull in/for future ❤❤

[@kameshnayak8677]

Hi Ma'am, Your videos are really helpful for interview preparation. Now we need not to waste precious time browsing confusing contents on net. Keep uploading more contents. :)

[@akhilgoyal6224]

I like the way she explains the problems and very good way to explain on papers by writing them self

[@yuvrajsingh1713]

I am watch many vedio about SQL in KZbin but I have not get man think about SQL Query question solving in easy way but after watching your vedio every think clear about SQL and I think you have too much knowledge about SQL Query and thanks for providing this type of think by the help of vedio...

[@simonoganga9535]

Am beginning to learn SQL, I can't wait to master it.

[@mirandaperry5245]

Same here! Good luck!

[@alokranjan7323]

4th one - select *from employees where firstname like '%A' and len(Firstname)=6 I think this should also work

[@stevequantie8064]

Yes, as long as you're using the right reserved words like "length" vs "len". I think of "len" when using almost all other languages.

[@NikhilSingh-l5f]

My Exam is there and i was having much doubts in my sql. 😢Thankyou for clarifying my doubts 😊🎉

[@YanYan_UJ]

Your videos are life saver! The explanations are easy to understand. Subscribed!

[@Desh-Videsh-Updates]

Give more questions like this. It is helpful when we practice this Looking at your questions at one place. If I don't practice sql for 3 4 days, i forget basics of SQL like insert, update, delete drop with where etc

[@vivekgupta5041]

Very useful and helpful videos !!! To the point and time savers !!!

[@DHANUSHrockyartist]

3 question I think we need to use having for aggregate functions

[@miteshjain4549]

super job . god bless you. nice job. In 5 min only i got more information.

[@SM-hw3yi]

Explained in simple and beautiful way. Thanks

[@mr.x6499]

Awesome voice..

[@arrigune]

Thank you. I love that you do it on papaer. That's my way of getting in everything.

[@amitejpratapsingh2702]

I have been looking for such vedios for long. Short ,simple and easy.

[@abdulatifkasim5332]

WHAT AVERY NICE AND CLEAR PRESENTETION KEEP IT UP!!!!!!!

[@veeramani8478]

Learnt SQL topics and queries few days back Just a beginner quite impressed by your q and a

[@aravinds3808]

Hi sister, Thanks for your videos..it helped me to land SQL developer job..

[@davinaugustine4379]

For query 4, it is meant to be SELECT * FROM employees WHERE first_name like '%_____a';

[@ashishashok9941]

Yes

[@stevequantie8064]

I do not believe so. When you put the wildcard at the beginning, the logic would tell me to expand on the number of starting characters. Test it! I did and the author is correct with the simplest solution.

[@jananiv7105]

Why they are not using* in 1&2?

[@mohammadriaj2804]

SQL compilation error: error line 2 at position 6 invalid identifier 'first_name'

[@MohanGonnabathula]

SELECT * FROM emp WHERE first_name LIKE '_____A'; THIS IS FINAL AND CORRECT. ( 5 underscores)

[@themaninthemirror2038]

Very Well Explained, and a nice practice for my learning.

[@amrindersingh8003]

i have exam tomorrow 😂

[@cgimotion3351]

😂I have an exam in 5hrs😊

[@sah_eli]

​@@cgimotion3351 hey ! How was your exam ? I have mine soon

[@cgimotion3351]

@@sah_eli aced it,

[@kennedy4405]

I have exam in 15 mins

[@PolBoy-is5rj]

I have in 0 minutes

[@shubhamgupta-ur3hf]

I have watched many video for SQL tutorials but I understand ur video properly thanks for the help

[@khushbooshivhare5530]

Thank you so much, this 5 min video idea is very helpful

[@crackconcepts]

Thank youu😊

[@areyentraidi_shafi4623]

Simple sample of sql queries with simple pen and awesome musical voice.. 💐

[@smarter_solutions]

For the first one update employers set income = income * 1,05 is easier Anyway good job

[@ab-lz2gh]

yes. thnkss. hi r u italian

[@smarter_solutions]

@@ab-lz2gh yes

[@ab-lz2gh]

@@smarter_solutions 👍👍🇮🇹🇮🇹

[@sunilSunil-lm5ck]

We can also use another method Select salary +5% as increment from employee

[@hamzaabaichi8361]

Thank you a lot for your efforts , and greeting from Morocco 🇲🇦❤

[@noormohammed2127]

Nice explanation.very helpful.easily understanding.

[@prashanthvenkatesh8207]

Awesome voice, I guess you must be full time singer

[@salimamansoura7838]

Thank you so much for all the efforts you are making to provide this information smoothly .

[@vishwajeetjadhav8807]

Concepts explained with such simplicity & sweet voice

[@kasirbarati3336]

What is the difference between `SELECT * FROM employees where first_name LIKE 'ABC';` and `SELECT * FROM employees where first_name = 'ABC';`?

[@venu__royal]

Both are same bro

[@Haiderali-hi5cj]

thankyou for the help tomorrow is my offline exam. thanks for making short and conceptual video.

[@shankar8816]

Bhut acha pda rhe ho mam. Thnku.

[@abilash5642]

It can be simply done as set income= income*1.05;

[@riteshtripathi8626]

Hi, in your third query, i remember somewhere in your other video you mentioned, if an 'aggregate function' is used, we can't use 'WHERE' clause rather 'HAVING' clause is to be used, however you have used COUNT with WHERE, kindly enlighten me, Thanks in advance

[@crackconcepts]

Please watch my latest video on WHERE VS HAVING IN SQL you’ll understand it properly

[@babavalishaik4874]

Amazing explanation easy to understand tq u for making easy👍🏻👌🏻👏

[@Lozzymee]

I am fresher.. tomorrow is my interview 😂😂but I don't anything about sql😢.. but this video is helpful ❤

[@knighthacker2307]

The lecture is great and fine! But I remember my ex after hearing your voice....lol...😄

[@tobio-chan7494]

Thank you. So beautifully explained.

[@nikhilrageer1315]

Voice is so cute 🤩

[@lakshmimurala5619]

Nice explanation......TQ for sharing the knowledge

[@tupacshakur648]

Thanks mam for explaining it in a simple manner.

[@michaelchiz8055]

Good tutorial. Please keep making these beautiful Tutorials.

[@omkarsatav2626]

Thank you so much 👍🏻. It was a great brief coverage of DML statements.

[@billhaqshaik563]

Thanks for your SQL query explanation sister 👍

[@TechCoach]

Clean,Simple and precisely explained :) . Good work.

[@MarioBritto76]

Would be good to include the questions/Queries in your description summary so that we can also practice once without having to run the video again

[@TechXplorePro]

Creative explanation. Another way of Quick Learn SQL. Keep Going 👍👍👍

[@srinivasreddy186]

Hello, i hope u r dng well ,good job and plz post some a little complex queries..

[@arshadahmed126]

Howww she is explaining over paper. To be honest it's more understandable than most of the channel who is on PC. Loved your channel ♥️

[@bhogendrayadav3985]

Her voice is hitting my soul ❤️💓

[@Abhishekyadav-xd2ib]

1. Select sal,sal+5/100 from emp;

[@EveryDaymast]

select first_name from employees where first_name like '%A' and length(first_name) = 6

[@aravindm6644]

Sissy it's just amazing and usefull.

[@AdnanKashemOxe]

Thanks a lot for all of your videos..helped me a lot. Best wishes to you. And keep making videos.

[@zamatallica7]

My answer is income=income*1.05 just to keep the math simpler.

[@Vee-Hive]

yup

[@rgkamal]

Perfect and easy to understand 👌

[@srashoknaidu3235]

excellent miss, and im sure about to follow your all videos and please keep going on.....

[@kttvenkat]

Thank you..Easy way to understand 😊

[@safarnaama8798]

Aapki writing meri tarha hai :D Good content and explanation btw. I am a working professional.

[@pujaprasad8523]

Thankyou Mam ....This helped me a lot...

[@sagarmishra7219]

Well explained sis 👏👏👏

[@ramanayudusadam2722]

The video is excellent. A small improvement; it's not an alphabet. It is a letter. Alphabet means A to Z.

[@jaazrawkstah9481]

Absolutely brilliant. I would like to see more query.

[@sureshbarma1320]

in this video if you show the table also, then it becomes very easy to understand for beginners

[@kiranbarai913]

Very well explained .... thank you mam ...

[@kapishmajumder2004]

Thanks for helping me.. Tomorrow is my offline practical exam, i am searching for this from morning i cant but in this video i was cleared about it.. Thanks a lot.. And by the way your voice is so sweet😌❤

[@shri7105]

such a nice quick video , tq so much

[@ashokmanne7371]

Nice explanation with a beautiful voice

[@AnshSharma-lw6rz]

Great work and explanation Sadia feels like a friend of mine is teaching me 👍🏻👍🏻

[@mujeebabbu]

Nice explanation 👏, your new Subscriber 🎉

[@JoudNovember]

Great explanation thank you!!

[@Vishalpanchal_27]

Nice❤❤

[@aa-zn8ig]

Voice is really amazing.❤️

[@Utk4rshNegi]

I have exam today starting 1 hour before exam wonder where i will be 5 years after this comment.

[@docali6729]

Wow she is mind blowing 👌

[@2amthoughtsz]

You have missed percentage sign in 4 ques. It's just a correction. Your vidios are well explained.😊

[@nonoobott8602]

Very concise and explicit

[@nageshpatil6114]

In question 3 group by clause is necessary to use but don't use

[@financialcrusader1364]

Great work 😅 Simple and sorted 👌

[@Vamsikc543]

To the point !!!🔥🔥

[@prakashvish3988]

Nice voice and good explanation ❤️

[@abdulatifkasim5332]

please give us some lecture on How to get odd and even number from the given table, thank you so much

[@sangameshsangu8517]

Nicely explained video tqu😊

[@manoranjanpanigrahi3677]

mesmerizing voice and to the point video

[@ashutoshmishra9610]

i am glad i found this......thankyou verymuch

[@harshadrajwade8856]

Hey thanks for sharing and your efforts, well explained. You're awesome 👏😁

[@nrk7772]

Very nice explanation 👌

[@shivanshsrivastava1715]

You explain in that way like if anyone didn't know about SQL then also he can understand and get the idea about what is happening and how the queries are written👌👌 thank-you soo much

[@sohail_ahmad]

Watching from Pakistan 🇵🇰 2024 anyhow who is watching this video

[@topclass5695]

Last but not least is emp ''salary'' very imp '''Q'''

[@kartiktarar858]

Great explanation with beautiful voice

[@anupama1381]

Thank you maam! Very easy to understand