Structured Query Language (SQL) is desinged for the retrieval of data from the database. Also it is used to manage the data in the database. SQL is also called as Database Langugae. It is english like so easy to human understanding.
Databases like - Oracle, MS Access, MySQL, PostgreSQL, MS SQL uses SQL as a standard language for database management.
For the management and retrieval of data from database, SQL has the following categories of commands.
- DDL - Data Definition Language
- DML - Data Manipulation Language
- DCL - Data Control Language
- TCL - Transaction Control Language
The following tutorials will give detailed explanation on each of the SQL Commands.
- DDL - Create, Alter, Drop, Truncate
- DML - Select, Insert, Update, Delete
- DCL - Grant, Revoke
- TCL - Commit, Rollback
Tutorials : Geeksforgeeks Javatpoint
