Advanced or intelligent joins in sql server - Part 13

In this video we will learn
1. Advanced or intelligent joins in SQL Server
2. Retrieve only the non matching rows from the left table
3. Retrieve only the non matching rows from the right table
4. Retrieve only the non matching rows from both the left and right table

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[meghawadhera]

Thanks Venkat for sharing these videos.These are very helpful.

[glodybadose]

People like you are gifts from God. I hope you're saved. And thank you for these videos

[nitinable]

Hi, In this video you already knows that null value will give you all data from table 'A' without the matching record, but if you have a large no of row in a table 'B' then you cannot write like this, so you must use some dynamic syntax to fetch data from table A without matching rows.

else i must say you have done a great work, these all videos are very helpful

thanks and keep posting videos like this

[baburamshapure]

Hi Venkat, greetings of the day! These tutorials are invaluable. I literally learned SQL Server by going through them. Really admire your work and the way your teach, so exhaustive. Thank you man. God bless you!

[ga]

Kudvenkat, You are the most sincere instructor on the Youtube, You always cover the subject to the smallest details, You do not know how much I am grateful for the way you teach, Thanks a million

[hbetre]

Mr. Venkat, thank you for posting these videos. It really helped me and taught me alot.

[raginiponnala]

Hi Venkat,

What an explanation!! Learnt SQL JOINS in less than 18 min.
Please be there and produce more wish in all the

Thanks for your time and sharing knowledge!!

[ThillaiG]

thanks a lot venkat, i seen so many tutorials to learn, but this is best video i can say . first time i am giving comment like this in my life, i really want to thank u for this excellent videos, i getting so much confident for my interview .

[anupamkhatri]

Thnak you So much Sir, I have gone through so many SQL Playlist but your Course is far better than others.

[hsuri]

Hii Venkat,
Thanks for the videos. Really great job.
My question: What if the Non-Matching rows are NOT NULL i.e. have different values other than null.

[galavyasarikonda]

Venkat- I really appreciate the way you present and detail easy to understand. Thanks a lot for elegant training.

[kleomeniskogias]

Nice Video! I believe that the initial values of the tblEmployee table is confusing. The point here is to fetch the rows that their id columns will be automatically filled with the NULL value because they don't belong to the INNER JOIN. For instance if there was an additional employee with DepartmentId = 5, he should have been retrieved from the non matching rows of the left table. To sum up, it is not the DepartmentId = NULL that enable us to make these smart retrievals, but the NULL autocompletion that is made to the rows that don't belong to the INNER JOIN.

[Csharp-video-tutorialsBlogspot]

Hi, thank you very much for taking time to give feedback. I am really glad you found these videos useful. To receive email alerts, when new videos are uploaded, please feel free to subscribe to my youtube channel. May I ask you for a favour. I want these tutorials to be helpful for as many people as possible. Please feel free to share the link with your friends and family who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video.

[temitopetalabi]

Hello Venkat,
Thank you so much for this video series. You are such a great teacher. I really appreciate you making this available to everyone .

[collinsgift]

I literally watched both prt 12 and 13 without feeling tired or losing interest in your teaching, thank you so much

[roxannereyes]

Thank you Mr. Venkat for these helpful videos. Which do you think is the most important to know in MS SQL? What do most employers would like us to emphasize?
I'm just curious to know because it's most important to prepare me for a job.
Thank you.

[faypork]

Hi Venkat, thank you for creating all the tutorials. There's something confusing me however. At the last section regarding FULL JOIN, were you trying to show "WHERE Employee.Id IS NULL OR Department.Id IS NULL" or simply "WHERE Employee.DepartmentId IS NULL" , instead of the combination in your tutorial? The "Department.Id" portion of your filter looks redundant to me. Not sure if I have misunderstood something.

[jo-ti]

All of your videos are just way of teaching is so simple and impressive...

[fozler]

This playlist really helpful for all types of beginners and professional bhai.
Bhai I have one query. I am not getting access of sql query of your sites

[clouddataodyssey]

Hi Venkat - Thanks for uploading the videos...excellent tutorials..
Merge Join is missing in the series. Could you please upload a video for Merge Join? That would be very helpful.