{"id":992,"date":"2024-01-03T00:34:34","date_gmt":"2024-01-02T21:34:34","guid":{"rendered":"https:\/\/kamp.linux.org.tr\/2024-kis\/?page_id=992"},"modified":"2024-01-08T16:11:18","modified_gmt":"2024-01-08T13:11:18","slug":"postgresql-102","status":"publish","type":"page","link":"https:\/\/kamp.linux.org.tr\/2024-kis\/kurslar\/postgresql-102\/","title":{"rendered":"PostgreSQL: Yaz\u0131l\u0131m Geli\u015ftiricileri \u0130\u00e7in"},"content":{"rendered":"\n

E\u011fitmenler: <\/strong>Yasin Tatar<\/a>, Muhammed Cihat \u00fclker<\/a>, Ahmet Fincan<\/a><\/p>\n\n\n\n

Kurslara kay\u0131t olmak i\u00e7in t\u0131klay\u0131n<\/a><\/p>\n\n\n\n

Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n \u015fartlar:<\/h3>\n\n\n\n

Giri\u015f d\u00fczeyi SQL bilgisi<\/p>\n\n\n\n

E\u011fitimin i\u00e7eri\u011fi:<\/h3>\n\n\n\n
    \n
  1. Giri\u015f
    PostgreSQL temelleri
    PostgreSQL kurulumu (Binary paket vekaynak koddan)
    Veritaban\u0131 Nesneleri (table,Schema,Index vb..)
    Veritaban\u0131 Olu\u015fturma
    PostgreSQL’ de kullan\u0131c\u0131\/grup kavram\u0131
    Kullan\u0131c\u0131\/grup yetkilendirmesi
    Eri\u015fim kontrol mekanizmas\u0131 (hba.conf)
    PostgreSQL yap\u0131land\u0131rmas\u0131
    Veritaban\u0131na Ba\u011flanma (psql de ba\u011fan\u0131lcak)
    ACID & RDBM<\/li>\n\n\n\n
  2. Temel Tablo \u0130\u015flemleri
    Normalizasyon Kurallar\u0131 (Index, TabloKullan\u0131m\u0131 vb. )
    Temel Tablo \u0130\u015flemleri: ALTER, DROP, CREATE, Truncate (sadece ana obje
    Tabloolanlar)
    Schema Kavram\u0131 (default shema de\u011fi\u015fimi olacak)
    Sequences (Ba\u011fl\u0131 Sequences yap\u0131s\u0131, ba\u011f\u0131 koparma ba\u011flama, Sequences
    s\u0131f\u0131rlama,Sequences de\u011fer art\u0131r\u0131m\u0131, DDL \u00c7al\u0131\u015f\u0131r de\u011fin)
    Tablespaces (optimizasyon da \u00f6nemi)<\/li>\n\n\n\n
  3. Veri Tipleri \u0130le \u00c7al\u0131\u015fmak
    Veri Tipleri (Array, Json, NoSQL, XML, IP )
    Karakter Veri Tipleri \u0130le \u00c7al\u0131\u015fmak
    Veri Tiplerini Birbirine D\u00f6n\u00fc\u015ft\u00fcrmek (tipCast)
    \u00d6zel Veri Tipleri \u0130le \u00c7al\u0131\u015fmak (Timestamp, Rowversion, Alias)
    Domain
    \u201cComposite Type\u201d Tan\u0131mlama ve Kullanma<\/li>\n\n\n\n
  4. Tablo K\u0131s\u0131tlar\u0131(constraints) ile Veri B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Sa\u011flamak
    Data B\u00fct\u00fcnl\u00fc\u011f\u00fc nedir?(Referential Integrity)
    Constraint \u00c7e\u015fitleri ve Tan\u0131mlanmas\u0131 (DEFAULT, CHECK)
    Tablolar Aras\u0131 Veri B\u00fct\u00fcnl\u00fc\u011f\u00fc Sa\u011flamak (Primary, Uniquee, Foreign
    Constraint)
    Cascade Operasyonlar
    Rules Tan\u0131mlamak ve \u201cCheck Constraints\u201d ile farkl\u0131<\/li>\n\n\n\n
  5. SELECT Deyimi ile Veri Sorgulama
    Temel Bir Select ifadesinin yaz\u0131lmas\u0131
    DISTINCT ile Tekil Veri Getirmek
    S\u00fctun ve Tablolara Takma \u0130sim Vermek,<\/li>\n\n\n\n
  6. Gruplama ve Grup Veri \u00dczerinde \u00c7al\u0131\u015fmak
    ORDER BY ile Veri S\u0131ralama
    GROUP BY \u0130fadesi
    HAVING \u0130fadesi
    OFFSET
    \u00d6n Tan\u0131ml\u0131 Fonksiyonlar (Sum, Max, Avg vs)<\/li>\n\n\n\n
  7. DML (Data Manipulation Kavram\u0131)
    Veritaban\u0131na Kay\u0131t Eklemek
    INSERT C\u00fcmlece\u011fi
    SELECT ve INSERT\u2019in Birlikte Kullan\u0131m\u0131
    Veritaban\u0131ndan Kay\u0131t G\u00fcncellemek
    UPDATE C\u00fcmleci\u011fi
    G\u00fcncellemede WHERE Kullan\u0131m\u0131
    Veritaban\u0131ndan Kay\u0131t Silmek
    DELETE C\u00fcmlece\u011fi<\/li>\n\n\n\n
  8. Birden \u00c7ok Tabloyu Birbirine Ba\u011flama, JOIN’ler
    INNER JOIN’ler ve Al\u0131\u015ft\u0131rmalar
    OUTER JOIN ve Al\u0131\u015ft\u0131rmalar
    SELF JOIN
    Ambiguous Hatas\u0131<\/li>\n\n\n\n
  9. Null De\u011ferle \u00c7al\u0131\u015fmak<\/li>\n\n\n\n
  10. \u0130leri Seviye SQL
    Alt Sorgular (Nested Query) ile \u00c7al\u0131\u015fmak
    Alt Sorgularda EXIST, ANY-SOME ve ALL Kullan\u0131m\u0131
    UNION, UNION ALL ve EXCEPT,INTERSECT sorgular\u0131na destek
    SELECT \u0130\u00e7erisinde Fonksiyon\/SP Kullan\u0131mlar\u0131 (Da\u011f\u0131t\u0131lan Foksiyon Listesi
    BazAl\u0131ncak)<\/li>\n\n\n\n
  11. Transaction Management & MVCC
    Temel TRANSACTION Y\u00f6netimi
    Transaction Gereklili\u011fi
    BEGIN, ROLLBACK ve COMMIT, SAVEPOINT Deyimleri<\/li>\n\n\n\n
  12. View Nesneleri ve Tablo \u0130fadeleri
    View Nesneleri
    View Yaratmak
    View\u2019lar\u0131 Sorguda Kullanmak (View i\u00e7inde View \u00c7a\u011f\u0131rmak)
    MATERIALIZED VIEW<\/li>\n\n\n\n
  13. Stored Procedure ile \u00c7al\u0131\u015fmak
    Stored Procedure Kullanarak Veri Sorgulamak& Tipleri
    Stored Procedure Parametreleri ile \u00c7al\u0131\u015fmak
    Stored Procedure Yaratmak
    Dinamik SQL \u0130fadleri Olu\u015fturmak ve\u00c7al\u0131\u015ft\u0131rmak
    Kontrol Logic Yap\u0131lar\u0131 (if, while vs)
    RAISE Yap\u0131s\u0131,
    Hata Y\u00f6netimi(RAISEERROR ve THROW Deyimleri)
    TRY-CATCH Kullan\u0131\u0131
    Throw Deyimi
    Exception ERROR Nesnesi ile \u00c7al\u0131\u015fmak
    Tablo D\u00f6nd\u00fcren Fonksiyonlar
    Parametreleri (In ve Out) SP\u2019lerle \u00c7al\u0131\u015fmak<\/li>\n\n\n\n
  14. Veri De\u011fi\u015fikliklerini Trigger Nesneleri ile Y\u00f6netmek
    AFTER ve INSTEAD OF Trigger\u2019lar\u0131
    INSERT, UPDATE ve DELETE Trigger\u2019lar\u0131
    \u0130\u00e7i\u00e7e Ge\u00e7mi\u015f Trigger\u2019lar
    Recursive Trigger Kavram\u0131
    Trigger \u0130\u00e7erisinde Update Yapmak
    Trigger\u2019lar\u0131n \u00c7al\u0131\u015fma S\u0131ras\u0131
    Trigger\u2019lar\u0131n Alternatifi
    Trigger\u2019lar \u0130le \u0130lgili Dikkat Edilmesi Gereken Kurallar\u0131<\/li>\n\n\n\n
  15. PL\/SQL ‘de operat\u00f6rler
    Kontrol Yap\u0131lar\u0131
    IF c\u00fcmleleri
    CASE c\u00fcmleleri
    Basit Loop c\u00fcmlesi
    While Loop c\u00fcmlesi
    For Loop c\u00fcmlesi
    Continue c\u00fcmlesi
    Explicit Cursors
    Cursor tan\u0131mlama
    Cursor A\u00e7ma\/Kapama
    Cursor’dan veri fetch etme
    Hata yakalama (Exception Handling)<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    E\u011fitmenler: Yasin Tatar, Muhammed Cihat \u00fclker, Ahmet Fincan Kurslara kay\u0131t olmak i\u00e7in t\u0131klay\u0131n Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n \u015fartlar: Giri\u015f d\u00fczeyi SQL bilgisi E\u011fitimin i\u00e7eri\u011fi:<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":362,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-992","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/pages\/992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/comments?post=992"}],"version-history":[{"count":6,"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/pages\/992\/revisions"}],"predecessor-version":[{"id":1209,"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/pages\/992\/revisions\/1209"}],"up":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/pages\/362"}],"wp:attachment":[{"href":"https:\/\/kamp.linux.org.tr\/2024-kis\/wp-json\/wp\/v2\/media?parent=992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}