{"id":1342,"date":"2024-05-04T19:22:37","date_gmt":"2024-05-04T17:22:37","guid":{"rendered":"https:\/\/twp.starinux.org\/?p=1342"},"modified":"2025-10-31T19:55:09","modified_gmt":"2025-10-31T17:55:09","slug":"postgresql-base-de-donnes-relationnelles-sgbdr-samedi-4-mai-2024-a-courbevoie","status":"publish","type":"post","link":"https:\/\/www.starinux.org\/?p=1342","title":{"rendered":"POSTGRESQL\u00a0(base de donn\u00e9s relationnelles SGBDR) &#8211; \u00a0samedi 4 mai 2024 \u00e0 Courbevoie"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>OBJECTIF<\/strong>\u00a0:<br>La formation d&rsquo;initiation \u00e0 PostgreSQL vise \u00e0 fournir aux participants une introduction compl\u00e8te \u00e0 la gestion de bases de donn\u00e9es relationnelles. \u00e0 la fin de la formation, les participants auront acquis les connaissances fondamentales n\u00e9cessaires pour concevoir, cr\u00e9er et interagir avec des bases de donn\u00e9es PostgreSQL.<br>Dur\u00e9e : 1 journ\u00e9e compl\u00e8te<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PROGRAMME<\/strong>\u00a0:<br><em>Matin\u00e9e (Th\u00e9orie)<\/em>\u00a0:<br>-Pr\u00e9sentation des concepts de base des bases de donn\u00e9es relationnelles<br>-Introduction \u00e0 PostgreSQL : histoire, caract\u00e9ristiques et avantages<br>-Mod\u00e9lisation des donn\u00e9es : tables, cl\u00e9s primaires et \u00e9trang\u00e8res<br>-Requ\u00eates SQL simples : SELECT, INSERT, UPDATE, DELETE<br>-Gestion de la s\u00e9curit\u00e9 : utilisateurs, privil\u00e8ges et r\u00f4les,<br><em>Apr\u00e8s-midi (Pratique)<\/em>\u00a0:<br>-Exercices pratiques pour mettre en pratique les concepts appris le matin<br>-Cr\u00e9ation d&rsquo;une base de donn\u00e9es simple en utilisant PostgreSQL<br>-Ex\u00e9cution de requ\u00eates pour interroger et modifier la base de donn\u00e9es<br>-Introduction aux outils d&rsquo;administration de PostgreSQL : pgAdmin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Avantages de la formation<\/strong>\u00a0:<br>Introduction compl\u00e8te aux bases de donn\u00e9es relationnelles avec PostgreSQL<br>Apprentissage pratique avec des exercices interactifs<br>Encadrement personnalis\u00e9 pour favoriser la compr\u00e9hension.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Formateur<\/strong>\u00a0:<br>Formation anim\u00e9e par Mermaz DESSIEHI, un professionnel exp\u00e9riment\u00e9 dans le domaine des bases de donn\u00e9es relationnelles.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>PR\u00e9-REQUIS<\/strong>\u00a0: connaissance du principe d&rsquo;une BdD (tables, champs) : toutes infos \u00e0 events@starinux.org<\/p>\n","protected":false},"excerpt":{"rendered":"<p>OBJECTIF\u00a0:La formation d&rsquo;initiation \u00e0 PostgreSQL vise \u00e0 fournir aux participants une introduction compl\u00e8te \u00e0 la gestion de bases de donn\u00e9es relationnelles. \u00e0 la fin de la formation, les participants auront acquis les connaissances fondamentales n\u00e9cessaires pour concevoir, cr\u00e9er et interagir avec des bases de donn\u00e9es PostgreSQL.Dur\u00e9e : 1 journ\u00e9e compl\u00e8te PROGRAMME\u00a0:Matin\u00e9e (Th\u00e9orie)\u00a0:-Pr\u00e9sentation des concepts de &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.starinux.org\/?p=1342\">Lire la suite<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_crdt_document":"","_piecal_is_event":true,"_piecal_start_date":"2024-05-04T19:21:00","_piecal_end_date":"2024-05-04T19:21:00","_piecal_is_allday":false,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1342","post","type-post","status-publish","format-standard","hentry","category-ateliers-passes","item-wrap"],"publishpress_future_action":{"enabled":false,"date":"2026-04-15 15:00:27","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/posts\/1342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.starinux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1342"}],"version-history":[{"count":1,"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/posts\/1342\/revisions"}],"predecessor-version":[{"id":1343,"href":"https:\/\/www.starinux.org\/index.php?rest_route=\/wp\/v2\/posts\/1342\/revisions\/1343"}],"wp:attachment":[{"href":"https:\/\/www.starinux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.starinux.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.starinux.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}