SQL Introduction
SQL is a non procedural language which was introdural Language which was introduced by the IBM in 1970’s.Which is used to Communicate with database.
SQL is also called as sequeal of CLI Language (Common Language Interface).This is only the language which can use to Communicate with any RDBMS product.
SQL is not Case sensitive language that we can write SQL SQL Predefined queries or syntaxes in any case characters.(either upper or lower).
Every SQL Statement should ends with a semicolon but it is optional in sql server.
Sub Language of SQL :
🡆Data Defination Language(DDL) : Create,Alter,Sp_Rename,Truncate,Drop
🡆Data Manupulation Language(DQL): INSERT, UPDATE, DELETE
🡆Data query Language(DQL) : select
🡆Transaction Control Language(TCL) :Commit,RoLLBack,Savepoint
🡆Data Control Language(DCL): Grant,Revoke,