Joins in sql server - Part 12
HTML-код
- Опубликовано: 8 сен 2024
- In this video we will learn about
1. The different types of Joins in sql server
2. Cross Join
3. Inner Join
4. Outer Join -- Left , Right and Full Outer Join.
Text version of the video
csharp-video-tu...
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 RUclips channel. Hope you can help.
/ @aarvikitchen5572
Slides
csharp-video-tu...
All SQL Server Text Articles
csharp-video-tu...
All SQL Server Slides
csharp-video-tu...
All Dot Net and SQL Server Tutorials in English
www.youtube.co...
All Dot Net and SQL Server Tutorials in Arabic
/ kudvenkatarabic
At last... Thanks to your video I'm all clear in joins
+Vishnu Menon Thank you so much for the feedback. Means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server video tutorials in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos and slides for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Best Regards
Venkat
me 2
thanks sir
Hi @kudvenkat , you’re the Best on RUclips. Thank you very much!
The dvd download link is not working.
@@Csharp-video-tutorialsBlogspot i
@@Csharp-video-tutorialsBlogspot u r a God for me sir
So lucky to have found this channel, it has literally everything there is to learn in SQL.. and so well taught. So neatly arranged. And its FREE.! Its 100 times better than any paid courses. Thanks lot of creating these lectures!
The best 17 mins spent in my life. This is so clear and straight to the point!
Finally the fear of hearing the Join query name lifted , it was so easy and your video explained it in such a simple language , thanks a lot
Just AWESOME! I wish you were my "teacher". My teacher just regurgitates what is in the book at the speed of light. You actually explain the reason for each syntax. THANK YOU!
Venkat you are a legend.
This more clearly explained than the official MCS courses.
Brilliant
Many Thanks
John
true that
Have went through many of your tutorials and the one on LINQ was phenomenal...many thanks for these!
Beautiful explanation....You made "Join" a transparent subject. Thank you!
hi.. I have download complete SQL tutorial and every single video is really very helpful. Your way of teaching is really very very interesting... Thank you for your videos.
I learnt Asp.net / Angular.js / C# and now learning SQL from you..
You subjects are easily understandable, on the mark..
Thank you Sir
Thanks for really good explanation. May Allmighty bless you
legend teaching SQL in this video, thank you!
hello venkat thanks for explaning the joins in a clear way.Really ur words and speech are very easy to understand.Amazing teacher.....
You are such a awesome person, I can understand your explanations your voice is really clear you helped me out a lot for a test I have tomorrow
I dont know from which world you are ...you made everything clear ..Thanks for sharing the video
superb..really superb... no one ever explained me joins better than this video.. will never get confused again.. thank you , venkat :)
It was,it is and it will be always the best tutorials ever created..Thank you Sir..!!!
I must say you have extra ordinary skills to present your projects. There is no single ppt i found any doubts. I just have to listen it once and i remember every single word of yours and never have to repeat that PPT again. I love your speech and the way you teach. I am so grateful for taking efforts to make these all lectures.
You are a global teacher in real. I have learnt so much from sql and v studio tutorial. salute to kudvenkat.
Thank you for such a clear explanation! Helped tremendously :)
Hi Venkat :) This video has cleared me all confused. I have seen few videos about joins but I felt no one has explained better than you. Thank you
just awesome. It helped me a lot in examinations. Thank you for providing such an easy lessons to difficult topics with examples.
As always loves your tutorial. You are the Best!! Thank you.
The best Join tutorial I've ever seen. Thank you so much
The simplicity with which you have explained is amazing. Thanks a lot for doing such a wonderful service. God Bless You.
bhai tu genious ha yar.. hats off to you... kya simplicity se samjhate ho yar.. gazab
your videos are very good for learning and i have learned many things. I have to say you did a great job and thanks for making learning so easy with examples keep doing this thanks a lot.
Love Venkat! One of the best teachers on this planet!
I watched many tutorials but the only one that explains in more of a plain and easy way is yours. Thank you a lot!
Thanks for making so easy ..............by providing nice clear explination
If this doesn't teach me what I want to know, Im going to throw my SQL Server out of the window! :)
Please, don't do that! lol
Most underrated comment🤐
Hahaha, I agree with you😅
Made my concepts Clear regarding JOINS. Greta Job sir :)
Nicely explained! This is the number 1 video on join on RUclips.
Thank you for the beautiful video, @kudvenkat. I'd been looking for this sort of video for a long time.
Very clear and easy to understand. Thank you so much
Venkat sir I appreciate the way you have documented, very simple way explained.
you r the best, better then they ever teach me on collage, thank u
Great video.. no more doubts regarding Joins.. thanks a lot.. your explanation is very simple and understandable..
Thanks for your video.
Finally I got the difference between all those joins.
Now Finally i understand the concepts of join.....
thanks to you so so much....
All this is valid also for MySQL, except for the full join, which isn't supported. Good stuff nonetheless! Thanks
i was struggling with joins. this video made it crystal clear for me. thank you so much.
Your videos are very valuable and helpful for every fresher.
Nice video..its very useful for beginners...Thank you...
Thankyew So much Sir, You are one of the best tutors in the World. Thankyew so much for this playlist. it helps a lot to learn things easily.
Finally i'm Now Clear with joins Thanks for this tutorial.
Venkat, I love the way you explain and make it so easy to grasp the concept. I love it and cannot get enough of watching these videos on various topics. Thank you so much...Would be glad to share with my friends.
awesome clarity in my head right now .... about the joins!... thanks venkat
thanks for ur all efforts ... i'm a beginner and have got a lot of knowledge....
Thank you Venkat ،You are A Great Person
Unbelievable neat & clean explanation!!!
Kudvenkat - you have a gift for bringing clarity to many things! Truly appreciate it, Keep up the good work you are doing! :-)
VERY NICE.EASY TO UNDERSTAND.GOOD JOB.
I am so happy I've watched the video. I think it was really clear and I got the information I was looking for.
Cheers
man. your're fantastic at explaining things
This playlist completed 10 years ago is this helpful for now also bro?
Excellent Tutorials on SQL , Thanks for Uploading such a Nice Tutorials on SQL server...
Very nice... the way the explanation is given for each of the tutorial is fantastic , doesnt not to see or watch this video again it just goes and store in the mind permanently... nice work keep it up..
This is the best video on joins ever. Thanks +kudvenkat
Very clear explanation and it's usefull for me🙏🙏🙏
wow,ur brillant, thank u somuch,ur teaching is very clear
In case you don't have the rows from this tutorial, here you go:
Use Sample1
GO
Create table tblEmployee (
id int primary key NOT NULL,
[name] varchar(50) NOT NULL,
gender varchar(15) NOT NULL,
salary int NOT NULL,
DepartmentId int,
)
ALTER TABLE tblEmployee ADD CONSTRAINT FK_tblEmployee_DepartmentId
Foreign Key(DepartmentId) REFERENCES tblDepartment(id)
Create table tblDepartment (
id int primary key NOT NULL,
DepartmentName varchar(50) NOT NULL,
[Location] varchar(50) NOT NULL,
DepartmentHead varchar(50) NOT NULL,
)
Insert into tblDepartment values(1,'IT', 'London', 'Rick')
Insert into tblDepartment values(2,'Payroll', 'Delhi', 'Ron')
Insert into tblDepartment values(3,'HR', 'New York', 'Christie')
Insert into tblDepartment values(4,'Other Department', 'Sydney', 'Cindrella')
Insert into tblEmployee values(1, 'Tom', 'Male', 4000, 1)
Insert into tblEmployee values(2, 'Pam', 'Female', 3000, 3)
Insert into tblEmployee values(3, 'John', 'Male', 3500, 1)
Insert into tblEmployee values(4, 'Sam', 'Male', 4000, 2)
Insert into tblEmployee values(5, 'Todd', 'Male', 2800, 2)
Insert into tblEmployee values(6, 'Ben', 'Male', 7000, 1)
Insert into tblEmployee values(7, 'Sara', 'Female', 4800, 3)
Insert into tblEmployee values(8, 'Valarie', 'Female', 5500, 1)
Insert into tblEmployee values(9, 'James', 'Male', 6500, NULL)
Insert into tblEmployee values(10, 'Russel', 'Male', 8800, NULL)
very Good Lecture and awesome teaching skills. Thanks from Pak
One of the best channel to learn sql.
Very helpful explanation of joins thankyou :)
It was really helpful for me.. Thank you sooo much
This Video clear all Concept in detail...Thank You sir
Hello Suryakant - Thank you very much for the feedback. Means a lot. I have included all the sql tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
When you have some time, can you please leave your rating and valuable feedback on the REVIEWS tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
Very clear explanation tq🙂
Finally I understood ... Thanks :)
Ohh what an explanation brother!!
Thank youu
This is the 3rd or 4th of your videos I see in a row and all of them were awesome! Excellent way of explaining things. Congratulations my friend!
Great explanation! First time i understood about joins!
Very well explained.Best videos ever. Thanks Venkat
Sir u r far better than my college RDBMS teacher. I will recommend him to watch ur videos☺
Thx man your videos are real very helpful
thank you so much sir......these videos are soo helping me....
Vankat, I have been watchin your SQL videos. You Rock !
Thank You so much.
Hi, all the information that is present in the slides is available on my blog.
amazing explanation. thank you for this video.
The best explanation on joins. Awesome work sir !!!!
You made it so easy. i was reading book but it was not such clear as it is after watching this video
Thank you!!! It's very easy to understand concept of Joins in Sql Server.
Hi Sir, Thanks for ur videos , it helps us to clear our doubts . Appreciated your efforts.
Thank you so much for ur videos
Could you please do a Playlist videos in SSRS, SSIS, SSAS, POWER BI.
The way you are taking the session are awesome and teaching skills are excellent 👌
you are really awesome sir really heads off too you
I like your video. you explained it very clear! Wow!
thank a lot sir !! your video mean a lot for me tomorrow in practical exam on plsql
u are amazing man , the way of your explaining is awesome .
i appreciate your work keep it up .
Perfectly Explained!!! :)
Thnks a lot sir.. U r the master of languages....
Thanks for the videos, they are awesome and so are you!
its phenomenal.u nailed it
good video.very helpful .very well said about cross join mainly .thanks
Still relevant in 2016!!! Thank you!
Great videos, very helpful! Thank you!!!
Literally this man has a Golden heart ♥
mama ... you are awesome.... god bless
Excellent sir!!! My pranams!!!
Watching SQL server, amazing, many thanks!
Thank you. It's very clear, simple.