{"id":224,"date":"2025-08-07T20:57:20","date_gmt":"2025-08-07T20:57:20","guid":{"rendered":"https:\/\/ledatalab.fr\/?p=224"},"modified":"2025-08-08T19:49:52","modified_gmt":"2025-08-08T19:49:52","slug":"serie-sql-debutant","status":"publish","type":"post","link":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/","title":{"rendered":"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">[S\u00e9rie SQL #0] Comprendre SQL<br>Pourquoi, comment, avec quoi ?<\/h1>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Bienvenue dans cette s\u00e9rie d\u2019articles con\u00e7ue pour d\u00e9mystifier SQL, ce langage trop souvent rel\u00e9gu\u00e9 aux d\u00e9veloppeurs alors qu\u2019il peut devenir votre meilleur alli\u00e9 pour interroger et comprendre vos donn\u00e9es.<\/p>\n\n\n\n<p>Si vous d\u00e9butez, vous pouvez consulter la d\u00e9finition compl\u00e8te de <a href=\"https:\/\/ledatalab.fr\/index.php\/glossaire\/sql\/\" data-type=\"page\" data-id=\"230\" target=\"_blank\" rel=\"noreferrer noopener\">SQL dans notre glossaire<\/a> pour bien comprendre ce langage.<\/p>\n\n\n\n<p>Que vous soyez analyste, product owner, \u00e9tudiant, ou simple curieux de la Data\u2026 vous allez apprendre \u00e0 ma\u00eetriser les bases de SQL, en commen\u00e7ant par la commande reine : <strong>SELECT<\/strong>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Pourquoi encore apprendre le SQL ?<\/h2>\n\n\n\n<p>Le SQL n\u2019est pas mort. Mieux encore : il est vivant, stable et plus utile que jamais.<\/p>\n\n\n\n<p>Voici pourquoi il reste un super-pouvoir \u00e0 acqu\u00e9rir :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ud83d\udd0d Il permet d\u2019explorer vos donn\u00e9es <strong>sans outil complexe ni ligne de code obscure<\/strong>.<\/li>\n\n\n\n<li>\ud83d\udcca Il est <strong>la porte d\u2019entr\u00e9e<\/strong> vers tous les outils BI : Power BI, Looker, Tableau, Metabase\u2026<\/li>\n\n\n\n<li>\ud83d\udda5\ufe0f Il s\u2019int\u00e8gre dans des solutions low-code, no-code ou full code (Dataiku, Retool, Notion, Python, etc.).<\/li>\n\n\n\n<li>\ud83d\udca1 Il est <strong>lisible<\/strong>, intuitif et partageable entre \u00e9quipes.<\/li>\n\n\n\n<li>\ud83e\udde0 Enfin\u2026 il vous rend plus autonome, plus rapide, plus intelligent dans vos analyses.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Les tables d\u2019exemples : bienvenue chez Le Data Lab Corp.<\/h2>\n\n\n\n<p>Tout au long de cette s\u00e9rie, nous allons utiliser des tables fictives et simplifi\u00e9es, inspir\u00e9es des bases p\u00e9dagogiques comme <a href=\"https:\/\/www.postgresql.org\/ftp\/projects\/pgFoundry\/dbsamples\/pagila\/\" target=\"_blank\" rel=\"noreferrer noopener\">Pagila<\/a> ou <a href=\"https:\/\/dev.mysql.com\/doc\/sakila\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">Sakila<\/a>. Voici notre \u00e9quipe :<\/p>\n\n\n\n<figure class=\"wp-block-table aligncenter\"><table class=\"has-fixed-layout\"><thead><tr><th>employee_id<\/th><th>first_name<\/th><th>last_name<\/th><th>department<\/th><th>salary<\/th><\/tr><\/thead><tbody><tr><td>1<\/td><td>Alice<\/td><td>Dubois<\/td><td>HR<\/td><td>3200<\/td><\/tr><tr><td>2<\/td><td>Karim<\/td><td>Nguyen<\/td><td>IT<\/td><td>4100<\/td><\/tr><tr><td>3<\/td><td>Fatou<\/td><td>Mendes<\/td><td>Sales<\/td><td>3900<\/td><\/tr><tr><td>&#8230;<\/td><td>&#8230;<\/td><td>&#8230;<\/td><td>&#8230;<\/td><td>&#8230;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">La feuille de route de la s\u00e9rie Comprendre SQL<\/h2>\n\n\n\n<figure class=\"wp-block-table alignwide\"><table><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">Article<\/th><th>Titre<\/th><th>Ce que vous allez apprendre<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">#1<\/td><td><a href=\"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant-select-premiers-pas\/\">Premiers pas avec SELECT<\/a><\/td><td>Lire une table, afficher des colonnes<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#2<\/td><td>Filtrer avec WHERE &amp; op\u00e9rateurs logiques<\/td><td>Restreindre les r\u00e9sultats<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#3<\/td><td>Trier et limiter les r\u00e9sultats : <br>ORDER BY, LIMIT\/OFFSET<\/td><td>Contr\u00f4ler l\u2019ordre et la pagination<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#4<\/td><td>Agr\u00e9gation 101 : <br>COUNT, SUM, AVG + GROUP BY &amp; HAVING<\/td><td>Faire des statistiques<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#5<\/td><td>S\u00e9lection conditionnelle : <br>CASE WHEN et expressions<\/td><td>Adapter dynamiquement les r\u00e9sultats<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">#6<\/td><td>Bonnes pratiques SELECT : <br>lisibilit\u00e9, performance, s\u00e9curit\u00e9<\/td><td>Optimiser, lisibilit\u00e9, performance, s\u00e9curit\u00e9<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\ud83d\udca1 Chaque article contient :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Des exemples concrets et progressifs<\/li>\n\n\n\n<li>Les pi\u00e8ges classiques \u00e0 \u00e9viter<\/li>\n\n\n\n<li>Un mini challenge \u00e0 r\u00e9aliser<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Pr\u00eat ? On d\u00e9colle !<\/h2>\n\n\n\n<p>Lire le premier article de la s\u00e9rie : <a href=\"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant-select-premiers-pas\/\" data-type=\"post\" data-id=\"222\">Comprendre SQL &#8211; premiers pas avec SELECT<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[S\u00e9rie SQL #0] Comprendre SQLPourquoi, comment, avec quoi ? Bienvenue dans cette s\u00e9rie d\u2019articles con\u00e7ue pour d\u00e9mystifier SQL, ce langage trop souvent rel\u00e9gu\u00e9 aux d\u00e9veloppeurs alors qu\u2019il peut devenir votre meilleur alli\u00e9 pour interroger et comprendre vos donn\u00e9es. Si vous d\u00e9butez, vous pouvez consulter la d\u00e9finition compl\u00e8te de SQL dans notre glossaire pour bien comprendre &#8230; <a title=\"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?\" class=\"read-more\" href=\"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/\" aria-label=\"En savoir plus sur [S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?\">Lire la suite<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[13,14,11,12,10],"class_list":["post-224","post","type-post","status-publish","format-standard","hentry","category-bases-donnees-sql","tag-apprendre-sql","tag-debuter-en-sql","tag-select","tag-serie-pedagogique","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab\" \/>\n<meta property=\"og:description\" content=\"[S\u00e9rie SQL #0] Comprendre SQLPourquoi, comment, avec quoi ? Bienvenue dans cette s\u00e9rie d\u2019articles con\u00e7ue pour d\u00e9mystifier SQL, ce langage trop souvent rel\u00e9gu\u00e9 aux d\u00e9veloppeurs alors qu\u2019il peut devenir votre meilleur alli\u00e9 pour interroger et comprendre vos donn\u00e9es. Si vous d\u00e9butez, vous pouvez consulter la d\u00e9finition compl\u00e8te de SQL dans notre glossaire pour bien comprendre ... Lire la suite\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/\" \/>\n<meta property=\"og:site_name\" content=\"Le Data Lab\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-07T20:57:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-08T19:49:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ledatalab.fr\/wp-content\/uploads\/2025\/08\/couleur-vertical-a-droite-superpose.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"1000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Laumont\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ledatalab\" \/>\n<meta name=\"twitter:site\" content=\"@ledatalab\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Laumont\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/\"},\"author\":{\"name\":\"David Laumont\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#\\\/schema\\\/person\\\/5b32bc34b960873d989e860dc2a770c2\"},\"headline\":\"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?\",\"datePublished\":\"2025-08-07T20:57:20+00:00\",\"dateModified\":\"2025-08-08T19:49:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/\"},\"wordCount\":392,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#organization\"},\"keywords\":[\"Apprendre SQL\",\"D\u00e9buter en SQL\",\"SELECT\",\"S\u00e9rie p\u00e9dagogique\",\"SQL\"],\"articleSection\":[\"Bases\u202fde\u202fdonn\u00e9es\u202f&amp;\u202fSQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/\",\"url\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/\",\"name\":\"[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#website\"},\"datePublished\":\"2025-08-07T20:57:20+00:00\",\"dateModified\":\"2025-08-08T19:49:52+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/2025\\\/08\\\/07\\\/serie-sql-debutant\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/ledatalab.fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#website\",\"url\":\"https:\\\/\\\/ledatalab.fr\\\/\",\"name\":\"Le Data Lab\",\"description\":\"Le blog pour comprendre, explorer et utiliser la Data.\",\"publisher\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#organization\"},\"alternateName\":\"ledatalab\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ledatalab.fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#organization\",\"name\":\"Le Data Lab\",\"alternateName\":\"ledatalab\",\"url\":\"https:\\\/\\\/ledatalab.fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ledatalab.fr\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/couleur-vertical-a-droite-superpose.png\",\"contentUrl\":\"https:\\\/\\\/ledatalab.fr\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/couleur-vertical-a-droite-superpose.png\",\"width\":1000,\"height\":1000,\"caption\":\"Le Data Lab\"},\"image\":{\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/ledatalab\",\"https:\\\/\\\/www.instagram.com\\\/ledatalab\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ledatalab\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ledatalab.fr\\\/#\\\/schema\\\/person\\\/5b32bc34b960873d989e860dc2a770c2\",\"name\":\"David Laumont\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g\",\"caption\":\"David Laumont\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/david-laumont\\\/\"],\"url\":\"https:\\\/\\\/ledatalab.fr\\\/index.php\\\/author\\\/david-l\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab","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:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/","og_locale":"fr_FR","og_type":"article","og_title":"[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab","og_description":"[S\u00e9rie SQL #0] Comprendre SQLPourquoi, comment, avec quoi ? Bienvenue dans cette s\u00e9rie d\u2019articles con\u00e7ue pour d\u00e9mystifier SQL, ce langage trop souvent rel\u00e9gu\u00e9 aux d\u00e9veloppeurs alors qu\u2019il peut devenir votre meilleur alli\u00e9 pour interroger et comprendre vos donn\u00e9es. Si vous d\u00e9butez, vous pouvez consulter la d\u00e9finition compl\u00e8te de SQL dans notre glossaire pour bien comprendre ... Lire la suite","og_url":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/","og_site_name":"Le Data Lab","article_published_time":"2025-08-07T20:57:20+00:00","article_modified_time":"2025-08-08T19:49:52+00:00","og_image":[{"width":1000,"height":1000,"url":"https:\/\/ledatalab.fr\/wp-content\/uploads\/2025\/08\/couleur-vertical-a-droite-superpose.png","type":"image\/png"}],"author":"David Laumont","twitter_card":"summary_large_image","twitter_creator":"@ledatalab","twitter_site":"@ledatalab","twitter_misc":{"\u00c9crit par":"David Laumont","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/#article","isPartOf":{"@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/"},"author":{"name":"David Laumont","@id":"https:\/\/ledatalab.fr\/#\/schema\/person\/5b32bc34b960873d989e860dc2a770c2"},"headline":"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?","datePublished":"2025-08-07T20:57:20+00:00","dateModified":"2025-08-08T19:49:52+00:00","mainEntityOfPage":{"@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/"},"wordCount":392,"commentCount":0,"publisher":{"@id":"https:\/\/ledatalab.fr\/#organization"},"keywords":["Apprendre SQL","D\u00e9buter en SQL","SELECT","S\u00e9rie p\u00e9dagogique","SQL"],"articleSection":["Bases\u202fde\u202fdonn\u00e9es\u202f&amp;\u202fSQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/","url":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/","name":"[S\u00e9rie SQL #0] Comprendre SQL - pourquoi, comment, avec quoi ? - Le Data Lab","isPartOf":{"@id":"https:\/\/ledatalab.fr\/#website"},"datePublished":"2025-08-07T20:57:20+00:00","dateModified":"2025-08-08T19:49:52+00:00","breadcrumb":{"@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ledatalab.fr\/index.php\/2025\/08\/07\/serie-sql-debutant\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/ledatalab.fr\/"},{"@type":"ListItem","position":2,"name":"[S\u00e9rie SQL #0] Comprendre SQL &#8211; pourquoi, comment, avec quoi ?"}]},{"@type":"WebSite","@id":"https:\/\/ledatalab.fr\/#website","url":"https:\/\/ledatalab.fr\/","name":"Le Data Lab","description":"Le blog pour comprendre, explorer et utiliser la Data.","publisher":{"@id":"https:\/\/ledatalab.fr\/#organization"},"alternateName":"ledatalab","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ledatalab.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/ledatalab.fr\/#organization","name":"Le Data Lab","alternateName":"ledatalab","url":"https:\/\/ledatalab.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/ledatalab.fr\/#\/schema\/logo\/image\/","url":"https:\/\/ledatalab.fr\/wp-content\/uploads\/2025\/08\/couleur-vertical-a-droite-superpose.png","contentUrl":"https:\/\/ledatalab.fr\/wp-content\/uploads\/2025\/08\/couleur-vertical-a-droite-superpose.png","width":1000,"height":1000,"caption":"Le Data Lab"},"image":{"@id":"https:\/\/ledatalab.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ledatalab","https:\/\/www.instagram.com\/ledatalab\/","https:\/\/www.linkedin.com\/company\/ledatalab"]},{"@type":"Person","@id":"https:\/\/ledatalab.fr\/#\/schema\/person\/5b32bc34b960873d989e860dc2a770c2","name":"David Laumont","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f41bc47d57445961a7cda575465b1faba2c35ffd0ac4aa81e7fc01aa87f68ccc?s=96&d=mm&r=g","caption":"David Laumont"},"sameAs":["https:\/\/www.linkedin.com\/in\/david-laumont\/"],"url":"https:\/\/ledatalab.fr\/index.php\/author\/david-l\/"}]}},"_links":{"self":[{"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/posts\/224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":10,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":261,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/posts\/224\/revisions\/261"}],"wp:attachment":[{"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ledatalab.fr\/index.php\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}