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