{"id":2117,"date":"2017-10-17T06:51:45","date_gmt":"2017-10-17T06:51:45","guid":{"rendered":"https:\/\/radiustheme.com\/demo\/wordpress\/eikra\/?post_type=lp_course&#038;p=690"},"modified":"2025-04-21T14:07:41","modified_gmt":"2025-04-21T14:07:41","slug":"build-a-full-web-chat-app-from-scratch-2","status":"publish","type":"lp_course","link":"https:\/\/freelance-provider.fr\/en\/courses\/build-a-full-web-chat-app-from-scratch-2\/","title":{"rendered":"SQL Databases Basics"},"content":{"rendered":"<p>This training on SQL databases will introduce you to the essential concepts and practices for managing and querying relational databases. It begins with an overview of database principles, including table structure, keys, and relationships. You will then learn basic SQL commands such as SELECT, INSERT, UPDATE, and DELETE to manipulate data. The course also covers joins to link tables, aggregation functions to summarize data, and subqueries for more complex analysis. By the end, you will be able to design efficient and optimized queries to extract valuable insights from databases. <strong>SELECT<\/strong>, <strong>INSERT<\/strong>, <strong>UPDATE<\/strong> et <strong>DELETE<\/strong>, pour manipuler les donn\u00e9es. Vous explorerez aussi les <strong>jointures<\/strong> pour lier des tables, les <strong>fonctions d\u2019agr\u00e9gation<\/strong> pour r\u00e9sumer les donn\u00e9es, et les <strong>sous-requ\u00eates<\/strong> pour effectuer des analyses plus complexes. \u00c0 la fin, vous saurez concevoir des requ\u00eates efficaces et optimis\u00e9es pour extraire des insights utiles des bases de donn\u00e9es<\/p>","protected":false},"excerpt":{"rendered":"<p>Cette formation sur les bases de donn\u00e9es SQL vous initiera aux concepts et pratiques essentiels pour g\u00e9rer et interroger des [&hellip;]<\/p>\n","protected":false},"featured_media":3666,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","course_category":[32],"course_tag":[25,31],"class_list":["post-2117","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-infrastructure","course_tag-android","course_tag-javascript","course"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Les Bases de donn\u00e9es SQL - Freelance Provider<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/freelance-provider.fr\/en\/courses\/build-a-full-web-chat-app-from-scratch-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les Bases de donn\u00e9es SQL - Freelance Provider\" \/>\n<meta property=\"og:description\" content=\"Cette formation sur les bases de donn\u00e9es SQL vous initiera aux concepts et pratiques essentiels pour g\u00e9rer et interroger des [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/freelance-provider.fr\/en\/courses\/build-a-full-web-chat-app-from-scratch-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Freelance Provider\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-21T14:07:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/\",\"url\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/\",\"name\":\"Les Bases de donn\u00e9es SQL - Freelance Provider\",\"isPartOf\":{\"@id\":\"https:\/\/freelance-provider.fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg\",\"datePublished\":\"2017-10-17T06:51:45+00:00\",\"dateModified\":\"2025-04-21T14:07:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage\",\"url\":\"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg\",\"contentUrl\":\"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg\",\"width\":1200,\"height\":600,\"caption\":\"equipe flp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/freelance-provider.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\/\/freelance-provider.fr\/courses\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Les Bases de donn\u00e9es SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/freelance-provider.fr\/#website\",\"url\":\"https:\/\/freelance-provider.fr\/\",\"name\":\"Freelance Provider\",\"description\":\"Together We Grow\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/freelance-provider.fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les Bases de donn\u00e9es SQL - Freelance Provider","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/freelance-provider.fr\/en\/courses\/build-a-full-web-chat-app-from-scratch-2\/","og_locale":"en_US","og_type":"article","og_title":"Les Bases de donn\u00e9es SQL - Freelance Provider","og_description":"Cette formation sur les bases de donn\u00e9es SQL vous initiera aux concepts et pratiques essentiels pour g\u00e9rer et interroger des [&hellip;]","og_url":"https:\/\/freelance-provider.fr\/en\/courses\/build-a-full-web-chat-app-from-scratch-2\/","og_site_name":"Freelance Provider","article_modified_time":"2025-04-21T14:07:41+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/","url":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/","name":"Les Bases de donn\u00e9es SQL - Freelance Provider","isPartOf":{"@id":"https:\/\/freelance-provider.fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage"},"image":{"@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage"},"thumbnailUrl":"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg","datePublished":"2017-10-17T06:51:45+00:00","dateModified":"2025-04-21T14:07:41+00:00","breadcrumb":{"@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#primaryimage","url":"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg","contentUrl":"https:\/\/freelance-provider.fr\/wp-content\/uploads\/2017\/10\/equipe-flp-1.jpg","width":1200,"height":600,"caption":"equipe flp"},{"@type":"BreadcrumbList","@id":"https:\/\/freelance-provider.fr\/courses\/build-a-full-web-chat-app-from-scratch-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/freelance-provider.fr\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/freelance-provider.fr\/courses\/"},{"@type":"ListItem","position":3,"name":"Les Bases de donn\u00e9es SQL"}]},{"@type":"WebSite","@id":"https:\/\/freelance-provider.fr\/#website","url":"https:\/\/freelance-provider.fr\/","name":"Freelance Provider","description":"Together We Grow","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/freelance-provider.fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/lp_course\/2117","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/types\/lp_course"}],"replies":[{"embeddable":true,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/comments?post=2117"}],"version-history":[{"count":1,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/lp_course\/2117\/revisions"}],"predecessor-version":[{"id":2696,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/lp_course\/2117\/revisions\/2696"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/media\/3666"}],"wp:attachment":[{"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/media?parent=2117"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/course_category?post=2117"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/freelance-provider.fr\/en\/wp-json\/wp\/v2\/course_tag?post=2117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}