What is SQL - Structured Query Language?

What is SQL - Structured Query Language?

SQL (Structured Query Language) is defined as a programming language for Relational Databases. 

Features of SQL

1. It is designed over relational algebra and tuple relational calculus. 

2. SQL comes as a package with all major distributions of RDBMS.

3. SQL consists of both data definition and data manipulation languages. 

4. By means of the data definition properties of SQL, one can design and modify database schema, but data manipulation properties allows SQL to store and retrieve data from database.

Data Manipulation Language in SQL

SQL is furnished with data manipulation language (DML). DML is in charge for all forms of data modification in a database. DML modifies or amends the database instance by inserting, updating, and deleting its data. SQL has the following set of commands in its DML section:

1. SELECT/FROM/WHERE

2. INSERT INTO/VALUES

3. UPDATE/SET/WHERE

4. DELETE FROM/WHERE

These basic constructs let database programmers and users to input data and information into the database and retrieve efficiently using a number of filter options.