00:30:08 Hours On demand videos
1 Lessons
Full lifetime access
Access on mobile and tv
None
The video demonstrates what are the different types of joins and who they work in SQL.
The tutorial is a little elaborate to make sure that you understand different kind of joins and where you should use which kind of join.
The 5 Kind of joins explained are.
1. Inner join (Join or simple join) :- Rows that are common to both tables are returned as the output.
2. Left Outer join (Left join):- Returns all rows from the left table along with matching rows from the right table
3.Right Outer join (Right join):- Returns all rows from the right table along with matching rows from the left table
4.Full outer join (Full join) :- Returns all the records when there is a match in either left or right table.
5. Cartesian Join : (Join with no where condition)also known as a Cartesian product, is a join of every row of one table to every row of another table.
Our goal is to help people with a free platform to learn online. Come and learn on Zversity. We do not charge a fee or anything here. This is a free university made for us all. Happy learning!
666 Courses
384 Students
9 Reviews
Average rating