SQL Introduction

  

•        SQL stands for Structured Query Language
•        SQL statements are used to retrieve and update data in a database
•        Is a Non-procedural query language
•        Used for creating, managing, manipulating and querying the database objects such as tables, views etc. 

       
            SQL is divided into the following

                          Data Definition Language (DDL)

                          Data Manipulation Language (DML)

     Data Retrieval Language (DRL)

     Transaction Control Language (TCL)

     Data Control Language (DCL)

DDL -- create, alter, drop, truncate, rename

DML -- insert, update, delete

DRL -- select

TCL -- commit, rollback, savepoint

DCL -- grant, revoke