SQL (Structured Query Language)


The standard language for manipulating databases


Consists of two parts:

  • DML(Data Manipulation Language), query and update commands:
    • SELECT - extracts a copy of the requested data from a database
    • UPDATE - updates data in a database
    • DELETE - deletes data from a database
    • INSERT INTO - inserts new data into a database
  • DDL(Data Definition Language), create and delete tables:
    • CREATE DATABASE - creates a new database
    • ALTER DATABASE - modifies a database
    • DROP DATABASE - deletes a database
    • CREATE TABLE - creates a new table
    • ALTER TABLE - modifies a table
    • DROP TABLE - deletes a table
    • CREATE INDEX - creates an index (search key)
    • DROP INDEX - deletes an index

Leave a Reply