Hello Followers today i will explain very small information but actually for me it is more good info because we should no the concept for our tools we are working on it so As we are DBA , DB Analyst or Developer we should know what is meaning of SQL Command ? and what is SQL ?
What is SQL?
SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in relational database.
SQL is the standard language for Relational Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server use SQL as standard database language.
Also, they are using different dialects, such as:
- MS SQL Server using T-SQL,
- Oracle using PL/SQL,
- MS Access version of SQL is called JET SQL (native format), etc
Meaning of SQL Command :
SQL Commands are mainly classified into four types, which are DDL command, DML command, TCL command and DCL command.
SQL is mainly divided into four sub language
- Data Definition Language(DDL)
- Data Manipulation Language(DML)
- Transaction Control Language(TCL)
- Data Control Language(DCL)