×
FREE ASSISTANCE FOR THE INQUISITIVE PEOPLE
Tutorial Topics
X
softetechnologies
CREATE TABLE - Structured Query Language
SQL - Structured Query Language - SQL
1043    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.
Sri Sri Ramakrishna Paramahamsa
All troubles come to an end when the ego dies
Sri Sri Ramakrishna Paramahamsa
2466
34.21
Today So Far
Total View (Lakh)
softetechnologies
01/01/2018     33608
28/06/2017     29530
02/08/2017     27024
26/05/2018     26987
15/05/2017     23239
06/07/2017     21773
01/08/2017     21320
25/06/2018     20123
21/04/2018     18620
14/07/2017     16470
softetechnologies