Introduction: SQL

SQL, or Sequenced Query Language, is a domain-specific language used in RDBMS to communicate with the database. 

Uses:


Based on the uses of SQL statements, there are four main categories of SQL:

DDL (Data Definition Language)

Data Definition Language (DDL) are the SQL statements that are used to define the database schemas. DDL, mostly:

DML (Data Manipulation Language)

Data Manipulation Language (DML) is used to for the manipulation of the data in a database. 

DQL (Data Query Language)

Data Query Language (DQL) is used to perform queries on a database. 

DCL (Data Control Language)

Data Control Language (DCL) contains statements that deals with the data security, such as permission to use, and control the database.


** MySQL != SQL **

MySQL is a RDBMS. It is a software system that allows user to store and utilize the data appropriately. The data handling in MySQL is performed using a query programming language, called SQL.