SQL Basic Syntax Principles

1. What is SQL

SQL is for Structured Query Language. It uses for accessing and manipulating the databases. It is based on ANSI(American National Standards Institute) standard.

2. What can SQL do.

Basically, it can insert/delete/update/retrieve/create data or  database.

 3. Basic SQL Commands

SELECT - extracts data from a database.

UPDATE - updates data in a database.

DELETE - deletes data from a database.

INSERT INTO - insert new data into a database

  CREATE DATABASE - creates a new database

ALTER DATABASE - modifies a database

CREATE TABLE - create a new table

ALTER TABLE - modifies a table

DROP TABLE - deletes a table

CREATE INDEX- create an index

DROP INDEX - deletes an index