SQL Server 2022 Developer Editor (Tutorial, Installation, How To)

Article Written by : AMAN SHARMA

What is SQL Server?

• SQL Server is a relational database management system (RDBMS) developed by Microsoft. SQL Server supports ANSI SQL, which is the standard Structured Query Language. However, SQL Server comes with its implementation of the SQL language, T-SQL (Transact-SQL). It is primarily designed and developed to compete with MySQL and Oracle databases.

2.1         Installation Steps

 Step#1: Download the file from the link.

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Step#2: Download the file from the link and open it.

Step#3: Than go and click Download Media.

Step#4: When the Developer Edition open then the click on CAB, and Select the Download Location.

Step#5: Click Download and wait for download.

Step#6: Finish the installation process

Once installation is completed successfully, Then open folder.

Step#7:      When the file open than go to the installation.

Step#7: After that, click on New SQL Server stand-alone installation.

Click next till you reach Licensing then accept the terms and click next.

Step#9: Click next till Instance configuration and select default instance then click next.

Click Next until Database Engine configuration and set authentication then, click Next.

Click accept, then click next Than the Installation progress.

Click the close SQL Server is successfully install.

Open the pre-downloaded setup file and click SQL Server Management tools.

Step#11: A download Page for SSMS will open in browser. Download and open the file then set the installation path and click Install.

The installation process will begin. After it ends click Close and the computer will restart.

Step#12: After the restart you can run SQL Server Management Studio

from start menu to use the database software.

2.1        Data Definition Language (DDL):

èDDL is used to specify a database scheme as a set of definitions expressed on a DDL. DDL statements are compiled, resulting in a set of tables stored in a special file called a data dictionary. The data dictionary contains metadata (data about data). Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

The Data Definition Language (DDL) includes:

• CREATE : to create a database and its objects like (table, index, views, store procedure, function, and triggers).

• ALTER: alters the structure of the existing

• DROP: delete objects from the database
• TRUNCATE: It is used to delete all the rows from the table and free the space containing the table.

2.1  Data Manipulation Language (DML):

èA DML is a language which enables users to access and manipulate data. The goal is to provide efficient human interaction with the system. It is used to store, modify, retrieve, delete and update data in a database.

The Data Manipulation Language (DML) includes:

• SELECT: retrieve data from a

• UPDATE: This command is used to update or modify the value of a column in the table.

• DELETE: Delete all records from a database

• INSERT: insert data into a table

2.1  Data Control Language:

DCL commands are used to grant and take back authority from any database user.

Here are some commands that come under DCL:

 

• Grant: It is used to give user access privileges to a

Example:

GRANT SELECT, UPDATE ON MY_TABLE TO SOME_USER, A NOTHER_USER;

Revoke:

It is used to take back permissions from the user.

Example:

REVOKE SELECT, UPDATE ON MY_TABLE FROM USE1, U SER2;