Introduction

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.

   

                                                OR


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.       

 

  

History

 

1970

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.

 

 

 1979

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

 

1987

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

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


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


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


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


Create


To use create a new database and table.


Select


To use a select table in the database.


Insert

To insert rows/records in the table.


Update    

To update rows/records in the table.


Delete    

To delete rows/records in the table.


Drop     

Too used to delete objects from the database.


Alter 

It is used to change the content in the table.

                                            

Post a Comment

0 Comments