SQ can be divided into 2 parts.
1 : DML (Data Manipulation Language)
2 : DDL (Data Definition Language)
1 : DML (Data Manipulation Language)
- SELECT
- UPDATE
- DELETE
- INSERT INTO
2 : DDL (Data Definition Language)
- CREATE DATABASE
- ALTER DATABASE
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
- CREATE INDEX
- DROP INDEX
Now we are going to learn a little bit about all the Queries used in SQL , with Example.