Understanding the Types of SQL Commands: A Student‑Friendly Guide

 

SQL (Structured Query Language) is not just one set of instructions; it is divided into different command categories based on what task they perform. Each category has a specific role in interacting with databases. Grouping commands this way helps students understand what a command does before learning how to write it.

The handwritten notes divide SQL commands into four main types:

• DDL
• DML
• DQL
• DCL

Each type is clearly highlighted in a small coloured box, making it easy to visually separate and revise.

---

DDL – Data Definition Language

The first category explained is DDL (Data Definition Language). These commands are used to define and manage the structure of the database.

In simple words, DDL commands decide how the database and tables are made.

The notes explain this concept briefly and then list clear examples:

• CREATE TABLE – used to create a new table
• ALTER TABLE – used to change the structure of an existing table
• DROP TABLE – used to delete a table completely

Important words like CREATE, ALTER, and DROP are underlined, helping students focus on keywords that are commonly asked in exams. Small drawings of tables and tools visually support the idea that DDL commands work on database structure rather than data.

---

DML – Data Manipulation Language

Next comes DML (Data Manipulation Language), which deals with the actual data stored inside tables.

The notes explain DML in very simple language:
It is used to manipulate data in the table.

The commonly used DML commands are listed:

• INSERT – add new data
• UPDATE – modify existing data
• DELETE – remove data

These commands are easy to remember because their names describe their actions. The handwritten notes reinforce this idea with icons like documents, pencils, and dustbins, making the learning process more visual and intuitive.

---

DQL – Data Query Language

The third category is DQL (Data Query Language). This section is short but very important because it covers how data is retrieved from the database.

The notes clearly state:

• DQL is used to fetch data from the database
• The main command is SELECT

Since SELECT is one of the most frequently used SQL commands, it is neatly underlined and supported by a magnifying glass illustration, symbolizing searching or retrieving information.

---

DCL – Data Control Language

The final category is DCL (Data Control Language), which focuses on database security and access control.

In simple terms, DCL commands decide who can use the data.

The notes list two key commands:

• GRANT – give permission
• REVOKE – remove permission

Icons of keys and locks help visually explain the idea of access and security. This makes it easier for students to remember that DCL is related to control and authorization.