Joins in SQL Made Easy for Beginners 2023 | Joins in SQL Tutorial With Examples | Scaler

🔹What are SQL Joins?

Structured Query Language allows us to perform action on a single table in a relational database. The actions are create, update, delete or select a record in that table. SQL join statements allows us access to two more tables at once. The database can be kept normalised because of SQL joins. There are different types of SQL Joins ranging from Inner Join to Full Join and Self Join.

Learn more about the different concepts in SQL with this one of a kind tutorial from Scaler Academy.

The following topics are covered in this video 👇🏼

0:00 - Introduction to Joins in SQL
1:39 - Inner Join Concept
3:12 - Left Join Concept
4:28 - Right Join Concept
5:55 - Full Join Concept
7:08 - Self Join Concept
8:26 - Joins Demo in MySQL Workbench

---------------------------------------- About Scaler --------------------------------------------------

We are a tech-focused upskilling and reskilling platform catering to tech enthusiasts in universities and working professionals. There are more Scaler graduates working at Amazon than all of the IITs combined!

📌 Follow us on Social and be a part of an amazing tech community📌

🔔 Hit that bell icon to get notified of all our new videos 🔔

If you liked this video, please don't forget to like and comment. Never miss out on our exclusive videos to help boost your coding career! Subscribe to Scaler now!

#sql #sqljoins #sqljoinstatement

[gauravkulkarni]

1] Output of left join query at 4:02 timestamp screen is wrong. The correct output is shown later in the video when the query is actually executed at 11:25 timestamp.
2] The last sentence of right join theory needs correction. It is: The resultant set displays null for the rows which have no matching row on the right side. Correction: on the left side.
3] Output of right join query at 5:35 timestamp screen is wrong. The correct output is shown later in the video when the query is actually executed at 12:28 timestamp.