SQL INTERVIEW QUESTIONS FOR DATA ANALYST|SQL INTERVIEW QUESTIONS FOR BUSINESS ANALYST| SQL QUESTIONS 

If you found this video helpful, Please consider helping me by subscribing to my new channel. "An Indian Abroad". Here I share meaningful conversations , my personal experiences abroad and a lot of other interesting stuff. Here is a link to a video that tells about why I moved back to India after staying in USA for more than 4 years ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6G1xGi-D5ow.html

Following questions have been answered in this Video, The remaining questions will be shared in the follow-up video 1. Difference between Rank and Dense_Rank ? 2. What is a Self Join ? 3. What is a natural Join ? 4. How to Delete Duplicates ? 5. What is the difference between Union and Union All ? 6. What is Merge statement in Oracle ? 7. What is a Sub-Query and what are its types ? 8. What is an Index and what are its types ? 9. What are Scaler functions in SQL ? 10.What is Aggregation and aggregate functions in SQL ? 11.What is Cardinality in a Database ? 12.What is Granularity in a Database ? 13.What are Joins in SQL ? What are there Types ? 14.What is Left Join ? 15.What is Right Join ? 16.What is Inner Join ? 17.What is Full Join ? 18.What is Cross/Cartesian Join ? 19.Creating Copy of a Table ? 20.Creating Copy of a table with No Data ? 21.Difference between Delete and Truncate ? 22.Difference between Drop and Truncate ? 23.What is Primary Key ? How is it different from Unique Key ? 24.What are Constraints and what are its types ?

Your Videos have AWESOME Explanation. I really appreciate your efforts.

Hi, your videos are quite helpfull in learning, I have watched your videos of informatica. Can you make some more on informatica production support issues with some real time project scenarios. This would help me in growing.

Good work.. Keep it up 👏

Good work 👍

Again Excellent explanation 👏

Good explanation! Thank you.

Excellent. Video,

It's really too helpful sir please make more videos on Oracle...

Fantastic

Hello, been going through your videos. your explanation is spot on. Can you answer these? 1. sub query vs join, which one is better and why 2. EXISTS vs IN which one is better and why Also can you make one vide on how to understand explain plan (cardinality, cost etc)

Excellent. Do more...

Easy he hoo jayega

Very good explanation

Hi vivek, can you make oracle sql performance tuning series. Please do the needful

The remove duplicates method not working for me...Please help. There is nothing called 'rowid' in mysql.