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

        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