{"id":4736,"date":"2023-04-25T15:56:03","date_gmt":"2023-04-25T13:56:03","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/postgresql-pour-les-developpeurs\/"},"modified":"2025-11-26T17:30:56","modified_gmt":"2025-11-26T16:30:56","slug":"postgresql-pour-les-developpeurs","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/","title":{"rendered":"PostgreSQL pour les d\u00e9veloppeurs"},"content":{"rendered":"
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>

Objectifs<\/h2>
\n\n

<\/h2>
  • Pourquoi les d\u00e9veloppeurs doivent-ils comprendre la base de donn\u00e9es ?<\/li>
  • Comprendre les utilisateurs, les r\u00f4les, les sch\u00e9mas et les relations<\/li>
  • Accorder et r\u00e9voquer des autorisations<\/li>
  • Comprendre l\u2019int\u00e9grit\u00e9 r\u00e9f\u00e9rentielle (contraintes, cl\u00e9s \u00e9trang\u00e8res, cl\u00e9s primaires)<\/li>
  • Introduire des donn\u00e9es dans et hors de PostgreSQL<\/li>
  • Comprendre les d\u00e9clencheurs<\/li>
  • Travailler avec JSON dans la base de donn\u00e9es<\/li>
  • Impl\u00e9menter la recherche plein texte avec PostgreSQL<\/li>
  • S\u00e9curiser votre base de donn\u00e9es<\/li>
  • Apprendre \u00e0 utiliser les bons types de donn\u00e9es<\/li>
  • Crypter et d\u00e9crypter des donn\u00e9es<\/li>
  • Comprendre le partitionnement des tables<\/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 Formation PostgreSQL pour les d\u00e9veloppeurs s\u2019adresse aux d\u00e9veloppeurs qui veulent commencer \u00e0 travailler avec PostgreSQL, aux d\u00e9veloppeurs travaillant d\u00e9j\u00e0 sur PostgreSQL et souhaitant renforcer leurs comp\u00e9tences en bases de donn\u00e9es ainsi qu\u2019aux administrateurs de bases de donn\u00e9es (DBA) qui souhaitent en savoir plus sur le d\u00e9veloppement.<\/li><\/ul>\n\n<\/div><\/div><\/section>

        Pr\u00e9requis<\/h2>

        <\/p>

        \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 sur SQL et dans les langages proc\u00e9duraux<\/li><\/ul>\n\n<\/div><\/div><\/section>
          <\/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":8285,"template":"","meta":{"_acf_changed":false},"categories":[35,39],"location":[21],"class_list":["post-4736","courses","type-courses","status-publish","has-post-thumbnail","hentry","category-database","category-open-source","location-nyon"],"acf":[],"yoast_head":"\nPostgreSQL pour les d\u00e9veloppeurs - dbi services<\/title>\n<meta name=\"description\" content=\"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.\" \/>\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\/postgresql-pour-les-developpeurs\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL pour les d\u00e9veloppeurs\" \/>\n<meta property=\"og:description\" content=\"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/\" \/>\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-26T16:30:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website-1024x1024.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\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\/postgresql-pour-les-developpeurs\/\",\"url\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/\",\"name\":\"PostgreSQL pour les d\u00e9veloppeurs - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png\",\"datePublished\":\"2023-04-25T13:56:03+00:00\",\"dateModified\":\"2025-11-26T16:30:56+00:00\",\"description\":\"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png\",\"width\":1200,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#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 les d\u00e9veloppeurs\"}]},{\"@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 les d\u00e9veloppeurs - dbi services","description":"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.","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\/postgresql-pour-les-developpeurs\/","og_locale":"fr_FR","og_type":"article","og_title":"PostgreSQL pour les d\u00e9veloppeurs","og_description":"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.","og_url":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2025-11-26T16:30:56+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website-1024x1024.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\/postgresql-pour-les-developpeurs\/","url":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/","name":"PostgreSQL pour les d\u00e9veloppeurs - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png","datePublished":"2023-04-25T13:56:03+00:00","dateModified":"2025-11-26T16:30:56+00:00","description":"Dans notre formation PostrgreSQL pour les d\u00e9veloppeurs, d\u00e9couvrez ce que PostgreSQL peut faire pour vous dans le cadre du d\u00e9veloppement.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#primaryimage","url":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png","contentUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png","width":1200,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/fr\/formations\/postgresql-pour-les-developpeurs\/#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 les d\u00e9veloppeurs"}]},{"@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\/4736","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\/8285"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/media?parent=4736"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/categories?post=4736"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/fr\/wp-json\/wp\/v2\/location?post=4736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}