SQL - Database Language

Posted by AnithaKamatchi on Thursday, March 02, 2017 in SQL | No comments

What is SQL?????

SQL stands for Structured Query Language. We are storing large volume of data in databases. So how the human interact with the database to store and retrieve the data, There comes the language which helps us to communicate with database called Structured Query Language (SQL). SQL is known as the standard language for relational database management systems.

Types of SQL 

There are two main types of SQL statement 

• DDL - Data Definition Language
• DML - Data Manipulation Language

Data Definition Language - DDL

As the name suggests it is mainly used to describe how the data resides in the database. Under DDL we have the following

• Create
• Alter
• Drop

Data Manipulation Language - DML

DML is mainly used for manipulating the data stored in the database. Under DML we have the following

• Select
• Insert 
• Update