{"id":254532,"date":"2024-11-01T06:30:00","date_gmt":"2024-11-01T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=254532"},"modified":"2024-10-22T12:05:04","modified_gmt":"2024-10-22T12:05:04","slug":"data-manipulation-language-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir","title":{"rendered":"Data Manipulation Language (DML) : Qu&rsquo;est-ce que c&rsquo;est ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"254532\" class=\"elementor elementor-254532\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-25cbcfc e-flex e-con-boxed e-con\" data-id=\"25cbcfc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-88fedce elementor-widget elementor-widget-text-editor\" data-id=\"88fedce\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>Dans le monde de la gestion des donn\u00e9es, le SQL reste un pilier incontournable. Et au c\u0153ur de ce langage se trouve le DML, un ensemble d&rsquo;instructions destin\u00e9es aux professionnels ayant pour mission d\u2019exploiter cette denr\u00e9e pr\u00e9cieuse qu\u2019est l\u2019information.<\/strong><\/p><p><span style=\"font-weight: 400;\">Qu\u2019entend-on par Data Manipulation Language (DML) langage de manipulation de donn\u00e9es ? Des commandes \u2013 du langage essentiel \u00e0 la gestion des bases de donn\u00e9es qu\u2019est <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">SQL<\/a>. <strong>Le DML sert \u00e0 acc\u00e9der aux donn\u00e9es et \u00e0 les modifier<\/strong>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f4af160 e-flex e-con-boxed e-con\" data-id=\"f4af160\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e71a16e elementor-widget elementor-widget-heading\" data-id=\"e71a16e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">\u00c0 quoi sert le DML ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e068a45 elementor-widget elementor-widget-text-editor\" data-id=\"e068a45\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Comparons une base de donn\u00e9es \u00e0 une biblioth\u00e8que municipale. Le DML serait l&rsquo;ensemble des outils n\u00e9cessaires pour qu\u2019il soit possible :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">d&#8217;emprunter un livre (s\u00e9lectionner des donn\u00e9es),<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">de le marquer comme emprunt\u00e9 (modifier des donn\u00e9es)<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">d\u2019indiquer qu\u2019il a \u00e9t\u00e9 rapport\u00e9 (supprimer des donn\u00e9es),<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">d&rsquo;en ajouter de nouveaux (ins\u00e9rer des donn\u00e9es) sur les \u00e9tag\u00e8res.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9018330 elementor-widget elementor-widget-text-editor\" data-id=\"9018330\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/top-10-des-langages-de-programmation\">SQL est un des langages<\/a> qui autorisent de telles manipulations au niveau informatique. Avant tout, il aide \u00e0 la cr\u00e9ation de tables que l\u2019on pourra relier entre elles au moyen de champs communs. Dans l\u2019exemple de la biblioth\u00e8que, une table pourrait stocker chaque livre selon son identifiant ISBN et indiquer quel est son titre et son auteur, tandis qu\u2019une autre table, indiquerait quel client a emprunt\u00e9 quel livre, l\u00e0 encore identifi\u00e9 par son ISBN.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d9fc463 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d9fc463\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir nos formations en data<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-117e7bc elementor-widget elementor-widget-heading\" data-id=\"117e7bc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Familles de commandes SQL<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-639296d elementor-widget elementor-widget-text-editor\" data-id=\"639296d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL g\u00e8re diverses familles de commandes :<\/span><\/p><ul><li><b>Data Definition Language<\/b><span style=\"font-weight: 400;\"> (DDL) \u2013 qui servent \u00e0 d\u00e9finir la forme d\u2019une base de donn\u00e9es et de son contenu.<\/span><\/li><li><b>Data Manipulation Language<\/b><span style=\"font-weight: 400;\"> (DML) \u2013 celles que nous abordons dans le pr\u00e9sent article.<\/span><\/li><li><b>Data Query Language<\/b><span style=\"font-weight: 400;\"> (DQL) \u2013 pour rechercher des informations dans une base ou une table.<\/span><\/li><li><b>Data Control Language<\/b><span style=\"font-weight: 400;\"> (DCL) \u2013 d\u00e9finition des contr\u00f4les d\u2019acc\u00e8s \u00e0 la base de donn\u00e9es,<\/span><\/li><li><b>Transaction Control Language<\/b><span style=\"font-weight: 400;\"> (TCL) \u2013 des instructions qui valident de fa\u00e7on permanente les mises \u00e0 jour effectu\u00e9es ou bien permettent de revenir \u00e0 un \u00e9tat ant\u00e9rieur.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-520e15e elementor-widget elementor-widget-image\" data-id=\"520e15e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1000\" height=\"571\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-1.webp\" class=\"attachment-full size-full wp-image-254562\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-1.webp 1000w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-1-300x171.webp 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-1-768x439.webp 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a5f3350 e-flex e-con-boxed e-con\" data-id=\"a5f3350\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-93d3491 elementor-widget elementor-widget-heading\" data-id=\"93d3491\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Les commandes DML<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-843d457 elementor-widget elementor-widget-text-editor\" data-id=\"843d457\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les principales commandes DML incluent :<\/span><\/p><ol><li><b>SELECT<\/b><span style=\"font-weight: 400;\"> : pour r\u00e9cup\u00e9rer des donn\u00e9es d\u2019une ou plusieurs tables.<\/span><\/li><li><b>INSERT<\/b><span style=\"font-weight: 400;\"> : ajout de nouvelles lignes dans une table.<\/span><\/li><li><b>UPDATE<\/b><span style=\"font-weight: 400;\"> : modification des valeurs dans des lignes existantes.<\/span><\/li><li><b>DELETE<\/b><span style=\"font-weight: 400;\"> : suppression de lignes d\u2019une table\u00a0<\/span><\/li><\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f75a8b3 elementor-widget elementor-widget-heading\" data-id=\"f75a8b3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">SELECT<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-693ffde elementor-widget elementor-widget-text-editor\" data-id=\"693ffde\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Nous avons ici la commande la plus utilis\u00e9e du DML, celle qui va autoriser toutes sortes d\u2019analyses. Elle va aider \u00e0 faire ressortir des informations cruciales, regrouper des donn\u00e9es, servir \u00e0 la g\u00e9n\u00e9ration de rapports ou de pr\u00e9sentations graphiques.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75a9e99 elementor-widget elementor-widget-heading\" data-id=\"75a9e99\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">INSERT, UPDATE et DELETE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de9f983 elementor-widget elementor-widget-text-editor\" data-id=\"de9f983\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Ces commandes servent \u00e0 la mise \u00e0 jour des informations et clairement, il est majeur qu\u2019une base de donn\u00e9es soit actualis\u00e9e, autant que possible en temps r\u00e9el, pour \u00e9viter que l\u2019on op\u00e8re sur des \u00e9l\u00e9ments obsol\u00e8tes.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4453767 elementor-widget elementor-widget-heading\" data-id=\"4453767\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Traitements automatis\u00e9s<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-032485f elementor-widget elementor-widget-text-editor\" data-id=\"032485f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Le DML permet aussi d&rsquo;automatiser certaines t\u00e2ches r\u00e9p\u00e9titives \u00e0 travers des scripts SQL, par exemple, l&rsquo;importation de nouveaux \u00e9l\u00e9ments.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-beafadf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"beafadf\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former \u00e0 la Data Science<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0a24630 e-flex e-con-boxed e-con\" data-id=\"0a24630\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6944d5b elementor-widget elementor-widget-heading\" data-id=\"6944d5b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">L'int\u00e9r\u00eat du Data Manipulation Language<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3016ced elementor-widget elementor-widget-text-editor\" data-id=\"3016ced\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">DML est un ensemble de commandes qui a l\u2019avantage d\u2019\u00eatre r\u00e9ellement simple \u00e0 apprendre et \u00e0 mettre en pratique. Le fait que <a href=\"https:\/\/datascientest.com\/sql3-nouvelle-generation-langage-requete\">le langage SQL<\/a> soit standardis\u00e9 aide \u00e0 employer le DML avec des bases de donn\u00e9es de fournisseurs divers : <a href=\"https:\/\/datascientest.com\/qui-est-oracle-principal-challenger-dazure-aws-et-google-cloud\">Oracle<\/a>, <a href=\"https:\/\/datascientest.com\/mongodb\">MongoDB<\/a>, <strong>IBM<\/strong>, <strong>Ingres<\/strong>.. De plus, DML aide \u00e0 effectuer des op\u00e9rations complexes sur de grands volumes de donn\u00e9es avec une grande pr\u00e9cision.<\/span><\/p><p><span style=\"font-weight: 400;\">Le DML est indispensable pour :<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/data-cleaning-definition\">Nettoyer les donn\u00e9es<\/a> au quotidien <\/span><b>:<\/b><span style=\"font-weight: 400;\"> corriger les erreurs, les incoh\u00e9rences et les valeurs manquantes.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Transformer les donn\u00e9es<\/span><b> :<\/b><span style=\"font-weight: 400;\"> les convertir dans un format adapt\u00e9 \u00e0 l&rsquo;analyse.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Pr\u00e9parer les donn\u00e9es pour la mod\u00e9lisation<\/span><b>.<\/b><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/datascientest.com\/data-exploration-tout-savoir\"><span style=\"font-weight: 400;\">Explorer les donn\u00e9es <\/span><\/a><b>:<\/b><span style=\"font-weight: 400;\"> Identifier des tendances, \u00e9tablir des corr\u00e9lations.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">D\u00e9velopper des applications.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-87f2974 e-flex e-con-boxed e-con\" data-id=\"87f2974\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-151d6f5 elementor-widget elementor-widget-heading\" data-id=\"151d6f5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Qui utilise le Data Manipulation Language ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd6e9ea elementor-widget elementor-widget-image\" data-id=\"bd6e9ea\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1000\" height=\"571\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-2.webp\" class=\"attachment-full size-full wp-image-254566\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-2.webp 1000w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-2-300x171.webp 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest-2-768x439.webp 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5161f7 elementor-widget elementor-widget-heading\" data-id=\"d5161f7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Data Scientists<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9b415d0 elementor-widget elementor-widget-text-editor\" data-id=\"9b415d0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Dans le cadre de leur travail, <a href=\"https:\/\/datascientest.com\/devenir-data-scientist-comment-faire\">les data scientists<\/a> consacrent une grande partie de leur temps \u00e0 manipuler des donn\u00e9es. Parfois, avant de pouvoir les analyser, ils se doivent de bien les pr\u00e9parer et m\u00eame aussi de les nettoyer \u2013 comme en supprimant des enregistrements inutiles. Ils peuvent aussi avoir \u00e0 cr\u00e9er des tables temporaires pour tester un mod\u00e8le ou une approche sp\u00e9cifique.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d9224e elementor-widget elementor-widget-heading\" data-id=\"0d9224e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Data Analysts<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a17bd4 elementor-widget elementor-widget-text-editor\" data-id=\"0a17bd4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/devenir-data-analyst-guide\">Les data analysts<\/a> utilisent couramment le DML pour extraire les donn\u00e9es n\u00e9cessaires \u00e0 leurs analyses. Ils cherchent \u00e0 obtenir des insights \u00e0 partir des donn\u00e9es disponibles.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-580cdff elementor-widget elementor-widget-heading\" data-id=\"580cdff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Administrateurs de Bases de Donn\u00e9es (DBA)<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d6cec4 elementor-widget elementor-widget-text-editor\" data-id=\"3d6cec4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/administrateur-de-base-de-donnees\">Les administrateurs de base de donn\u00e9es<\/a> utilisent le DML pour g\u00e9rer les op\u00e9rations quotidiennes sur les donn\u00e9es.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6908025 elementor-widget elementor-widget-heading\" data-id=\"6908025\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">D\u00e9veloppeurs<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a414c54 elementor-widget elementor-widget-text-editor\" data-id=\"a414c54\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/developpeur-full-stack\">Les d\u00e9veloppeurs<\/a> sont en mesure d\u2019int\u00e9grer des instructions DML dans leurs applications afin de faciliter l\u2019interaction avec les r\u00e9servoirs d\u2019informations de l\u2019entreprise.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5ad4b6e e-flex e-con-boxed e-con\" data-id=\"5ad4b6e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7704773 elementor-widget elementor-widget-heading\" data-id=\"7704773\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Le DML : un outil essentiel<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c13b62c elementor-widget elementor-widget-text-editor\" data-id=\"c13b62c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Le DML est un outil majeur dans le paysage de <a href=\"https:\/\/datascientest.com\/data-management-tout-savoir\">la gestion des donn\u00e9es<\/a>. Sa simplicit\u00e9 d&rsquo;utilisation n\u2019a d\u2019\u00e9gale que sa puissance et en font un choix privil\u00e9gi\u00e9 pour ceux qui exploitent les donn\u00e9es dans une strat\u00e9gie de d\u00e9veloppement d\u2019une activit\u00e9. Bien que de nombreuses alternatives soient apparues,<strong> la ma\u00eetrise du DML de SQL<\/strong> demeure une comp\u00e9tence pr\u00e9cieuse dans le monde de la data.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4198faa elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4198faa\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formations-data\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir nos formations en data<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-69979e2 e-flex e-con-boxed e-con\" data-id=\"69979e2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-79d5e35 elementor-widget elementor-widget-html\" data-id=\"79d5e35\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que le Data Manipulation Language (DML) ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le Data Manipulation Language (DML) est un sous-ensemble du SQL qui permet d'interagir avec les donn\u00e9es dans une base de donn\u00e9es. Il inclut des commandes pour ins\u00e9rer, mettre \u00e0 jour, supprimer et s\u00e9lectionner des donn\u00e9es dans des tables.\"\r\n    }\r\n  }, {\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quelles sont les principales commandes DML ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les principales commandes DML sont : \\n1. **INSERT** : pour ajouter des enregistrements dans une table. \\n2. **UPDATE** : pour modifier des donn\u00e9es existantes. \\n3. **DELETE** : pour supprimer des enregistrements d'une table. \\n4. **SELECT** : pour interroger et r\u00e9cup\u00e9rer des donn\u00e9es dans une table.\"\r\n    }\r\n  }, {\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quelle est la diff\u00e9rence entre DML et DDL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"DML (Data Manipulation Language) est utilis\u00e9 pour manipuler les donn\u00e9es stock\u00e9es dans une base de donn\u00e9es (ajouter, modifier, supprimer, interroger des enregistrements). En revanche, DDL (Data Definition Language) est utilis\u00e9 pour d\u00e9finir ou modifier la structure de la base de donn\u00e9es elle-m\u00eame (cr\u00e9er, modifier ou supprimer des tables et des sch\u00e9mas).\"\r\n    }\r\n  }, {\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne la commande SELECT en DML ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La commande SELECT permet de r\u00e9cup\u00e9rer des donn\u00e9es d'une ou plusieurs tables dans une base de donn\u00e9es. Elle peut \u00eatre utilis\u00e9e avec des clauses comme WHERE pour filtrer les r\u00e9sultats, ORDER BY pour les trier, et JOIN pour combiner des donn\u00e9es de plusieurs tables. Exemple :\\n```sql\\nSELECT * FROM employees WHERE age > 30;\\n```\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Dans le monde de la gestion des donn\u00e9es, le SQL reste un pilier incontournable. Et au c\u0153ur de ce langage se trouve le DML, un ensemble d&rsquo;instructions destin\u00e9es aux professionnels ayant pour mission d\u2019exploiter cette denr\u00e9e pr\u00e9cieuse qu\u2019est l\u2019information. Qu\u2019entend-on par Data Manipulation Language (DML) langage de manipulation de donn\u00e9es ? Des commandes \u2013 du [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":254534,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data Manipulation Language (DML) : Qu&#039;est-ce que c&#039;est ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez le Data Manipulation Language (DML) et apprenez \u00e0 ins\u00e9rer, mettre \u00e0 jour, supprimer et interroger des donn\u00e9es dans une base de donn\u00e9es. Ma\u00eetrisez les commandes SQL pour manipuler efficacement vos donn\u00e9es.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data Manipulation Language (DML) : Qu&#039;est-ce que c&#039;est ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-01T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-22T12:05:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir\",\"name\":\"Data Manipulation Language (DML) : Qu'est-ce que c'est ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-11-01T06:30:00+00:00\",\"dateModified\":\"2024-10-22T12:05:04+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"D\u00e9couvrez le Data Manipulation Language (DML) et apprenez \u00e0 ins\u00e9rer, mettre \u00e0 jour, supprimer et interroger des donn\u00e9es dans une base de donn\u00e9es. Ma\u00eetrisez les commandes SQL pour manipuler efficacement vos donn\u00e9es.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Manipulation Language (DML) : Qu'est-ce que c'est ?","description":"D\u00e9couvrez le Data Manipulation Language (DML) et apprenez \u00e0 ins\u00e9rer, mettre \u00e0 jour, supprimer et interroger des donn\u00e9es dans une base de donn\u00e9es. Ma\u00eetrisez les commandes SQL pour manipuler efficacement vos donn\u00e9es.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Data Manipulation Language (DML) : Qu'est-ce que c'est ?","og_url":"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-11-01T06:30:00+00:00","article_modified_time":"2024-10-22T12:05:04+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/10\/data-manipulation-language-dml-datascientest.webp","type":"image\/webp"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir","url":"https:\/\/datascientest.com\/data-manipulation-language-tout-savoir","name":"Data Manipulation Language (DML) : Qu'est-ce que c'est ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-11-01T06:30:00+00:00","dateModified":"2024-10-22T12:05:04+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"D\u00e9couvrez le Data Manipulation Language (DML) et apprenez \u00e0 ins\u00e9rer, mettre \u00e0 jour, supprimer et interroger des donn\u00e9es dans une base de donn\u00e9es. Ma\u00eetrisez les commandes SQL pour manipuler efficacement vos donn\u00e9es.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/data-manipulation-language-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/254532"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=254532"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/254532\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/254534"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=254532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=254532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=254532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}