http://sql.sh

Analyse de la page d'accueil du site

<!DOCTYPE html> <!--[if IE 6]><html id="ie6" lang="fr-FR"> <![endif]--> <!--[if IE 7]><html id="ie7" lang="fr-FR"> <![endif]--> <!--[if IE 8]><html id="ie8" lang="fr-FR"> <![endif]--> <!--[if !(IE 6) | !(IE 7) | !(IE 8)  ]><!--><html lang="fr-FR"> <!--<![endif]--><head><link rel="stylesheet" href="https://sql.sh/wp-content/cache/min/1/a3367e2b1bc02fec826d0a882d73114a.css" data-minify="1"/><script src="https://sql.sh/wp-content/cache/min/1/f6372e09d7041483506f5a5bf1102315.js" data-minify="1"></script> <meta charset="UTF-8" /><meta name="viewport" content="width=device-width" /><title>Cours et Tutoriels sur le Langage SQL</title><link rel="profile" href="https://gmpg.org/xfn/11" /><link rel="pingback" href="https://sql.sh/xmlrpc.php" /><link type="image/png" href="https://sql.sh/favicon.ico" rel="icon" /> <!--[if lt IE 9]> <script src="https://sql.sh/wp-content/themes/sql_sh/js/html5shiv.js" type="text/javascript"></script> <![endif]--><meta name="description" content="Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de données. SQL.sh permet d&#039;apprendre le langage SQL."/><meta name="robots" content="max-snippet:-1, max-image-preview:large, max-video-preview:-1"/><link rel="canonical" href="https://sql.sh/" /><meta property="og:locale" content="fr_FR" /><meta property="og:type" content="website" /><meta property="og:title" content="Cours et Tutoriels sur le Langage SQL" /><meta property="og:description" content="Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de données. SQL.sh permet d&#039;apprendre le langage SQL." /><meta property="og:url" content="https://sql.sh/" /><meta property="og:site_name" content="SQL" /><meta name="twitter:card" content="summary_large_image" /><meta name="twitter:description" content="Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de données. SQL.sh permet d&#039;apprendre le langage SQL." /><meta name="twitter:title" content="Cours et Tutoriels sur le Langage SQL" /><meta name="twitter:creator" content="@tonyarchambeau" /> <script type='application/ld+json' class='yoast-schema-graph yoast-schema-graph--main'>{"@context":"https://schema.org","@graph":[{"@type":"WebSite","@id":"https://sql.sh/#website","url":"https://sql.sh/","name":"SQL","potentialAction":{"@type":"SearchAction","target":"https://sql.sh/?s={search_term_string}","query-input":"required name=search_term_string"}},{"@type":"WebPage","@id":"https://sql.sh/#webpage","url":"https://sql.sh/","inLanguage":"fr-FR","name":"Cours et Tutoriels sur le Langage SQL","isPartOf":{"@id":"https://sql.sh/#website"},"datePublished":"2012-03-14T21:30:28+00:00","dateModified":"2014-05-27T20:02:07+00:00","description":"Le SQL (Structured Query Language) est un langage permettant de communiquer avec une base de donn\u00e9es. SQL.sh permet d'apprendre le langage SQL."}]}</script> <link rel='dns-prefetch' href='//s.w.org' /><link rel="alternate" type="application/rss+xml" title="SQL &raquo; Flux" href="https://sql.sh/feed" /><link rel="alternate" type="application/rss+xml" title="SQL &raquo; Flux des commentaires" href="https://sql.sh/comments/feed" /><link rel="alternate" type="application/rss+xml" title="SQL &raquo; Accueil Flux des commentaires" href="https://sql.sh/accueil/feed" /> <script type="text/javascript">window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/12.0.0-1\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/12.0.0-1\/svg\/","svgExt":".svg","source":{"concatemoji":"https:\/\/sql.sh\/wp-includes\/js\/wp-emoji-release.min.js?ver=0.0.1"}};
			!function(e,a,t){var n,r,o,i=a.createElement("canvas"),p=i.getContext&&i.getContext("2d");function s(e,t){var a=String.fromCharCode;p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,e),0,0);e=i.toDataURL();return p.clearRect(0,0,i.width,i.height),p.fillText(a.apply(this,t),0,0),e===i.toDataURL()}function c(e){var t=a.createElement("script");t.src=e,t.defer=t.type="text/javascript",a.getElementsByTagName("head")[0].appendChild(t)}for(o=Array("flag","emoji"),t.supports={everything:!0,everythingExceptFlag:!0},r=0;r<o.length;r++)t.supports[o[r]]=function(e){if(!p||!p.fillText)return!1;switch(p.textBaseline="top",p.font="600 32px Arial",e){case"flag":return s([127987,65039,8205,9895,65039],[127987,65039,8203,9895,65039])?!1:!s([55356,56826,55356,56819],[55356,56826,8203,55356,56819])&&!s([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]);case"emoji":return!s([55357,56424,55356,57342,8205,55358,56605,8205,55357,56424,55356,57340],[55357,56424,55356,57342,8203,55358,56605,8203,55357,56424,55356,57340])}return!1}(o[r]),t.supports.everything=t.supports.everything&&t.supports[o[r]],"flag"!==o[r]&&(t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&t.supports[o[r]]);t.supports.everythingExceptFlag=t.supports.everythingExceptFlag&&!t.supports.flag,t.DOMReady=!1,t.readyCallback=function(){t.DOMReady=!0},t.supports.everything||(n=function(){t.readyCallback()},a.addEventListener?(a.addEventListener("DOMContentLoaded",n,!1),e.addEventListener("load",n,!1)):(e.attachEvent("onload",n),a.attachEvent("onreadystatechange",function(){"complete"===a.readyState&&t.readyCallback()})),(n=t.source||{}).concatemoji?c(n.concatemoji):n.wpemoji&&n.twemoji&&(c(n.twemoji),c(n.wpemoji)))}(window,document,window._wpemojiSettings);</script> <style type="text/css">img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0
