What is SQL?
SQL stands for Structured Query Language.You access and manipulate databases.
RDBMS
RDBMS ( Relational Database Management System) is the basis for SQL, and for all modern database systems such as MS SQL Server, MySQL etc.
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.
SQL Important Commands
SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies 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