What Is SQL?

SQL Stand For Structured Query Language, is used in Relational Database Management System.

SQL is a Computer Programming Language for storing, manipulating, and retrieving data stored in a relational database.



SQL is the standard language for DBMS, All Relational Database Management System (RDMS)such as MySQL, MS Access, Oracle, Sybase, Postgre, and SQL.

Mainly software used for SQL Server includes Microsoft AccessMySQL, and Oracle.





  Advantage of MySQL

  • We can manage large data amounts in the database.
  • Users have the ability to create and drop databases and tables.
  • Allows SQL users to access data in a relational database management system.       






SQL was developed at IBM by Donald DChamberlin and Raymond F. Boyce after learning about the relational model from Ted Codd in the 1970s.

SQL was the first commercial language to utilize Edgar F. Codd’s relational model. The model was described in his 1970 paper.




Relational Software, Inc. introduced the first commercially available implementation of SQL, Oracle V2 (Version2) for VAX computers in June.



In 1987, SQL became a standard of the International Organization for Standardization (ISO).



Some Important SQL Command 

  1. DDL- Data Definition Language
  2. DML- Data Manipulation Language
  3. DQL- Data Query Language
  4. DCL- Data Control Language



DDL is a Computer Language That plays the main role in the creation of database language. It is used to specify the database schema and database structure. Through this, both the database schema and database structure are defined as well.

Some commands are also used 

· Create: To Create a new Database and Table.

· Drop: To use to delete data from the table.

· After: It is used to alter the content in the table.


DML stands for "Data Manipulation Language". Data manipulating language It is a computer programming language. We can insert, deleting, and modifying data with the help of DML.

Some commands are also used

· Insert: To insert data rows/records in a table.

· Update: To update data rows/records in the table.

· Delete: To delete records in a table.


DQL is used to retrieve data from the database and is collectively called DQL.

Some commands are also used

· Select: To used table select in the database.


DCL is used to control access to data stored in the database are called DCL.

Some command is also used

· Grant:  All user access privileges to the database.

· Revoke: In Revoke withdraw user’s access privileges given by using the GRANT command.


SQL Important Statements


To use create a new database and table.


To use a select table in the database.


To insert rows/records in the table.


To update rows/records in the table.


To delete rows/records in the table.


Too used to delete objects from the database.


It is used to change the content in the table.


Post a Comment