.07em !important;vertical-align:-0.1em !important;background:none !important;padding:0
!important}</style> <script>if (document.location.protocol != "https:") {document.location = document.URL.replace(/^http:/i, "https:");}</script><script type='text/javascript'>/*  */
var cnArgs = {"ajaxUrl":"https:\/\/sql.sh\/wp-admin\/admin-ajax.php","nonce":"7c8c68185b","hideEffect":"fade","position":"bottom","onScroll":"0","onScrollOffset":"100","onClick":"0","cookieName":"cookie_notice_accepted","cookieTime":"2592000","cookieTimeRejected":"2592000","cookiePath":"\/","cookieDomain":"","redirection":"0","cache":"1","refuse":"0","revokeCookies":"0","revokeCookiesOpt":"automatic","secure":"1"};
/*  */</script> <link rel='https://api.w.org/' href='https://sql.sh/wp-json/' /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://sql.sh/xmlrpc.php?rsd" /><link rel="wlwmanifest" type="application/wlwmanifest+xml" href="https://sql.sh/wp-includes/wlwmanifest.xml" /><link rel='shortlink' href='https://sql.sh/' /><link rel="alternate" type="application/json+oembed" href="https://sql.sh/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fsql.sh%2F" /><link rel="alternate" type="text/xml+oembed" href="https://sql.sh/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fsql.sh%2F&#038;format=xml" /><style type="text/css" media="all">@import url("https://sql.sh/wp-content/plugins/wp-table-reloaded/css/plugin.css?ver=1.9.4");</style><script data-no-minify="1" data-cfasync="false">(function(w,d){function a(){var b=d.createElement("script");b.async=!0;b.src="https://sql.sh/wp-content/plugins/wp-rocket/inc/front/js/lazyload.1.0.5.min.js";var a=d.getElementsByTagName("script")[0];a.parentNode.insertBefore(b,a)}w.attachEvent?w.attachEvent("onload",a):w.addEventListener("load",a,!1)})(window,document);</script><script type="text/javascript">jQuery(document).ready(function(){
	// hide back to top button
	jQuery("#back_to_top").hide();
	
	// display back to top button after some scroll
	jQuery(window).scroll(function () {
		if (jQuery(this).scrollTop() > 100) {
			jQuery('#back_to_top').fadeIn('slow');
		} else {
			jQuery('#back_to_top').fadeOut('slow');
		}
	});

	// scroll body to 0px on click
	jQuery('#back_to_top').click(function () {
		jQuery('body,html').animate({
			scrollTop: 0
		}, 800);
		return false;
	});
});</script> </head><body data-rsssl=1 class="home page-template-default page page-id-11 cookies-not-set"> <script type="text/javascript">window.google_analytics_uacct = "UA-1599467-30";</script> <div id="page" class="hfeed"> <header id="branding" role="banner"> <hgroup><div id="site-title"> <a href="https://sql.sh/" title="SQL" rel="home"> <img src="https://sql.sh/wp-content/themes/sql_sh/img/sql-sh-logo-245.png" alt="SQL" width="245" height="63" /> </a></div><div id="site-description">Cours et tutoriels sur le langage SQL</div> </hgroup><form method="get" id="searchform" action="https://sql.sh/"> <label for="s" class="assistive-text">Rechercher</label> <input type="text" class="field" name="s" id="s" placeholder="Rechercher" /> <input type="submit" class="submit" name="submit" id="searchsubmit" value="Rechercher" /></form> <nav id="access" role="navigation"><h3 class="assistive-text">Menu principal</h3><div class="skip-link"><a class="assistive-text" href="#content" title="Aller au contenu">Aller au contenu</a></div><div class="menu-menu_header-container"><ul id="menu-menu_header" class="menu"><li id="menu-item-156" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home current-menu-item page_item page-item-11 current_page_item menu-item-156"><a href="https://sql.sh/" aria-current="page">Accueil</a></li><li id="menu-item-158" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-158"><a href="https://sql.sh/cours">Cours</a><ul class="sub-menu"><li id="menu-item-161" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-161"><a href="https://sql.sh/cours/select">SQL SELECT</a></li><li id="menu-item-162" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-162"><a href="https://sql.sh/cours/distinct">SQL DISTINCT</a></li><li id="menu-item-163" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-163"><a href="https://sql.sh/cours/where">SQL WHERE</a></li><li id="menu-item-193" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-193"><a href="https://sql.sh/cours/group-by">SQL GROUP BY</a></li><li id="menu-item-333" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-333"><a href="https://sql.sh/cours/having">SQL HAVING</a></li><li id="menu-item-252" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-252"><a href="https://sql.sh/cours/order-by">SQL ORDER BY</a></li><li id="menu-item-276" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-276"><a href="https://sql.sh/cours/limit">SQL LIMIT</a></li><li id="menu-item-165" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-165"><a href="https://sql.sh/cours/insert-into">SQL INSERT INTO</a></li><li id="menu-item-166" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-166"><a href="https://sql.sh/cours/update">SQL UPDATE</a></li><li id="menu-item-222" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-222"><a href="https://sql.sh/cours/delete">SQL DELETE</a></li><li id="menu-item-3222" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3222"><a href="https://sql.sh/exercices-sql">Exercices SQL</a></li></ul></li><li id="menu-item-159" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-159"><a href="https://sql.sh/sgbd">Bases de Données</a></li><li id="menu-item-3145" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3145"><a href="https://sql.sh/optimisation">Optimisation</a></li><li id="menu-item-2091" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2091"><a href="https://sql.sh/livres">Livres</a></li><li id="menu-item-157" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-157"><a href="https://sql.sh/blog">Blog</a></li></ul></div> </nav> </header><div id="main"><div id="primary"><div id="content" role="main"> <article id="post-11" class="post-11 page type-page status-publish hentry"> <header class="entry-header"><h1 class="entry-title">Apprendre le SQL</h1> </header><div class="entry-content"><p>Le <strong>SQL</strong> (Structured Query Language) est un langage permettant de communiquer avec une base de données. Ce langage informatique est notamment très utilisé par les développeurs web pour communiquer avec les données d&#8217;un site web. SQL.sh recense des cours de SQL et des explications sur les principales commandes pour lire, insérer, modifier et supprimer des données dans une base.</p><h2>Cours</h2><p>Les cours ont pour but d&#8217;apprendre les principales commandes SQL telles que: <a title="SQL SELECT" href="https://sql.sh/cours/select">SELECT</a>, <a title="SQL INSERT INTO" href="https://sql.sh/cours/insert-into">INSERT INTO</a>, <a title="SQL UPDATE" href="https://sql.sh/cours/update">UPDATE</a>, <a title="SQL DELETE" href="https://sql.sh/cours/delete">DELETE</a>, <a title="SQL DROP TABLE" href="https://sql.sh/cours/sql-drop-table">DROP TABLE</a>&#8230; Chaque commande SQL est présentée par des exemples clairs et concis. Ces tutoriels peuvent vous aider à faire votre propre <strong>formation SQL</strong>.</p><p>En plus de la liste des commandes SQL, les cours présentes des fiches mnémotechniques présentant les fonctions SQL telles que <a title="SQL AVG()" href="https://sql.sh/fonctions/agregation/avg">AVG()</a>, <a title="SQL COUNT()" href="https://sql.sh/fonctions/agregation/count">COUNT()</a>, <a title="SQL MAX()" href="https://sql.sh/fonctions/agregation/max">MAX()</a> &#8230;</p><h2>Système de gestion de base de données (SGBD)</h2><p>Chaque SGBD possède ses propres spécificités et caractéristiques. Pour présenter ces différences, les logiciels de gestion de bases de données sont cités, tels que : MySQL, PostgreSQL, SQLite, Microsoft SQL Server ou encore Oracle.</p><p>Des SGBD de type NoSQL sont également présentés, tel que Cassandra, Redis ou MongoDB.</p><h2>Optimisation</h2><p>Savoir effectuer des requêtes n&#8217;est pas trop difficile, mais il convient de véritablement comprendre comment fonctionne le stockage des données et la façon dont elles sont lues pour optimiser les performances. Les optimisations sont basées dans 2 catégories: les bons choix à faire lorsqu&#8217;il faut définir la structure de la base de données et les méthodes les plus adaptées pour lire les données.</p><div class="clear"></div></div> <footer class="entry-meta"> </footer> </article></div></div><div id="secondary_left" class="widget-area" role="complementary"><div class="menu-page_sidebar-container"><ul id="menu-page_sidebar" class="menu"><li id="menu-item-281" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-281"><a href="https://sql.sh/cours">Cours</a><ul class="sub-menu"><li id="menu-item-282" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-282"><a href="https://sql.sh/cours/select">SQL SELECT</a><ul class="sub-menu"><li id="menu-item-283" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-283"><a href="https://sql.sh/cours/distinct">SQL DISTINCT</a></li><li id="menu-item-3203" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3203"><a href="https://sql.sh/cours/select/sql_no_cache">SQL SQL_NO_CACHE</a></li></ul></li><li id="menu-item-284" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-284"><a href="https://sql.sh/cours/where">SQL WHERE</a><ul class="sub-menu"><li id="menu-item-285" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-285"><a href="https://sql.sh/cours/where/and-or">SQL AND &#038; OR</a></li><li id="menu-item-432" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-432"><a href="https://sql.sh/cours/where/in">SQL IN</a></li><li id="menu-item-415" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-415"><a href="https://sql.sh/cours/where/between">SQL BETWEEN</a></li><li id="menu-item-441" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-441"><a href="https://sql.sh/cours/where/like">SQL LIKE</a><ul class="sub-menu"><li id="menu-item-3101" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3101"><a href="https://sql.sh/cours/where/like/wildcards">SQL Wildcards</a></li></ul></li><li id="menu-item-1378" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1378"><a href="https://sql.sh/cours/where/is">SQL IS NULL / IS NOT NULL</a></li></ul></li><li id="menu-item-286" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-286"><a href="https://sql.sh/cours/group-by">SQL GROUP BY</a><ul class="sub-menu"><li id="menu-item-3072" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3072"><a href="https://sql.sh/cours/group-by/with-rollup">SQL WITH ROLLUP</a></li></ul></li><li id="menu-item-334" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-334"><a href="https://sql.sh/cours/having">SQL HAVING</a></li><li id="menu-item-287" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-287"><a href="https://sql.sh/cours/order-by">SQL ORDER BY</a></li><li id="menu-item-1355" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1355"><a href="https://sql.sh/cours/alias">SQL AS (alias)</a></li><li id="menu-item-288" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-288"><a href="https://sql.sh/cours/limit">SQL LIMIT</a></li><li id="menu-item-1525" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1525"><a href="https://sql.sh/cours/case">SQL CASE</a></li><li id="menu-item-700" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-700"><a href="https://sql.sh/cours/union">SQL UNION</a><ul class="sub-menu"><li id="menu-item-710" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-710"><a href="https://sql.sh/cours/union/union-all">SQL UNION ALL</a></li></ul></li><li id="menu-item-983" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-983"><a href="https://sql.sh/cours/intersect">SQL INTERSECT</a></li><li id="menu-item-1024" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1024"><a href="https://sql.sh/cours/except">SQL EXCEPT / MINUS</a></li><li id="menu-item-289" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-289"><a href="https://sql.sh/cours/insert-into">SQL INSERT INTO</a><ul class="sub-menu"><li id="menu-item-1174" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1174"><a href="https://sql.sh/cours/insert-into/on-duplicate-key">SQL ON DUPLICATE KEY UPDATE</a></li></ul></li><li id="menu-item-290" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-290"><a href="https://sql.sh/cours/update">SQL UPDATE</a></li><li id="menu-item-291" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-291"><a href="https://sql.sh/cours/delete">SQL DELETE</a></li><li id="menu-item-2041" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2041"><a href="https://sql.sh/cours/merge">SQL MERGE</a></li><li id="menu-item-1956" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1956"><a href="https://sql.sh/cours/truncate-table">SQL TRUNCATE TABLE</a></li><li id="menu-item-447" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-447"><a href="https://sql.sh/cours/create-database">SQL CREATE DATABASE</a></li><li id="menu-item-487" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-487"><a href="https://sql.sh/cours/drop-database">SQL DROP DATABASE</a></li><li id="menu-item-488" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-488"><a href="https://sql.sh/cours/create-table">SQL CREATE TABLE</a><ul class="sub-menu"><li id="menu-item-3087" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3087"><a href="https://sql.sh/cours/create-table/primary-key">SQL PRIMARY KEY</a></li><li id="menu-item-3080" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3080"><a href="https://sql.sh/cours/create-table/auto_increment">SQL AUTO_INCREMENT</a></li></ul></li><li id="menu-item-503" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-503"><a href="https://sql.sh/cours/alter-table">SQL ALTER TABLE</a></li><li id="menu-item-574" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-574"><a href="https://sql.sh/cours/drop-table">SQL DROP TABLE</a></li><li id="menu-item-677" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-677"><a href="https://sql.sh/cours/jointures">Jointure SQL</a><ul class="sub-menu"><li id="menu-item-1070" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1070"><a href="https://sql.sh/cours/jointures/inner-join">SQL INNER JOIN</a></li><li id="menu-item-1081" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1081"><a href="https://sql.sh/cours/jointures/cross-join">SQL CROSS JOIN</a></li><li id="menu-item-1098" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1098"><a href="https://sql.sh/cours/jointures/left-join">SQL LEFT JOIN</a></li><li id="menu-item-1131" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1131"><a href="https://sql.sh/cours/jointures/right-join">SQL RIGHT JOIN</a></li><li id="menu-item-1146" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1146"><a href="https://sql.sh/cours/jointures/full-join">SQL FULL JOIN</a></li><li id="menu-item-1158" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1158"><a href="https://sql.sh/cours/jointures/self-join">SQL SELF JOIN</a></li><li id="menu-item-2182" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2182"><a href="https://sql.sh/cours/jointures/natural-join">SQL NATURAL JOIN</a></li></ul></li><li id="menu-item-1469" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1469"><a href="https://sql.sh/cours/sous-requete">SQL Sous-requête</a><ul class="sub-menu"><li id="menu-item-2047" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2047"><a href="https://sql.sh/cours/where/exists">SQL EXISTS</a></li><li id="menu-item-2055" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2055"><a href="https://sql.sh/cours/where/all">SQL ALL</a></li><li id="menu-item-2080" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2080"><a href="https://sql.sh/cours/where/any">SQL ANY / SOME</a></li></ul></li><li id="menu-item-1624" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1624"><a href="https://sql.sh/cours/index">Index SQL</a><ul class="sub-menu"><li id="menu-item-1633" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1633"><a href="https://sql.sh/cours/index/create">SQL CREATE INDEX</a></li></ul></li><li id="menu-item-1994" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1994"><a href="https://sql.sh/cours/explain">SQL EXPLAIN</a></li><li id="menu-item-2644" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2644"><a href="https://sql.sh/cours/optimize">SQL OPTIMIZE</a></li><li id="menu-item-2228" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2228"><a href="https://sql.sh/cours/commentaires">Commentaires en SQL</a></li><li id="menu-item-3223" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3223"><a href="https://sql.sh/exercices-sql">Exercices SQL</a></li></ul></li><li id="menu-item-580" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-580"><a href="https://sql.sh/fonctions">Fonctions SQL</a><ul class="sub-menu"><li id="menu-item-589" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-589"><a href="https://sql.sh/fonctions/agregation">Fonctions d&#8217;agrégation</a><ul class="sub-menu"><li id="menu-item-621" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-621"><a href="https://sql.sh/fonctions/agregation/avg">SQL AVG()</a></li><li id="menu-item-637" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-637"><a href="https://sql.sh/fonctions/agregation/count">SQL COUNT()</a></li><li id="menu-item-729" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-729"><a href="https://sql.sh/fonctions/agregation/max">SQL MAX()</a></li><li id="menu-item-1241" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1241"><a href="https://sql.sh/fonctions/agregation/min">SQL MIN()</a></li><li id="menu-item-1292" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1292"><a href="https://sql.sh/fonctions/agregation/sum">SQL SUM()</a></li></ul></li><li id="menu-item-1191" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1191"><a href="https://sql.sh/fonctions/chaines-de-caracteres">Fonctions de chaînes de caractères</a><ul class="sub-menu"><li id="menu-item-1648" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1648"><a href="https://sql.sh/fonctions/concat">SQL CONCAT()</a></li><li id="menu-item-1802" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1802"><a href="https://sql.sh/fonctions/length">SQL LENGTH()</a></li><li id="menu-item-1203" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1203"><a href="https://sql.sh/fonctions/replace">SQL REPLACE()</a></li><li id="menu-item-1778" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1778"><a href="https://sql.sh/fonctions/soundex">SQL SOUNDEX()</a></li><li id="menu-item-1269" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1269"><a href="https://sql.sh/fonctions/substring">SQL SUBSTRING()</a></li><li id="menu-item-2585" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2585"><a href="https://sql.sh/fonctions/left">SQL LEFT()</a></li><li id="menu-item-2589" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2589"><a href="https://sql.sh/fonctions/right">SQL RIGHT()</a></li><li id="menu-item-2510" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2510"><a href="https://sql.sh/fonctions/reverse">SQL REVERSE()</a></li><li id="menu-item-1664" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1664"><a href="https://sql.sh/fonctions/trim">SQL TRIM()</a></li><li id="menu-item-1681" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1681"><a href="https://sql.sh/fonctions/ltrim">SQL LTRIM()</a></li><li id="menu-item-1690" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1690"><a href="https://sql.sh/fonctions/rtrim">SQL RTRIM()</a></li><li id="menu-item-2280" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2280"><a href="https://sql.sh/fonctions/lpad">SQL LPAD()</a></li><li id="menu-item-1709" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1709"><a href="https://sql.sh/fonctions/upper">SQL UPPER()</a></li><li id="menu-item-1717" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1717"><a href="https://sql.sh/fonctions/lower">SQL LOWER()</a></li><li id="menu-item-2656" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2656"><a href="https://sql.sh/fonctions/ucase">SQL UCASE()</a></li><li id="menu-item-2655" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2655"><a href="https://sql.sh/fonctions/lcase">SQL LCASE()</a></li><li id="menu-item-1961" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1961"><a href="https://sql.sh/fonctions/locate">SQL LOCATE()</a></li><li id="menu-item-1855" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1855"><a href="https://sql.sh/fonctions/instr">SQL INSTR()</a></li></ul></li><li id="menu-item-1749" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1749"><a href="https://sql.sh/fonctions/mathematiques">Fonctions mathématiques / numérique</a><ul class="sub-menu"><li id="menu-item-1699" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1699"><a href="https://sql.sh/fonctions/rand">SQL RAND()</a></li><li id="menu-item-1485" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1485"><a href="https://sql.sh/fonctions/round">SQL ROUND()</a></li></ul></li><li id="menu-item-1757" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1757"><a href="https://sql.sh/fonctions/date-heure">Fonctions de dates et d&#8217;heures</a><ul class="sub-menu"><li id="menu-item-3161" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3161"><a href="https://sql.sh/fonctions/date_format">SQL DATE_FORMAT()</a></li><li id="menu-item-2480" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2480"><a href="https://sql.sh/fonctions/datediff">SQL DATEDIFF()</a></li><li id="menu-item-3114" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3114"><a href="https://sql.sh/fonctions/date-heure/dayofweek">SQL DAYOFWEEK()</a></li><li id="menu-item-2635" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2635"><a href="https://sql.sh/fonctions/month">SQL MONTH()</a></li><li id="menu-item-1737" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1737"><a href="https://sql.sh/fonctions/now">SQL NOW()</a></li><li id="menu-item-2469" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2469"><a href="https://sql.sh/fonctions/sec_to_time">SQL SEC_TO_TIME()</a></li><li id="menu-item-3125" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3125"><a href="https://sql.sh/fonctions/timediff">SQL TIMEDIFF()</a></li><li id="menu-item-3132" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3132"><a href="https://sql.sh/fonctions/timestamp">SQL TIMESTAMP()</a></li><li id="menu-item-2625" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2625"><a href="https://sql.sh/fonctions/year">SQL YEAR()</a></li></ul></li><li id="menu-item-1792" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1792"><a href="https://sql.sh/fonctions/chiffrement">Fonctions de chiffrements</a><ul class="sub-menu"><li id="menu-item-1816" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1816"><a href="https://sql.sh/fonctions/md5">SQL MD5()</a></li></ul></li><li id="menu-item-1768" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1768"><a href="https://sql.sh/fonctions/cast">SQL CAST()</a></li><li id="menu-item-2574" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2574"><a href="https://sql.sh/fonctions/convert">SQL CONVERT() (MySQL et SQL Server)</a></li><li id="menu-item-2580" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2580"><a href="https://sql.sh/fonctions/convert-postgresql-oracle">SQL CONVERT() (PostgreSQL et Oracle)</a></li><li id="menu-item-2270" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2270"><a href="https://sql.sh/fonctions/isnull">SQL ISNULL()</a></li><li id="menu-item-1944" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1944"><a href="https://sql.sh/fonctions/group_concat">SQL GROUP_CONCAT()</a></li><li id="menu-item-2497" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2497"><a href="https://sql.sh/fonctions/version">SQL VERSION()</a></li></ul></li><li id="menu-item-3273" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3273"><a href="https://sql.sh/cours/procedure-stockee">Procédure stockée (CREATE PROCEDURE)</a></li><li id="menu-item-3279" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3279"><a href="https://sql.sh/cours/create-trigger">CREATE TRIGGER</a></li><li id="menu-item-280" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-280"><a href="https://sql.sh/sgbd">Système de Gestion de Base de Données</a><ul class="sub-menu"><li id="menu-item-984" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-984"><a href="https://sql.sh/sgbd/mysql">MySQL</a></li><li id="menu-item-985" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-985"><a href="https://sql.sh/sgbd/postgresql">PostgreSQL</a></li><li id="menu-item-2219" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2219"><a href="https://sql.sh/sgbd/mariadb">MariaDB</a></li><li id="menu-item-2070" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2070"><a href="https://sql.sh/sgbd/oracle-database">Oracle Database</a></li><li id="menu-item-2155" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2155"><a href="https://sql.sh/sgbd/sql-server">Microsoft SQL Server</a></li><li id="menu-item-2065" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2065"><a href="https://sql.sh/sgbd/sqlite">SQLite</a></li><li id="menu-item-2120" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2120"><a href="https://sql.sh/sgbd/microsoft-access">Access</a></li><li id="menu-item-2129" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2129"><a href="https://sql.sh/sgbd/openoffice-org-base">OpenOffice.org Base</a></li><li id="menu-item-2099" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2099"><a href="https://sql.sh/sgbd/cassandra">Cassandra</a></li><li id="menu-item-2105" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2105"><a href="https://sql.sh/sgbd/redis">Redis</a></li><li id="menu-item-2114" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2114"><a href="https://sql.sh/sgbd/mongodb">MongoDB</a></li><li id="menu-item-3189" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3189"><a href="https://sql.sh/sgbd/neo4j">Neo4j</a></li></ul></li><li id="menu-item-1953" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1953"><a href="https://sql.sh/moteurs">Moteurs de stockage</a></li><li id="menu-item-2263" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2263"><a href="https://sql.sh/logiciels">Logiciels SQL</a></li></ul></div></div><div id="secondary_right" class="widget-area" role="complementary"><div></div> <aside class="widget"> <script type="text/javascript">google_ad_client = "ca-pub-3353185178320650";
			/* Sql_sh_sidebar */
			google_ad_slot = "8828142100";
			google_ad_width = 160;
			google_ad_height = 600;</script> <script type="text/javascript"
			src="//pagead2.googlesyndication.com/pagead/show_ads.js"></script> </aside><aside class="widget"><div id="ebook_pdf_sql" class="sidebar_box"> <a href="https://sql.sh/2143-cours-sql-pdf">Ebook SQL (PDF)</a></div><div id="ebook_epub_sql" class="sidebar_box"> <a href="https://sql.sh/2408-ebook-cours-sql">Ebook SQL (.epub)</a></div><div id="memento_sql" class="sidebar_box"> <a href="https://sql.sh/919-aide-memoire-mysql">Aide mémoire MySQL</a></div><div id="boutique_sql" class="sidebar_box"> <a href="https://sql.sh/boutique">Boutique SQL</a></div><div id="sql_facebook" class="sidebar_box"> <a href="http://www.facebook.com/pages/SQLsh/384110728362992">SQL.sh sur Facebook</a></div><div id="sql_twitter" class="sidebar_box"> <a href="https://twitter.com/sql_sh">SQL.sh sur Twitter</a></div> </aside></div><div class="clear"></div></div><footer id="colophon" role="contentinfo"><div class="col"><h2>Livres recommandés</h2> <button class="livre_lien" title="SQL de Frédéric Brouard"
