{"id":191495,"date":"2024-12-18T06:35:00","date_gmt":"2024-12-18T05:35:00","guid":{"rendered":"https:\/\/liora.io\/en\/?p=191495"},"modified":"2026-02-17T08:40:02","modified_gmt":"2026-02-17T07:40:02","slug":"all-about-data-manipulation-language","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/all-about-data-manipulation-language","title":{"rendered":"Data Manipulation Language (DML): What is it?"},"content":{"rendered":"\n<p><b>In the realm of data management, SQL stands as a fundamental pillar. At the core of this language is DML, a collection of commands crafted for professionals tasked with leveraging the invaluable asset of information.<\/b><\/p>\n\n\n\n<p>What is meant by Data Manipulation Language (DML)? These are the commands of the fundamental language for database management known as <a href=\"https:\/\/liora.io\/en\/sql-learn-all-about-the-programming-language-for-databases\">SQL<\/a>. <b>DML is employed to access and modify data<\/b>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-the-purpose-of-dml\">What is the purpose of DML?<\/h2>\n\n\n\n<p>Let&#8217;s liken a database to a municipal library. The DML would be the set of tools needed to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>borrow a book (select data),<\/li>\n\n\n\n<li>mark it as borrowed (update data),<\/li>\n\n\n\n<li>indicate it has been returned (delete data),<\/li>\n\n\n\n<li>add new ones (insert data) onto the shelves.<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/liora.io\/en\/top-10-programming-languages\">SQL is a language that allows such manipulations at the IT level<\/a>. It primarily assists in the creation of tables that can be interconnected via common fields. In the library example, one table could catalog each book by its ISBN identifier, detailing its title and author, while another table might show which customer borrowed which book, once again identified by ISBN.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/data-scientist\">Follow a course in Data Science<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-sql-command-families\">SQL Command Families<\/h2>\n\n\n\n<p>SQL manages several command families:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><b>Data Definition Language<\/b> (DDL) \u2013 used to define the structure of a database and its contents.<\/li>\n\n\n\n<li><b>Data Manipulation Language<\/b> (DML) \u2013 the focus of this article.<\/li>\n\n\n\n<li><b>Data Query Language<\/b> (DQL) \u2013 used to search for information within a database or table.<\/li>\n\n\n\n<li><a href=\"https:\/\/liora.io\/en\/all-about-data-control-language\"><b>Data Control Language<\/b><\/a> (DCL) \u2013 defining access controls in databases,<\/li>\n\n\n\n<li><b>Transaction Control Language<\/b> (TCL) \u2013 instructions that permanently validate updates made or allow a rollback to a previous state.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2024\/11\/data-manipulation-language-dml-datascientest-1.webp\" alt=\"\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-dml-commands\">DML Commands<\/h2>\n\n\n\n<p>The key DML commands include:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><b>SELECT<\/b>: to retrieve data from one or more tables.<\/li>\n\n\n\n<li><b>INSERT<\/b>: add new rows into a table.<\/li>\n\n\n\n<li><b>UPDATE<\/b>: modify values in existing rows.<\/li>\n\n\n\n<li><b>DELETE<\/b>: remove rows from a table<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-select\">SELECT<\/h3>\n\n\n\n<p>This is the most frequently used DML command, enabling a variety of analyses. It assists in extracting crucial information, aggregating data, and is instrumental in generating reports or presentations.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-insert-update-and-delete\">INSERT, UPDATE, and DELETE<\/h3>\n\n\n\n<p>These commands are used to update information, which is crucial for a database to remain up-to-date, ideally in real-time, to avoid working with outdated elements.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-automated-processing\">Automated Processing<\/h2>\n\n\n\n<p>DML also enables the automation of certain repetitive tasks through SQL scripts, such as importing new elements.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/data-analyst\">Become a Data Analyst<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-importance-of-data-manipulation-language\">The Importance of Data Manipulation Language<\/h2>\n\n\n\n<p>DML offers a suite of commands that is notably easy to learn and apply. The standardization of <a href=\"https:\/\/liora.io\/en\/all-about-sql3\">SQL language<\/a> facilitates the use of DML with databases from various providers: Oracle, MongoDB, <b>IBM<\/b>, <b>Ingres<\/b>, and more. Additionally, DML allows for the execution of complex operations on large datasets with high precision.<\/p>\n\n\n\n<p>DML is crucial for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cleaning data on a daily basis : correcting errors, resolving inconsistencies, and addressing missing values.<\/li>\n\n\n\n<li>Transforming data: converting it into a format suitable for analysis.<\/li>\n\n\n\n<li>Preparing data for modeling.<\/li>\n\n\n\n<li>Exploring data: identifying trends, and establishing correlations.<\/li>\n\n\n\n<li>Developing applications.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-who-uses-the-data-manipulation-language\">Who Uses the Data Manipulation Language?<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/liora.io\/app\/uploads\/sites\/9\/2024\/11\/data-manipulation-language-dml-datascientest-2.webp\" alt=\"\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-data-scientists\">Data Scientists<\/h3>\n\n\n\n<p>In their roles, data scientists spend a considerable amount of time manipulating data. Often, before analysis, they must thoroughly prepare and even clean the data, such as by eliminating unnecessary records. They may also need to create temporary tables to test a model or specific approach.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-data-analysts\">Data Analysts<\/h3>\n\n\n\n<p>Data analysts frequently employ DML to extract the data essential for their analyses. They aim to derive insights from the data at their disposal.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-database-administrators-dba\">Database Administrators (DBA)<\/h3>\n\n\n\n<p><a href=\"https:\/\/liora.io\/en\/database-administrator-role-and-training\">Database administrators<\/a> use DML to oversee daily operations concerning data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-developers\">Developers<\/h3>\n\n\n\n<p>Developers can integrate DML instructions into their applications to enhance interaction with the company&#8217;s data repositories.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-dml-an-essential-tool\">The DML: An Essential Tool<\/h2>\n\n\n\n<p>The DML is a crucial tool within <a href=\"\/en\/courses\/data-ai\/data-management\">the data management sphere<\/a>. Its remarkable ease of use is matched by its potent capabilities, making it a preferred choice for those leveraging data in strategies for business development. Although numerous alternatives have emerged, <b>proficiency in SQL&#8217;s DML<\/b> continues to be a valuable asset in the data industry.<\/p>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link wp-element-button\" href=\"\/en\/courses\/data-ai\/\">Discover our data courses<\/a><\/div>\n<\/div>\n\n\n\n<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [\n    {\n      \"@type\": \"Question\",\n      \"name\": \"What is Data Manipulation Language (DML)?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"Data Manipulation Language (DML) is a subset of SQL used to manage and modify the data stored in a database. It allows users to insert, update, delete, and retrieve records from database tables without changing the database structure itself.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"What are the main DML commands?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"The main DML commands are SELECT, INSERT, UPDATE, and DELETE. SELECT retrieves data from a table, INSERT adds new records, UPDATE modifies existing data, and DELETE removes records from the database.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"What is the difference between DML and DDL?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"DML is used to manipulate the data inside database tables, while DDL (Data Definition Language) is used to define and modify the structure of the database itself. DDL commands include operations such as creating, altering, or dropping tables, whereas DML works only with the stored data.\"\n      }\n    },\n    {\n      \"@type\": \"Question\",\n      \"name\": \"Why is DML important?\",\n      \"acceptedAnswer\": {\n        \"@type\": \"Answer\",\n        \"text\": \"DML is essential because it enables applications and users to interact with database content. It supports daily operations such as querying information, maintaining records, and updating datasets, making it a fundamental component of database management and data-driven applications.\"\n      }\n    }\n  ]\n}\n<\/script>\n\n","protected":false},"excerpt":{"rendered":"<p>In the realm of data management, SQL stands as a fundamental pillar. At the core of this language is DML, a collection of commands crafted for professionals tasked with leveraging the invaluable asset of information. What is meant by Data Manipulation Language (DML)? These are the commands of the fundamental language for database management known [&hellip;]<\/p>\n","protected":false},"author":88,"featured_media":191497,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-191495","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/191495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/88"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=191495"}],"version-history":[{"count":5,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/191495\/revisions"}],"predecessor-version":[{"id":206958,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/191495\/revisions\/206958"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/191497"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=191495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=191495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}