{"id":4740,"date":"2023-04-25T16:02:05","date_gmt":"2023-04-25T14:02:05","guid":{"rendered":"https:\/\/www.dbi-services.com\/courses\/postgresql-for-developers\/"},"modified":"2025-11-26T17:30:57","modified_gmt":"2025-11-26T16:30:57","slug":"postgresql-fuer-entwickler","status":"publish","type":"courses","link":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/","title":{"rendered":"PostgreSQL f\u00fcr Entwickler"},"content":{"rendered":"
\n\n
\"\"<\/figure>\n\n<\/div><\/div><\/section>

Ziele<\/h2>
\n\n

<\/h2>
  • Warum Entwickler Datenbanken verstehen m\u00fcssen?<\/li>
  • Benutzer, Rollen, Schemata und Beziehungen verstehen.<\/li>
  • Berechtigungen erteilen und widerrufen<\/li>
  • Verst\u00e4ndnis der referentielle Integrit\u00e4t (Einschr\u00e4nkungen, Fremdschl\u00fcssel, Prim\u00e4rschl\u00fcssel).<\/li>
  • Daten in und aus PostgreSQL eingeben.<\/li>
  • Trigger verstehen<\/li>
  • Mit JSON in der Datenbank arbeiten.<\/li>
  • Die Volltextsuche mit PostgreSQL implementieren.<\/li>
  • Ihre Datenbank sichern<\/li>
  • Nutzung der richtigen Datentypen.<\/li>
  • Daten verschl\u00fcsseln und entschl\u00fcsseln<\/li>
  • Die Partitionierung von Tabellen verstehen<\/li><\/ul>\n\n<\/div><\/div><\/section>

    Methode<\/h2>
    \n\n

    <\/h2>
    • Pr\u00e4sentationen mit zahlreichen praktischen \u00dcbungen, Fallstudien und Live-Demonstrationen<\/li>
    • Diskussion und Networking w\u00e4hrend der Pausen und des Mittagessens (inklusive)<\/li><\/ul>\n\n<\/div><\/div><\/section>

      Zielgruppen<\/h2>
      \n\n

      <\/h2>
      • Diese PostgreSQL-Schulung f\u00fcr Entwickler richtet sich an Entwickler, die mit PostgreSQL beginnen m\u00f6chten, an Entwickler, die bereits mit PostgreSQL arbeiten und ihre Datenbankkenntnisse erweitern m\u00f6chten, sowie an Datenbankadministratoren (DBAs), die mehr \u00fcber die Entwicklung erfahren m\u00f6chten.<\/li><\/ul>\n\n<\/div><\/div><\/section>

        Voraussetzungen<\/h2>

        <\/p>

        \n\n

        <\/h2>
        • In der Lage sein, auf Linux-Shell zu navigieren<\/li>
        • Grundkenntnisse in Bezug auf Datenbanken haben.<\/li>
        • Grundlegende Kenntnisse \u00fcber SQL und mit prozeduralen Sprachen haben.<\/li><\/ul>\n\n<\/div><\/div><\/section>
          <\/div><\/section>

          Rabatt von 5% f\u00fcr SOUG-, SwissPUG- und DOAG-Mitglieder<\/strong><\/p><\/div><\/section>","protected":false},"author":4,"featured_media":8286,"template":"","meta":{"_acf_changed":false},"categories":[74,78],"location":[100],"class_list":["post-4740","courses","type-courses","status-publish","has-post-thumbnail","hentry","category-database-de","category-open-source-de","location-nyon-de"],"acf":[],"yoast_head":"\nPostgreSQL f\u00fcr Entwickler - dbi services<\/title>\n<meta name=\"description\" content=\"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.\" \/>\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\/de\/schulungen\/postgresql-fuer-entwickler\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL f\u00fcr Entwickler\" \/>\n<meta property=\"og:description\" content=\"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/\" \/>\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:57+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\/de\/schulungen\/postgresql-fuer-entwickler\/\",\"url\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/\",\"name\":\"PostgreSQL f\u00fcr Entwickler - dbi services\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png\",\"datePublished\":\"2023-04-25T14:02:05+00:00\",\"dateModified\":\"2025-11-26T16:30:57+00:00\",\"description\":\"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#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\/de\/schulungen\/postgresql-fuer-entwickler\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dbi-services.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schulungen\",\"item\":\"https:\/\/www.dbi-services.com\/de\/schulungen\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PostgreSQL f\u00fcr Entwickler\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/de\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/de\/\",\"name\":\"dbi services\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.dbi-services.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dbi-services.com\/de\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi services\",\"url\":\"https:\/\/www.dbi-services.com\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/www.dbi-services.com\/de\/#\/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\/de\/#\/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 f\u00fcr Entwickler - dbi services","description":"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.","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\/de\/schulungen\/postgresql-fuer-entwickler\/","og_locale":"de_DE","og_type":"article","og_title":"PostgreSQL f\u00fcr Entwickler","og_description":"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.","og_url":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/","og_site_name":"dbi services","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_modified_time":"2025-11-26T16:30:57+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\/de\/schulungen\/postgresql-fuer-entwickler\/","url":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/","name":"PostgreSQL f\u00fcr Entwickler - dbi services","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/wp-content\/uploads\/2023\/04\/PostgreSQL-for-Devs-workshop-website.png","datePublished":"2023-04-25T14:02:05+00:00","dateModified":"2025-11-26T16:30:57+00:00","description":"In unserem Kurs PostrgreSQL f\u00fcr Entwickler erfahren Sie, was PostgreSQL f\u00fcr Sie bei der Entwicklung tun kann.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.dbi-services.com\/de\/schulungen\/postgresql-fuer-entwickler\/#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\/de\/schulungen\/postgresql-fuer-entwickler\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/de\/"},{"@type":"ListItem","position":2,"name":"Schulungen","item":"https:\/\/www.dbi-services.com\/de\/schulungen\/"},{"@type":"ListItem","position":3,"name":"PostgreSQL f\u00fcr Entwickler"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/de\/#website","url":"https:\/\/www.dbi-services.com\/de\/","name":"dbi services","description":"","publisher":{"@id":"https:\/\/www.dbi-services.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/de\/#organization","name":"dbi services","alternateName":"dbi services","url":"https:\/\/www.dbi-services.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.dbi-services.com\/de\/#\/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\/de\/#\/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\/de\/wp-json\/wp\/v2\/courses\/4740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/types\/courses"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/users\/4"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/media\/8286"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/media?parent=4740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/categories?post=4740"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.dbi-services.com\/de\/wp-json\/wp\/v2\/location?post=4740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}