Great! I was surprised that he has a non-tech background, the way he explained all the SQL stuff was incredible. His presence of mind and communication was excellent. I am proud and inspired by it. 👏👍And Thank you sir for sharing such inspiring videos with us.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
@@LotusITHub Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Amazing interview.I will improve my skills from this video. I saw Candidate confidence and body language is very good .this video will help me to improve skills and confidence. Thank you nilesh sir🙏
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
The way he answered is very good but he got confused with left join and right join. In left join it returns all the values from left table and common values from right table and in right join it returns all the values from right table and common values from left table.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table. follow me for more .i will be making good videos for student.
I know this all about the sql , data visualisation in excel ,powerbi , python, R , Data cleaning still not able to get the internship. Can anybody here tell me what am I missing? Or how to approach others(company )for the internship . It will be off great help;)
Have a good resume do project which are of industry standards, know the technologies software which are used in everyday work, look, python power bi sql are known by anyone and written by many in there linkedin profile the thing is if you really want to get a call from a recruiter show him the projects and add some weight in ur resume.
Answer given for Left outer join is totally wrong.right answers is ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
It is correct, he wrote using subquery, and if u use limit u will get one output of 2nd highest salary, whereas in table maybe more than 1 person having 2nd highest salary
Answer given for RIGHT outer join is totally wrong.right answers is RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table. FOLLOW ME FOR MORE SQL KNOWLEDEGE
Very useful, helpful and appreciable as I am also trying to switch my career into SQL with non tech background.
Thank you jitendra , Best Wishes for your Future
Pp szszs@@LotusITHub
😮uZ,I?LJZN/W6byI-9J+e7😮😊 0:15 🎉😂😅
Ib )%-jk]
😂😢
Great! I was surprised that he has a non-tech background, the way he explained all the SQL stuff was incredible. His presence of mind and communication was excellent. I am proud and inspired by it. 👏👍And Thank you sir for sharing such inspiring videos with us.
Thank you Divya
Can good
Best class
Thank you Divya 😊
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
It is a best composition for beginners to learn how to give your interview. Always be confident whether you are right or wrong.
Thank you Jaishree😊
Very helpful interview for the college students or freshers because it's only fear for the students
Thank you bhumika 😊
@@LotusITHub Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Amazing interview.I will improve my skills from this video. I saw Candidate confidence and body language is very good .this video will help me to improve skills and confidence.
Thank you nilesh sir🙏
Thank you akshay 😊
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
The way he answered is very good but he got confused with left join and right join. In left join it returns all the values from left table and common values from right table and in right join it returns all the values from right table and common values from left table.
ok thank you dear comment and valuable
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
follow me for more .i will be making good videos for student.
I think he is not a fresher although the questions are very helpful for freshers
Thank you so much
This was great and for sure increase my confidence 😊
Great session to watch 😊
Good one , it’s very helpful …candidate looks like prabhas😀😀
This was so helpful. This interview boosted my confidence. Thanks a lot
@@kunalmanwar1615 thank you 👍
Very useful information regarding interview 👏👏
Thanks a lot
❤️👍 best wishes
When you drop a view in a database, it's typically not stored in a cache memory...
Very Helpful , thank you
Thank you shree 😊
Thank you, sir please upload mock Interview for java
Thank you for makeing this types of video ❤
It will boost our confidence as well as knowledge
Thank You pankaj
Very nice Nilesh sir
Thank you Pradip 😊
it was helpful
Very nice video..thankyou for guidance 🙏🏻👍🏻
Thank you bhumika 😊
sir ap puchte gaye main video pause karke jawab deta gaya ... very resourceful content thankyou
Ok dear
Ok will have some more interviews
Thank you Ashish 😊
Helpful ❤❤
I'm glad!
Left join and right join is not correct
Nice
Thank you 😊
For which job role this interview helps...
Informative, Can we say query in place of command.
SQL means structure query language
So query is better
can anyone help me with building resume from non tech to IT background
useful next javascript? wi8ing...
Yes, definitely
4.32 wrong..thee rowid is same
Didn't give the right answer of joins of left join and right join
ok thank you
How can i give this interview ??
I know this all about the sql , data visualisation in excel ,powerbi , python, R , Data cleaning still not able to get the internship.
Can anybody here tell me what am I missing? Or how to approach others(company )for the internship . It will be off great help;)
use linkdin ....or search for company websites...
If you need any kind of help for internship then you can contact me
Which platforms u apply through??
Have a good resume do project which are of industry standards, know the technologies software which are used in everyday work, look, python power bi sql are known by anyone and written by many in there linkedin profile the thing is if you really want to get a call from a recruiter show him the projects and add some weight in ur resume.
Sir left and right ko ulta define karr dia..kindly check n correct
Answer given for Left outer join is totally wrong.right answers is
ANS:- LEFT (OUTER) JOIN : Returns all records from the left table, and the matched records from the right table.
Sql is enough to get job?
Yes sql dev
0:05
Second highest salary query is wrong he needs to give limit or offset
It is correct, he wrote using subquery, and if u use limit u will get one output of 2nd highest salary, whereas in table maybe more than 1 person having 2nd highest salary
From where u learned sql?
Actually this is a mock interview in Actually even if u are little bit nervous it's okay
Thank you ayush for comment,will sure improve
Answer given for RIGHT outer join is totally wrong.right answers is
RIGHT (OUTER) JOIN : Returns all records from the right table, and the matched records from the left table.
FOLLOW ME FOR MORE SQL KNOWLEDEGE
Lgta he USA mein aa gya ,by by