Cours en ligne SQL : Les syntaxes avancées | LinkedIn Learning, anciennement Lynda.com

<!DOCTYPE html> <html lang="fr"> <head> <meta name="pageKey" content="d_learning_course_guest">  <meta name="locale" content="fr_FR"> <meta id="config" data-app-version="2.0.2217" data-call-tree-id="AAYn3th202OQKHYd9wjAqg==" data-multiproduct-name="learning-guest-frontend" data-service-name="learning-guest-frontend" data-browser-id="34cf0f89-1b1f-4fea-846c-78eee72094bb" data-enable-page-view-heartbeat-tracking data-page-instance="urn:li:page:learning_course_guest;rLf85uvQQ9eZq5ODgTtjmg==" data-disable-jsbeacon-pagekey-suffix="false" data-member-id="0"> <link rel="canonical" href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees">     <link rel="manifest" href="/homepage-guest/manifest.json" crossorigin="use-credentials">  <script> function getDfd() {let yFn,nFn;const p=new Promise(function(y, n){yFn=y;nFn=n;});p.resolve=yFn;p.reject=nFn;return p;} window.lazyloader = getDfd(); window.tracking = getDfd(); window.impressionTracking = getDfd(); window.ingraphTracking = getDfd(); window.appDetection = getDfd(); window.pemTracking = getDfd(); </script>  <link rel="icon" href="https://static.licdn.com/aero-v1/sc/h/444zstxv7s91nepfm5et6ofge"> <title>Cours en ligne SQL : Les syntaxes avancées | LinkedIn Learning, anciennement Lynda.com</title> <meta name="robots" content="noarchive, max-image-preview:large"> <meta name="description" content="Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage."> <meta property="og:site_name" content="LinkedIn"> <meta name="twitter:site" content="@LI_Learning"> <meta name="twitter:card" content="summary"> <meta name="litmsProfileName" content="learning-guest-frontend"> <meta property="og:title" content="Cours en ligne SQL : Les syntaxes avancées | LinkedIn Learning, anciennement Lynda.com"> <meta name="twitter:title" content="Cours en ligne SQL : Les syntaxes avancées | LinkedIn Learning, anciennement Lynda.com"> <meta property="og:description" content="Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage."> <meta name="twitter:description" content="Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage."> <meta property="og:image" content="https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M"> <meta name="twitter:image" content="https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M">  <meta property="og:url" content="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees"> <meta property="og:type" content="website"> <meta name="clientSideIngraphs" content="1" data-gauge-metric-endpoint="/learning-guest/api/ingraphs/gauge" data-counter-metric-endpoint="/learning-guest/api/ingraphs/counter"> <link rel="stylesheet" href="https://static.licdn.com/aero-v1/sc/h/44a2yyoi4akpb7zqlci31zdxo"> <script type="application/ld+json"> {"@context":"http://schema.org/","@type":"Course","provider":{"@type":"Organization","name":"LinkedIn Learning","url":"https://www.linkedin.com/learning/"},"publisher":{"@type":"Organization","name":"LinkedIn Learning","url":"https://www.linkedin.com/learning/"},"hasCourseInstance":{"@type":"CourseInstance","courseMode":"online","courseWorkload":"PT1H33M27S","instructor":[{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"}]},"inLanguage":"fr","name":"SQL : Les syntaxes avancées","offers":[{"@type":"Offer","category":"Subscription"},{"@type":"Offer","category":"Paid","price":"299.99","priceCurrency":"HKD"}],"description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","image":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","creator":[{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"}],"author":[{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"}],"dateCreated":"2018-09-18","datePublished":"2018-09-18","thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","timeRequired":"PT1H33M27S","totalHistoricalEnrollment":18810,"url":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees","about":[{"@type":"Thing","url":"https://www.linkedin.com/learning/topics/sql","name":"SQL"}],"hasPart":[[{"@type":"VideoObject","name":"Bienvenue dans « SQL : Les syntaxes avancées » - Introduction","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT1M2S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/bienvenue-dans-sql-les-syntaxes-avancees"}],[{"@type":"VideoObject","name":"Utiliser les fichiers d'exercice - 1. Maîtriser les fonctions","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT1M32S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-fichiers-d-exercice"},{"@type":"VideoObject","name":"Découvrir la base d'exemple - 1. Maîtriser les fonctions","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT1M50S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/decouvrir-la-base-d-exemple"},{"@type":"VideoObject","name":"Maîtriser l'imbrication - 1. Maîtriser les fonctions","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT3M21S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/maitriser-l-imbrication"},{"@type":"VideoObject","name":"Gérer correctement les NULL - 1. Maîtriser les fonctions","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M16S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/gerer-correctement-les-null"},{"@type":"VideoObject","name":"Rechercher à l'intérieur d'un texte - 1. Maîtriser les fonctions","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M27S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/rechercher-a-l-interieur-d-un-texte"}],[{"@type":"VideoObject","name":"Réussir les jointures externes - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M13S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/reussir-les-jointures-externes"},{"@type":"VideoObject","name":"Filtrer avec les jointures externes - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M22S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/filtrer-avec-les-jointures-externes"},{"@type":"VideoObject","name":"Comprendre l'ordre d'exécution - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT3M47S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/comprendre-l-ordre-d-execution"},{"@type":"VideoObject","name":"Développer des branches de jointures - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M31S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/developper-des-branches-de-jointures"},{"@type":"VideoObject","name":"Mettre à profit des tables de calculs - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT6M10S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/mettre-a-profit-des-tables-de-calculs"},{"@type":"VideoObject","name":"Écrire des sous-requêtes - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/ecrire-des-sous-requetes"},{"@type":"VideoObject","name":"Utiliser les clauses ANY et ALL - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT3M34S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-clauses-any-et-all"},{"@type":"VideoObject","name":"Déplacer les sous-requêtes dans des expressions de table - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M4S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/deplacer-les-sous-requetes-dans-des-expressions-de-table"},{"@type":"VideoObject","name":"Utiliser l'expression de table pour un appel récursif - 2. Comprendre les jointures et les sous-requêtes","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M6S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-l-expression-de-table-pour-un-appel-recursif"}],[{"@type":"VideoObject","name":"Comprendre les fonctions de fenêtrage - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M59S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/comprendre-les-fonctions-de-fenetrage"},{"@type":"VideoObject","name":"Appliquer les fonctions d'agrégation à une fenêtre - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT2M38S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/appliquer-les-fonctions-d-agregation-a-une-fenetre"},{"@type":"VideoObject","name":"Utiliser les fonctions de comptage et de rang - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M28S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-fonctions-de-comptage-et-de-rang"},{"@type":"VideoObject","name":"Calculer une médiane avec ROW_NUMBER - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M49S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/calculer-une-mediane-avec-row-number"},{"@type":"VideoObject","name":"Utiliser un percentile - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M14S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-un-percentile"},{"@type":"VideoObject","name":"Calculer une position avec les fonctions d'offset - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT4M51S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/calculer-une-position-avec-les-fonctions-d-offset"},{"@type":"VideoObject","name":"Appliquer un cadrage - 3. Utiliser les fonctions de fenêtrage","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT5M6S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/appliquer-un-cadrage"}],[{"@type":"VideoObject","name":"Conclure cette formation sur le langage SQL - Conclusion","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT1M7S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":true,"isAccessibleForFree":false,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/conclure-cette-formation-sur-le-langage-sql"}]],"syllabusSections":[{"@type":"Syllabus","name":"Bienvenue dans « SQL : Les syntaxes avancées »","timeRequired":"PT1M2S","description":"Rudi Bruchez vous présente les objectifs de cette formation sur le langage de programmation SQL. Ce cours est destiné à un public averti qui souhaite approfondir ses connaissances de base."},{"@type":"Syllabus","name":"Utiliser les fichiers d'exercice","timeRequired":"PT1M32S","description":"Vous verrez ici comment utiliser les fichiers d'exercice fourni par votre formateur. Réalisez ainsi les manipulations avec des fichiers identiques à ceux utilisés tout au long de la formation."},{"@type":"Syllabus","name":"Découvrir la base d'exemple","timeRequired":"PT1M50S","description":"Parcourez la base de données d'exemple qui représente un centre de formation. Abordez également le sujet des différents moteurs de bases de données."},{"@type":"Syllabus","name":"Maîtriser l'imbrication","timeRequired":"PT3M21S","description":"Apprenez à utiliser au mieux les fonctions mises à votre disposition. Voyez comment utiliser une imbrication de la fonction replace."},{"@type":"Syllabus","name":"Gérer correctement les NULL","timeRequired":"PT4M16S","description":"La gestion des NULL est spécifique aux bases de données. Découvrez les fonctions avancées pour maîtriser cet aspect dans la clause WHERE et gérer les comparaisons avec les NULL."},{"@type":"Syllabus","name":"Rechercher à l'intérieur d'un texte","timeRequired":"PT4M27S","description":"Faites le tour des solutions qui permettent d'effectuer des recherches à l'intérieur d'une colonne contenant une longue chaîne de caractères. Pour cela, vous utiliserez l'opérateur LIKE, ainsi que les caractères de remplacement."},{"@type":"Syllabus","name":"Réussir les jointures externes","timeRequired":"PT5M13S","description":"Les jointures externes permettent d'exprimer une ouverture de la jointure sur une table ou sur les deux tables. Passez en revue ce concept important en langage SQL."},{"@type":"Syllabus","name":"Filtrer avec les jointures externes","timeRequired":"PT5M22S","description":"Apprenez à utiliser le mécanisme des jointures externes afin d'identifier les cas de non-correspondance dans les tables filles de vos jointures."},{"@type":"Syllabus","name":"Comprendre l'ordre d'exécution","timeRequired":"PT3M47S","description":"Vous devez comprendre l'ordre d'exécution des parties d'une requête SELECT. Il s'agit notamment de l'exécution ensembliste de la partie FROM et de celle de la partie WHERE."},{"@type":"Syllabus","name":"Développer des branches de jointures","timeRequired":"PT4M31S","description":"Créez deux branches d'un arbre de jointure pour réaliser une jointure interne et trouver des correspondances. Réalisez aussi une jointure externe pour identifier les cas de non-correspondance."},{"@type":"Syllabus","name":"Mettre à profit des tables de calculs","timeRequired":"PT6M10S","description":"Les tables de nombres et de dates, ou Tally tables, vous aident à résoudre des problèmes de façon ensembliste. Voyez comment utiliser efficacement une table de dates."},{"@type":"Syllabus","name":"Écrire des sous-requêtes","timeRequired":"PT5M","description":"Abordez les différents types de sous-requêtes ainsi que leur utilité. Apprenez également à utiliser une sous-requête qui retourne une liste dans la clause WHERE avec l'opérateur IN."},{"@type":"Syllabus","name":"Utiliser les clauses ANY et ALL","timeRequired":"PT3M34S","description":"Les clauses ANY et ALL enrichissent les possibilités de comparaison avec une sous-requête. Vous les utiliserez dans la clause WHERE afin de trouver des correspondances avec des opérateurs de différence."},{"@type":"Syllabus","name":"Déplacer les sous-requêtes dans des expressions de table","timeRequired":"PT4M4S","description":"La CTE, ou expression de table commune, permet de placer l'équivalent d'une sous-requête simple en en-tête de requête. Prenez ici une sous-requête et déplacez-la en en-tête à l'aide de cette syntaxe."},{"@type":"Syllabus","name":"Utiliser l'expression de table pour un appel récursif","timeRequired":"PT5M6S","description":"La CTE peut être appelée récursivement. Vous allez découvrir la syntaxe et l'utilité qui permettent de parcourir une hiérarchie."},{"@type":"Syllabus","name":"Comprendre les fonctions de fenêtrage","timeRequired":"PT4M59S","description":"Les fonctions de fenêtrage sont très puissantes. Elles permettent de découper des fenêtres dans le résultat du SELECT. Découvrez leur fonctionnement par rapport à des regroupements classiques."},{"@type":"Syllabus","name":"Appliquer les fonctions d'agrégation à une fenêtre","timeRequired":"PT2M38S","description":"Les fonctions d'agrégation classiques peuvent être utilisées avec une fonction de fenêtrage en leur appliquant la clause OVER. Utilisez cette fonctionnalité pour extraire des agrégations d'une requête sans GROUP BY."},{"@type":"Syllabus","name":"Utiliser les fonctions de comptage et de rang","timeRequired":"PT5M28S","description":"Les fonctions spécifiques de comptage et de rang, comme ROW_NUMBER et RANK, ont de nombreuses utilités. Découvrez un exemple d'utilisation de la fonction ROW_NUMBER."},{"@type":"Syllabus","name":"Calculer une médiane avec ROW_NUMBER","timeRequired":"PT4M49S","description":"Le calcul de la médiane est souvent plus intéressant que la moyenne arithmétique. Appliquez des astuces classiques pour calculer une médiane à partir d'une table d'employés."},{"@type":"Syllabus","name":"Utiliser un percentile","timeRequired":"PT5M14S","description":"Le sous-ensemble des fonctions de fenêtrage, que sont les fonctions de distribution, permet de définir les distributions relatives dans les lignes. Voyez comment utiliser une fonction de percentile pour réaliser le calcul de votre médiane."},{"@type":"Syllabus","name":"Calculer une position avec les fonctions d'offset","timeRequired":"PT4M51S","description":"Les fonctions d'offset, avec ou sans instruction de cadrage, permettent de récupérer le résultat d'une autre ligne du jeu de données. Apprenez à utiliser les positions pour récupérer des calculs d'autres lignes."},{"@type":"Syllabus","name":"Appliquer un cadrage","timeRequired":"PT5M6S","description":"Appliquez une instruction de cadrage de votre fenêtre pour réaliser facilement un total cumulé. Sans cette instruction, le total cumulé serait plus difficile à obtenir."},{"@type":"Syllabus","name":"Conclure cette formation sur le langage SQL","timeRequired":"PT1M7S","description":"Vous voici arrivé au terme de cette formation. Vous avez en main les outils nécessaires pour résoudre les problématiques complexes d'extraction d'informations de bases de données SQL."}],"aggregateRating":{"@type":"AggregateRating","ratingCount":62,"ratingValue":4.5,"bestRating":5,"worstRating":1},"review":[{"@type":"Review","author":{"@type":"Person","name":"nicolas delon","jobTitle":"Directeur de projet IT","url":"https://pf.linkedin.com/in/nicolas-delon-ab784422"},"reviewRating":{"@type":"Rating","ratingValue":3},"reviewBody":"Très intéressant et clair mais un vif regret sur le fait de ne trouver aucune instructions sur les exercices. Il manque dans le fichier d’exercices un document travaux pratiques qui énumérerait tous les exercices avec leurs instructions et sur les lesquels on pourrait revenir après coups ...","datePublished":"2022-05-28T19:18:18.877Z","publisher":{"@type":"Organization","name":"LinkedIn"},"bestRating":5,"worstRating":1},{"@type":"Review","author":{"@type":"Person","name":"Sandrine DELANDRE","jobTitle":"DAF CFO - Contrôleur Financier Financial Controller","url":"https://fr.linkedin.com/in/s2landre"},"reviewRating":{"@type":"Rating","ratingValue":4},"reviewBody":"Intéressant pour travailler efficacement avec le département SI","datePublished":"2021-07-20T14:47:35.582Z","publisher":{"@type":"Organization","name":"LinkedIn"},"bestRating":5,"worstRating":1}],"video":{"@type":"VideoObject","name":"Bienvenue dans « SQL : Les syntaxes avancées » - SQL : Les syntaxes avancées","author":{"@type":"Person","name":"Rudi Bruchez","description":"Sql Server consultant and trainer, Data Platform MVP","jobTitle":"Sql Server consultant and trainer, Data Platform MVP","url":"https://fr.linkedin.com/in/rudibruchez","image":"https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk"},"thumbnailUrl":"https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M","description":"Abordez les syntaxes avancées du langage SQL pour obtenir des extractions complexes plus efficacement. Allez plus loin avec les sous-requêtes, les jointures ou encore les fonctions de fenêtrage.","duration":"PT1M2S","datePublished":"2018-09-18","uploadDate":"2018-09-18","requiresSubscription":false,"isAccessibleForFree":true,"contentUrl":"https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/bienvenue-dans-sql-les-syntaxes-avancees"},"educationalLevel":"Advanced","educationalCredentialAwarded":[{"@type":"EducationalOccupationalCredential","name":"Certificat d’accomplissement LinkedIn Learning","url":"https://www.linkedin.com/help/learning/answer/a598944/learning-certificates-of-completion-faqs","credentialCategory":"Certificate","offers":[{"@type":"Offer","category":"Subscription"}]}]} </script>  </head> <body dir="ltr">   <a href="#main-content" class="skip-link btn-md btn-primary absolute z-11 -top-[100vh] focus:top-0"> Passer au contenu principal </a> <header class="header base-detail-page__header px-mobile-container-padding bg-color-background-container global-alert-offset sticky-header"> <nav class="nav pt-1.5 pb-2 flex items-center justify-between relative flex-nowrap babymamabear:py-1.5 nav--minified-mobile " aria-label="Principal"> <a href="https://fr.linkedin.com/learning/?trk=learning-course_nav-header-logo" class="nav__logo-link link-no-visited-state z-1 mr-auto min-h-[52px] flex items-center babybear:z-0 hover:no-underline focus:no-underline active:no-underline babymamabear:mr-3" data-tracking-control-name="learning-course_nav-header-logo" data-tracking-will-navigate> <div class="learning-logo"> <icon class="learning-logo__inbug onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4zqr0f9jf98vi2nkijyc3bex2"></icon> <span class="learning-logo__text" aria-hidden="true">Learning</span> <span class="sr-only">LinkedIn Learning</span> </div> </a> <section class="search-bar relative flex flex-grow h-[40px] bg-cool-gray-20 min-w-0 max-w-full mx-4 rounded-sm babymamabear:mx-0 babymamabear:mb-1.5 babymamabear:bg-color-transparent babymamabear:w-full babymamabear:flex babymamabear:flex-wrap search-bar--minified-mobile" data-current-search-type="LEARNING"> <button class="search-bar__placeholder papabear:hidden text-input w-full mt-1.5 !pl-[14px] border-1 border-solid border-color-border-faint rounded-[2px] h-[40px] max-h-[40px] flex items-center overflow-hidden cursor-text" data-tracking-control-name="learning-course_search-switcher-opener"> <icon class="text-color-icon w-3 h-3 mr-1" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/397vrsk6op88l4981ji1xe1qt"></icon> <div class="search-bar__full-placeholder font-sans text-md text-color-text max-w-[calc(100%-40px)] text-left whitespace-nowrap overflow-hidden text-ellipsis">  Chercher des compétences, sujets ou logiciels  </div> <span class="sr-only">Étendre la recherche</span> </button> <div class="switcher-tabs__trigger-and-tabs babymamabear:flex"> <button aria-expanded="false" class="switcher-tabs__placeholder flex !h-full !py-0 !pl-2 !pr-1.5 border-r-1 border-solid border-r-color-border-faint babymamabear:hidden tab-md papabear:tab-vertical papabear:justify-start cursor-pointer" data-tracking-control-name="learning-course_switcher-tabs-placeholder" aria-describedby="switcher-description"> <span class="switcher-tabs__placeholder-text m-auto"></span> <icon class="switcher-tabs__caret-down-filled onload pointer-events-none block my-auto min-h-[24px] min-w-[24px] h-[24px] babymamabear:hidden" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7asbl4deqijhoy3z2ivveispv"></icon> </button> <div id="switcher-description" class="hidden">Ce bouton affiche le type de recherche actuellement sélectionné. Il permet de détailler la liste des options de recherche, qui modifieront les termes saisis pour correspondre à la sélection actuelle.</div>  <div class="switcher-tabs hidden z-[1] w-auto min-w-[160px] mb-1.5 py-1 absolute top-[48px] left-0 border-solid border-1 border-color-border-faint papabear:container-raised babymamabear:static babymamabear:w-[100vw] babymamabear:h-[48px] babymamabear:p-0 overflow-y-hidden overflow-x-auto md:overflow-x-hidden"> <ul class="switcher-tabs__list flex flex-1 items-stretch papabear:flex-col" role="tablist"> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="jobs-search-panel" aria-selected="false" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer " data-switcher-type="JOBS" data-tracking-control-name="learning-course_switcher-tabs-jobs-search-switcher" id="job-switcher-tab" role="tab"> Emplois </button> </li> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="people-search-panel" aria-selected="false" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer " data-switcher-type="PEOPLE" data-tracking-control-name="learning-course_switcher-tabs-people-search-switcher" id="people-switcher-tab" role="tab"> Personnes </button> </li> <li class="switcher-tabs__tab h-[44px] babymamabear:basis-1/2" role="presentation"> <button aria-controls="learning-search-panel" aria-selected="true" class="switcher-tabs__button w-full h-full tab-md papabear:tab-vertical papabear:justify-start cursor-pointer tab-selected" data-switcher-type="LEARNING" data-tracking-control-name="learning-course_switcher-tabs-learning-search-switcher" id="learning-switcher-tab" role="tab"> LinkedIn Learning </button> </li> </ul> <button aria-label="Fermer" class="switcher-tabs__cancel-btn papabear:hidden block w-6 h-6 m-auto text-color-text-low-emphasis" data-tracking-control-name="learning-course_switcher-tabs-cancel-search-switcher" type="button"> <icon class="switcher-tabs__cancel-icon block w-3 h-3 m-auto onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </div> </div> <section class="base-search-bar w-full h-full" data-searchbar-type="PEOPLE" aria-labelledby="people-switcher-tab" id="people-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/pub/dir" data-tracking-control-name="learning-course_people-search-bar_base-search-bar-form"> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="Prénom " autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_people-search-bar_first-name_dismissable-input" maxlength="500" name="firstName" placeholder="Prénom " type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_people-search-bar_first-name_dismissable-input-clear" type="button"> <label class="sr-only">Effacer le texte</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="Nom " autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_people-search-bar_last-name_dismissable-input" maxlength="500" name="lastName" placeholder="Nom " type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_people-search-bar_last-name_dismissable-input-clear" type="button"> <label class="sr-only">Effacer le texte</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input name="trk" value="learning-course_people-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Rechercher" data-tracking-control-name="learning-course_people-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section> <section class="base-search-bar w-full h-full" data-searchbar-type="JOBS" aria-labelledby="job-switcher-tab" id="jobs-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/jobs/search" data-tracking-control-name="learning-course_jobs-search-bar_base-search-bar-form"> <code id="i18n_aria_live_text_no-suggestions" style="display: none"></code> <code id="i18n_aria_live_text_one-suggestion" style="display: none"></code> <code id="i18n_aria_live_text_multiple-suggestions" style="display: none"></code> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 typeahead-input keywords-typeahead-input text-input"> <input aria-autocomplete="list" aria-controls="job-search-bar-keywords-typeahead-list" aria-haspopup="listbox" aria-label="Rechercher des emplois ou des entreprises" autocomplete="off" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_dismissable-input" id="job-search-bar-keywords" maxlength="500" name="keywords" placeholder="Rechercher des emplois ou des entreprises" role="combobox" type="search">  <div class="typeahead-input__dropdown container-lined absolute top-[calc(100%+3px)] left-0 w-full rounded-b-md rounded-t-none z-[10] overflow-hidden max-w-none babybear:min-w-full babybear:bottom-0 babybear:overflow-y-auto"> <template class="typeahead-item-template"> <li class="typeahead-input__dropdown-item py-1.5 px-2 hover:cursor-pointer hover:bg-color-surface-new-hover hover:border-y-2 hover:border-solid hover:border-color-container-primary" role="option"> <span class="typeahead-input__dropdown-text font-sans text-sm font-bold text-color-text"></span> </li> </template> <ul class="typeahead-input__dropdown-list w-full" id="job-search-bar-keywords-typeahead-list" role="listbox"></ul> </div>  <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_dismissable-input-clear" type="button"> <label class="sr-only">Effacer le texte</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section>  <code id="i18n_aria_live_text_no-suggestions" style="display: none"></code> <code id="i18n_aria_live_text_one-suggestion" style="display: none"></code> <code id="i18n_aria_live_text_multiple-suggestions" style="display: none"></code> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 typeahead-input location-typeahead-input"> <input aria-autocomplete="list" aria-controls="job-search-bar-location-typeahead-list" aria-haspopup="listbox" aria-label="Lieu" autocomplete="off" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_dismissable-input" id="job-search-bar-location" maxlength="500" name="location" placeholder="Lieu" role="combobox" value="Île de Hong Kong" type="search">  <div class="typeahead-input__dropdown container-lined absolute top-[calc(100%+3px)] left-0 w-full rounded-b-md rounded-t-none z-[10] overflow-hidden max-w-none babybear:min-w-full babybear:bottom-0 babybear:overflow-y-auto"> <template class="typeahead-item-template"> <li class="typeahead-input__dropdown-item py-1.5 px-2 hover:cursor-pointer hover:bg-color-surface-new-hover hover:border-y-2 hover:border-solid hover:border-color-container-primary" role="option"> <span class="typeahead-input__dropdown-text font-sans text-sm font-bold text-color-text"></span> </li> </template> <ul class="typeahead-input__dropdown-list w-full" id="job-search-bar-location-typeahead-list" role="listbox"></ul> </div>  <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_dismissable-input-clear" type="button"> <label class="sr-only">Effacer le texte</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input name="geoId" value="102817007" type="hidden"> <input name="trk" value="learning-course_jobs-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Rechercher" data-tracking-control-name="learning-course_jobs-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section> <section class="base-search-bar w-full h-full" data-searchbar-type="LEARNING" aria-labelledby="learning-switcher-tab" id="learning-search-panel" role="tabpanel"> <form class="base-search-bar__form w-full flex babymamabear:mx-mobile-container-padding babymamabear:flex-col" role="search" action="/learning/search" data-tracking-control-name="learning-course_learning-search-bar_base-search-bar-form"> <section class="dismissable-input text-input !pr-3 bg-color-transparent flex items-center h-[40px] min-w-0 relative babybear:w-full babybear:mb-1 search-input"> <input aria-label="Chercher des compétences, sujets ou logiciels" autocomplete="on" class="dismissable-input__input font-sans text-md text-color-text bg-color-transparent flex items-center flex-1 focus:outline-none placeholder:text-color-text-secondary" data-tracking-control-name="learning-course_learning-search-bar_keywords_dismissable-input" maxlength="500" name="keywords" placeholder="Chercher des compétences, sujets ou logiciels" type="search"> <button class="dismissable-input__button text-color-text h-[40px] min-w-[24px] w-[24px] -mr-2 opacity-0 transition-opacity duration-[0.1s] disabled:invisible focus:opacity-100" data-tracking-control-name="learning-course_learning-search-bar_keywords_dismissable-input-clear" type="button"> <label class="sr-only">Effacer le texte</label> <icon class="dismissable-input__button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cs55jggk4p3uqh9ozxdmpvjg7"></icon> </button> </section> <input class="nav__search-uoo" name="upsellOrderOrigin" type="hidden"> <input name="trk" value="learning-course_learning-search-bar_search-submit" type="hidden"> <button class="base-search-bar__submit-btn block basis-[40px] flex-shrink-0 cursor-pointer babymamabear:invisible babymamabear:ml-[-9999px] babymamabear:w-[1px] babymamabear:h-[1px]" aria-label="Rechercher" data-tracking-control-name="learning-course_learning-search-bar_base-search-bar-search-submit" type="submit"> <icon class="base-search-bar__search-icon onload mx-auto" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cb5bsr4tsn2r4sjg9e3ls4tjl"></icon> </button> </form> </section>  <div aria-live="polite" class="search-bar__live-text sr-only" role="status"></div> </section>  <div class="nav__cta-container order-3 flex gap-x-1 justify-end min-w-[100px] flex-nowrap flex-shrink-0 babybear:flex-wrap flex-2 babymamabear:min-w-[50px] "> <a class="nav__button-tertiary btn-md btn-tertiary" href="http://fr.linkedin.com/learning/subscription/products?courseSlug=sql-les-syntaxes-avancees&destRedirectURL=https%3A%2F%2Ffr%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees&trk=learning-course_nav-header-join&upsellTrk=lil_upsell_nav_subscription&session_redirect=https%3A%2F%2Ffr.linkedin.com%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card" data-tracking-control-name="lil_upsell_nav_subscription" data-tracking-impression-name="lil_upsell_nav_subscription" data-test-live-nav-primary-cta data-tracking-will-navigate> Démarrer mon essai gratuit </a> <a class="nav__button-secondary btn-md btn-secondary-emphasis" href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&fromSignIn=true&session_redirect=https%3A%2F%2Ffr.linkedin.com%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_nav-header-signin" data-tracking-control-name="learning-course_nav-header-signin" data-tracking-will-navigate> S’identifier </a> <a aria-label="S’identifier" class="nav__link-person papabear:hidden mamabear:hidden" data-tracking-control-name="learning-course_nav-header-signin" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&fromSignIn=true&session_redirect=https%3A%2F%2Ffr.linkedin.com%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_nav-header-signin"> <img class="inline-block relative rounded-[50%] w-4 h-4 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt> </a> </div>   </nav> </header>  <div class="cta-banner "> <div class="enterprise-nav"> <div class="enterprise-nav__content-wrapper"> <p id="enterprise-nav-solutions" class="enterprise-nav__content" tabindex="-1"> Solutions pour : </p> <a href="https://learning.linkedin.com/fr-fr/for-entire-companies?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-business" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-business">Entreprise</a> <a href="https://learning.linkedin.com/fr-fr/for-higher-education?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-education" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-education">Enseignement supérieur</a> <a href="https://learning.linkedin.com/fr-fr/for-governments?src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-government" class="enterprise-nav__content" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" id="business-nav-government">Administration publique</a> <a href="/learning/subscription/teams?veh=lil_upx&src=li-learning-nav&trk=learning-course_enterprise-nav" aria-labelledby="enterprise-nav-solutions business-nav-buy" class="enterprise-nav__content" data-test-live-enterprise-upsell="true" data-tracking-control-name="learning-course_enterprise-nav" data-tracking-will-navigate="true" data-tracking-impression-name="lil_upsell_learning-course_enterprise-nav_teambuy" id="business-nav-buy">Acheter pour mon équipe</a> </div> </div>   </div> <main class="main papabear:flex papabear:w-content-max-w papabear:mx-auto papabear:pt-desktop-content-top-margin mamabear:pt-desktop-content-top-margin " id="main-content" role="main"> <section class="core-rail mx-auto papabear:w-core-rail-width mamabear:max-w-[790px] babybear:max-w-[790px]"> <ol class="breadcrumb__list"> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://fr.linkedin.com/learning/browse?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Toutes les rubriques</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://fr.linkedin.com/learning/topics/technologie?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Technologie</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://fr.linkedin.com/learning/topics/developpement-logiciel?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Développement logiciel</a> </li> <li class="breadcrumb__item"> <a class="breadcrumb__link" href="https://fr.linkedin.com/learning/topics/langages-de-programmation?trk=learning-course_breadcrumb" data-tracking-control-name="learning-course_breadcrumb" data-tracking-will-navigate>Langages de programmation</a> </li> </ol> <script type="application/ld+json"> {"@context":"http://schema.org/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Toutes les rubriques","item":"https://fr.linkedin.com/learning/browse"},{"@type":"ListItem","position":2,"name":"Technologie","item":"https://fr.linkedin.com/learning/topics/technologie"},{"@type":"ListItem","position":3,"name":"Développement logiciel","item":"https://fr.linkedin.com/learning/topics/developpement-logiciel"},{"@type":"ListItem","position":4,"name":"Langages de programmation","item":"https://fr.linkedin.com/learning/topics/langages-de-programmation"}]} </script> <section class="top-card-layout container-lined overflow-hidden babybear:rounded-[0px]"> <section class="top-card__image-container"> <img class="top-card__image" alt="SQL : Les syntaxes avancées" data-delayed-url="https://media.licdn.com/dms/image/v2/C4D0DAQG-Kw3uido1kg/learning-public-crop_675_1200/learning-public-crop_675_1200/0/1627915257993?e=2147483647&v=beta&t=o5X3S0sI5yQ2tVD_IPU8Q2-BCCpn0fJv9oJWB-vJd-M"> <a class="top-card__overlay-button" data-tracking-control-name="course_preview" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/bienvenue-dans-sql-les-syntaxes-avancees?autoplay=true&trk=course_preview"> <span class="top-card__preview-cta "> <icon class="top-card__preview-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l"> </icon> <span class="top-card__preview-cta-text">Aperçu</span> </span>  </a> </section> <div class="top-card-layout__card relative p-2 papabear:p-details-container-padding"> <div class="top-card-layout__entity-info-container flex flex-wrap papabear:flex-nowrap"> <div class="top-card-layout__entity-info flex-grow flex-shrink-0 basis-0 babybear:flex-none babybear:w-full babybear:flex-none babybear:w-full"> <h1 class="top-card-layout__title font-sans text-lg papabear:text-xl font-bold leading-open text-color-text mb-0"> SQL : Les syntaxes avancées </h1> <h2 class="top-card-layout__headline break-words font-sans text-md leading-open text-color-text"> <div class="top-card__headline-row"> <span class="top-card__headline-row-item top-card__headline-row-item--large">Avec Rudi Bruchez</span> <span class="top-card__headline-row-item">Aimé par 868 utilisateurs</span> </div> <div class="top-card__headline-row"> <span class="top-card__headline-row-item">Durée : 1 h 33 m</span> <span class="top-card__headline-row-item">Niveau de compétence : Avancé</span> <span class="top-card__headline-row-item">Émission : 18/09/2018</span> </div> </h2>   <div class="top-card-layout__cta-container flex flex-wrap mt-0.5 papabear:mt-0 ml-[-12px]"> <a href="http://fr.linkedin.com/learning/subscription/products?courseSlug=sql-les-syntaxes-avancees&destRedirectURL=https%3A%2F%2Ffr%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees&trk=course_info&upsellTrk=lil_upsell_course_info_subscription" data-tracking-control-name="lil_upsell_course_info_subscription" data-tracking-impression-name="lil_upsell_course_info_subscription" data-litms-tracking-control-name="lil_upsell_course_info_subscription" data-tracking-will-navigate class="top-card__upsell-link top-card-layout__cta mt-2 ml-1.5 h-auto babybear:flex-auto top-card-layout__cta--primary btn-md btn-primary" data-test-live-course-sub-upsell> Démarrer mon mois d’essai gratuit </a> <a class="buy-for-your-team-cta__link top-card-layout__cta mt-2 ml-1.5 h-auto babybear:flex-auto top-card-layout__cta--secondary btn-md btn-secondary" href="/learning/subscription/teams?veh=lil_upx&src=li-lil-upsell&trk=learning-course_buy-for-your-team-cta" data-tracking-control-name="learning-course_buy-for-your-team-cta" data-tracking-impression-name="lil_upsell_learning-course_buy-for-your-team-cta_teambuy" data-test-live-buy-for-your-team-upsell data-tracking-will-navigate> Acheter pour mon équipe </a> </div> </div>  </div>   </div> </section> <div class="details mx-details-container-padding"> <section class="core-section-container my-3 course-details">  <h2 class="core-section-container__title section-title"> Détails du cours </h2>  <div class="core-section-container__content break-words"> <section class="show-more-less-html course-details__description" data-max-lines="4"> <div class="show-more-less-html__markup show-more-less-html__markup--clamp-after-4 relative overflow-hidden"> Si vous avez acquis les bases du langage SQL, vous êtes capable d'effectuer des requêtes simples pour extraire les données dont vous avez besoin. Qu'en est-il des questions plus complexes pour lesquelles vous souhaitez obtenir des réponses rapidement ? Simplement en apprenant les syntaxes avancées du langage SQL, vous obtiendrez des extractions complexes de façon plus élégante et plus rapide. Dans ce cours, vous ferez le tour des outils nécessaires pour résoudre les problématiques d'extraction d'informations des bases de données et vous simplifier la tâche. Avec Rudi Bruchez, vous irez plus loin avec les sous-requêtes, les jointures qui vous permettront de lier plusieurs tables entre elles, ou encore les fonctions de fenêtrage qui ajouteront de la puissance à vos requêtes de regroupement. </div> <button class="show-more-less-html__button show-more-less-button show-more-less-html__button--more ml-0.5" data-tracking-control-name="learning-course_show-more-html-btn" aria-label="i18n_show_more" aria-expanded="false">  Show more <icon class="show-more-less-html__button-icon show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less-html__button show-more-less-button show-more-less-html__button--less ml-0.5" data-tracking-control-name="learning-course_show-less-html-btn" aria-label="i18n_show_less" aria-expanded="true">  Show less <icon class="show-more-less-html__button-icon show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button>  </section> </div> </section> <section class="core-section-container my-3 course-skills">  <h2 class="core-section-container__title section-title"> Compétences que vous obtiendrez </h2>  <div class="core-section-container__content break-words"> <ul class="course-skills__skill-list"> <li class="course-skills__skill-list-item"> <a href="https://www.linkedin.com/learning/topics/sql?trk=learning-course_pill-list" data-tracking-control-name="learning-course_pill-list" data-tracking-will-navigate class="pill flex w-fit mr-[6px] mb-1 hover:no-underline skill-pill"> SQL </a> </li> </ul> </div> </section> <section class="core-section-container my-3">  <h2 class="core-section-container__title section-title"> Obtenez un certificat à partager </h2>  <div class="core-section-container__content break-words"> <p class="course-certificate__body-paragraph">Partager ce que vous avez appris et démarquez-vous dans le secteur souhaité avec un certificat mettant en valeur vos connaissances acquises dans le cours.</p> <div class="course-certificate__image-container"> <img class="course-certificate__certificate-image" alt="Exemple de certificat" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/52nu8qc7cfcn7vrftr7ttceqt"> <div> <h3 class="course-certificate__detail-list-heading"> <div class="learning-logo"> <icon class="learning-logo__inbug onload" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4zqr0f9jf98vi2nkijyc3bex2"></icon> <span class="learning-logo__text learning-logo__text--show-on-mobile" aria-hidden="true">Learning</span> <span class="sr-only">LinkedIn Learning</span> </div> <span>Certificat d’accomplissement</span> </h3> <ul> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Affichez sur votre profil LinkedIn dans la rubrique “Licences et certificat”</p> </li> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Téléchargez ou imprimez au format PDF pour partager avec d’autres personnes</p> </li> <li class="course-certificate__detail-list-item"> <div class="course-certificate__detail-list-item-icon-wrapper"><icon data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5lqa4dj5v9gp6yjh6s6iwtdbb"></icon></div> <p class="course-certificate__detail-list-item-text">Partagez comme image en ligne pour afficher votre compétence</p> </li> </ul> </div> </div> </div> </section> <section class="core-section-container my-3 course-instructors">  <h2 class="core-section-container__title section-title"> Rencontrez le formateur </h2>  <div class="core-section-container__content break-words"> <ul class="course-instructors__list"> <li class="course-instructors__list-item"> <a href="https://fr.linkedin.com/in/rudibruchez?trk=learning-course_instructor" target="_self" data-tracking-control-name="learning-course_instructor" data-tracking-will-navigate class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link">  <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C5603AQHnIAmwZgrtjQ/profile-displayphoto-shrink_400_400/profile-displayphoto-shrink_400_400/0/1516253227814?e=2147483647&v=beta&t=mN9DZap4cMfkqdYSTQaGW27u1qOB2FolhqFIRfzunIk" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Cliquez ici pour voir le profil de formateur de Rudi Bruchez"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Rudi Bruchez </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> Sql Server consultant and trainer, Data Platform MVP </h4>   </div>  </a> </li> </ul> </div> </section> <section class="core-section-container my-3 reviews-feed">  <h2 class="core-section-container__title section-title"> Avis des apprenants </h2>  <div class="core-section-container__content break-words"> <div class="reviews-feed__ratings-summary"> <section class="ratings-summary"> <div class="ratings-summary__overall-rating"> <h3 class="ratings-summary__header"><span class="ratings-summary__rating-average">4,5</span> <span class="ratings-summary__rating-max">sur 5</span></h3> <figure class="ratings-summary__figure"> <span class="star-rating" role="img" aria-label="Évaluation : 4.5 sur 5 étoiles"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/7dacecy4xq1otzk8pae2g0hxd"></icon> </span> </span> <figcaption class="ratings-summary__ratings-total">62 notes</figcaption> </figure> </div> <div class="ratings-summary__breakdown"> <div class="ratings-summary__disclaimer"> <div class="tooltip"> <button class="tooltip__trigger ratings-summary__disclaimer-trigger" data-tracking-control-name="toggle_disclaimer" type="button"> <icon class="ratings-summary__disclaimer-icon" data-svg-class-name="ratings-summary__disclaimer-icon-svg" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/g8uts9v3k83n9e3iyvcxit0k"> </icon> <span class="ratings-summary__disclaimer-text">Comment sont calculées les notes ?</span> </button> <span role="tooltip" class="tooltip__popup" aria-hidden="true"> La note globale est calculée à partir de la moyenne des notes soumises. Les notes et les avis peuvent être soumis uniquement par des apprenants non anonymes ayant effectué au moins 40% du cours. Cela nous permet d’éviter les faux avis et le spam. </span> </div> </div> <ul> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 5 étoile </figcaption> <progress class="ratings-summary__progress-bar" max="62" value="41" aria-valuemin="0" aria-valuenow="41" aria-valuemax="62"> Valeur actuelle : 41 </progress> <span class="ratings-summary__rating-count-percent"> 66 % </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 4 étoile </figcaption> <progress class="ratings-summary__progress-bar" max="62" value="13" aria-valuemin="0" aria-valuenow="13" aria-valuemax="62"> Valeur actuelle : 13 </progress> <span class="ratings-summary__rating-count-percent"> 21 % </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 3 étoile </figcaption> <progress class="ratings-summary__progress-bar" max="62" value="8" aria-valuemin="0" aria-valuenow="8" aria-valuemax="62"> Valeur actuelle : 8 </progress> <span class="ratings-summary__rating-count-percent"> 13 % </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 2 étoile </figcaption> <progress class="ratings-summary__progress-bar" max="62" value="0" aria-valuemin="0" aria-valuenow="0" aria-valuemax="62"> Valeur actuelle : 0 </progress> <span class="ratings-summary__rating-count-percent"> 0 % </span> </figure> </li> <li> <figure class="ratings-summary__rating-count"> <figcaption class="ratings-summary__rating-count-label"> 1 étoile </figcaption> <progress class="ratings-summary__progress-bar" max="62" value="0" aria-valuemin="0" aria-valuenow="0" aria-valuemax="62"> Valeur actuelle : 0 </progress> <span class="ratings-summary__rating-count-percent"> 0 % </span> </figure> </li> </ul> </div> </section> </div> <ul class="reviews-feed__reviews-list"> <li class="reviews-feed__reviews-list-item"> <div class="review-card"> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link review-card__entity"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://pf.linkedin.com/in/nicolas-delon-ab784422?trk=learning-course" data-tracking-control-name="learning-course" data-tracking-will-navigate> <span class="sr-only"> nicolas delon  </span> </a> <img class="inline-block relative rounded-[50%] w-6 h-6 bg-color-entity-ghost-background" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="nicolas delon"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> nicolas delon  </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> Directeur de projet IT </h4>  <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <div class="review-card__content"> <div class="review-card__centered-row"> <div class="review-card__star-container"> <span class="star-rating" role="img" aria-label="Évaluation : 3 sur 5 étoiles"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0hq4l058yoqerjsrssp5pbr0"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0hq4l058yoqerjsrssp5pbr0"></icon> </span> </span> </div> <span class="review-card__rating"> 3/5 </span> <span class="review-card__date"> 28 mai 2022 </span> </div> <div class="review-card__text"> Très intéressant et clair mais un vif regret sur le fait de ne trouver aucune instructions sur les exercices. Il manque dans le fichier d’exercices un document travaux pratiques qui énumérerait tous les exercices avec leurs instructions et sur les lesquels on pourrait revenir après coups ... </div> <div class="review-card__centered-row review-card__actions"> <a class="review-card__centered-row review-card__action-button" aria-label="le commentaire de nicolas delon est utile" data-tracking-control-name="learning-course_review-card-helpful-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_review-card-helpful-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5ptx189gjbxrh9wf3ncsehms9" data-svg-class-name="review-card__like-icon"></icon> Utile </a> <span class="review-card__dot-delimiter">·</span> <a class="review-card__centered-row review-card__action-button" aria-label="Signaler le commentaire de nicolas delon" data-tracking-control-name="learning-course_review-card-report-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_review-card-report-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/d04ze1wt0ev8ck8e4ovqk762o" data-svg-class-name="review-card__flag-icon"></icon> Signaler </a> </div> </div> </div> </div>  </div> </div> </li> <li class="reviews-feed__reviews-list-item"> <div class="review-card"> <div class="base-card relative w-full hover:no-underline focus:no-underline base-card--link base-main-card flex flex-wrap py-2 pr-2 babybear:pr-0 base-main-card--link review-card__entity"> <a class="base-card__full-link absolute top-0 right-0 bottom-0 left-0 p-0 z-[2]" href="https://fr.linkedin.com/in/s2landre?trk=learning-course" data-tracking-control-name="learning-course" data-tracking-will-navigate> <span class="sr-only"> Sandrine DELANDRE  </span> </a> <img class="inline-block relative rounded-[50%] w-6 h-6 " data-delayed-url="https://media.licdn.com/dms/image/v2/C4E03AQESsJ7uncXS4g/profile-displayphoto-shrink_100_100/profile-displayphoto-shrink_100_100/0/1648393720726?e=2147483647&v=beta&t=REM1Q7rptIcYuBMoL6DFXMfTuRdRUOpgL-IDIF-G-TI" data-ghost-classes="bg-color-entity-ghost-background" data-ghost-url="https://static.licdn.com/aero-v1/sc/h/9c8pery4andzj6ohjkjp54ma2" alt="Sandrine DELANDRE"> <div class="base-main-card__info self-center ml-1 flex-1 relative break-words papabear:min-w-0 mamabear:min-w-0 babybear:w-full"> <h3 class="base-main-card__title font-sans text-[18px] font-bold text-color-text overflow-hidden "> Sandrine DELANDRE  </h3> <h4 class="base-main-card__subtitle body-text text-color-text overflow-hidden"> DAF CFO - Contrôleur Financier Financial Controller </h4>  <div class="body-text text-color-text-low-emphasis base-main-card__metadata"> <div class="review-card__content"> <div class="review-card__centered-row"> <div class="review-card__star-container"> <span class="star-rating" role="img" aria-label="Évaluation : 4 sur 5 étoiles"> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cg0ud3t24av7pe8eamnp39hfq"></icon> </span> <span class="star-rating__icon-container" aria-hidden="true"> <icon class="star-rating__icon star-rating__icon--small " data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e0hq4l058yoqerjsrssp5pbr0"></icon> </span> </span> </div> <span class="review-card__rating"> 4/5 </span> <span class="review-card__date"> 20 juillet 2021 </span> </div> <div class="review-card__text"> Intéressant pour travailler efficacement avec le département SI </div> <div class="review-card__centered-row review-card__actions"> <a class="review-card__centered-row review-card__action-button" aria-label="le commentaire de Sandrine DELANDRE est utile" data-tracking-control-name="learning-course_review-card-helpful-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_review-card-helpful-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5ptx189gjbxrh9wf3ncsehms9" data-svg-class-name="review-card__like-icon"></icon> Utile </a> <span class="review-card__dot-delimiter">·</span> <a class="review-card__centered-row review-card__action-button" aria-label="Signaler le commentaire de Sandrine DELANDRE" data-tracking-control-name="learning-course_review-card-report-button" data-tracking-will-navigate href="https://www.linkedin.com/learning-login/?redirect=https%3A%2F%2Fwww%2Elinkedin%2Ecom%2Flearning%2Fsql-les-syntaxes-avancees%3Ftrk%3Dlearning-topics_learning-search-card_search-card%26trk%3Dlearning-topics_learning-search-card_search-card&trk=learning-course_review-card-report-button" rel="nofollow"> <icon class="review-card__centered-row review-card__action-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/d04ze1wt0ev8ck8e4ovqk762o" data-svg-class-name="review-card__flag-icon"></icon> Signaler </a> </div> </div> </div> </div>  </div> </div> </li> </ul> </div> </section> </div> </section> <section class="right-rail papabear:w-right-rail-width papabear:ml-column-gutter mamabear:max-w-[790px] mamabear:px-mobile-container-padding babybear:max-w-[790px] babybear:px-mobile-container-padding"> <section class="table-of-contents mb-4 table-of-contents--with-max-height"> <h2 class="table-of-contents__header"> Table des matières </h2> <ul class="table-of-contents__list"> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Introduction <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Introduction <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/bienvenue-dans-sql-les-syntaxes-avancees?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Bienvenue dans « SQL : Les syntaxes avancées » </div> <div class="table-of-contents__item-duration"> 1 m 2 s </div> </div> </a> </li> </ul>  </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 1. Maîtriser les fonctions <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 1. Maîtriser les fonctions <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-fichiers-d-exercice?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Utiliser les fichiers d'exercice </div> <div class="table-of-contents__item-duration"> 1 m 32 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/decouvrir-la-base-d-exemple?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Découvrir la base d'exemple </div> <div class="table-of-contents__item-duration"> 1 m 50 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/maitriser-l-imbrication?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Maîtriser l'imbrication </div> <div class="table-of-contents__item-duration"> 3 m 21 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/gerer-correctement-les-null?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Gérer correctement les NULL </div> <div class="table-of-contents__item-duration"> 4 m 16 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/rechercher-a-l-interieur-d-un-texte?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Rechercher à l'intérieur d'un texte </div> <div class="table-of-contents__item-duration"> 4 m 27 s </div> </div> </a> </li> </ul>  </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 2. Comprendre les jointures et les sous-requêtes <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 2. Comprendre les jointures et les sous-requêtes <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/reussir-les-jointures-externes?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Réussir les jointures externes </div> <div class="table-of-contents__item-duration"> 5 m 13 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/filtrer-avec-les-jointures-externes?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Filtrer avec les jointures externes </div> <div class="table-of-contents__item-duration"> 5 m 22 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/comprendre-l-ordre-d-execution?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Comprendre l'ordre d'exécution </div> <div class="table-of-contents__item-duration"> 3 m 47 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/developper-des-branches-de-jointures?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Développer des branches de jointures </div> <div class="table-of-contents__item-duration"> 4 m 31 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/mettre-a-profit-des-tables-de-calculs?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Mettre à profit des tables de calculs </div> <div class="table-of-contents__item-duration"> 6 m 10 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/ecrire-des-sous-requetes?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Écrire des sous-requêtes </div> <div class="table-of-contents__item-duration"> 5 m </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-clauses-any-et-all?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <icon class="table-of-contents__item-status table-of-contents__item-status--unlocked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/5jwhkytplzxiejvhzfu0t7m8l" data-svg-class-name="table-of-contents__item-status-svg--unlocked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Utiliser les clauses ANY et ALL </div> <div class="table-of-contents__item-duration"> 3 m 34 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/deplacer-les-sous-requetes-dans-des-expressions-de-table?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Déplacer les sous-requêtes dans des expressions de table </div> <div class="table-of-contents__item-duration"> 4 m 4 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-l-expression-de-table-pour-un-appel-recursif?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Utiliser l'expression de table pour un appel récursif </div> <div class="table-of-contents__item-duration"> 5 m 6 s </div> </div> </a> </li> </ul>  </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 3. Utiliser les fonctions de fenêtrage <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> 3. Utiliser les fonctions de fenêtrage <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/comprendre-les-fonctions-de-fenetrage?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Comprendre les fonctions de fenêtrage </div> <div class="table-of-contents__item-duration"> 4 m 59 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/appliquer-les-fonctions-d-agregation-a-une-fenetre?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Appliquer les fonctions d'agrégation à une fenêtre </div> <div class="table-of-contents__item-duration"> 2 m 38 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-les-fonctions-de-comptage-et-de-rang?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Utiliser les fonctions de comptage et de rang </div> <div class="table-of-contents__item-duration"> 5 m 28 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/calculer-une-mediane-avec-row-number?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Calculer une médiane avec ROW_NUMBER </div> <div class="table-of-contents__item-duration"> 4 m 49 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/utiliser-un-percentile?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Utiliser un percentile </div> <div class="table-of-contents__item-duration"> 5 m 14 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/calculer-une-position-avec-les-fonctions-d-offset?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Calculer une position avec les fonctions d'offset </div> <div class="table-of-contents__item-duration"> 4 m 51 s </div> </div> </a> </li> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/appliquer-un-cadrage?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Appliquer un cadrage </div> <div class="table-of-contents__item-duration"> 5 m 6 s </div> </div> </a> </li> </ul>  </div> </li> <li class="toc-section"> <div class="show-more-less"> <button class="show-more-less__button show-more-less__more-button show-more-less-button " aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Conclusion <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> <button class="show-more-less__button show-more-less__less-button show-more-less-button show-more-less__button--hide" aria-expanded="false" data-tracking-control-name="learning-course_toc-section_show_more"> Conclusion <icon class="show-more-less__button--chevron show-more-less-button-icon" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/4chtt12k98xwnba1nimld2oyg"></icon> </button> <ul data-max-num-to-show="0" class="show-more-less__list show-more-less__list--hide-after-0" data-impression-id="learning-course_toc-section_show-more-less"> <li class="toc-item"> <a data-tracking-control-name="learning-course_tocItem" data-tracking-will-navigate href="https://fr.linkedin.com/learning/sql-les-syntaxes-avancees/conclure-cette-formation-sur-le-langage-sql?autoplay=true&trk=learning-course_tocItem" class="toc-item__link" aria-current="false"> <span class="a11y-text">(Verrouillé)</span> <icon class="table-of-contents__item-status table-of-contents__item-status--locked" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cfu0devb5o77ym5x8vv0oilfz" data-svg-class-name="table-of-contents__item-status-svg--locked"></icon> <div class="table-of-contents__item-details"> <div class="table-of-contents__item-title"> Conclure cette formation sur le langage SQL </div> <div class="table-of-contents__item-duration"> 1 m 7 s </div> </div> </a> </li> </ul>  </div> </li> </ul> </section> <section class="aside-section-container mb-4 subscription-value-props-aside-section"> <h2 class="aside-section-container__title section-title"> Ce qui est inclus : </h2>  <div class="aside-section-container__content break-words"> <ul> <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Entraînez-vous tout en suivant la formation</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">1 fichier d’exercice</span> </li>  <li class="subscription-value-props-aside-section__list-item"> <span class="subscription-value-props-aside-section__value-prop-label">Apprenez même en déplacement</span> <span class="subscription-value-props-aside-section__value-prop-sublabel">Accès sur tablette et téléphone</span> </li>  </ul> </div> </section>  <section class="aside-section-container mb-4"> <h2 class="aside-section-container__title section-title"> Télécharger les cours </h2>  <div class="aside-section-container__content break-words"> <p>Utilisez votre appli LinkedIn Learning iOS ou Android et regardez des cours sur votre appareil mobile sans connexion à Internet.</p> <div class="app-links-aside-section__link-container"> <a class="app-links-aside-section__link" href="https://itunes.apple.com/fr/app/apple-store/id1084807225?ls=1&pt=10746&mt=8&ct=learning_course_app_links&trk=learning-course_apple-app-store" data-tracking-control-name="learning-course_apple-app-store" data-tracking-will-navigate rel="noopener noreferrer" target="_blank"> <img alt="Télécharger sur l’App Store" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/emczv26hz24woii2j4aleyry" height="42px" width="142px"> </a> <a class="app-links-aside-section__link" href="https://play.google.com/store/apps/details?id=com.linkedin.android.learning&referrer=utm_source=linkedinlearning&utm_medium=mobileWeb&utm_campaign=learning_guest&hl=fr&ct=learning_course_app_links&trk=learning-course_google-play-store" data-tracking-control-name="learning-course_google-play-store" data-tracking-will-navigate rel="noopener noreferrer" target="_blank"> <img alt="Télécharger sur Google Play" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/535kqf5rsexfx0lucb3t6palb" height="42px" width="142px"> </a> </div> </div> </section> </section> </main> <div class="pre-footer "> <section class="core-section-container my-3 price-disclaimer">    <div class="core-section-container__content break-words"> <p class="price-disclaimer__copy"> <sup class="price-disclaimer__copy--sup">*</sup>Le prix peut varier en fonction des informations relatives au profil et au pays de facturation saisies lors de l’identification ou de l’inscription </p> </div> </section> <section class="tw-linkster bg-cool-gray-20 browse-map" data-impression-id="learning-course_linkster" data-js-module-id="linkster"> <div class="max-w-screen-content-max-w w-full flex justify-between my-0 mx-auto mamabear:px-3 babybear:px-2 babybear:flex-col"> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Parcourez la catégorie business </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/strategie-et-analyse-metier?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Analyse et stratégie d'affaires </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/leadership-et-developpement-professionnel?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Compétences professionnelles </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/diversite-equite-et-inclusion-dei?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Diversité, équité, et inclusion (DEI&B) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/developpement-de-carriere-16111848?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Développement de carrière </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/enseignement-et-pedagogie-16116198?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Enseignement et pédagogie </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/finance-et-comptabilite?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Finance et comptabilité </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/gestion-de-projet-16112729?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Gestion de projet </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/leadership-et-management-16112728?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Leadership et management </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/marketing-3?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Marketing </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/outils-et-logiciels-bureautiques?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Outils et logiciels bureautiques </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/petites-entreprises-et-entrepreneuriat?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Petites entreprises et entrepreneuriat </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/ressources-humaines-16117026?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Ressources humaines </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/service-clients-16113696?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Service client </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/ventes-16114566?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Ventes </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="Voir tous les cours en business" href="https://fr.linkedin.com/learning/topics/business-2?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> Tout voir </a> </div> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Parcourez la catégorie créativité </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/aic-architecture-ingenierie-et-construction?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> AIC (Architecture, ingénierie et construction) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/animation-et-illustration?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Animation et illustration </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/audio-et-musique?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Audio et musique </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/design-web-et-ux?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Design web </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/experience-utilisateur-16115211?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Expérience utilisateur </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/fabrication-de-produit?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Fabrication de produit </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/graphisme?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Graphisme </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/motion-graphics-et-effet-speciaux-vfx?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Motion graphics et effet spéciaux (VFX) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/retouche-d-images-photographie-2?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Retouche d'images & Photographie </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/video-audio-2?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Vidéo </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/visualisation-et-temps-reel?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Visualisation et temps réel </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="Voir tous les cours en créativité" href="https://fr.linkedin.com/learning/topics/creativite?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> Tout voir </a> </div> <div class="flex-1 w-1/2 pt-2 pr-4 pb-4 pl-0 babybear:pb-2 babybear:w-full babybear:border-b-1 babybear:border-solid babybear:border-color-border-low-emphasis babybear:last:border-b-0"> <h3 class="text-md font-bold text-color-text leading-open"> Parcourez la catégorie technologie </h3> <ul class="my-1"> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/cloud-computing?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Administration système et réseaux </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/cloud-computing-16114570?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Cloud Computing </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/securite?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Cybersécurité </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/data-science-16113699?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Data science </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/devops-16110802?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> DevOps </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/developpement-logiciel?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Développement logiciel </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/developpement-mobile?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Développement mobile </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/developpement-web?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Développement web </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/gestion-des-bases-de-donnees?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Gestion des bases de données </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/help-desk-it-16114571?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Help desk IT </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/intelligence-artificielle-ia?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Intelligence artificielle (IA) </a> </li> <li class="tw-link-column-item"> <a class="link tw-linkster-link" href="https://fr.linkedin.com/learning/topics/materiel?trk=learning-course_browsemap_link" data-js-module-id="link-column-link" data-tracking-control-name="learning-course_browsemap_link" data-tracking-will-navigate> Matériel </a> </li> </ul> <a class="link tw-linkster-general-link" aria-label="Voir tous les cours en technologie" href="https://fr.linkedin.com/learning/topics/technologie?trk=learning-course_browsemap_general-link" data-tracking-control-name="learning-course_browsemap_general-link" data-tracking-will-navigate> Tout voir </a> </div> </div> </section> </div> <footer class="li-footer bg-transparent w-full "> <ul class="li-footer__list flex flex-wrap flex-row items-start justify-start w-full h-auto min-h-[50px] my-[0px] mx-auto py-3 px-2 papabear:w-[1128px] papabear:p-0"> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <span class="sr-only">LinkedIn</span> <icon class="li-footer__copy-logo text-color-logo-brand-alt inline-block self-center h-[14px] w-[56px] mr-1" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/e12h2cd8ac580qen9qdd0qks8"></icon> <span class="li-footer__copy-text flex items-center">© 2024</span> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://about.linkedin.com?trk=d_learning_course_guest_footer-about" data-tracking-control-name="d_learning_course_guest_footer-about" data-tracking-will-navigate> À propos </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/accessibility?trk=d_learning_course_guest_footer-accessibility" data-tracking-control-name="d_learning_course_guest_footer-accessibility" data-tracking-will-navigate> Accessibilité </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/user-agreement?trk=d_learning_course_guest_footer-user-agreement" data-tracking-control-name="d_learning_course_guest_footer-user-agreement" data-tracking-will-navigate> Conditions générales d’utilisation de LinkedIn </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/privacy-policy?trk=d_learning_course_guest_footer-privacy-policy" data-tracking-control-name="d_learning_course_guest_footer-privacy-policy" data-tracking-will-navigate> Politique de confidentialité </a> </li>  <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/cookie-policy?trk=d_learning_course_guest_footer-cookie-policy" data-tracking-control-name="d_learning_course_guest_footer-cookie-policy" data-tracking-will-navigate> Politique relative aux cookies </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/copyright-policy?trk=d_learning_course_guest_footer-copyright-policy" data-tracking-control-name="d_learning_course_guest_footer-copyright-policy" data-tracking-will-navigate> Politique de copyright </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://brand.linkedin.com/policies?trk=d_learning_course_guest_footer-brand-policy" data-tracking-control-name="d_learning_course_guest_footer-brand-policy" data-tracking-will-navigate> Politique de la marque </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/psettings/guest-controls?trk=d_learning_course_guest_footer-guest-controls" data-tracking-control-name="d_learning_course_guest_footer-guest-controls" data-tracking-will-navigate> Réglages invités </a> </li> <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <a class="li-footer__item-link flex items-center font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover focus:text-color-link-focus" href="https://www.linkedin.com/legal/professional-community-policies?trk=d_learning_course_guest_footer-community-guide" data-tracking-control-name="d_learning_course_guest_footer-community-guide" data-tracking-will-navigate> Directives de la communauté </a> </li>  <li class="li-footer__item font-sans text-xs text-color-text-low-emphasis flex flex-shrink-0 justify-start p-1 relative w-50% papabear:justify-center papabear:w-auto"> <div class="collapsible-dropdown collapsible-dropdown--footer collapsible-dropdown--up flex items-center relative hyphens-auto language-selector z-2">  <ul class="collapsible-dropdown__list hidden container-raised absolute w-auto overflow-y-auto flex-col items-stretch z-1 bottom-[100%] top-auto" role="menu" tabindex="-1"> <li class="language-selector__item" role="presentation">  <button aria-label="العربية (Arabe)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ar_AE" data-locale="ar_AE" role="menuitem" lang="ar_AE"> العربية (Arabe) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="বাংলা (Bengali)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-bn_IN" data-locale="bn_IN" role="menuitem" lang="bn_IN"> বাংলা (Bengali) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Čeština (Tchèque)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-cs_CZ" data-locale="cs_CZ" role="menuitem" lang="cs_CZ"> Čeština (Tchèque) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Dansk (Danois)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-da_DK" data-locale="da_DK" role="menuitem" lang="da_DK"> Dansk (Danois) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Deutsch (Allemand)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-de_DE" data-locale="de_DE" role="menuitem" lang="de_DE"> Deutsch (Allemand) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Ελληνικά (Grec)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-el_GR" data-locale="el_GR" role="menuitem" lang="el_GR"> Ελληνικά (Grec) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="English (Anglais)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-en_US" data-locale="en_US" role="menuitem" lang="en_US"> English (Anglais) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Español (Espagnol)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-es_ES" data-locale="es_ES" role="menuitem" lang="es_ES"> Español (Espagnol) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="فارسی (Perse)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fa_IR" data-locale="fa_IR" role="menuitem" lang="fa_IR"> فارسی (Perse) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Suomi (Finnois)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-fi_FI" data-locale="fi_FI" role="menuitem" lang="fi_FI"> Suomi (Finnois) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Français (Français) sélectionné" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link--selected" data-tracking-control-name="language-selector-fr_FR" data-locale="fr_FR" role="menuitem" lang="fr_FR"> <strong>Français (Français)</strong> </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="हिंदी (Hindi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hi_IN" data-locale="hi_IN" role="menuitem" lang="hi_IN"> हिंदी (Hindi) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Magyar (Hongrois)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-hu_HU" data-locale="hu_HU" role="menuitem" lang="hu_HU"> Magyar (Hongrois) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Bahasa Indonesia (Indonésien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-in_ID" data-locale="in_ID" role="menuitem" lang="in_ID"> Bahasa Indonesia (Indonésien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Italiano (Italien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-it_IT" data-locale="it_IT" role="menuitem" lang="it_IT"> Italiano (Italien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="עברית (Hébreu)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-iw_IL" data-locale="iw_IL" role="menuitem" lang="iw_IL"> עברית (Hébreu) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="日本語 (Japonais)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ja_JP" data-locale="ja_JP" role="menuitem" lang="ja_JP"> 日本語 (Japonais) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="한국어 (Coréen)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ko_KR" data-locale="ko_KR" role="menuitem" lang="ko_KR"> 한국어 (Coréen) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="मराठी (Marathi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-mr_IN" data-locale="mr_IN" role="menuitem" lang="mr_IN"> मराठी (Marathi) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Bahasa Malaysia (Malaisien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ms_MY" data-locale="ms_MY" role="menuitem" lang="ms_MY"> Bahasa Malaysia (Malaisien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Nederlands (Néerlandais)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-nl_NL" data-locale="nl_NL" role="menuitem" lang="nl_NL"> Nederlands (Néerlandais) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Norsk (Norvégien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-no_NO" data-locale="no_NO" role="menuitem" lang="no_NO"> Norsk (Norvégien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="ਪੰਜਾਬੀ (Penjabi)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pa_IN" data-locale="pa_IN" role="menuitem" lang="pa_IN"> ਪੰਜਾਬੀ (Penjabi) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Polski (Polonais)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pl_PL" data-locale="pl_PL" role="menuitem" lang="pl_PL"> Polski (Polonais) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Português (Portugais)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-pt_BR" data-locale="pt_BR" role="menuitem" lang="pt_BR"> Português (Portugais) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Română (Roumain)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ro_RO" data-locale="ro_RO" role="menuitem" lang="ro_RO"> Română (Roumain) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Русский (Russe)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-ru_RU" data-locale="ru_RU" role="menuitem" lang="ru_RU"> Русский (Russe) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Svenska (Suédois)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-sv_SE" data-locale="sv_SE" role="menuitem" lang="sv_SE"> Svenska (Suédois) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="తెలుగు (Télougou)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-te_IN" data-locale="te_IN" role="menuitem" lang="te_IN"> తెలుగు (Télougou) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="ภาษาไทย (Thaï)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-th_TH" data-locale="th_TH" role="menuitem" lang="th_TH"> ภาษาไทย (Thaï) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Tagalog (Tagalog)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tl_PH" data-locale="tl_PH" role="menuitem" lang="tl_PH"> Tagalog (Tagalog) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Türkçe (Turc)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-tr_TR" data-locale="tr_TR" role="menuitem" lang="tr_TR"> Türkçe (Turc) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Українська (Ukrainien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-uk_UA" data-locale="uk_UA" role="menuitem" lang="uk_UA"> Українська (Ukrainien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="Tiạng Viạt (Vietnamien)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-vi_VN" data-locale="vi_VN" role="menuitem" lang="vi_VN"> Tiạng Viạt (Vietnamien) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="简体中文 (Chinois simplifié)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_CN" data-locale="zh_CN" role="menuitem" lang="zh_CN"> 简体中文 (Chinois simplifié) </button> </li> <li class="language-selector__item" role="presentation">  <button aria-label="正體中文 (Chinois traditionnel)" class="font-sans text-xs link block py-[5px] px-2 w-full hover:cursor-pointer hover:bg-color-action hover:text-color-text-on-dark focus:bg-color-action focus:text-color-text-on-dark language-selector__link !font-regular" data-tracking-control-name="language-selector-zh_TW" data-locale="zh_TW" role="menuitem" lang="zh_TW"> 正體中文 (Chinois traditionnel) </button> </li>  </ul> <button class="language-selector__button select-none relative pr-2 font-sans text-xs font-bold text-color-text-low-emphasis hover:text-color-link-hover hover:cursor-pointer focus:text-color-link-focus focus:outline-dotted focus:outline-1" aria-expanded="false" data-tracking-control-name="footer-lang-dropdown_trigger"> <span class="language-selector__label-text mr-0.5 break-words"> Langue </span> <icon class="language-selector__label-chevron w-2 h-2 absolute top-0 right-0" data-delayed-url="https://static.licdn.com/aero-v1/sc/h/cyolgscd0imw2ldqppkrb84vo"></icon> </button> </div> </li> </ul>  </footer> <script src="https://static.licdn.com/aero-v1/sc/h/eh08muqvrde4h3hc6koyij5ti" async></script>  <script src="https://static.licdn.com/aero-v1/sc/h/awgwgu3fg49q0tcvd24ku87qq" async defer></script> <script data-delayed-url="https://static.licdn.com/aero-v1/sc/h/81wy0f4hfrhoilx9eqdwg202z" data-module-id="media-player"></script> <code id="trackingData" style="display: none"></code> <code id="alcOnlyData" style="display: none"></code> </body> </html>

CINXE.COM

Cours en ligne SQL : Les syntaxes avancées | LinkedIn Learning, anciennement Lynda.com