What is SQL?

SQL became a standard of the American English language(ANSI) in 1986, and of the International Organisation for Standardization(ISO) in 1987.

SQL is a short-form of the structured query language which lets you access and manipulate the database. SQL is not a database system, but it is a query language.

What can SQL do?

SQL can execute queries on the database. Queries that can be used to create and set permission on new tables, views, and store procedures, insert, retrieve, update and delete data from the database tables, views, etc.

This language is specially designed for maintaining the data in the relational database management system.

Where can SQL use?

If you want to get yourself in the field of data science or big data, then it is the most important query language to learn. Big Companies like Facebook, Instagram, and LinkedIn, use SQL for handling their websites data.

Different Types of SQL Queries

1. DDL (data definition language)

• Create
• Alter
• Drop
• Truncate

2. DML (data manipulation language)

• Insert
• Update
• Delete

3. DCL (data control language)

• Grant
• Revoke

4. TCL (transaction control language)

• Commit
• Rollback
• Save Point

5. DQL (data query language)

• Select

I hope this information will help you to understand the basic concept of SQL. Thank you, and if you like my post please share it with your friends too.