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