T-SQL tutorial

Welcome to beginner to advance T-SQL tutorial. In this tutorial I have explained you about basic to advance T-SQL statement .This tutorial also help those person going to DBA(Database Administrator) in future .

What is  T-SQL language ?

T-SQL (Transact Structured Query Language ) is a non-procedural language for changing data in the database . T-SQL encompassed several components , such as

1. DML-(Data Manipulation Language)
   
2. DDL-(Data definition language)
3. DCL –(Data control language ). 
4. TCL (Transactional control Language).

DML-(Data Manipulation Language):-

DML is used to insert, update, delete store  and modify data from database table .

Example :-select ,insert, update ,delete,

DDL-(Data definition language):

DDL  is used to create and modify the structure of database objects from database.
Example : create , alter and drop .

DCL –(Data control language ):

DCL  is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

Example : grant, revoke and  deny

TCL (Transactional Control language)

It is used for manage different transactions occurring within  a database .
Example : rollback, commit