INTRODUCTION OF SQL

1.                                 INTRODUCTION OF SQL

1.WHAT IS SQL???

:-Before the definition of sql i would like to make you understand that what is ORACLE????

• ORACLE IS a company that make RDMS software which is highly dependendent on server based and multiuser system based .
•  It support sql language.
• V2 was the first oracle product. 

why sql????

• Because it is common language that support all RDMS.
• SQL is structured query language by which we can easily create table,select table,insert table,update the table,modify the table.
• Also we give grant to table,revoke the table,commit the table ,rollback the table by running the query..

we understand these query on later class.

SOME SQL STATEMENT:

• SELECT,INSERT,UPDATE,DELETE,MERGE KNOWN AS DATA MANUPULATION LANGAUGE.(DML)
• CREATE,ALTER DROP,RENAME,TRUNCATE,COMMENT KNOWN AS DATA DEFINITION LANGUAGE(DDL) 

•  GRANT,REVOKE.

• COMMIT,ROLLBACK,SAVEPOINT.
•  

AND MANY MORE I WILL DISCUSS  ALL THESE QUERY IN LATER CLASS.

we give you a complete guide just follow step by step.

THANKU YOU