Loading Data Driven Insights
Preparing your learning content.
Preparing your learning content.
A beginner-friendly guide to Data Manipulation Language, common DML commands, and how DML is used to read, add, update, and delete table data.
On this page
Jump to a lesson section
DML stands for Data Manipulation Language.
It is the part of SQL used to work with the data stored inside tables.
DML is not mainly about changing table structure. It is about reading, adding, changing, and removing table rows.
DML commands help you interact with records that already live inside a table, or add new records to that table.
DML and DDL both belong to SQL, but they focus on different parts of a database.
DML works with rows inside tables. DDL changes the design or structure of database objects.
DML works with rows inside tables.
DDL changes the design or structure of database objects.
SELECT is a common DML command used to read data from a table.
SELECT
employee_name,
department,
salary
FROM Employees;
The most common DML commands are used to read, add, update, and delete records.
Once your table structure exists, DML helps you read, add, update, and delete records.
SQL Roadmap Progress
Topic 16 of 111
14% complete
Next in SQL Roadmap
Continue with the next SQL topic in the recommended roadmap order.
Continue learning →