onclick="window.open('http://www.amazon.fr/gp/product/2744011843/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&tag=tonyarchacom-21&linkCode=as2&camp=1642&creative=6746&creativeASIN=2744011843'); _gaq.push(['_trackEvent', 'footer', 'click', 'livre-sql-frederic-brouard']);"><div id="livre1"></div><div class="livre_titre">SQL</div><div class="livre_auteur">Frédéric Brouard</div> </button> <button class="livre_lien" title="Administrez vos bases de données avec MySQL de Chantal Gribaumont"
onclick="window.open('http://www.amazon.fr/gp/product/B00850RB1S/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&tag=tonyarchacom-21&linkCode=as2&camp=1642&creative=6746&creativeASIN=B00850RB1S'); _gaq.push(['_trackEvent', 'footer', 'click', 'livre-mysql-sdz']);"><div id="livre2"></div><div class="livre_titre">Administrez vos bases de données avec MySQL</div><div class="livre_auteur">Chantal Gribaumont</div> </button></div><div class="col"><h2>A propos</h2> <nav id="footer-link" role="navigation"><div class="menu-menu_footer-container"><ul id="menu-menu_footer" class="menu"><li id="menu-item-3225" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3225"><a href="https://sql.sh/forums">Forums</a></li><li id="menu-item-155" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-155"><a href="https://sql.sh/plan">Plan du site</a></li><li id="menu-item-185" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-185"><a href="https://sql.sh/mentions-legales">Mentions légales</a></li><li id="menu-item-1833" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1833"><a href="https://sql.sh/partenaires">Partenaires</a></li><li id="menu-item-186" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-186"><a href="https://sql.sh/contact">Contact</a></li></ul></div> </nav></div><div class="col"><h2>Suivre sql.sh</h2> <a href="http://feeds.feedburner.com/sql-sh">S'abonner au flux RSS</a></div><div id="site-generator"> Copyright sql.sh</div> </footer></div><button id="back_to_top" onclick="_gaq.push(['_trackEvent', 'ergonomie', 'click', 'back-to-top']);" title="Retour en haut"> <img src="https://sql.sh/wp-content/themes/sql_sh/img/button-back-to-top-40.png" alt="bouton de retour en haut" width="40" height="40" /> </button><div id="cookie-notice" role="banner" class="cookie-notice-hidden cookie-revoke-hidden cn-position-bottom" aria-label="Cookie Notice" style="background-color: rgba(50,50,58,1);"><div class="cookie-notice-container" style="color: #fff;"><span id="cn-notice-text" class="cn-text-container">Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site web. Si vous continuez à utiliser ce site, nous supposerons que vous en êtes satisfait.</span><span id="cn-notice-buttons" class="cn-buttons-container"><a href="#" id="cn-accept-cookie" data-cookie-set="accept" class="cn-set-cookie cn-button bootstrap" aria-label="OK">OK</a></span><a href="javascript:void(0);" id="cn-close-notice" data-cookie-set="accept" class="cn-close-icon" aria-label="OK"></a></div></div> <script src="https://sql.sh/wp-content/cache/min/1/8f2f5cad466a2ce10073221302892ef7.js" data-minify="1"></script><div id="fb-root"></div> <script type="text/javascript">(function(d, s, id) {
  var js, fjs = d.getElementsByTagName(s)[0];
  if (d.getElementById(id)) return;
  js = d.createElement(s); js.id = id;
  js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1";
  fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));


