SQL JOINS Basics - What is Join and why we use ? Detailed Explanation | SQL Tutorial Part 17 скачать в хорошем качестве

SQL JOINS Basics - What is Join and why we use ? Detailed Explanation | SQL Tutorial Part 17

Hello Everyone, This is the 17th part of the SQL Tutorial for Beginners. You can refer to the playlist 'SQL Tutorial' for all related videos. and 1st Part of the SQL Joins Tutorial Series In this video, we are going to discuss: 1.What is mean by SQL JOINS? 2.Why we use SQL Joins? 3.Table Creation - Department and Employee 4.Types of Joins -Detailed Explanation -------------------------------- SQL Query ----------------------------------------------- --What is join?? --Create Table --Dept table CREATE TABLE Departments ( department_id INT PRIMARY KEY, department_name VARCHAR(50) NOT NULL ); INSERT INTO Departments (department_id, department_name) VALUES (10, 'HR'), (20, 'IT'), (30, 'Marketing'), (40, 'Sales'); CREATE TABLE Employees ( employee_id INT PRIMARY KEY, name VARCHAR(50) NOT NULL, department_id INT, FOREIGN KEY (department_id) REFERENCES Departments(department_id) ); INSERT INTO Employees (employee_id, name, department_id) VALUES (1, 'Alice', 10), (2, 'Bob', 20), (3, 'Charlie', 30), (4, 'David', NULL); ----------------------------------------------- select * from dbo.Departments select * from dbo.Employees --Why do we use joins?? --1.Retrieve related data --2.Normalize data --3.Avoids data duplication --4.Build complex queries #sql #sqlserver #join #sqljoins #beginners #tutorial #detailedexplanation