SQL

Hi there! This particular branch of the SQL repository covers every component of SQL from Basics to Intermediate to Advanced operations. Required Software

Microsoft SQL Server Management Studio (SSMS)

• Installation

  https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16

• Connection Establishment

Create Table

CREATE TABLE GigbigEmployeeDemo (EmployeeID int, FirstName varchar(50), LastName varchar(50), Age int, Gender varchar(50) )

CREATE TABLE GigbigEmployeeDemo (EmployeeID int, JobTitle varchar(50), Salary int )

Select + From

SELECT * FROM GigbigEmployeeDemo

SELECT * FROM EmployeeSalary