SQL Server Tutorials

Getting started with MS SQL Server

SQL Stands for Structured Query Language. It is a relational database management system (RDBMS), developed by Microsoft.

SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

Let’s get started with below topics-

What is SQL SERVER?

CREATE TABLE

INSERT

UPDATE

DELETE

SELECT

SQL Keys

SQL Commands

Alter Table

IDENTITY Functions in SQL Server

SQL Server Configurations Functions

SQL OUTPUT Clause

Query Optimization in SQL Server

Replicate Function in SQL Server

SQL CAST vs TRY_CAST()

SQL CONVETRT vs TRY_CONVERT 

Full Database Backup Script in SQL Server

SQL Server Dirty Read Concurrency

BEGIN TRAN

ROLLBACK TRANSACTION

COMMIT TRANSACTION

SAVEPOINT TRANSACTION