{"id":532,"date":"2024-02-29T19:15:31","date_gmt":"2024-02-29T18:15:31","guid":{"rendered":"http:\/\/192.168.10.110:8080\/?page_id=532"},"modified":"2024-02-29T22:04:24","modified_gmt":"2024-02-29T21:04:24","slug":"pgsql-init","status":"publish","type":"page","link":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/","title":{"rendered":"PostgreSQL \u2013 Initiation pgsql-init"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote gutenify-section-c52aca00-d72d-11ee-91e7-7793d3d6f54a\">\n<p class=\"gutenify-section-dacad490-d72d-11ee-91e7-7793d3d6f54a\"><\/p>\n\n\n\n<p class=\"gutenify-section-c539be20-d72d-11ee-91e7-7793d3d6f54a\">D\u00e9couverte, installation, administration basique et utilisation de PostgreSQL<\/p>\n<\/blockquote>\n\n\n\n<h1 class=\"wp-block-heading gutenify-section-f37e87c0-d72d-11ee-91e7-7793d3d6f54a\">Objectifs p\u00e9dagogiques<\/h1>\n\n\n\n<p class=\"gutenify-section-f37f7220-d72d-11ee-91e7-7793d3d6f54a\">\u00c0 l\u2019issue de cette formation, le stagiaire sera en mesure de\u00a0:<\/p>\n\n\n\n<ul class=\"gutenify-section-f38628e0-d72d-11ee-91e7-7793d3d6f54a\">\n<li class=\"gutenify-section-f380d1b0-d72d-11ee-91e7-7793d3d6f54a\">conna\u00eetre l\u2019architecture de PostgreSQL,<\/li>\n\n\n\n<li class=\"gutenify-section-f381bc10-d72d-11ee-91e7-7793d3d6f54a\">installer PostgreSQL,<\/li>\n\n\n\n<li class=\"gutenify-section-f382a670-d72d-11ee-91e7-7793d3d6f54a\">cr\u00e9er des bases de donn\u00e9es,<\/li>\n\n\n\n<li class=\"gutenify-section-f38369c0-d72d-11ee-91e7-7793d3d6f54a\">faire des requ\u00eates SQL,<\/li>\n\n\n\n<li class=\"gutenify-section-0b1ef630-d72e-11ee-91e7-7793d3d6f54a\">conna\u00eetre la notion de droits et d\u2019acc\u00e8s aux bases de donn\u00e9es.<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading gutenify-section-0c0648f0-d72e-11ee-91e7-7793d3d6f54a\">Programme<\/h1>\n\n\n\n<ol class=\"gutenify-section-0c081db0-d72e-11ee-91e7-7793d3d6f54a\">\n<li class=\"gutenify-section-0c073350-d72e-11ee-91e7-7793d3d6f54a\">Introduction\n<ul class=\"gutenify-section-0c0f2290-d72e-11ee-91e7-7793d3d6f54a\">\n<li class=\"gutenify-section-0c08e100-d72e-11ee-91e7-7793d3d6f54a\">Le r\u00f4le et les enjeux d&rsquo;un SGBD,<\/li>\n\n\n\n<li class=\"gutenify-section-0c09f270-d72e-11ee-91e7-7793d3d6f54a\">Comprendre le mod\u00e8le serveur-client,<\/li>\n\n\n\n<li class=\"gutenify-section-0c0ab5c0-d72e-11ee-91e7-7793d3d6f54a\">Ma\u00eetriser la gestion de sch\u00e9mas et tables,<\/li>\n\n\n\n<li class=\"gutenify-section-0c0bc730-d72e-11ee-91e7-7793d3d6f54a\">Pr\u00e9sentation, historique, versionnement, licence<\/li>\n\n\n\n<li class=\"gutenify-section-0c0cb190-d72e-11ee-91e7-7793d3d6f54a\">L\u2019\u00e9cosyst\u00e8me<\/li>\n\n\n\n<li class=\"gutenify-section-0c0d74e0-d72e-11ee-91e7-7793d3d6f54a\">Les composants du serveur PostgreSQL : serveur, client, connecteurs jdbc, python, php<\/li>\n\n\n\n<li class=\"gutenify-section-0c0e3830-d72e-11ee-91e7-7793d3d6f54a\">Les outils compl\u00e9mentaires<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-0c100cf0-d72e-11ee-91e7-7793d3d6f54a\">Installation et S\u00e9curit\u00e9\n<ul class=\"gutenify-section-0c136850-d72e-11ee-91e7-7793d3d6f54a\">\n<li class=\"gutenify-section-0c11baa0-d72e-11ee-91e7-7793d3d6f54a\">Installation<\/li>\n\n\n\n<li class=\"gutenify-section-0c127df0-d72e-11ee-91e7-7793d3d6f54a\">Configuration, postgresql.conf<\/li>\n\n\n\n<li class=\"gutenify-section-0c142ba0-d72e-11ee-91e7-7793d3d6f54a\">Syst\u00e8me des privil\u00e8ges : principe de fonctionnement, authentification, contr\u00f4le des droits pour les requ\u00eates<\/li>\n\n\n\n<li class=\"gutenify-section-0c153d10-d72e-11ee-91e7-7793d3d6f54a\">Gestion des comptes utilisateurs : cr\u00e9ation\/suppression de comptes, limitation des ressources, s\u00e9curisation des acc\u00e8s (\ufb01chier pg_hba.conf)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li class=\"gutenify-section-0c16eac0-d72e-11ee-91e7-7793d3d6f54a\">Utilisation\n<ul class=\"gutenify-section-0c203990-d72e-11ee-91e7-7793d3d6f54a\">\n<li class=\"gutenify-section-0c18bf80-d72e-11ee-91e7-7793d3d6f54a\">Commande psql<\/li>\n\n\n\n<li class=\"gutenify-section-0c19a9e0-d72e-11ee-91e7-7793d3d6f54a\">Les m\u00e9ta-commandes en \\xxx<\/li>\n\n\n\n<li class=\"gutenify-section-0c1a9440-d72e-11ee-91e7-7793d3d6f54a\">pgAdmin : installation, configuration<\/li>\n\n\n\n<li class=\"gutenify-section-0c1b7ea0-d72e-11ee-91e7-7793d3d6f54a\">Cr\u00e9er des objets (dont base de donn\u00e9es et tables) via les commandes (DDL) : CREATE et DROP,<\/li>\n\n\n\n<li class=\"gutenify-section-0c1c6900-d72e-11ee-91e7-7793d3d6f54a\">Manipuler les donn\u00e9es via les commandes (DML) : SELECT, INSERT, DELETE<\/li>\n\n\n\n<li class=\"gutenify-section-0c1d5360-d72e-11ee-91e7-7793d3d6f54a\">Utilisation des transactions,<\/li>\n\n\n\n<li class=\"gutenify-section-0c1e64d0-d72e-11ee-91e7-7793d3d6f54a\">R\u00e9alisation de requ\u00eates SQL via psql et pgAdmin<\/li>\n\n\n\n<li class=\"gutenify-section-0c1f2820-d72e-11ee-91e7-7793d3d6f54a\">Utilisation de connecteurs PostgreSQL (python, php)<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p class=\"gutenify-section-0c220e50-d72e-11ee-91e7-7793d3d6f54a\">SIGMAZ Consilium vous accompagne dans la d\u00e9finition de vos besoins (p\u00e9rim\u00e8tre, granularit\u00e9, format, donn\u00e9es attributaires, etc) afin de vous proposer une solution personnalis\u00e9e.<\/p>\n\n\n\n<div data-wp-interactive=\"\" class=\"wp-block-file gutenify-section-092f9560-d746-11ee-91e7-7793d3d6f54a\"><object data-wp-bind--hidden=\"!selectors.core.file.hasPdfPreview\" hidden class=\"wp-block-file__embed\" data=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-init_PostgreSQL_Initiation.pdf\" type=\"application\/pdf\" style=\"width:100%;height:600px\" aria-label=\"Contenu embarqu\u00e9 pgsql-init_PostgreSQL_Initiation.\"><\/object><a id=\"wp-block-file--media-f1eb263c-573f-4be3-ab8c-f85dee58ab7f\" href=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-init_PostgreSQL_Initiation.pdf\">pgsql-init_PostgreSQL_Initiation<\/a><a href=\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2024\/02\/pgsql-init_PostgreSQL_Initiation.pdf\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f1eb263c-573f-4be3-ab8c-f85dee58ab7f\">T\u00e9l\u00e9charger<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>D\u00e9couverte, installation, administration basique et utilisation de PostgreSQL Objectifs p\u00e9dagogiques \u00c0 l\u2019issue de cette formation, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":274,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","gutenify_custom_css":"","gutenify_custom_css_data":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium\" \/>\n<meta property=\"og:description\" content=\"D\u00e9couverte, installation, administration basique et utilisation de PostgreSQL Objectifs p\u00e9dagogiques \u00c0 l\u2019issue de cette formation, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/\" \/>\n<meta property=\"og:site_name\" content=\"SIGMAZ Consilium\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-29T21:04:24+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@SigmazConsilium\" \/>\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\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/\",\"url\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/\",\"name\":\"PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium\",\"isPartOf\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#website\"},\"datePublished\":\"2024-02-29T18:15:31+00:00\",\"dateModified\":\"2024-02-29T21:04:24+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"http:\/\/192.168.10.110:8080\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"http:\/\/192.168.10.110:8080\/formations\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL \u2013 Initiation pgsql-init\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/192.168.10.110:8080\/#website\",\"url\":\"http:\/\/192.168.10.110:8080\/\",\"name\":\"SIGMAZ Consilium\",\"description\":\"Cogit\u00e4re optimum\",\"publisher\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/192.168.10.110:8080\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/192.168.10.110:8080\/#organization\",\"name\":\"SIGMAZ Consilium\",\"url\":\"http:\/\/192.168.10.110:8080\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png\",\"contentUrl\":\"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png\",\"width\":367,\"height\":150,\"caption\":\"SIGMAZ Consilium\"},\"image\":{\"@id\":\"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/twitter.com\/SigmazConsilium\",\"https:\/\/www.linkedin.com\/company\/sigmaz-consilium\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium","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":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/","og_locale":"fr_FR","og_type":"article","og_title":"PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium","og_description":"D\u00e9couverte, installation, administration basique et utilisation de PostgreSQL Objectifs p\u00e9dagogiques \u00c0 l\u2019issue de cette formation, [&hellip;]","og_url":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/","og_site_name":"SIGMAZ Consilium","article_modified_time":"2024-02-29T21:04:24+00:00","twitter_card":"summary_large_image","twitter_site":"@SigmazConsilium","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/","url":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/","name":"PostgreSQL \u2013 Initiation pgsql-init - SIGMAZ Consilium","isPartOf":{"@id":"http:\/\/192.168.10.110:8080\/#website"},"datePublished":"2024-02-29T18:15:31+00:00","dateModified":"2024-02-29T21:04:24+00:00","breadcrumb":{"@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/192.168.10.110:8080\/formations\/pgsql-init\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"http:\/\/192.168.10.110:8080\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"http:\/\/192.168.10.110:8080\/formations\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL \u2013 Initiation pgsql-init"}]},{"@type":"WebSite","@id":"http:\/\/192.168.10.110:8080\/#website","url":"http:\/\/192.168.10.110:8080\/","name":"SIGMAZ Consilium","description":"Cogit\u00e4re optimum","publisher":{"@id":"http:\/\/192.168.10.110:8080\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/192.168.10.110:8080\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"http:\/\/192.168.10.110:8080\/#organization","name":"SIGMAZ Consilium","url":"http:\/\/192.168.10.110:8080\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/","url":"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png","contentUrl":"http:\/\/192.168.10.110:8080\/wp-content\/uploads\/2022\/10\/Logo-complet-Sigmaz-Consilium-367x150-1.png","width":367,"height":150,"caption":"SIGMAZ Consilium"},"image":{"@id":"http:\/\/192.168.10.110:8080\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/twitter.com\/SigmazConsilium","https:\/\/www.linkedin.com\/company\/sigmaz-consilium\/"]}]}},"_links":{"self":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/532"}],"collection":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/comments?post=532"}],"version-history":[{"count":4,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/532\/revisions"}],"predecessor-version":[{"id":549,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/532\/revisions\/549"}],"up":[{"embeddable":true,"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/pages\/274"}],"wp:attachment":[{"href":"http:\/\/192.168.10.110:8080\/wp-json\/wp\/v2\/media?parent=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}