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

This video is the 1st video of the video series SQL INTERVIEW questions.
I will try to cover every single question that can be asked during your interview so that on the day of the interview you can just visit these videos and you will be all set.
Here are the links to the videos that I have mentioned in the videos
Indexing series :
Keys :
subquery :

[TechCoach]

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

[TechCoach]

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 ?

[prakashchakravarthyg]

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

[veeranjaneyulubapatla]

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

[anuvlogs]

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.

[gn]

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

[shivroop]

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

[ravikanthr]

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)