{"id":27966,"date":"2025-08-21T11:30:25","date_gmt":"2025-08-21T08:30:25","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/"},"modified":"2025-08-21T11:30:25","modified_gmt":"2025-08-21T08:30:25","slug":"sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/","title":{"rendered":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi"},"content":{"rendered":"

SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi<\/p>\n

\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL’i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!<\/p>\n

\u00d6\u011frenci-Ders Y\u00f6netim Sistemi i\u00e7in Temel SQL Kavramlar\u0131<\/h2>\n

\u00d6ncelikle, \u00f6\u011frenci ve ders y\u00f6netim sistemimiz i\u00e7in gerekli temel SQL kavramlar\u0131n\u0131 g\u00f6zden ge\u00e7irelim. Bu sistemde, muhtemelen “\u00d6\u011frenciler” ve “Dersler” adl\u0131 iki ana tablo ile \u00e7al\u0131\u015faca\u011f\u0131z. “\u00d6\u011frenciler” tablosu, her \u00f6\u011frenci i\u00e7in \u00f6\u011frenci kimli\u011fi (\u00f6\u011frenci_id), ad\u0131, soyad\u0131, b\u00f6l\u00fcm bilgisi gibi alanlar i\u00e7erecektir. “Dersler” tablosu ise ders kodu (ders_kodu), ders ad\u0131, kredi bilgisi ve hoca bilgisi gibi alanlar i\u00e7erecektir. Bu iki tablo aras\u0131nda bir ili\u015fki kuracak bir “\u00d6\u011frenciDers” tablosu da ekleyebiliriz. Bu tabloda, \u00f6\u011frenci_id ve ders_kodu alanlar\u0131 yer alarak her \u00f6\u011frencinin hangi dersleri ald\u0131\u011f\u0131n\u0131 takip edebiliriz. <\/p>\n

\u0130\u015fte bu tablolar\u0131 olu\u015fturmak i\u00e7in kullanabilece\u011fimiz SQL komutlar\u0131:<\/p>\n

CREATE TABLE Ogrenciler (\n    ogrenci_id INT PRIMARY KEY,\n    adi VARCHAR(255),\n    soyadi VARCHAR(255),\n    bolum VARCHAR(255)\n);\n\nCREATE TABLE Dersler (\n    ders_kodu VARCHAR(10) PRIMARY KEY,\n    ders_adi VARCHAR(255),\n    kredi INT,\n    hoca_adi VARCHAR(255)\n);\n\nCREATE TABLE OgrenciDers (\n    ogrenci_id INT,\n    ders_kodu VARCHAR(10),\n    FOREIGN KEY (ogrenci_id) REFERENCES Ogrenciler(ogrenci_id),\n    FOREIGN KEY (ders_kodu) REFERENCES Dersler(ders_kodu),\n    PRIMARY KEY (ogrenci_id, ders_kodu)\n);<\/pre>\n
<\/code><\/p>\n
Bu komutlar, her bir tablonun yap\u0131s\u0131n\u0131 ve alanlar\u0131n\u0131 tan\u0131mlar.  PRIMARY KEY<\/code> k\u0131s\u0131tlamas\u0131, her tablonun benzersiz bir kay\u0131t tan\u0131mlay\u0131c\u0131s\u0131na sahip olmas\u0131n\u0131 sa\u011flar.  FOREIGN KEY<\/code> k\u0131s\u0131tlamas\u0131 ise iki tablo aras\u0131ndaki ili\u015fkiyi tan\u0131mlar ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korur.  Bu temel yap\u0131y\u0131 olu\u015fturduktan sonra, daha karma\u015f\u0131k sorgular yazmaya ba\u015flayabiliriz.<\/p>\n
\u00d6\u011frenci Bilgilerine Nas\u0131l Eri\u015filir?<\/h2>\n
Sistemde kay\u0131tl\u0131 \u00f6\u011frencilerin bilgilerini g\u00f6r\u00fcnt\u00fclemek i\u00e7in SELECT<\/code> komutunu kullanabiliriz. \u00d6rne\u011fin, t\u00fcm \u00f6\u011frencilerin ad\u0131n\u0131, soyad\u0131n\u0131 ve b\u00f6l\u00fcm\u00fcn\u00fc g\u00f6r\u00fcnt\u00fclemek i\u00e7in a\u015fa\u011f\u0131daki sorguyu kullanabiliriz:<\/p>\n
SELECT adi, soyadi, bolum\nFROM Ogrenciler;<\/pre>\n
<\/code><\/p>\n
Belirli bir b\u00f6l\u00fcme ait \u00f6\u011frencilerin bilgilerini g\u00f6r\u00fcnt\u00fclemek i\u00e7in WHERE<\/code> ko\u015fulunu kullanabiliriz.  \u00d6rne\u011fin, Bilgisayar M\u00fchendisli\u011fi b\u00f6l\u00fcm\u00fcndeki \u00f6\u011frencilerin bilgilerini g\u00f6r\u00fcnt\u00fclemek i\u00e7in:<\/p>\n
SELECT adi, soyadi, bolum\nFROM Ogrenciler\nWHERE bolum = 'Bilgisayar M\u00fchendisli\u011fi';<\/pre>\n
<\/code><\/p>\n
Daha karma\u015f\u0131k sorgular i\u00e7in ORDER BY<\/code> ve LIMIT<\/code> komutlar\u0131n\u0131 da kullanabiliriz.  \u00d6rne\u011fin, alfabetik s\u0131rada ilk 10 \u00f6\u011frencinin listesini g\u00f6r\u00fcnt\u00fclemek i\u00e7in:<\/p>\n
SELECT adi, soyadi, bolum\nFROM Ogrenciler\nORDER BY soyadi\nLIMIT 10;<\/pre>\n
<\/code><\/p>\n
Ders Bilgilerine ve \u00d6\u011frenci-Ders \u0130li\u015fkisine Nas\u0131l Eri\u015filir?<\/h2>\n
Ders bilgilerine eri\u015fmek i\u00e7in Dersler<\/code> tablosunu sorgulayabiliriz.  T\u00fcm derslerin listesini g\u00f6r\u00fcnt\u00fclemek i\u00e7in \u015fu sorguyu kullanabiliriz:<\/p>\n
SELECT ders_kodu, ders_adi, kredi, hoca_adi\nFROM Dersler;<\/pre>\n
<\/code><\/p>\n
Bir \u00f6\u011frencinin ald\u0131\u011f\u0131 dersleri g\u00f6r\u00fcnt\u00fclemek i\u00e7in JOIN<\/code> komutunu kullanarak Ogrenciler<\/code> ve OgrenciDers<\/code> tablolar\u0131n\u0131 birle\u015ftirebiliriz. \u00d6rne\u011fin, \u00f6\u011frenci_id'si 1 olan \u00f6\u011frencinin ald\u0131\u011f\u0131 dersleri g\u00f6r\u00fcnt\u00fclemek i\u00e7in:<\/p>\n
SELECT d.ders_adi, d.kredi\nFROM OgrenciDers od\nJOIN Dersler d ON od.ders_kodu = d.ders_kodu\nWHERE od.ogrenci_id = 1;<\/pre>\n
<\/code><\/p>\n
Bu sorgu, OgrenciDers<\/code> tablosundaki ogrenci_id<\/code> ve Dersler<\/code> tablosundaki ders_kodu<\/code> alanlar\u0131n\u0131 kullanarak iki tabloyu birle\u015ftirir ve  \u00f6\u011frenci_id'si 1 olan \u00f6\u011frencinin ald\u0131\u011f\u0131 derslerin adlar\u0131n\u0131 ve kredilerini g\u00f6r\u00fcnt\u00fcler.  Daha karma\u015f\u0131k raporlamalar i\u00e7in GROUP BY<\/code> ve HAVING<\/code> komutlar\u0131n\u0131 da kullanabiliriz. \u00d6rne\u011fin, her dersin ka\u00e7 \u00f6\u011frenci taraf\u0131ndan al\u0131nd\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcnt\u00fclemek i\u00e7in:<\/p>\n
SELECT d.ders_adi, COUNT(od.ogrenci_id) AS ogrenci_sayisi\nFROM OgrenciDers od\nJOIN Dersler d ON od.ders_kodu = d.ders_kodu\nGROUP BY d.ders_adi\nHAVING COUNT(od.ogrenci_id) > 5;<\/pre>\n
<\/code><\/p>\n
Veri G\u00fcncelleme ve Silme \u0130\u015flemleri<\/h2>\n
Sistemdeki verileri g\u00fcncellemek ve silmek i\u00e7in UPDATE<\/code> ve DELETE<\/code> komutlar\u0131n\u0131 kullan\u0131r\u0131z. \u00d6rne\u011fin, \u00f6\u011frenci_id'si 1 olan \u00f6\u011frencinin b\u00f6l\u00fcm\u00fcn\u00fc de\u011fi\u015ftirmek i\u00e7in:<\/p>\n
UPDATE Ogrenciler\nSET bolum = 'Yaz\u0131l\u0131m M\u00fchendisli\u011fi'\nWHERE ogrenci_id = 1;<\/pre>\n
<\/code><\/p>\n
\u00d6\u011frenci_id'si 2 olan \u00f6\u011frencinin kay\u0131tlar\u0131n\u0131 silmek i\u00e7in (Dikkat: Bu i\u015flem geri al\u0131namaz!):<\/p>\n
DELETE FROM Ogrenciler\nWHERE ogrenci_id = 2;<\/pre>\n
<\/code><\/p>\n
 Dikkat:<\/strong> Veri silme i\u015flemlerini yaparken son derece dikkatli olun.  Yanl\u0131\u015fl\u0131kla \u00f6nemli verileri silebilirsiniz.  \u0130\u015flemlerden \u00f6nce mutlaka yedek almay\u0131 veya i\u015flemleri test ortam\u0131nda denemeyi unutmay\u0131n.  DELETE<\/code> komutu kullanmadan \u00f6nce mutlaka SELECT<\/code> komutu ile silinecek verileri kontrol etmelisiniz.<\/p>\n
\u0130leri D\u00fczey SQL Sorgular\u0131 ve Optimizasyon<\/h2>\n
Daha geli\u015fmi\u015f SQL sorgular\u0131, performans iyile\u015ftirmeleri ve optimize edilmi\u015f sorgular i\u00e7in alt sorgular (subqueries<\/code>), birden \u00e7ok tablo birle\u015ftirmeleri (JOIN<\/code> \u00e7e\u015fitleri: INNER JOIN<\/code>, LEFT JOIN<\/code>, RIGHT JOIN<\/code>, FULL OUTER JOIN<\/code>), indeksleme ve view'ler gibi konulara de\u011finebiliriz.  \u00d6rne\u011fin, bir \u00f6\u011frencinin ald\u0131\u011f\u0131 derslerin ortalama kredilerini bulmak i\u00e7in alt sorgu kullanabiliriz:<\/p>\n
SELECT AVG(kredi) AS ortalama_kredi\nFROM (\n    SELECT d.kredi\n    FROM OgrenciDers od\n    JOIN Dersler d ON od.ders_kodu = d.ders_kodu\n    WHERE od.ogrenci_id = 1\n) AS Dersler;<\/pre>\n
<\/code><\/p>\n
Veritaban\u0131 performans\u0131n\u0131 art\u0131rmak i\u00e7in indeksleme \u00e7ok \u00f6nemlidir. S\u0131k\u00e7a sorgu yap\u0131lan alanlara indeks eklemek sorgular\u0131n \u00e7ok daha h\u0131zl\u0131 \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flar.  Bunun i\u00e7in CREATE INDEX<\/code> komutunu kullanabilirsiniz. \u00d6rne\u011fin, Ogrenciler<\/code> tablosundaki soyadi<\/code> alan\u0131na indeks eklemek i\u00e7in:<\/p>\n
CREATE INDEX soyadi_index ON Ogrenciler (soyadi);<\/pre>\n
<\/code><\/p>\n
Daha karma\u015f\u0131k ve b\u00fcy\u00fck veritabanlar\u0131nda performans iyile\u015ftirmeleri i\u00e7in, sorgular\u0131 optimize etmeniz ve uygun indeksleri olu\u015fturman\u0131z gerekir. Fatih Soysal'\u0131n veritaban\u0131 optimizasyonu hakk\u0131ndaki yaz\u0131lar\u0131n\u0131 (https:\/\/fatihsoysal.com) inceleyerek daha detayl\u0131 bilgi edinebilirsiniz.<\/p>\n
\u00d6\u011frenme Yol Haritas\u0131<\/h2>\n
Bu makalede anlat\u0131lan konular\u0131 \u00f6\u011frenmek i\u00e7in a\u015fa\u011f\u0131daki yol haritas\u0131n\u0131 takip edebilirsiniz:<\/p>\n
Yeni Ba\u015flayanlar \u0130\u00e7in:<\/h3>\n
    \n
  • Temel SQL komutlar\u0131n\u0131 (SELECT, INSERT, UPDATE, DELETE) \u00f6\u011frenin.<\/li>\n
  • Veritaban\u0131 tablolar\u0131n\u0131 nas\u0131l olu\u015fturaca\u011f\u0131n\u0131z\u0131 ve ili\u015fkilendirece\u011finizi \u00f6\u011frenin.<\/li>\n
  • WHERE, ORDER BY, LIMIT gibi temel ko\u015ful ve s\u0131ralama komutlar\u0131n\u0131 \u00f6\u011frenin.<\/li>\n
  • Basit SELECT sorgular\u0131 yazarak verileri sorgulama al\u0131\u015ft\u0131rmas\u0131 yap\u0131n.<\/li>\n<\/ul>\n
    Orta Seviye:<\/h3>\n
      \n
    • JOIN komutlar\u0131n\u0131 kullanarak birden \u00e7ok tabloyu birle\u015ftirin.<\/li>\n
    • Alt sorgular (subqueries) kullanmay\u0131 \u00f6\u011frenin.<\/li>\n
    • GROUP BY ve HAVING komutlar\u0131n\u0131 kullanarak verileri gruplay\u0131n ve filtreleyin.<\/li>\n
    • Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc ve k\u0131s\u0131tlamalar\u0131 \u00f6\u011frenin (PRIMARY KEY, FOREIGN KEY).<\/li>\n<\/ul>\n
      \u0130leri Seviye:<\/h3>\n
        \n
      • Veritaban\u0131 optimizasyon tekniklerini \u00f6\u011frenin (indeksleme, sorgu optimizasyonu).<\/li>\n
      • Farkl\u0131 JOIN t\u00fcrlerini (INNER JOIN, LEFT JOIN, RIGHT JOIN) ve kullan\u0131m alanlar\u0131n\u0131 \u00f6\u011frenin.<\/li>\n
      • Stored procedures, triggers ve functions gibi geli\u015fmi\u015f SQL \u00f6zelliklerini \u00f6\u011frenin.<\/li>\n
      • Karma\u015f\u0131k sorgular yazarak ve performans analizleri yaparak deneyiminizi geli\u015ftirin.<\/li>\n<\/ul>\n
        Ger\u00e7ek D\u00fcnya Senaryosu: Not Giri\u015fi ve Ortalama Hesaplama<\/h2>\n
        \u00d6\u011frenci ders y\u00f6netim sisteminde, her ders i\u00e7in notlar\u0131n girilmesi ve \u00f6\u011frencilerin d\u00f6nem sonu ortalamalar\u0131n\u0131n hesaplanmas\u0131 kritik bir i\u015flevdir.  Bu i\u015flem i\u00e7in, \"Notlar\" adl\u0131 yeni bir tablo olu\u015fturabiliriz. Bu tabloda, \u00f6\u011frenci_id, ders_kodu ve not gibi alanlar bulunur.<\/p>\n
        CREATE TABLE Notlar (\n    ogrenci_id INT,\n    ders_kodu VARCHAR(10),\n    not INT,\n    FOREIGN KEY (ogrenci_id) REFERENCES Ogrenciler(ogrenci_id),\n    FOREIGN KEY (ders_kodu) REFERENCES Dersler(ders_kodu),\n    PRIMARY KEY (ogrenci_id, ders_kodu)\n);<\/pre>\n
        <\/code><\/p>\n
        Bir \u00f6\u011frencinin d\u00f6nem sonu not ortalamas\u0131n\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki SQL sorgusunu kullanabiliriz:<\/p>\n
        SELECT AVG(not) AS ortalama_not\nFROM Notlar\nWHERE ogrenci_id = 1;<\/pre>\n
        <\/code><\/p>\n
        Sonu\u00e7<\/h2>\n
        SQL, \u00f6\u011frenci ve ders y\u00f6netim sistemleri i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r.  Bu makalede, temel SQL komutlar\u0131n\u0131 ve bir \u00f6\u011frenci-ders y\u00f6netim sistemini olu\u015fturmak ve y\u00f6netmek i\u00e7in nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 \u00f6\u011frendiniz.  Daha ileri d\u00fczey konular i\u00e7in Fatih Soysal'\u0131n (https:\/\/fatihsoysal.com) web sitesini ziyaret edebilirsiniz.  SQL'in g\u00fcc\u00fcn\u00fc ke\u015ffetmeye devam edin ve verilerinizi y\u00f6netme becerilerinizi geli\u015ftirin!<\/p>\n
        S\u0131k\u00e7a Sorulan Sorular<\/h3>\n
          \n
        • SQL nedir?<\/b> SQL (Structured Query Language), veritabanlar\u0131n\u0131 y\u00f6netmek ve sorgulamak i\u00e7in kullan\u0131lan bir dildir.<\/li>\n
        • JOIN komutu nedir?<\/b> JOIN komutu, birden fazla tablodaki verileri birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r.<\/li>\n
        • Veritaban\u0131 optimizasyonu neden \u00f6nemlidir?<\/b> Veritaban\u0131 optimizasyonu, sorgular\u0131n h\u0131zl\u0131 ve verimli \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flar.<\/li>\n
        • SQL'de indeksleme nedir?<\/b> \u0130ndeksleme, veritaban\u0131ndaki verileri h\u0131zl\u0131 bir \u015fekilde aramak i\u00e7in kullan\u0131lan bir tekniktir.<\/li>\n
        • Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc nedir?<\/b> Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc, verilerin do\u011frulu\u011funu ve tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamakt\u0131r.<\/li>\n<\/ul>\n
          Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi \u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n…","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-27966","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\nSQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi<\/title>\n<meta name=\"description\" content=\"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi\" \/>\n<meta property=\"og:description\" content=\"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-21T08:30:25+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi\",\"datePublished\":\"2025-08-21T08:30:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\"},\"wordCount\":1167,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\",\"name\":\"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-08-21T08:30:25+00:00\",\"description\":\"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi","description":"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!","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:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi","og_description":"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!","og_url":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-08-21T08:30:25+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi","datePublished":"2025-08-21T08:30:25+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/"},"wordCount":1167,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/","url":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/","name":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-08-21T08:30:25+00:00","description":"\u00dcniversiteler ve kolejler i\u00e7in verimli bir \u00f6\u011frenci ve ders y\u00f6netim sistemi kurman\u0131n en kritik noktalar\u0131ndan biri, verinin etkili bir \u015fekilde y\u00f6netilmesidir. Bu noktada, SQL veritaban\u0131 y\u00f6netim sistemleri ve g\u00fc\u00e7l\u00fc SQL sorgular\u0131 devreye girer. Bu makale, SQL'i kullanarak bir \u00f6\u011frenci ve ders y\u00f6netim sistemini nas\u0131l tasarlayabilece\u011finizi ve y\u00f6netebilece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacakt\u0131r. \u00d6\u011frenci kay\u0131tlar\u0131n\u0131, ders bilgilerini, notlar\u0131 ve daha fazlas\u0131n\u0131 SQL sorgular\u0131 ile nas\u0131l sorgulayaca\u011f\u0131n\u0131z\u0131, g\u00fcncelleyece\u011finizi ve y\u00f6netece\u011finizi \u00f6\u011freneceksiniz. Haz\u0131rsan\u0131z, SQL d\u00fcnyas\u0131na dalal\u0131m!","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/sql-sorgulari-ile-ogrenci-ders-yonetim-sistemi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Sorgular\u0131 ile \u00d6\u011frenci-Ders Y\u00f6netim Sistemi"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=27966"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27966\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=27966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=27966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=27966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}