Getting started with SQL commands
Introduction:
SQL stands for Structured Query Language.SQL is used to communicate (store data/manage data) with RDBMS(Relational Database Management System). It is used to perform data operations on RDBMS.
SQL follows different ways to manipulate data. The basic commands in SQL are bifurcated into 5 commands:
- DDL
- DML
- TCL
- DQL
- DCL
Data manipulation language (DML)
INSERT, UPDATE, DELETE, MERGE
Note : Rollback is applicable
Data definition language (DDL)
CREATE, ALTER, DROP, RENAME, TRUNCATE
Note : Rollback is not applicable
Transaction control language (TCL)
COMMIT, ROLLBACK, SAVEPOINT
Data query language (DQL)
SELECT
Data control language (DCL)
GRANT, REVOKE
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.
Lorem ipsum dolor sit amet, consectetur adipisicing elit. Optio, neque qui velit. Magni dolorum quidem ipsam eligendi, totam, facilis laudantium cum accusamus ullam voluptatibus commodi numquam, error, est. Ea, consequatur.
