SQL

Introduction:
           1) SQL stands for Structured Query Language.
           2) SQL is used to interact with the databases.
           3) SQL is used to define,retrive,and manipulate data in the tables.  
           4) SQL has several parts(statements).
           5) SQL statements are not case sensitive.
Parts Of SQL: 
  1.  Data Retrival
    • SELECT---> Retrives data from the database.
  2. Data Manipulation Language
    • INSERT,UPDATE,DELETE,MERGE--->Enters new rows,changes existing rows and removes unwanted rows from the tables in the database.
  3. Data Definition Language
    • CREATE,ALTER,DROP,RENAME,TRUNCATE--->Create,change and remove data structure from tables.
  4. Transaction Control
    • COMMIT,ROLLBACK,SAVEPOINT--->Manages the changes made by DML Statements.
  5. Data Control
    • GRANT,REVOKE--->Gives or Removes access rights to the database and the structures with it.