What is transact-SQL? Describe its types?

1.Data Definition Language (DDL)
2.Data Control Language (DCL)
3.Data Manipulation Language (DML)

Data Definition Language (DDL)
It allows creating, altering and dropping database objects.

Data Control Language (DCL)

It is used to control access to data in the database.
It controls permission on the database objects using grant, revoke or deny statement.

Data Manipulation Language (DML)

It involves retrieval, insertion, deletion, modification in the database.
It includes select, insert, update, and delete command.