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.
SQL is just a query language, it is not a database. To perform SQL queries, you need to install any database, for example, Oracle, MySQL, MongoDB, PostGre SQL, SQL Server, DB2, etc.
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
SELECT column1, column2....columnN FROM table_name;
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 {ADD|DROP|MODIFY} column_name {data_ype};
INSERT INTO table_name( column1, column2....columnN) VALUES ( value1, value2....valueN);