DML: Data Manipulation Language (Contains commands for insert, update and delete operations).DCL: Data Control Language (Contains access control related commands).DDL: Data Definition language (Contains commands to create and modify tasks).SQL is comprised of many types of statements which are classed as SQL sub-languages: It also removes the requirement to specify how to reach a record.Īs SQL is specific to interacting with relational databases, it falls in the category of DSL (Domain Specific Languages). SQL offers the advantage of retrieving multiple records through a single command. It is mainly useful for handling structured data where relations exist between various data entities and variables.

It is employed for writing programs and caters the purpose to manage data stored in the relational database management systems (RDBMS), or for processing data streams in real-time in relational data stream management system (RDSMS). SQL (also pronounced as the sequel) is an acronym for Structured Query Language. Difference Between SQL and MySQL Commands.Difference Between SQL and MySQL in Table Format.

Sql server versions