{"id":198405,"date":"2023-05-11T19:30:00","date_gmt":"2023-05-11T19:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=198405"},"modified":"2023-11-09T13:52:30","modified_gmt":"2023-11-09T13:52:30","slug":"cinq-requetes-sql-a-connaitre","status":"publish","type":"post","link":"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre","title":{"rendered":"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"198405\" class=\"elementor elementor-198405\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3217f21 e-flex e-con-boxed e-con\" data-id=\"3217f21\" 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-24a012d elementor-widget elementor-widget-heading\" data-id=\"24a012d\" 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><h2 class=\"elementor-heading-title elementor-size-default\">Pour communiquer avec les bases de donn\u00e9es, les d\u00e9veloppeurs ou data analysts utilisent largement le langage SQL (Structured Query Language). Gr\u00e2ce \u00e0 ces diff\u00e9rentes commandes, il est possible de manipuler les tables en toute simplicit\u00e9. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses. <\/h2>\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-cbbe932 e-flex e-con-boxed e-con\" data-id=\"cbbe932\" 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-27946bf elementor-widget elementor-widget-heading\" data-id=\"27946bf\" 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\">La requ\u00eate SQL \"SELECT\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8014f78 elementor-widget elementor-widget-text-editor\" data-id=\"8014f78\" 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><span style=\"font-weight: 400;\">La commande SELECT est sans aucun doute la requ\u00eate la plus utilis\u00e9e par les d\u00e9veloppeurs et experts data. Comme son nom l\u2019indique, il s\u2019agit de s\u00e9lectionner des donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Pour cela, la requ\u00eate se pr\u00e9sente sous la forme suivante :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>SELECT nom de la colonne FROM nom du tableau.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Vous pouvez \u00e9galement s\u00e9lectionner plusieurs colonnes au sein d\u2019une m\u00eame table. Dans ce cas, vous devez s\u00e9parer les donn\u00e9es par une virgule :<\/span><\/p><p style=\"padding-left: 40px;\"><b>SELECT nom de la colonne 1,nom de la colonne 2 FROM nom du tableau.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Au-del\u00e0 de la s\u00e9lection de donn\u00e9es, la requ\u00eate SELECT permet aussi de supprimer des doublons, calculer des sommes, identifier des minimums, des maximums, etc. Pour toutes ces fonctionnalit\u00e9s, SELECT se combine avec d\u2019autres commandes, comme <a href=\"https:\/\/datascientest.com\/sql-where-tout-savoir\">WHERE<\/a><\/span><span style=\"font-weight: 400;\">, GROUP BY, ORDER BY, HAVING, \u2026<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple, si vous souhaitez s\u00e9lectionner une colonne en fonction d\u2019une condition d\u00e9termin\u00e9e, il vous suffira de renseigner la requ\u00eate suivante\u00a0 :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>SELECT nom de la colonne FROM table WHERE condition.\u00a0<\/b><\/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-8bebf0f elementor-widget elementor-widget-image\" data-id=\"8bebf0f\" 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=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_select.png\" class=\"attachment-full size-full wp-image-198437\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_select.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_select-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_select-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\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-b31e8ba e-flex e-con-boxed e-con\" data-id=\"b31e8ba\" 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-7c5de1f elementor-widget elementor-widget-heading\" data-id=\"7c5de1f\" 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\">La requ\u00eate \"INSERT INTO\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ff2c29 elementor-widget elementor-widget-text-editor\" data-id=\"1ff2c29\" 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 requ\u00eate SQL vous permet d\u2019ajouter de nouvelles donn\u00e9es au sein d\u2019une table. Elle se pr\u00e9sente comme ceci :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>INSERT INTO nom de la table VALUES<\/b><\/p><p><span style=\"font-weight: 400;\">En fonction de vos besoins, INSERT INTO peut int\u00e9grer une ou plusieurs lignes. Si vous souhaitez ins\u00e9rer 1 seule ligne, deux possibilit\u00e9s s\u2019offrent \u00e0 vous :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Sp\u00e9cifier les informations pour chaque colonne : dans ce cas, vous devrez respecter l\u2019ordre des donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Renseigner seulement les colonnes souhait\u00e9es : ici, l\u2019ordre n\u2019est pas aussi important.\u00a0<\/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-ccf2e2c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ccf2e2c\" 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\/formation-sql\">\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\">Apprendre \u00e0 effectuer des requ\u00eates SQL<\/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-e30cbe1 e-flex e-con-boxed e-con\" data-id=\"e30cbe1\" 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-66d6d7f elementor-widget elementor-widget-heading\" data-id=\"66d6d7f\" 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\">La commande \"UPDATE\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93b3313 elementor-widget elementor-widget-text-editor\" data-id=\"93b3313\" 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 vous permet d\u2019actualiser des tables en effectuant des modifications sur des lignes existantes. Pour cela, la requ\u00eate SQL UPDATE est utilis\u00e9e avec d\u2019autres commandes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SET : il s\u2019agit de savoir quelle colonne remplacer et par quoi.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">WHERE : cette commande permet d\u2019identifier les lignes \u00e0 modifier et de d\u00e9finir une condition. Ainsi, les colonnes concern\u00e9es par cette condition seront modifi\u00e9es. Les autres resteront identiques.\u00a0<\/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-d70ff0f elementor-widget elementor-widget-text-editor\" data-id=\"d70ff0f\" 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;\">Concr\u00e8tement, SQL Update se pr\u00e9sente comme suit :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>UPDATE table<\/b><\/p><p style=\"padding-left: 40px;\"><b>SET colonne_1 = &lsquo;nouvelle valeur 1&rsquo;, colonne_2 = &lsquo;nouvelle valeur 2&rsquo;, colonne_3 = &lsquo;nouvelle valeur 3&rsquo;, etc<\/b><\/p><p style=\"padding-left: 40px;\"><b>WHERE condition<\/b><\/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-a4c8909 e-flex e-con-boxed e-con\" data-id=\"a4c8909\" 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-7b7e56a elementor-widget elementor-widget-heading\" data-id=\"7b7e56a\" 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\">La commande SQL \"DELETE\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8966bc1 elementor-widget elementor-widget-text-editor\" data-id=\"8966bc1\" 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;\">DELETE permet d\u2019effacer des donn\u00e9es ; soit toutes les lignes d\u2019une table, soit seulement quelques lignes sp\u00e9cifiques. Dans cette deuxi\u00e8me hypoth\u00e8se, la requ\u00eate SQL est associ\u00e9e \u00e0 la commande WHERE afin d\u2019identifier les lignes \u00e0 supprimer.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La syntaxe est la suivante :\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><b>DELETE FROM `table`<\/b><\/p><p style=\"padding-left: 40px;\"><b>WHERE condition<\/b><\/p><p><span style=\"font-weight: 400;\"><strong>Bon \u00e0 savoir :<\/strong> nous vous conseillons de sauvegarder votre base de donn\u00e9es avant de supprimer la moindre ligne.\u00a0<\/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-1a512f8 elementor-widget elementor-widget-image\" data-id=\"1a512f8\" 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=\"800\" height=\"450\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_delete.png\" class=\"attachment-full size-full wp-image-198436\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_delete.png 800w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_delete-300x169.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requete_sql_delete-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\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-c84f0d7 e-flex e-con-boxed e-con\" data-id=\"c84f0d7\" 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-f95c366 elementor-widget elementor-widget-heading\" data-id=\"f95c366\" 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\">La requ\u00eate SQL \"DROP TABLE\"<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3130bbd elementor-widget elementor-widget-text-editor\" data-id=\"3130bbd\" 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 requ\u00eate SQL est utilis\u00e9e si vous souhaitez supprimer l\u2019int\u00e9gralit\u00e9 d\u2019une table de votre <a href=\"https:\/\/datascientest.com\/bien-choisir-sa-base-de-donnees-typologie\">base de donn\u00e9es<\/a>. Dans ce cas, vous supprimez tout ce qui est associ\u00e9 \u00e0 cette table, comme <\/span><span style=\"font-weight: 400;\">les index, les triggers, les contraintes et les permissions. C\u2019est pour cette raison qu\u2019il est primordial de r\u00e9aliser une sauvegarde en amont. \u00c0 d\u00e9faut, toutes vos donn\u00e9es seront perdues. D\u2019ailleurs, s\u2019il y a des d\u00e9pendances entre la table \u00e0 supprimer et d\u2019autres tables, nous vous conseillons de les effacer en amont.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Comme DROP TABLE n\u2019exige aucune condition ou commande suppl\u00e9mentaire, la syntaxe est tr\u00e8s simple : <\/span><b><\/b><\/p><p style=\"padding-left: 40px;\"><b>DROP TABLE nom de la table.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">La suppression d\u2019une table dans son int\u00e9gralit\u00e9 permet alors de lib\u00e9rer de la m\u00e9moire et de simplifier la compr\u00e9hension de la data base.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Il ne s\u2019agit que de quelques exemples de <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">requ\u00eates SQL<\/a> <\/span><span style=\"font-weight: 400;\">les plus courantes. Si vous souhaitez approfondir vos connaissances, n\u2019h\u00e9sitez pas \u00e0 suivre une formation avec Datascientest.\u00a0<\/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-46ac04b e-flex e-con-boxed e-con\" data-id=\"46ac04b\" 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-4cc2c17 elementor-widget elementor-widget-heading\" data-id=\"4cc2c17\" 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\">Apprenez les requ\u00eates SQL avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-41dc884 elementor-widget elementor-widget-text-editor\" data-id=\"41dc884\" 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;\">Que ce soit pour l\u2019analyse de donn\u00e9es ou le d\u00e9veloppement d&rsquo;applications, la ma\u00eetrise des requ\u00eates SQL est indispensable. Pour approfondir vos connaissances, n\u2019h\u00e9sitez pas \u00e0 <a href=\"https:\/\/datascientest.com\/formations-data\">rejoindre nos formations chez Datascientest<\/a><\/span><span style=\"font-weight: 400;\">. En plus de ma\u00eetriser ce langage informatique, vous d\u00e9couvrirez tous les outils utiles \u00e0 la manipulation des donn\u00e9es.\u00a0<\/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-cbff505 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"cbff505\" 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\/formation-sql\">\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 notre formation sur SQL <\/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-f199f01 e-flex e-con-boxed e-con\" data-id=\"f199f01\" 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-833a163 elementor-widget elementor-widget-html\" data-id=\"833a163\" 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\": \"La requ\u00eate SQL \"SELECT\"\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La commande SELECT est sans aucun doute la requ\u00eate la plus utilis\u00e9e par les d\u00e9veloppeurs et experts data. Comme son nom l\u2019indique, il s\u2019agit de s\u00e9lectionner des donn\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La requ\u00eate \"INSERT INTO\"\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Cette requ\u00eate SQL vous permet d\u2019ajouter de nouvelles donn\u00e9es au sein d\u2019une table.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La commande \"UPDATE\"\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Cette commande vous permet d\u2019actualiser des tables en effectuant des modifications sur des lignes existantes. Pour cela, la requ\u00eate SQL UPDATE est utilis\u00e9e avec d\u2019autres commandes\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"La commande SQL \"DELETE\"\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"DELETE permet d\u2019effacer des donn\u00e9es ; soit toutes les lignes d\u2019une table, soit seulement quelques lignes sp\u00e9cifiques. Dans cette deuxi\u00e8me hypoth\u00e8se, la requ\u00eate SQL est associ\u00e9e \u00e0 la commande WHERE afin d\u2019identifier les lignes \u00e0 supprimer.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\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>Pour communiquer avec les bases de donn\u00e9es, les d\u00e9veloppeurs ou data analysts utilisent largement le langage SQL (Structured Query Language). Gr\u00e2ce \u00e0 ces diff\u00e9rentes commandes, il est possible de manipuler les tables en toute simplicit\u00e9. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses. La requ\u00eate SQL \u00ab\u00a0SELECT\u00a0\u00bb La [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":198432,"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>Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre<\/title>\n<meta name=\"description\" content=\"Pour communiquer efficacement avec les bases de donn\u00e9es, les experts data peuvent utiliser diff\u00e9rentes requ\u00eates SQL. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses.\" \/>\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\/cinq-requetes-sql-a-connaitre\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-11T19:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:52:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requetes_sql.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=\"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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\",\"url\":\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\",\"name\":\"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-05-11T19:30:00+00:00\",\"dateModified\":\"2023-11-09T13:52:30+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Pour communiquer efficacement avec les bases de donn\u00e9es, les experts data peuvent utiliser diff\u00e9rentes requ\u00eates SQL. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\"]}]},{\"@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":"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre","description":"Pour communiquer efficacement avec les bases de donn\u00e9es, les experts data peuvent utiliser diff\u00e9rentes requ\u00eates SQL. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses.","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\/cinq-requetes-sql-a-connaitre","og_locale":"fr_FR","og_type":"article","og_title":"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre","og_url":"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-05-11T19:30:00+00:00","article_modified_time":"2023-11-09T13:52:30+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/04\/requetes_sql.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre","url":"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre","name":"Requ\u00eates SQL : Les 5 commandes principales \u00e0 conna\u00eetre","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-05-11T19:30:00+00:00","dateModified":"2023-11-09T13:52:30+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Pour communiquer efficacement avec les bases de donn\u00e9es, les experts data peuvent utiliser diff\u00e9rentes requ\u00eates SQL. Alors quelles sont les principales requ\u00eates SQL et \u00e0 quoi servent-elles ? D\u00e9couvrez les r\u00e9ponses.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre"]}]},{"@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\/198405"}],"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=198405"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/198405\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/198432"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=198405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=198405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=198405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}