window.___gcfg = {lang: 'fr'};
(function() {
  var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
  po.src = 'https://apis.google.com/js/plusone.js';
  var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
})();


var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-1599467-30']);
_gaq.push(['_trackPageview']);
_gaq.push(['_trackPageLoadTime']);
(function() {
  var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
  ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
  var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();</script> </body></html>
<!-- Cached page for great performance - Debug: cached@1762085645 -->
Gestion des entetes

15/11/2025 09:49:19
Recherche du Favicon

favicon => (0)<=
Mise à jour du favicon

FAVICON:
Recherche Balises Title + Metas...

Recherche du Titre

TITLE:
Cours et Tutoriels sur le Langage SQL
15/11/2025 09:49:19
Recherche du Titre1

Balise H1:
(vide)
Recherche META Description de la page

Trouvé au moins une balise meta
META DESCRIPTION:
le sql structured query language est un langage permettant de communiquer avec une base de données. sql.sh permet d'apprendre le langage sql.
Indexing(295012)

ici 15/11/2025 09:49:19 295012
SELECT titre,description,keywords,boost FROM domaines with(nolock) WHERE id=295012
decortiquer(Cours et Tutoriels sur le Langage SQL,295012)

decortiquer_cleaner(Cours et Tutoriels sur le Langage SQL)

TITLE
N°	Mot	Résultat
0	Cours
1	et	KO (stop word)
2	Tutoriels
3	sur	KO (stop word)
4	le	KO (stop word)
5	Langage
6	SQL
decortiquer(le sql structured query language est un langage permettant de communiquer avec une base de données. sql.sh permet d'apprendre le langage sql.,295012)

decortiquer_cleaner(le sql structured query language est un langage permettant de communiquer avec une base de données. sql.sh permet d'apprendre le langage sql.)

decortiquer_cleaner(le sql structured query language est un langage permettant de communiquer avec une base de données {point} sql {point} sh permet d apprendre le langage sql {point} )

DESCRIPTION
N°	Mot	Résultat
0	le	KO (stop word)
1	sql
2	structured
3	query
4	language
5	est
6	un	KO (stop word)
7	langage
8	permettant
9	de	KO (stop word)
10	communiquer
11	avec	KO (stop word)
12	une	KO (stop word)
13	base
14	de	KO (stop word)
15	données
16	{point}
17	sql
18	{point}
19	sh
20	permet
22	apprendre
23	le	KO (stop word)
24	langage
25	sql
26	{point}
(keywords)(boost)