Different types of SQL commands with examples

How To Learn SQL Fast From Scratch

Data Definition Language (DDL)

Data Manipulation Language (DML)

Data Query Language (DQL)

Data Control Language (DCL)

Transaction Control Language (TCL)

How to learn SQL fast

[{"selector":"#anim-d865e2a2-fe3a-4e23-997d-e41e308e88c7","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5e9561c7-e7da-43fd-b094-81de2e9efd90","keyframes":{"opacity":[0,1]},"delay":0,"duration":6000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-26f1fc6c-ccfd-4bf4-b989-05094429f473","keyframes":{"transform":["rotate(90deg) translate3d(81.53477%, 0px, 0) rotate(-90deg)","rotate(90deg) translate3d(0px, 0px, 0) rotate(-90deg)"]},"delay":0,"duration":6000,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-89d1c3df-336a-46e5-ab6c-e8622f2196bb [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(3.3045977011494228%, 0, 0)","translate3d(0%, 0, 0)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"both"}] [{"selector":"#anim-cd18bbd9-941d-4e94-bde1-0d13a3487595","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-876f5029-a0f3-47b2-88d1-93246a9816f5","keyframes":{"opacity":[0,1]},"delay":0,"duration":2000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Flight Path

How To Learn SQL Fast From Scratch

Data Definition Language (DDL)

DDL commands are used to define structure of data. Example - Create , Alter , Drop

----------------------

Data Manipulation Language (DML)

DDL commands are used to manipulate data within database. Example - Create , Alter , Drop

----------------------

Data Query Language (DQL)

DQL commands are used to query data from database. Example - Select

----------------------

Data Control Language (DCL)

DCL commands manage permissions and access controls Example - Grant , Revoke

----------------------

Transaction Control Language (TCL)

TCL commands manage transactions in the database Example - Commit , Rollback

----------------------

How to learn SQL fast

Another Story

Read Article

Types of SQL command - Full Guide