SQL

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