SQL - Structured Query Language
softetechnologies
28-03-2018    458 times
SQL

SQL

The full form of SQL is Structured Query Language. It is a language which handles the database, Specially RDBMS (Relational Database Management System) like MySQL, MS Access, Sybase, Oracle, Informix, SQL Server and Postgres. We can manage the following task through SQL –

  1. Create Database
  2. Alter Database
  3. Drop Database
  4. Insert data
  5. Update data
  6. Delete data
  7. Select data
  8. Save the action
  9. Revoke the action
  10. Grand the permission to a selective user
  11. Revoke the permission to a selective user

It is a ANSI(American National Standards Institute) standard language.

Types of SQL

Four types of SQL are available for doing different database related task

  • DDL – DATA DEFINITION LANGUAGE
    1. CREATE - Create table
    2. ALTER - Alter the table structure
    3. DROP - Delete table
  • DML - DATA MANIPULATION LANGUAGE
    1. INSERT - Insert tupple in a table
    2. UPDATE- Update the inserted tupple
    3. DELETE- Delete the inserted tupple
    4. SELECT- Select the tupple depend on the condition
  • Private Teacher

  • TCL
    1. COMMIT- save the action
    2. ROLLBACK- undo the action
  • DCL
    1. GRANT - Grant the different permission to a user.
    2. REVOKE- Revoke the different permission to a user.
SQL TYPES
SQL TYPES
softetechnologies
softetechnologies
    Author Details
Arnab De
I have over 16 years of experience working as an IT professional, ranging from teaching at my own institute to being a computer faculty at different leading institute across Kolkata. I also work as a web developer and designer, having worked for renowned companies and brand. Through tutorialathome, I wish to share my years of knowledge with the readers.
    Related Post
  Query About the post