SQL stands for structured query language ,It is the standard language used to communicate with relational databases.
It is used to
- store data
- Retrieve data
- Update data
- Delete data
- Manage database structure
Almost every major relational databases uses SQL ,including
Microsoft SQL Server(MsSql)
MySql
PostgreSql
Oracle Database
Even though each system has small differences, the core SQL concepts remain the same.
Types of SQL Commands:
DDL :Data Definition Language
DML :Data Manipulation Language
DQL :Data Query Language
DCL :Data Control Language
TCL :Transaction Control Language