#2 SQL Crash Course | Components of SQL | SQL for beginners Part-2

There are 3 main components of SQL :->

1. DDL (Data Definition language)
2. DML (Data Manipulation Language)
3. DCL (Data Control Language)

1) DDL :-

It is used to define database, modify its structure after it has been created and destroy it after it is no longer needed. DDL Commands are given below.

a) Create Table 

b) Create View 

c) Alter table 

d) Drop table

2)DML :-

DML is used to manipulate data such as to insert, modify, delete or query the data in the 

database. DML commands are following.

a) Insert 

b) Delete 

c) Update 

d) Select

3)DCL :-

It is used to grant or revoke authorization for database access, auditing the database use and dealing with transactions. There are many ways that a database can be corrupted. The tools provided by the DCL, if properly used will prevent many of these problems. DCL commands are follows.

a) Commit 

b) Roll Back 

c) Grant 

d) Revoke

Note :-

We'll briefly learn about all these sub-parts in upcoming articles.

If you like our posts or want to appreciate our efforts then, you can leave us a your valuable comment in comment section below. Don't forget to join us on telegram channel @Technitesh_com