SQL Oracle PHP Java JSP JDBC MORE

SQL Tutorials


  SQL (Structured Query Language) is a query language which perform relational database operations.

  By using SQL we can we can create database and its object like table view and index.

We have to write SQL Query to perform any kind of operation on database.

Key Statement of SQL:

Insert Statement

Select Statement

Update Statement

Delete Statement

Insert Statement Query

INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...);

Select Statement Query

SELECT column_name,column_name

FROM table_name;

and

SELECT * FROM table_name;

Update Statement Query

UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;

Delete Statement Query

DELETE FROM table_name;

or

DELETE * FROM table_name;