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

Creating view in ssms step 1

Creating view in ssms step 2

Creating view in ssms step 3

Creating view in ssms step 4

Creating view in ssms step 5

Creating view in ssms step 6

Creating view in ssms step 7

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