×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
CREATE TABLE - Structured Query Language
SQL - Structured Query Language - SQL
1722    Arnab De    28/03/2018

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.

softetechnologies

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
  • softetechnologies

  • 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
CREATE TABLE - Structured Query Language
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.
Enter New Comment
Comment History
No Comment Found Yet.
Albert Einstein
Education is not the learning of facts. It is rather the training of the mind to think
Albert Einstein
16064
52.47
Today So Far
Total View (Lakh)
softetechnologies
26/05/2018     41979
01/01/2018     35991
28/06/2017     34082
25/06/2018     33432
02/08/2017     32394
01/08/2017     26806
06/07/2017     26783
15/05/2017     26415
14/07/2017     21851
21/04/2018     20711
softetechnologies