{"id":4752,"date":"2023-04-25T16:30:30","date_gmt":"2023-04-25T14:30:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/postgresql-pour-devops\/"},"modified":"2025-11-25T15:09:37","modified_gmt":"2025-11-25T14:09:37","slug":"formation-postgresql-pour-devops","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/","title":{"rendered":"PostgreSQL pour DevOps"},"content":{"rendered":"
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>

Objectifs<\/h2>
\n\n

<\/h2>
  • Architecture PostgreSQL : processus, cluster, instance, base de donn\u00e9es<\/li>
  • Cr\u00e9er des bases de donn\u00e9es<\/li>
  • S\u2019habituer \u00e0 l\u2019interface en ligne de commande : psql<\/li>
  • Apprendre \u00e0 entrer et sortir des donn\u00e9es de PostgreSQL<\/li>
  • Comprendre les outils de surveillance<\/li>
  • Comprendre les outils de surveillance<\/li>
  • Apprendre comment l\u2019optimiseur bas\u00e9 sur les co\u00fbts optimise l\u2019acc\u00e8s \u00e0 vos donn\u00e9es.<\/li>
  • Tout savoir sur les op\u00e9rations du plan d’ex\u00e9cution (scans s\u00e9quentiels, acc\u00e8s aux index, tris, etc.)<\/li>
  • Surveiller les performances avec les outils et extensions standards de PostgreSQL<\/li>
  • Apprendre le tuning des requ\u00eates via les fonctionnalit\u00e9s disponibles pour le d\u00e9veloppeur et\/ou le DBA<\/li>
  • Comprendre les types d’index PostgreSQL<\/li><\/ul>\n\n<\/div><\/div><\/section>

    M\u00e9thode<\/h2>
    \n\n

    <\/h2>
    • Pr\u00e9sentations, exercices pratiques, \u00e9tudes de cas et d\u00e9monstrations orient\u00e9es en fonction des questions<\/li>
    • Discussion et networking durant les pauses et le repas de midi (inclus)<\/li><\/ul>\n\n<\/div><\/div><\/section>

      Cibles<\/h2>
      \n\n

      <\/h2>
      • Cette formation PostgreSQL pour DevOps s\u2019adresse aux administrateurs de bases de donn\u00e9es souhaitant acqu\u00e9rir des connaissances sur le Cluster PostgreSQL, les d\u00e9veloppeurs et DBA utilisant PostgreSQL en tant que service, dans le Cloud public ou priv\u00e9.<\/li><\/ul>\n\n<\/div><\/div><\/section>

        Pr\u00e9requis<\/strong><\/h2>
        \n\n

        <\/h2>
        • Savoir naviguer sur Linux shell<\/li>
        • Avoir des notions en mati\u00e8re de bases de donn\u00e9es.<\/li>
        • Avoir des connaissances de base en cloud computing.<\/li><\/ul>\n\n<\/div><\/div><\/section>

          R\u00e9duction de 5% pour les membres du SOUG, du SwissPUG et de la DOAG.<\/strong><\/p><\/div><\/section>","protected":false},"author":4,"featured_media":8241,"template":"","meta":{"_acf_changed":false},"categories":[35,30,39],"location":[19],"class_list":["post-4752","courses","type-courses","status-publish","has-post-thumbnail","hentry","category-database","category-devops","category-open-source","location-sur-demande"],"acf":[],"yoast_head":"\nPostgreSQL pour DevOps - dbi services<\/title>\n<meta name=\"description\" content=\"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.\" \/>\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.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL pour DevOps\" \/>\n<meta property=\"og:description\" content=\"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-25T14:09:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-DevOps-Training.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"1200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/\",\"name\":\"PostgreSQL pour DevOps - dbi services\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PostgreSQL-for-DevOps-Training.png\",\"datePublished\":\"2023-04-25T14:30:30+00:00\",\"dateModified\":\"2025-11-25T14:09:37+00:00\",\"description\":\"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PostgreSQL-for-DevOps-Training.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PostgreSQL-for-DevOps-Training.png\",\"width\":1200,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/formation-postgresql-pour-devops\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Formations\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/formations\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL pour DevOps\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/dbi-services-by-sequotech-01-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/dbi-services-by-sequotech-01-1.png\",\"width\":3230,\"height\":1100,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL pour DevOps - dbi services","description":"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.","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.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/","og_locale":"fr_FR","og_type":"article","og_title":"PostgreSQL pour DevOps","og_description":"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2025-11-25T14:09:37+00:00","og_image":[{"width":1200,"height":1200,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-DevOps-Training.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@dbiservices","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/","name":"PostgreSQL pour DevOps - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-DevOps-Training.png","datePublished":"2023-04-25T14:30:30+00:00","dateModified":"2025-11-25T14:09:37+00:00","description":"Toutes les connaissances de base dans cette formation PostgreSQL: architecture, monitoring, performance tuning, et bien plus encore.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-DevOps-Training.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-DevOps-Training.png","width":1200,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/formation-postgresql-pour-devops\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Formations","item":"https:\/\/www.dbi-services.com\/fr\/formations\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL pour DevOps"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/fr\/#website","url":"https:\/\/www.dbi-services.com\/fr\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/fr\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/06\/dbi-services-by-sequotech-01-1.png","width":3230,"height":1100,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"]}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses\/4752","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/users\/4"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media\/8241"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4752"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}