{"id":1325,"date":"2025-07-17T14:22:07","date_gmt":"2025-07-17T11:22:07","guid":{"rendered":"https:\/\/kamp.linux.org.tr\/2025-yaz\/?page_id=1325"},"modified":"2026-07-21T14:22:22","modified_gmt":"2026-07-21T11:22:22","slug":"postgresql-veritabani-yonetimi","status":"publish","type":"page","link":"https:\/\/kamp.linux.org.tr\/2026-yaz\/kurslar\/postgresql-veritabani-yonetimi\/","title":{"rendered":"PostgreSQL Veritaban\u0131 Y\u00f6netimi"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><a class=\"btn btn-lyk\" href=\"https:\/\/kayit.linux.org.tr\/\" target=\"_blank\" rel=\"noreferrer noopener\">Kurslara kay\u0131t olmak i\u00e7in t\u0131klay\u0131n<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>E\u011fitmenler:<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Cihat K\u00fc\u00e7\u00fckba\u011fr\u0131a\u00e7\u0131k, Zeki Onur K\u00fctahya, Sungur Alp Akay<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL&#8217;in kurulumu, mimarisi, SQL nesneleri ve yetkilendirme temellerinden ba\u015flayarak; bak\u0131m, kilit mekanizmalar\u0131, MVCC ve partitioning gibi geli\u015fmi\u015f performans y\u00f6netimini, ard\u0131ndan da sistemin kesintisiz \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayan yedekleme (PITR) ve y\u00fcksek eri\u015filebilirlik (replikasyon) stratejilerini kapsaml\u0131 bir \u015fekilde ele alaca\u011f\u0131z.<\/p>\n\n\n\n<h3 class=\"wp-block-heading mb10\"><strong>Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n-\u015fartlar:<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/kamp.linux.org.tr\/2025-kis\/kurslar\/gnu-linux-sistem-yonetimi-0-5\/\" data-type=\"link\" data-id=\"https:\/\/kamp.linux.org.tr\/2025-kis\/kurslar\/gnu-linux-sistem-yonetimi-0-5\/\">GNU\/Linux Sistem Y\u00f6netimi 0.5<\/a> konular\u0131na hakim olmak <\/li>\n\n\n\n<li>Temel D\u00fczeyde SQL Bilmesi.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading mb10\"><strong>Kat\u0131l\u0131mc\u0131lar\u0131n e\u011fitime bilgisayar d\u0131\u015f\u0131nda getirmesi gereken donan\u0131m\/yaz\u0131l\u0131m:<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>VirtualBox programlar\u0131n\u0131n kurulu olmas\u0131.<\/li>\n\n\n\n<li>Ubuntu 24.04 versiyonun ISO dosyas\u0131n\u0131n indirilmesi.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading mb10\"><strong>E\u011fitim \u0130\u00e7eri\u011fi<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131 Temelleri ve \u0130li\u015fkisel Veritaban\u0131 Y\u00f6netim Sistemleri (RDBMS)<\/li>\n\n\n\n<li>PostgreSQL Giri\u015f: Tarih\u00e7e ve Temel \u00d6zellikler<\/li>\n\n\n\n<li>PostgreSQL Kurulumu ve Temel Y\u00f6netimi<\/li>\n\n\n\n<li>PostgreSQL Sistem Mimarisi ve \u00c7al\u0131\u015fma Prensipleri<\/li>\n\n\n\n<li>PostgreSQL \u0130stemci Ara\u00e7lar\u0131 ve Y\u00f6netim Uygulamalar\u0131<\/li>\n\n\n\n<li>PostgreSQL Yap\u0131land\u0131rmas\u0131 ve Parametre Y\u00f6netimi<\/li>\n\n\n\n<li>SQL Temelleri<\/li>\n\n\n\n<li>PostgreSQL Veritabanlar\u0131 Nesneleri<\/li>\n\n\n\n<li>PostgreSQL Eri\u015fim, Kullan\u0131c\u0131 ve Yetkilendirme Y\u00f6netimi<\/li>\n\n\n\n<li>PostgreSQL Sistem Kataloglar\u0131 ve Veri S\u00f6zl\u00fc\u011f\u00fc Y\u00f6netimi<\/li>\n\n\n\n<li>PostgreSQL Bak\u0131m \u0130\u015flemleri<\/li>\n\n\n\n<li>PostgreSQL Kilit Mekanizmalar\u0131<\/li>\n\n\n\n<li>PostgreSQL \u0130statistik Y\u00f6netimi<\/li>\n\n\n\n<li>PostgreSQL Transaction Y\u00f6netimi ve MVCC Mimarisi<\/li>\n\n\n\n<li>PostgreSQL Tablo B\u00f6l\u00fcmlendirme (Partitioning) Mimarisi ve Y\u00f6netimi<\/li>\n\n\n\n<li>PostgreSQL Yedekleme, Kurtarma ve PITR (Point-In-Time Recovery)<\/li>\n\n\n\n<li>PostgreSQL Y\u00fcksek Eri\u015filebilirlik ve Replikasyon Temelleri<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kurslara kay\u0131t olmak i\u00e7in t\u0131klay\u0131n E\u011fitmenler: Cihat K\u00fc\u00e7\u00fckba\u011fr\u0131a\u00e7\u0131k, Zeki Onur K\u00fctahya, Sungur Alp Akay PostgreSQL&#8217;in kurulumu, mimarisi, SQL nesneleri ve yetkilendirme temellerinden ba\u015flayarak; bak\u0131m, kilit mekanizmalar\u0131, MVCC ve partitioning gibi geli\u015fmi\u015f performans y\u00f6netimini, ard\u0131ndan da sistemin kesintisiz \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayan yedekleme (PITR) ve y\u00fcksek eri\u015filebilirlik (replikasyon) stratejilerini kapsaml\u0131 bir \u015fekilde ele alaca\u011f\u0131z. Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n-\u015fartlar: Kat\u0131l\u0131mc\u0131lar\u0131n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1018,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1325","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/pages\/1325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/comments?post=1325"}],"version-history":[{"count":3,"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/pages\/1325\/revisions"}],"predecessor-version":[{"id":1458,"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/pages\/1325\/revisions\/1458"}],"up":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/pages\/1018"}],"wp:attachment":[{"href":"https:\/\/kamp.linux.org.tr\/2026-yaz\/wp-json\/wp\/v2\/media?parent=1325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}