SQL is referred as Structured Query Language, a standard query language certified by ANSI and ISO. SQL is used to access different databases like SQL Server, MySQL, MS Access, Sybase, Oracle, DB2, Informix and Teradata etc.
SQL is a database computer language designed for the retrieval and management of data in a relational database. This tutorial will give you a quick push towards SQL database. It covers most of the topics required for a basic understanding of SQL and to get a feel of how it works.
SELECT column1, column2....columnN FROM table_name;
SELECT DISTINCT column1, column2....columnN FROM table_name;
SELECT column1, column2. ...columnN FROM table_name WHERE CONDITION;
SELECT column1, column2....columnN FROM table_name WHERE CONDITION-1 {AND|OR} CONDITION-2;
SELECT column1, column2....columnN FROM table_name WHERE column_name IN (val-1, val-2,...val-N);
SELECT column1, column2....columnN FROM table_name WHERE column_name BETWEEN val-1 AND val-2;
SELECT column1, column2....columnN FROM table_name WHERE column_name LIKE { PATTERN };
SELECT column1, column2....columnN FROM table_name WHERE CONDITION ORDER BY column_name {ASC|DESC};
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name;
SELECT COUNT(column_name) FROM table_name WHERE CONDITION;
SELECT SUM(column_name) FROM table_name WHERE CONDITION GROUP BY column_name HAVING (arithematic function condition);
CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );
DROP TABLE table_name;
CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);
ALTER TABLE table_name DROP INDEX index_name;
DESC table_name;
TRUNCATE TABLE table_name;
ALTER TABLE table_name {ADD|DROP|MODIFY} column_name {data_ype};
ALTER TABLE table_name RENAME TO new_table_name;
INSERT INTO table_name( column1, column2....columnN) VALUES ( value1, value2....valueN);
UPDATE table_name SET column1 = value1, column2 = value2....columnN=valueN [ WHERE CONDITION ];
DELETE FROM table_name WHERE {CONDITION};
CREATE DATABASE database_name;
DROP DATABASE database_name;
USE database_name;
COMMIT;
ROLLBACK;