{"id":11069,"date":"2020-11-03T08:44:03","date_gmt":"2020-11-03T08:44:03","guid":{"rendered":"https:\/\/datascientest.com\/?p=11069"},"modified":"2024-09-19T08:31:27","modified_gmt":"2024-09-19T08:31:27","slug":"sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-tout-savoir","title":{"rendered":"SQL : Tout savoir sur le langage des bases de donn\u00e9es"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"11069\" class=\"elementor elementor-11069\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7209fc1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7209fc1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-762d651\" data-id=\"762d651\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d762592 elementor-widget elementor-widget-heading\" data-id=\"d762592\" 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\">SQL est un langage de programmation permettant de manipuler les bases de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir \u00e0 son sujet : fonctionnement, cas d'usage, m\u00e9thodes d'apprentissage...<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bcc71b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bcc71b2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-65fc6bc\" data-id=\"65fc6bc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5bf0f07 elementor-widget elementor-widget-text-editor\" data-id=\"5bf0f07\" 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=\"color: #000000;\">SQL ou \u00ab\u00a0Structured Query Language\u00a0\u00bb est un langage de programmation permettant de<strong> manipuler les donn\u00e9es et les syst\u00e8mes de bases de donn\u00e9es relationnelles<\/strong>. Ce langage permet principalement de communiquer avec les bases de donn\u00e9es afin de g\u00e9rer les donn\u00e9es qu&rsquo;elles contiennent.<\/span><\/p><p><span style=\"color: #000000;\">Il permet notamment de stocker, de manipuler et de retrouver ces donn\u00e9es. Il est aussi possible <strong>d&rsquo;effectuer des requ\u00eates<\/strong>, de mettre \u00e0 jour les donn\u00e9es, de les r\u00e9organiser, ou encore de cr\u00e9er et de modifier le sch\u00e9ma et la structure d&rsquo;un syst\u00e8me de base de donn\u00e9es et de contr\u00f4ler l&rsquo;acc\u00e8s \u00e0 ses 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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ff752cb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ff752cb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9f0057f\" data-id=\"9f0057f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b8b53dd elementor-widget elementor-widget-heading\" data-id=\"b8b53dd\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">L'histoire de SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d27743 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d27743\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ce2bf37\" data-id=\"ce2bf37\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a1004de elementor-widget elementor-widget-text-editor\" data-id=\"a1004de\" 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=\"color: #000000;\">L&rsquo;histoire de SQL commence en 1969, lorsque <strong>le chercheur d&rsquo;IBM Edgar F.Codd<\/strong> d\u00e9finit le mod\u00e8le de base de donn\u00e9es relationnelle. Ce mod\u00e8le repose sur l&rsquo;association de \u00a0\u00bb cl\u00e9s \u00a0\u00bb avec diverses donn\u00e9es. Par exemple, un nom d&rsquo;utilisateur peut \u00eatre associ\u00e9 \u00e0 un vrai nom et \u00e0 un num\u00e9ro de t\u00e9l\u00e9phone.<\/span><\/p><p><span style=\"color: #000000;\">Quelques ann\u00e9es plus tard, <strong>IBM cr\u00e9e un langage<\/strong> pour les syst\u00e8mes de gestion de bases de donn\u00e9es relationnelles en se basant sur les travaux de Codd. Ce langage s&rsquo;appellera d&rsquo;abord SEQUEL, pour \u00a0\u00bb Structured English Query Language \u00ab\u00a0. Apr\u00e8s plusieurs impl\u00e9mentations et r\u00e9visions, il s&rsquo;appellera finalement SQL.<\/span><\/p><p><span style=\"color: #000000;\">Les <strong>tests d\u00e9butent en 1978<\/strong>, puis <a href=\"https:\/\/www.ibm.com\/fr-fr\">IBM<\/a> commence \u00e0 d\u00e9velopper des produits commerciaux comme SQL\/DS en 1981 et DB2 en 1983. D&rsquo;autres vendeurs suivront, comme Sybase, Ingres, ou Oracle qui lance son premier produit en 1979.<\/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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-10047d3 e-flex e-con-boxed e-con\" data-id=\"10047d3\" 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<div class=\"elementor-element elementor-element-41a6052 e-con-full e-flex e-con\" data-id=\"41a6052\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5462be0 e-con-full e-flex e-con\" data-id=\"5462be0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1ce31b2 elementor-widget elementor-widget-video\" data-id=\"1ce31b2\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=GHTySE_Uk9w&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.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-video .elementor-widget-container{overflow:hidden;transform:translateZ(0)}.elementor-widget-video .elementor-wrapper{aspect-ratio:var(--video-aspect-ratio)}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{height:100%;width:100%;display:flex;border:none;background-color:#000}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-wrapper{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-wrapper iframe,.elementor-widget-video .elementor-wrapper video{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .elementor-open-inline .elementor-custom-embed-image-overlay{position:absolute;top:0;right:0;bottom:0;left:0;background-size:cover;background-position:50%}.elementor-widget-video .elementor-custom-embed-image-overlay{cursor:pointer;text-align:center}.elementor-widget-video .elementor-custom-embed-image-overlay:hover .elementor-custom-embed-play i{opacity:1}.elementor-widget-video .elementor-custom-embed-image-overlay img{display:block;width:100%;aspect-ratio:var(--video-aspect-ratio);-o-object-fit:cover;object-fit:cover;-o-object-position:center center;object-position:center center}@supports not (aspect-ratio:1\/1){.elementor-widget-video .elementor-custom-embed-image-overlay{position:relative;overflow:hidden;height:0;padding-bottom:calc(100% \/ var(--video-aspect-ratio))}.elementor-widget-video .elementor-custom-embed-image-overlay img{position:absolute;top:0;right:0;bottom:0;left:0}}.elementor-widget-video .e-hosted-video .elementor-video{-o-object-fit:cover;object-fit:cover}.e-con-inner>.elementor-widget-video,.e-con>.elementor-widget-video{width:var(--container-widget-width);--flex-grow:var(--container-widget-flex-grow)}<\/style>\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f46b1fc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f46b1fc\" 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 les bases de 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<\/div>\n\t\t<div class=\"elementor-element elementor-element-73f7fcc e-con-full e-flex e-con\" data-id=\"73f7fcc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a8aabc6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a8aabc6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d0c995d\" data-id=\"d0c995d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-557083e elementor-widget elementor-widget-heading\" data-id=\"557083e\" 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\">Comment fonctionne SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bd2de9b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bd2de9b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a056368\" data-id=\"a056368\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ca45b7d elementor-widget elementor-widget-text-editor\" data-id=\"ca45b7d\" 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=\"color: #000000;\">Les applications peuvent \u00eatre programm\u00e9es avec <strong>diff\u00e9rents langages comme Python, PHP ou Ruby<\/strong>. En revanche, historiquement, les bases de donn\u00e9es ne comprennent pas ces langages. Jusqu&rsquo;\u00e0 r\u00e9cemment, elles ne comprenaient que SQL (m\u00eame si les choses ont beaucoup chang\u00e9 au fil des derni\u00e8res ann\u00e9es).<\/span><\/p><p><span style=\"color: #000000;\">C&rsquo;est la raison pour laquelle l&rsquo;apprentissage de SQL est indispensable pour travailler dans <strong>les domaines du d\u00e9veloppement d&rsquo;applications ou du d\u00e9veloppement web<\/strong>. Avant de pouvoir l&rsquo;utiliser, il est n\u00e9cessaire d&rsquo;apprendre son \u00a0\u00bb markup \u00a0\u00bb ou balisage en Fran\u00e7ais.<\/span><\/p><p><span style=\"color: #000000;\">Ceci est valable pour tous les langages de programmation. En revanche, SQL pr\u00e9sente une caract\u00e9ristique unique qui le distingue des autres langages : <strong>le concept des tableaux<\/strong>.<\/span><\/p><p><span style=\"color: #000000;\">En effet, une base de donn\u00e9es est constitu\u00e9e de tableaux. Chacun de ces tableaux est compos\u00e9 de colonnes et de lignes, et repr\u00e9sente un ensemble de donn\u00e9es. Ainsi, <strong>SQL permet de cr\u00e9er ou de manipuler des tableaux<\/strong>.<\/span><\/p><p><span style=\"color: #000000;\">Plusieurs <strong>commandes SQL sont fr\u00e9quemment utilis\u00e9es<\/strong> pour travailler avec les bases de donn\u00e9es. Par exemple, \u00ab\u00a0CREATE DATABASE\u00a0\u00bb permet de cr\u00e9er une base de donn\u00e9es, \u00ab\u00a0CREATE TABLE\u00a0\u00bb permet de cr\u00e9er des tableaux.<\/span><\/p><p><span style=\"color: #000000;\">La commande <strong>\u00a0\u00bb SELECT \u00a0\u00bb permet de trouver ou d&rsquo;extraire des donn\u00e9es<\/strong> en provenance d&rsquo;une base de donn\u00e9es. \u00ab\u00a0UPDATE\u00a0\u00bb permet d&rsquo;ajuster ou d&rsquo;\u00e9diter les donn\u00e9es, et \u00ab\u00a0DELETE\u00a0\u00bb permet de supprimer certaines donn\u00e9es.<\/span><\/p><p><span style=\"color: #000000;\">Il <strong>ne s&rsquo;agit l\u00e0 que de quelques exemples<\/strong> de commandes tr\u00e8s couramment utilis\u00e9es, pour vous offrir un aper\u00e7u du fonctionnement de SQL. Plus la base de donn\u00e9es est complexe, plus l&rsquo;utilisateur devra utiliser de commandes.<\/span><\/p><p><span style=\"color: #000000;\">Ces commandes permettent d&rsquo;\u00e9crire des \u00ab\u00a0requ\u00eates\u00a0\u00bb pour manipuler les donn\u00e9es dans les bases de donn\u00e9es. Le<strong> syst\u00e8me interpr\u00e8te et traite ces commandes<\/strong>, par exemple pour cr\u00e9er un nouvel enregistrement dans une 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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ddb4215 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ddb4215\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-15cb781\" data-id=\"15cb781\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dec4f91 elementor-widget elementor-widget-heading\" data-id=\"dec4f91\" 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\">\u00c0 quoi sert le langage SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-43ef7f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43ef7f4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e400121\" data-id=\"e400121\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19bd34e elementor-widget elementor-widget-image\" data-id=\"19bd34e\" 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\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2020\/11\/infography_SQL-03.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-da22639 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da22639\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-da799bd\" data-id=\"da799bd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-31debba elementor-widget elementor-widget-text-editor\" data-id=\"31debba\" 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>Le <strong>langage SQL est utilis\u00e9 dans tous les domaines<\/strong> o\u00f9 les bases de donn\u00e9es sont exploit\u00e9es. En d&rsquo;autres termes, on le retrouve dans pratiquement tous les domaines o\u00f9 des donn\u00e9es sont g\u00e9n\u00e9r\u00e9es et analys\u00e9es.<\/p><p>Dans <strong>l&rsquo;industrie de la finance<\/strong>, les applications de\u00a0<a href=\"https:\/\/datascientest.com\/open-banking\" target=\"_blank\" rel=\"noopener\">banking<\/a>\u00a0et de traitement de paiements stockent les donn\u00e9es sur les transactions financi\u00e8res et les utilisateurs. Ces syst\u00e8mes reposent sur des bases de donn\u00e9es complexes et requi\u00e8rent donc l&rsquo;usage de SQL.<\/p><p>De m\u00eame, <strong>les applications de streaming musical<\/strong> comme Spotify ou Deezer utilisent intensivement les bases de donn\u00e9es, par exemple pour stocker les vastes catalogues de fichiers musicaux issus de diff\u00e9rents albums par diff\u00e9rents artistes.<\/p><p>Le SQL permet de manipuler ces donn\u00e9es pour trouver ce que l&rsquo;utilisateur recherche, ou encore de<strong> stocker des donn\u00e9es sur l&rsquo;utilisateur et ses pr\u00e9f\u00e9rences<\/strong>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3789114 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3789114\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4b5efff\" data-id=\"4b5efff\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c7ba79 elementor-widget elementor-widget-text-editor\" data-id=\"0c7ba79\" 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>Les r\u00e9seaux sociaux tels que Facebook ou Instagram utilisent SQL pour stocker les informations sur le profil d&rsquo;un utilisateur telles que sa biographie ou sa position g\u00e9ographique. Chaque fois qu&rsquo;un utilisateur cr\u00e9e une publication ou partage un contenu, le SQL permet de mettre \u00e0 jour la base de donn\u00e9es.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8e9a891 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8e9a891\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0530f7d\" data-id=\"0530f7d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e3a0dc3 elementor-widget elementor-widget-text-editor\" data-id=\"e3a0dc3\" 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=\"color: #000000;\">Vous l&rsquo;aurez compris : le langage SQL est utilis\u00e9 par une large vari\u00e9t\u00e9 d&rsquo;applications dont tout un chacun se sert au quotidien. La <strong>plupart des logiciels les plus populaires reposent fortement sur SQL<\/strong>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-e8a68e0 e-flex e-con-boxed e-con\" data-id=\"e8a68e0\" 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<div class=\"elementor-element elementor-element-21c609a e-con-full e-flex e-con\" data-id=\"21c609a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-74bf417 e-con-full e-flex e-con\" data-id=\"74bf417\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dc12cf4 elementor-widget elementor-widget-video\" data-id=\"dc12cf4\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=mXnrjQTR6U0&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-abc5cb2 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"abc5cb2\" 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\">Se former au langage 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<\/div>\n\t\t<div class=\"elementor-element elementor-element-2702d2e e-con-full e-flex e-con\" data-id=\"2702d2e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-48f03de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"48f03de\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0d69928\" data-id=\"0d69928\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f9fb834 elementor-widget elementor-widget-heading\" data-id=\"f9fb834\" 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\">Quels sont les syst\u00e8mes de bases de donn\u00e9es SQL les plus populaires ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8475381 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8475381\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-300a1bc\" data-id=\"300a1bc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bdd7477 elementor-widget elementor-widget-text-editor\" data-id=\"bdd7477\" 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=\"color: #000000;\">Un <b>syst\u00e8me de base de donn\u00e9es (SGBD)<\/b> est un programme permettant \u00e0 un d\u00e9veloppeur de travailler avec une base de donn\u00e9es <strong>par le biais d&rsquo;une interface utilisateur<\/strong>. Ceci permet de manipuler les bases de donn\u00e9es de mani\u00e8re plus intuitive, notamment gr\u00e2ce \u00e0 des templates pr\u00e9con\u00e7us et des outils de building.<\/span><\/p><p><span style=\"color: #000000;\">Ces diff\u00e9rents outils simplifient la vie du programmeur de base de donn\u00e9es <strong>en automatisant les t\u00e2ches les plus communes <\/strong>comme le nettoyage du syst\u00e8me. Il en existe un grand nombre.<\/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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-63c1fa8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"63c1fa8\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bd99690\" data-id=\"bd99690\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c37e69d elementor-widget elementor-widget-heading\" data-id=\"c37e69d\" 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-default\">Oracle DataBase<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f24eb44 elementor-widget elementor-widget-text-editor\" data-id=\"f24eb44\" 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>Le plus populaire \u00e0 l&rsquo;\u00e9chelle mondiale est <a href=\"https:\/\/www.oracle.com\/database\/\"><b>Oracle Database<\/b><\/a>. Ce syst\u00e8me de base de donn\u00e9es SQL est utilis\u00e9 dans un grand nombre d&rsquo;industries, et notamment pour le Data Warehousing et le traitement de transactions en ligne.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c0cd745 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c0cd745\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c321104\" data-id=\"c321104\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-33794c6 elementor-widget elementor-widget-heading\" data-id=\"33794c6\" 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-default\">MySQL<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40ef76d elementor-widget elementor-widget-text-editor\" data-id=\"40ef76d\" 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=\"color: #000000;\">Un autre syst\u00e8me populaire est <strong><a href=\"https:\/\/datascientest.com\/mysql-tout-comprendre\">MySQL<\/a><\/strong>, propos\u00e9 en open source et gratuitement pour les individus et les entreprises. Les petites entreprises et les startups l&rsquo;appr\u00e9cient particuli\u00e8rement pour sa gratuit\u00e9, et de nombreuses applications Open Source l&rsquo;utilisent \u00e9galement.<\/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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-da9c388 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"da9c388\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5952c46\" data-id=\"5952c46\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f47e14e elementor-widget elementor-widget-heading\" data-id=\"f47e14e\" 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-default\">SQL Server<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef0e228 elementor-widget elementor-widget-text-editor\" data-id=\"ef0e228\" 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=\"color: #000000;\">Pour son syst\u00e8me d&rsquo;exploitation Windows, Microsoft propose son propre syst\u00e8me de gestion de base de donn\u00e9es SQL appel\u00e9 <strong><a href=\"https:\/\/datascientest.com\/microsoft-sql-server-tout-savoir\">SQL Server<\/a><\/strong>. Ce syst\u00e8me est utilis\u00e9 dans les logiciels grand public et sur les serveurs web fonctionnant sur Windows, ce qui lui conf\u00e8re une large base d&rsquo;utilisateurs.<\/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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-083678a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"083678a\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ef7b2bb\" data-id=\"ef7b2bb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-50f6e16 elementor-widget elementor-widget-heading\" data-id=\"50f6e16\" 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-default\">PostgreSQL<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d133ded elementor-widget elementor-widget-text-editor\" data-id=\"d133ded\" 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=\"color: #000000;\">Enfin, <strong><a href=\"https:\/\/datascientest.com\/postgresql-tout-savoir\">PostgreSQL<\/a><\/strong> est le principal concurrent de MySQL. Il s&rsquo;agit l\u00e0 encore d&rsquo;un syst\u00e8me de base de donn\u00e9es open source, utilis\u00e9 par de nombreuses startups pour sa gratuit\u00e9. Ce syst\u00e8me est compatible avec tous les principaux OS tels que macOS, Windows et Linux. Contrairement \u00e0 d&rsquo;autres syst\u00e8mes comme SQL Server, PostgreSQL met un point d&rsquo;honneur \u00e0 suivre la syntaxe SQL standard ce qui facilite grandement son apprentissage.<\/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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-6be6564 e-flex e-con-boxed e-con\" data-id=\"6be6564\" 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<div class=\"elementor-element elementor-element-86ae2a6 e-con-full e-flex e-con\" data-id=\"86ae2a6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8a43d0c e-con-full e-flex e-con\" data-id=\"8a43d0c\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b6bc593 elementor-widget elementor-widget-video\" data-id=\"b6bc593\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=8NU6pTtQo2I&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-100c4a3 e-con-full e-flex e-con\" data-id=\"100c4a3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4aedc74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4aedc74\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8f524bf\" data-id=\"8f524bf\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dfaa306 elementor-widget elementor-widget-heading\" data-id=\"dfaa306\" 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\">Comment apprendre le langage SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8d7bf4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8d7bf4c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b615225\" data-id=\"b615225\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2f74fd0 elementor-cta--skin-classic elementor-animated-content elementor-bg-transform elementor-bg-transform-zoom-in elementor-widget elementor-widget-call-to-action\" data-id=\"2f74fd0\" data-element_type=\"widget\" data-widget_type=\"call-to-action.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<link rel=\"stylesheet\" href=\"https:\/\/datascientest.com\/wp-content\/uploads\/elementor\/css\/custom-pro-widget-call-to-action.min.css?ver=1730971027\">\t\t<a class=\"elementor-cta\" href=\"https:\/\/datascientest.com\/wp-content\/uploads\/2020\/11\/Cheat-Sheet-SQL-1.png\" target=\"_blank\">\n\t\t\t\t\t<div class=\"elementor-cta__bg-wrapper\">\n\t\t\t\t<div class=\"elementor-cta__bg elementor-bg\" style=\"background-image: url(https:\/\/datascientest.com\/wp-content\/uploads\/2020\/11\/Cheat-Sheet-SQL-1-616x1024.png);\" role=\"img\" aria-label=\"Cheat Sheet SQL (1)\"><\/div>\n\t\t\t\t<div class=\"elementor-cta__bg-overlay\"><\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-cta__content\">\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<h2 class=\"elementor-cta__title elementor-cta__content-item elementor-content-item\">\n\t\t\t\t\t\tTOUT SAVOIR SUR SQL\t\t\t\t\t<\/h2>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-cta__description elementor-cta__content-item elementor-content-item\">\n\t\t\t\t\t\tCa tombe bien, on en a fait une fiche m\u00e9mo ! \t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-cta__button-wrapper elementor-cta__content-item elementor-content-item \">\n\t\t\t\t\t<span class=\"elementor-cta__button elementor-button elementor-size-sm\">\n\t\t\t\t\t\tD\u00c9COUVRIR\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-51ebb43 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"51ebb43\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-663030f\" data-id=\"663030f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-489331e elementor-widget elementor-widget-text-editor\" data-id=\"489331e\" 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>Il existe <strong>une large vari\u00e9t\u00e9 d&rsquo;options pour apprendre SQL<\/strong>. Vous pouvez vous tourner vers des livres d\u00e9di\u00e9s, afin d&rsquo;apprendre les fondamentaux et de d\u00e9couvrir les erreurs \u00e0 ne pas commettre. Il existe aussi de nombreuses formations en ligne, comme celles propos\u00e9es par DataScientest.<\/p><p>Si vous \u00eates confront\u00e9 \u00e0 un probl\u00e8me ou une difficult\u00e9 durant votre apprentissage ou votre utilisation de SQL, vous pouvez aussi vous tourner vers <strong>des communaut\u00e9s en ligne<\/strong> pour demander de l&rsquo;aide et \u00e9toffer votre expertise. Vous pourrez trouver le soutien de programmeurs exp\u00e9riment\u00e9s sur des plateformes comme Stack Overflow, Quora, Reddit ou StackExchange.<\/p><p>Quelques semaines suffisent pour apprendre les bases de SQL si vous avez d\u00e9j\u00e0 des notions de programmation et connaissez d&rsquo;autres langages. La meilleure fa\u00e7on d&rsquo;acc\u00e9l\u00e9rer votre apprentissage est de <strong>travailler sur des projets concrets<\/strong> : une base de donn\u00e9es, une application web&#8230; entra\u00eenez-vous chaque jour, et vous progresserez rapidement.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-89c89eb e-flex e-con-boxed e-con\" data-id=\"89c89eb\" 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<div class=\"elementor-element elementor-element-1da9284 e-con-full e-flex e-con\" data-id=\"1da9284\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-952eb80 e-con-full e-flex e-con\" data-id=\"952eb80\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ea2d3dd elementor-widget elementor-widget-video\" data-id=\"ea2d3dd\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=JRmnNlzkKM4&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-63c37fd e-con-full e-flex e-con\" data-id=\"63c37fd\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9d3581b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d3581b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-28b54fb\" data-id=\"28b54fb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-84e3466 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"84e3466\" 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\">S'inscrire \u00e0 notre formation 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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2afe95f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2afe95f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c41626a\" data-id=\"c41626a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a7c3860 elementor-widget elementor-widget-text-editor\" data-id=\"a7c3860\" 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>Vous<strong> savez maintenant tout sur SQL<\/strong>. Pour en savoir plus, d\u00e9couvrez <a href=\"https:\/\/datascientest.com\/gestion-de-bases-de-donnees-avance\" target=\"_blank\" rel=\"noopener\">notre dossier sur la gestion de bases de donn\u00e9es<\/a> ou <a href=\"https:\/\/datascientest.com\/formation-data-engineer\" target=\"_blank\" rel=\"noopener\">notre formation de Data Engineer<\/a> (ing\u00e9nieur des donn\u00e9es).<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-096d1dc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"096d1dc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-44ab130\" data-id=\"44ab130\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-406593f elementor-widget elementor-widget-html\" data-id=\"406593f\" 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\": \"L'histoire de SQL\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"L'histoire de SQL commence en 1969, lorsque le chercheur d'IBM Edgar F.Codd d\u00e9finit le mod\u00e8le de base de donn\u00e9es relationnelle. Ce mod\u00e8le repose sur l'association de \\\" cl\u00e9s \\\" avec diverses donn\u00e9es. Par exemple, un nom d'utilisateur peut \u00eatre associ\u00e9 \u00e0 un vrai nom et \u00e0 un num\u00e9ro de t\u00e9l\u00e9phone.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les applications peuvent \u00eatre programm\u00e9es avec diff\u00e9rents langages comme Python, PHP ou Ruby. En revanche, historiquement, les bases de donn\u00e9es ne comprennent pas ces langages. Jusqu'\u00e0 r\u00e9cemment, elles ne comprenaient que SQL (m\u00eame si les choses ont beaucoup chang\u00e9 au fil des derni\u00e8res ann\u00e9es).\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi sert le langage SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le langage SQL est utilis\u00e9 dans tous les domaines o\u00f9 les bases de donn\u00e9es sont exploit\u00e9es. En d'autres termes, on le retrouve dans pratiquement tous les domaines o\u00f9 des donn\u00e9es sont g\u00e9n\u00e9r\u00e9es et analys\u00e9es.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quels sont les syst\u00e8mes de bases de donn\u00e9es SQL les plus populaires ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Un syst\u00e8me de base de donn\u00e9es est un programme permettant \u00e0 un d\u00e9veloppeur de travailler avec une base de donn\u00e9es par le biais d'une interface utilisateur. Ceci permet de manipuler les bases de donn\u00e9es de mani\u00e8re plus intuitive, notamment gr\u00e2ce \u00e0 des templates pr\u00e9con\u00e7us et des outils de building.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment apprendre le langage SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Il existe une large vari\u00e9t\u00e9 d'options pour apprendre SQL. Vous pouvez vous tourner vers des livres d\u00e9di\u00e9s, afin d'apprendre les fondamentaux et de d\u00e9couvrir les erreurs \u00e0 ne pas commettre. Il existe aussi de nombreuses formations en ligne, comme celles propos\u00e9es par DataScientest.\"\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<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>SQL est un langage de programmation permettant de manipuler les bases de donn\u00e9es. D\u00e9couvrez tout ce que vous devez savoir \u00e0 son sujet : fonctionnement, cas d&rsquo;usage, m\u00e9thodes d&rsquo;apprentissage&#8230; SQL ou \u00ab\u00a0Structured Query Language\u00a0\u00bb est un langage de programmation permettant de manipuler les donn\u00e9es et les syst\u00e8mes de bases de donn\u00e9es relationnelles. Ce langage permet [&hellip;]<\/p>\n","protected":false},"author":78,"featured_media":185614,"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>SQL : Tout savoir sur le langage des bases de donn\u00e9es<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez tout ce que vous devez savoir sur SQL, le langage de programmation permettant de manipuler les bases de donn\u00e9es relationnelles.\" \/>\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\/sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL : Tout savoir sur le langage des bases de donn\u00e9es\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-03T08:44:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-19T08:31:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2020\/11\/Illu_BLOG_NEW_SQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1025\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-tout-savoir\",\"name\":\"SQL : Tout savoir sur le langage des bases de donn\u00e9es\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2020-11-03T08:44:03+00:00\",\"dateModified\":\"2024-09-19T08:31:27+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925\"},\"description\":\"D\u00e9couvrez tout ce que vous devez savoir sur SQL, le langage de programmation permettant de manipuler les bases de donn\u00e9es relationnelles.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-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":"SQL : Tout savoir sur le langage des bases de donn\u00e9es","description":"D\u00e9couvrez tout ce que vous devez savoir sur SQL, le langage de programmation permettant de manipuler les bases de donn\u00e9es relationnelles.","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\/sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"SQL : Tout savoir sur le langage des bases de donn\u00e9es","og_url":"https:\/\/datascientest.com\/sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2020-11-03T08:44:03+00:00","article_modified_time":"2024-09-19T08:31:27+00:00","og_image":[{"width":1025,"height":563,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2020\/11\/Illu_BLOG_NEW_SQL.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-tout-savoir","url":"https:\/\/datascientest.com\/sql-tout-savoir","name":"SQL : Tout savoir sur le langage des bases de donn\u00e9es","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2020-11-03T08:44:03+00:00","dateModified":"2024-09-19T08:31:27+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/7af2361c48e24e79a8aa2360e6e74925"},"description":"D\u00e9couvrez tout ce que vous devez savoir sur SQL, le langage de programmation permettant de manipuler les bases de donn\u00e9es relationnelles.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-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\/11069"}],"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=11069"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/11069\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/185614"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=11069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=11069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=11069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}