{"id":110,"date":"2023-09-23T16:57:32","date_gmt":"2023-09-23T16:57:32","guid":{"rendered":"https:\/\/www.wpexample.rejeanpineault.ca\/?post_type=product&#038;p=110"},"modified":"2023-09-23T19:45:00","modified_gmt":"2023-09-23T19:45:00","slug":"cours-mysql","status":"publish","type":"product","link":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql","title":{"rendered":"Cours MySQL"},"content":{"rendered":"<p>Qu&#8217;est-ce qu&#8217;une base de donn\u00e9es? C&#8217;est ce qui va nous permettre d&#8217;enregistrer des donn\u00e9es de fa\u00e7on<br \/>\norganis\u00e9e. Par exemple, on peut avoir besoin d&#8217;une base de donn\u00e9es si on veut stocker les infos<br \/>\nconcernant les utilisateurs de notre site. Et alors qu&#8217;est-ce que MySQL? C&#8217;est un syst\u00e8me de gestion de<br \/>\nbase de donn\u00e9es? Il y en a des autres comme Microsoft SQL server, Oracle mais MySQL a l&#8217;avantage<br \/>\nd&#8217;\u00eatre gratuit et surtout, il est tr\u00e8s populaire ! Pour suivre ce cours, vous devez connaitre un minimum<br \/>\nvos classiques, c&#8217;est \u00e0 dire HTML, CSS et PHP.<br \/>\nEt on d\u00e9couvrira ensemble tout l&#8217;univers des bases de donn\u00e9es: qu&#8217;est-ce qu&#8217;une table, un champs, une<br \/>\nclef, etc. Puis on apprendra le SQL, c&#8217;est le langage qui va nous permettre de manipuler nos donn\u00e9es. Je<br \/>\nvous montrerai aussi les fonctions PHP que l&#8217;on va utiliser dans nos pages Web pour communiquer avec<br \/>\nMySQL. Et le clou du spectacle c&#8217;est un site Web de folie ! On va r\u00e9aliser ensemble un menu de<br \/>\nrestaurant de A \u00e0 Z ! Hamburger, Frites, Milkshakes&#8230; Bref, vous allez saliver&#8230;. Mais attention, il ne<br \/>\ns&#8217;agit pas d&#8217;un simple site statique. Non, il est dynamique, et on va cr\u00e9er aussi tout le syst\u00e8me<br \/>\nd&#8217;administration de ce site qui va nous permettre de g\u00e9rer le contenu. On pourra ajouter, modifier et<br \/>\nsupprimer les \u00e9l\u00e9ments de notre menu directement depuis la partie admin. Bon rien que d&#8217;y penser, j&#8217;en<br \/>\nai l&#8217;eau \u00e0 la bouche. Allez, on passe \u00e0 l&#8217;action !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Qu&#8217;est-ce qu&#8217;une base de donn\u00e9es? C&#8217;est ce qui va nous permettre d&#8217;enregistrer des donn\u00e9es de fa\u00e7on organis\u00e9e. Par exemple, on peut avoir besoin d&#8217;une base de donn\u00e9es si on veut stocker les infos concernant les utilisateurs de notre site. Et alors qu&#8217;est-ce que MySQL? C&#8217;est un syst\u00e8me de gestion de base de donn\u00e9es? Il y [&hellip;]<\/p>\n","protected":false},"featured_media":96,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_cat":[30],"product_tag":[],"class_list":{"0":"post-110","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-formation-developpeur-web","8":"first","9":"instock","10":"sale","11":"virtual","12":"purchasable","13":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cours MySQL - Exemple de Blog<\/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:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cours MySQL - Exemple de Blog\" \/>\n<meta property=\"og:description\" content=\"Qu&#8217;est-ce qu&#8217;une base de donn\u00e9es? C&#8217;est ce qui va nous permettre d&#8217;enregistrer des donn\u00e9es de fa\u00e7on organis\u00e9e. Par exemple, on peut avoir besoin d&#8217;une base de donn\u00e9es si on veut stocker les infos concernant les utilisateurs de notre site. Et alors qu&#8217;est-ce que MySQL? C&#8217;est un syst\u00e8me de gestion de base de donn\u00e9es? Il y [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql\" \/>\n<meta property=\"og:site_name\" content=\"Exemple de Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-23T19:45:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql\",\"url\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql\",\"name\":\"Cours MySQL - Exemple de Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png\",\"datePublished\":\"2023-09-23T16:57:32+00:00\",\"dateModified\":\"2023-09-23T19:45:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage\",\"url\":\"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png\",\"contentUrl\":\"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.wpexample.rejeanpineault.ca\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Boutique\",\"item\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?page_id=80\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cours MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wpexample.rejeanpineault.ca\/#website\",\"url\":\"https:\/\/www.wpexample.rejeanpineault.ca\/\",\"name\":\"Exemple de Blog\",\"description\":\"Site d'exemple\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wpexample.rejeanpineault.ca\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cours MySQL - Exemple de Blog","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:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql","og_locale":"fr_FR","og_type":"article","og_title":"Cours MySQL - Exemple de Blog","og_description":"Qu&#8217;est-ce qu&#8217;une base de donn\u00e9es? C&#8217;est ce qui va nous permettre d&#8217;enregistrer des donn\u00e9es de fa\u00e7on organis\u00e9e. Par exemple, on peut avoir besoin d&#8217;une base de donn\u00e9es si on veut stocker les infos concernant les utilisateurs de notre site. Et alors qu&#8217;est-ce que MySQL? C&#8217;est un syst\u00e8me de gestion de base de donn\u00e9es? Il y [&hellip;]","og_url":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql","og_site_name":"Exemple de Blog","article_modified_time":"2023-09-23T19:45:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql","url":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql","name":"Cours MySQL - Exemple de Blog","isPartOf":{"@id":"https:\/\/www.wpexample.rejeanpineault.ca\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage"},"image":{"@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage"},"thumbnailUrl":"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png","datePublished":"2023-09-23T16:57:32+00:00","dateModified":"2023-09-23T19:45:00+00:00","breadcrumb":{"@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#primaryimage","url":"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png","contentUrl":"https:\/\/www.wpexample.rejeanpineault.ca\/wp-content\/uploads\/2023\/09\/mysql.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/www.wpexample.rejeanpineault.ca\/?product=cours-mysql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.wpexample.rejeanpineault.ca\/"},{"@type":"ListItem","position":2,"name":"Boutique","item":"https:\/\/www.wpexample.rejeanpineault.ca\/?page_id=80"},{"@type":"ListItem","position":3,"name":"Cours MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.wpexample.rejeanpineault.ca\/#website","url":"https:\/\/www.wpexample.rejeanpineault.ca\/","name":"Exemple de Blog","description":"Site d'exemple","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wpexample.rejeanpineault.ca\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"}]}},"_links":{"self":[{"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=\/wp\/v2\/product\/110"}],"collection":[{"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=110"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=\/wp\/v2\/media\/96"}],"wp:attachment":[{"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=110"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_cat&post=110"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.wpexample.rejeanpineault.ca\/index.php?rest_route=%2Fwp%2Fv2%2Fproduct_tag&post=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}