SQL (pronouncing as 'sequel') means Structured Query Language. It is a programming language to manage data in a DBMS or RDBMS. SQL is the back bone of any modern RDBMS.
SQL developed by IBM in 1970. In 1986 ANSI standardized the SQL.
SELECT - Uses to fetches and displaying the data in a structured manner.
INSERT - Uses to store data into the database.
UPDATE - Update or modify the stored data.
DELETE - Removing the stored data.
SELECT statement is the most widely and frequently used one.
To explain the above statements we need to define a table first. Assume tat
EMP table stores employee details like Empno, Name, Age,
Structure of EMP Table
There are 4 records in EMP table.
Example :- select * from EMP;
The above statement will fetch all records from a table called EMP.
Example :- insert into EMP values(50,‘Lo‘,33);
The above statement will insert one records into EMP table.
Example :- update EMP set name = ‘Lopez‘ where Empno = 50;
The above statement will update name column in EMP table.
Example :- delete from EMP where Empno = 50;
Explanation :-The above statement will update name column in EMP table.