Introduction to Joins in SQL
If you're looking for a SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you'll be able to write SQL queries. In this video we will learn about the joins. The video gives you an overview about the join and also explains why joins are used in SQL? At the end you will find an exercise for you to practice.
______________________
Video starts with the Introduction and later we check few examples and the syntax part. It also covers the Vein Diagram of Inner Join. Later, we check an example on SQL Server Management Studio 2019. The video ends with an exercise for the viewers to practice.
______________________
Exercise -
-------------------------
• Create Two tables 1. Employee 2. Department.
• Employee table should contain -
Employee_id, Name, Salary, Location, DOB, Team_ID.
• Department Table should contain -
Department_ID, Department Name, Department head, Number of employees.
• Insert minimum 10 values in each table.
• Join the Employee Table and the Department Table and find all the Employee Names, Salary, Department Head and Department ID
(Hint – Team_ID can be the key column between the two tables)
_________________________
SQL JOINS - Overview
• JOIN means to combine something. In case of SQL, JOIN means "to combine two or more tables".
• The SQL JOIN clause takes records from two or more tables in a database and combines it together.
_________________________________________________
◆For more videos related to SQL and other languages, please subscribe to my channel "Let's Learn".
_________________________________________________
◆ Subscribe to our channel - / letslearn-in
_________________________________________________
◆To Learn more, check out the Playlists -
_________________________________________________
◆ SQL Tutorial Playlist -
https://www.youtube.com/watch?v=0i991...
_________________________________________________
◆ YouTube Channel - / letslearn-in
_________________________________________________
◆ CATIA Playlist:
https://www.youtube.com/watch?v=VgBcF...
_________________________________________________
◆You can follow us on Facebook:
www.facebook.com/letuslearnindia
◆You can follow me on Twitter:
www.twitter.com/ismails_007
◆You can follow me on Instagram:
www.instagram.com/letuslearnindia
_________________________________________________
#SQL #SQLSERVER #SQLJOINS #PROGRAMMING #PROGRAMMER #SQLTUTORIAL #INNERJOIN