What is view

Types of Views

https://docs.microsoft.com/en-us/sql/relational-databases/views/views#types-of-views

Advantages of view

Creating view in SSMS

Step-1

Creating view in ssms Step 1

Step-2

Creating view in ssms Step 2

Step-3

Creating view in ssms Step 3

Step-4

Creating view in ssms Step 4

Step-5

Creating view in ssms Step 5

Step-6

Creating view in ssms Step 6

Step-7

Creating view in ssms Step 7

Step-8

Creating view in ssms Step 8

Creating view using T-SQL

CREATE VIEW hiredate_view  
AS   
SELECT p.FirstName, p.LastName, e.BusinessEntityID, e.HireDate  
FROM HumanResources.Employee e   
JOIN Person.Person AS p ON e.BusinessEntityID = p.BusinessEntityID ;  
GO

Usage

SELECT * FROM hiredate_view

More: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql