Thursday 4 December 2014

What is SQL and types of SQL Statements ?

What is Sql ?

     It is specific type of Structured query Language , used to manage the DataBase , by retrieving , updating and modifying the database.. 
           



    Types of SQL Statements : 
   
    DML : Data Manipulation Language is used for managing data with in schema Objects. 

            > Select , Insert , Update , Delete.

    DDL : Data Definition Language is used to define db structure or schema. 

           > Alter , Create , Truncate , Drop.Comment,Rename. 

    DCL : Data Control Language is used to control access to data stored in the database. 
          
           > Grant , Revoke. 

     TCL : Transition Control Language is used to control set of actions called transactions                   like insert,update,delete. 

          > Commit , Rollback . 

No comments:

Post a Comment