{"id":252914,"date":"2024-10-17T05:30:00","date_gmt":"2024-10-17T05:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=252914"},"modified":"2024-10-16T12:27:08","modified_gmt":"2024-10-16T12:27:08","slug":"data-definition-language-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/data-definition-language-tout-savoir","title":{"rendered":"Data Definition Language (DDL) : Qu&rsquo;est-ce que c&rsquo;est ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"252914\" class=\"elementor elementor-252914\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-766ccc5 e-flex e-con-boxed e-con\" data-id=\"766ccc5\" 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-92c4f71 elementor-widget elementor-widget-text-editor\" data-id=\"92c4f71\" 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>Que vous soyez Data Scientist ou responsable \u00e0 une \u00e9chelle ou une autre, du d\u00e9veloppement de votre activit\u00e9, votre mati\u00e8re premi\u00e8re essentielle est la donn\u00e9e. A ce titre, il est probable que vous vous serviez de SQL pour g\u00e9rer les informations. Bien ma\u00eetriser l\u2019une des composantes de SQL, appel\u00e9e le DDL, va aider \u00e0 maintenir la coh\u00e9rence et la gestion optimis\u00e9e desdites donn\u00e9es\u2026<\/strong><\/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-de3bd32 elementor-widget elementor-widget-text-editor\" data-id=\"de3bd32\" 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;\">Qu\u2019entend-on par Data Definition Language\u00a0(DDL) &#8211; <strong>langage de d\u00e9finition de donn\u00e9es<\/strong> en fran\u00e7ais? Une famille de commandes du langage SQL qui servent \u00e0 cr\u00e9er ou modifier la structure des objets d\u2019une base de donn\u00e9es.<\/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-ede7942 e-flex e-con-boxed e-con\" data-id=\"ede7942\" 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-d0eea73 elementor-widget elementor-widget-heading\" data-id=\"d0eea73\" 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\">Petit rappel sur SQL et les bases de donn\u00e9es<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e7d72e elementor-widget elementor-widget-text-editor\" data-id=\"8e7d72e\" 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;\">Vous le savez sans doute, une base de donn\u00e9es est un syst\u00e8me de gestion des informations qui facilite la mise en relation de plusieurs tables. Ainsi, si nous avons\u00a0:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">une table qui r\u00e9pertorie les clients avec les adresses de livraison,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">une table qui r\u00e9pertorie les achats effectu\u00e9s par les clients,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">une table qui r\u00e9pertorie les produits avec leur prix.<\/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-281653b elementor-widget elementor-widget-text-editor\" data-id=\"281653b\" 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;\">Lors de la cr\u00e9ation d\u2019une facture, Il devient possible d\u2019associer l\u2019achat effectu\u00e9 au client correspondant et au prix des produits command\u00e9s. <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">Le langage SQL<\/a> facilite de telles op\u00e9rations sur les tables comme sur la base elle-m\u00eame.<\/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-f56fae5 elementor-widget elementor-widget-heading\" data-id=\"f56fae5\" 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-9b5804c elementor-widget elementor-widget-text-editor\" data-id=\"9b5804c\" 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\u00a0:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Definition Language<\/b><span style=\"font-weight: 400;\"> (DDL) \u2013 pour d\u00e9finir la structure de donn\u00e9es. Ce sont celles que nous abordons ici.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Manipulation Language<\/b><span style=\"font-weight: 400;\"> (DML) \u2013 pour manipuler les donn\u00e9es elles-m\u00eames\u00a0: insertion, mise \u00e0 jour, suppression.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Query Language<\/b><span style=\"font-weight: 400;\"> (DQL)\u00a0\u2013 pour rechercher des informations dans une base ou une table.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Data Control Languag<\/b><span style=\"font-weight: 400;\">e (DCL) \u2013 d\u00e9finition des contr\u00f4les d\u2019acc\u00e8s \u00e0 la base de donn\u00e9es,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><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 avec DML 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-6abc6e5 elementor-widget elementor-widget-text-editor\" data-id=\"6abc6e5\" 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;\">Ainsi donc, DDL, tout comme DML, DCL et TCL est un sous-ensemble de SQL.<\/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-47be7cb elementor-widget elementor-widget-image\" data-id=\"47be7cb\" 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\/09\/Data-Definition-Language-DDL-DataScientest-2.jpg\" class=\"attachment-full size-full wp-image-252930\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-2.jpg 1000w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-2-300x171.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-2-768x439.jpg 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-ab84070 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ab84070\" 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\">Tout apprendre sur le DDL<\/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-0741156 e-flex e-con-boxed e-con\" data-id=\"0741156\" 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-b0f2b04 elementor-widget elementor-widget-heading\" data-id=\"b0f2b04\" 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 DDL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4aaa5ed elementor-widget elementor-widget-text-editor\" data-id=\"4aaa5ed\" 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 commandes DDL interviennent en tout premier, lors de la gen\u00e8se d\u2019une base de donn\u00e9es. Elles servent \u00e0 cr\u00e9er la structure de la base de donn\u00e9es, \u00e0 d\u00e9finir chaque colonne avec son type de contenu. Et le point essentiel est qu\u2019elles favorisent une grande souplesse dans la gestion des informations.<\/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-e7f3846 elementor-widget elementor-widget-heading\" data-id=\"e7f3846\" 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\">CREATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f695e60 elementor-widget elementor-widget-text-editor\" data-id=\"f695e60\" 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;\">C\u2019est la commande qui g\u00e8re la cr\u00e9ation d\u2019une structure de donn\u00e9es. Elle permet de d\u00e9finir\u00a0:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">le nom de la base de donn\u00e9es ou celui d\u2019une table particuli\u00e8re au sein de cette base,\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">les colonnes qui la composent,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">la taille fixe ou variable de chacune de ces colonnes,<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">le type de donn\u00e9es autoris\u00e9es pour chaque colonne, en d\u2019autres termes, de quelle nature seront ces donn\u00e9es\u00a0: num\u00e9rique, date, texte\u2026<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">des contraintes.<\/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-7d52fc8 elementor-widget elementor-widget-heading\" data-id=\"7d52fc8\" 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\">ALTER<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fdd3cc6 elementor-widget elementor-widget-text-editor\" data-id=\"fdd3cc6\" 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;\">C\u2019est cette commande que nous utiliserions pour ajouter une colonne \u00e0 une table ou pour changer les composantes d\u2019une base de donn\u00e9es. Elle procure une grande souplesse dans la gestion des informations puisqu\u2019une table n\u2019est pas fig\u00e9e de fa\u00e7on d\u00e9finitive.<\/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-c2e0eb5 elementor-widget elementor-widget-heading\" data-id=\"c2e0eb5\" 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\">DROP<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c4bdaa2 elementor-widget elementor-widget-text-editor\" data-id=\"c4bdaa2\" 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;\">Cette commande sert \u00e0 supprimer une colonne ou m\u00eame une table qui ne serait plus n\u00e9cessaire et elle peut donc contribuer \u00e0 une meilleure gestion des espaces disque.<\/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-74bb5fc elementor-widget elementor-widget-heading\" data-id=\"74bb5fc\" 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\">RENAME<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-162f42e elementor-widget elementor-widget-text-editor\" data-id=\"162f42e\" 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;\">Renommer une table ou bien une colonne est effectu\u00e9 au moyen de cette commande.<\/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-14320cf elementor-widget elementor-widget-heading\" data-id=\"14320cf\" 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\">TRUNCATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-afc3474 elementor-widget elementor-widget-text-editor\" data-id=\"afc3474\" 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;\">Si vous souhaitez purger une table, en d\u2019autres termes, supprimer ses donn\u00e9es, tout en conservant intacte sa structure, c\u2019est cette commande qu\u2019il faudrait utiliser.<\/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-0635e7c elementor-widget elementor-widget-image\" data-id=\"0635e7c\" 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\/09\/Data-Definition-Language-DDL-DataScientest-1.jpg\" class=\"attachment-full size-full wp-image-252926\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-1.jpg 1000w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-1-300x171.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-1-768x439.jpg 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-c3c9701 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c3c9701\" 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\">Ma\u00eetriser le DDL<\/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-759833b e-flex e-con-boxed e-con\" data-id=\"759833b\" 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-70568c7 elementor-widget elementor-widget-heading\" data-id=\"70568c7\" 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\">Pourquoi est-il n\u00e9cessaire de ma\u00eetriser le Data Definition Language ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-edf7d32 elementor-widget elementor-widget-text-editor\" data-id=\"edf7d32\" 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;\">La ma\u00eetrise de DDL est cruciale pour plusieurs raisons :<\/span><\/p><ol><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Bien d\u00e9finir la structure des donn\u00e9es aide \u00e0 maintenir une coh\u00e9rence. Si la phase du DDL est bien op\u00e9r\u00e9e, la base de donn\u00e9es sera performante et fiable, que ce soit au niveau du stockage comme de la r\u00e9cup\u00e9ration d\u2019informations<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La d\u00e9finition de contraintes peut contribuer \u00e0 maintenir l\u2019int\u00e9grit\u00e9 et \u00e0 fiabilit\u00e9 globale des donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">La cr\u00e9ation d\u2019index va am\u00e9liorer la rapidit\u00e9 des requ\u00eates.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Si l\u2019environnement l\u00e9gislatif ou commercial \u00e9volue, il est possible de modifier la structure de la base de donn\u00e9es.<\/span><\/li><\/ol>\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-2eb014c e-flex e-con-boxed e-con\" data-id=\"2eb014c\" 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-78efeed elementor-widget elementor-widget-heading\" data-id=\"78efeed\" 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 Definition Language ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-028a5a1 elementor-widget elementor-widget-text-editor\" data-id=\"028a5a1\" 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 m\u00e9tiers concern\u00e9s au premier plan par le DDL sont les suivants\u00a0:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/administrateur-de-base-de-donnees\">Administrateurs de Bases de Donn\u00e9es (DBA)<\/a>.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/data-engineer-tout-savoir\">Data Engineers<\/a> (charg\u00e9s de la mise en place des infrastructures de donn\u00e9es).\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/sql-developer-tout-savoir\">D\u00e9veloppeurs backend \/ SQL<\/a>.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/devenir-data-analyst-guide\">Data analysts<\/a>.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/devenir-data-scientist-comment-faire\">Data Scientists<\/a>.<\/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-4f26989 e-flex e-con-boxed e-con\" data-id=\"4f26989\" 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-378eab5 elementor-widget elementor-widget-heading\" data-id=\"378eab5\" 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\">De l\u2019int\u00e9r\u00eat du DDL pour les analystes de donn\u00e9es<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f70450 elementor-widget elementor-widget-text-editor\" data-id=\"3f70450\" 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;\">Bien \u00e9videmment, <a href=\"https:\/\/datascientest.com\/data-scientist-vs-data-analyst-tout-savoir\">la mission du Data Analyst et du Data Scientist<\/a> est avant tout l\u2019analyse de donn\u00e9es \u00e0 une vaste \u00e9chelle. Pourtant, une connaissance du DDL va s\u2019av\u00e9rer bien utile. Elle va<strong> faciliter la collaboration entre les diff\u00e9rents membres d&rsquo;une \u00e9quipe de data science<\/strong> et aussi la communication avec les DBA et les Data Engineers. De plus, s\u2019il sait comment les informations sont structur\u00e9es, le Data Scientist sera en mesure de <strong>formuler des requ\u00eates plus efficaces<\/strong>.\u00a0 Et dans le cadre d\u2019analyses sp\u00e9cifiques, un Data Analyst saura <strong>cr\u00e9er des tables ou encore des vues adapt\u00e9es<\/strong> \u00e0 ses besoins.<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c0 premi\u00e8re vue, il n\u2019est nullement n\u00e9cessaire \u00e0 un pilote de conna\u00eetre l\u2019anatomie des moteurs pour participer \u00e0 un rallye automobile. Toutefois, cette connaissance pourra s\u2019av\u00e9rer utile dans bien des circonstances et parfois m\u00eame aider \u00e0 faire la diff\u00e9rence. Nous pourrions en dire autant de la comp\u00e9tence relative au DDL\u2026<\/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-ea8f5bf elementor-widget elementor-widget-image\" data-id=\"ea8f5bf\" 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\/09\/Data-Definition-Language-DDL-DataScientest-3.jpg\" class=\"attachment-full size-full wp-image-252931\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-3.jpg 1000w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-3-300x171.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest-3-768x439.jpg 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-0c47209 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0c47209\" 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 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-7a2cdea e-flex e-con-boxed e-con\" data-id=\"7a2cdea\" 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-18ddb09 elementor-widget elementor-widget-html\" data-id=\"18ddb09\" 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    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"Qu'est-ce que le Data Definition Language (DDL) ?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Le Data Definition Language (DDL) est un sous-ensemble du SQL (Structured Query Language) utilis\u00e9 pour d\u00e9finir et g\u00e9rer la structure des bases de donn\u00e9es. Il permet la cr\u00e9ation, la modification et la suppression de sch\u00e9mas de bases de donn\u00e9es, comme les tables, les index, et les vues.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"Quelles sont les principales commandes DDL ?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Les principales commandes DDL incluent CREATE (pour cr\u00e9er des objets de base de donn\u00e9es comme des tables), ALTER (pour modifier la structure existante d'un objet), DROP (pour supprimer des objets), et TRUNCATE (pour supprimer toutes les lignes d'une table sans supprimer la table elle-m\u00eame).\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"Quelle est la diff\u00e9rence entre DDL et DML ?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Le DDL (Data Definition Language) concerne la structure de la base de donn\u00e9es, tandis que le DML (Data Manipulation Language) se concentre sur la manipulation des donn\u00e9es dans ces structures. DDL g\u00e8re la cr\u00e9ation et la gestion des objets (tables, index), tandis que DML permet l'insertion, la mise \u00e0 jour et la suppression de donn\u00e9es \u00e0 l'int\u00e9rieur de ces objets.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"Les commandes DDL peuvent-elles \u00eatre annul\u00e9es avec un ROLLBACK ?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Non, les commandes DDL sont implicitement valid\u00e9es dans la plupart des syst\u00e8mes de gestion de bases de donn\u00e9es (SGDB), ce qui signifie qu'elles ne peuvent g\u00e9n\u00e9ralement pas \u00eatre annul\u00e9es avec un ROLLBACK apr\u00e8s leur ex\u00e9cution. Une fois qu'une commande DDL est ex\u00e9cut\u00e9e, ses effets sont permanents.\"\r\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>Que vous soyez Data Scientist ou responsable \u00e0 une \u00e9chelle ou une autre, du d\u00e9veloppement de votre activit\u00e9, votre mati\u00e8re premi\u00e8re essentielle est la donn\u00e9e. A ce titre, il est probable que vous vous serviez de SQL pour g\u00e9rer les informations. Bien ma\u00eetriser l\u2019une des composantes de SQL, appel\u00e9e le DDL, va aider \u00e0 maintenir [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":252916,"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 Definition Language (DDL) : Qu&#039;est-ce que c&#039;est ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez le Data Definition Language (DDL), un sous-ensemble du SQL utilis\u00e9 pour cr\u00e9er, modifier et supprimer des structures de bases de donn\u00e9es telles que des tables, des index et des sch\u00e9mas.\" \/>\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-definition-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 Definition Language (DDL) : Qu&#039;est-ce que c&#039;est ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/data-definition-language-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-17T05:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-16T12:27:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest.png\" \/>\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\/png\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00e9my Robert\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00e9my Robert\" \/>\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-definition-language-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/data-definition-language-tout-savoir\",\"name\":\"Data Definition Language (DDL) : Qu'est-ce que c'est ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-10-17T05:30:00+00:00\",\"dateModified\":\"2024-10-16T12:27:08+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"D\u00e9couvrez le Data Definition Language (DDL), un sous-ensemble du SQL utilis\u00e9 pour cr\u00e9er, modifier et supprimer des structures de bases de donn\u00e9es telles que des tables, des index et des sch\u00e9mas.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/data-definition-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\/7af2361c48e24e79a8aa2360e6e74925\",\"name\":\"J\u00e9r\u00e9my Robert\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg\",\"caption\":\"J\u00e9r\u00e9my Robert\"},\"description\":\"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jeremyrobert1\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/jeremyrobert\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Data Definition Language (DDL) : Qu'est-ce que c'est ?","description":"D\u00e9couvrez le Data Definition Language (DDL), un sous-ensemble du SQL utilis\u00e9 pour cr\u00e9er, modifier et supprimer des structures de bases de donn\u00e9es telles que des tables, des index et des sch\u00e9mas.","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-definition-language-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"Data Definition Language (DDL) : Qu'est-ce que c'est ?","og_url":"https:\/\/datascientest.com\/data-definition-language-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-10-17T05:30:00+00:00","article_modified_time":"2024-10-16T12:27:08+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/09\/Data-Definition-Language-DDL-DataScientest.png","type":"image\/png"}],"author":"J\u00e9r\u00e9my Robert","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"J\u00e9r\u00e9my Robert","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/data-definition-language-tout-savoir","url":"https:\/\/datascientest.com\/data-definition-language-tout-savoir","name":"Data Definition Language (DDL) : Qu'est-ce que c'est ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-10-17T05:30:00+00:00","dateModified":"2024-10-16T12:27:08+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"D\u00e9couvrez le Data Definition Language (DDL), un sous-ensemble du SQL utilis\u00e9 pour cr\u00e9er, modifier et supprimer des structures de bases de donn\u00e9es telles que des tables, des index et des sch\u00e9mas.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/data-definition-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\/7af2361c48e24e79a8aa2360e6e74925","name":"J\u00e9r\u00e9my Robert","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/jeremyrobert.jpeg","caption":"J\u00e9r\u00e9my Robert"},"description":"J\u00e9r\u00e9my Robert est actuellement Directeur p\u00e9dagogique B2B chez DataScientest.com. Avant de rejoindre DataScientest, il a travaill\u00e9 en tant que Consultant Business Intelligence chez DEAPDATA, o\u00f9 il a g\u00e9r\u00e9 des projets dans les domaines de l'assurance, bancaire et industrie. Il a \u00e9galement \u00e9t\u00e9 Co-fondateur et pr\u00e9sident de Tripzer. En tant que consultant ind\u00e9pendant, J\u00e9r\u00e9my a propos\u00e9 des formations sur MicroStrategy pour divers niveaux professionnels. Il est dipl\u00f4m\u00e9 de l'Universit\u00e9 Paris Cit\u00e9 avec un Master MIAGE, combinant comp\u00e9tences en informatique et gestion.","sameAs":["https:\/\/www.linkedin.com\/in\/jeremyrobert1\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/jeremyrobert"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/252914"}],"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\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=252914"}],"version-history":[{"count":4,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/252914\/revisions"}],"predecessor-version":[{"id":254809,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/252914\/revisions\/254809"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/252916"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=252914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=252914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=252914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}