G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, bilginin toplanmas\u0131, depolanmas\u0131, y\u00f6netilmesi ve analiz edilmesi, hem bireyler hem de kurumlar i\u00e7in hayati bir \u00f6neme sahiptir. Bu karma\u015f\u0131k veri ekosisteminin merkezinde, ili\u015fkisel veritaban\u0131 y\u00f6netim sistemleriyle (RDBMS) etkile\u015fim kurmak i\u00e7in tasarlanm\u0131\u015f g\u00fc\u00e7l\u00fc bir dil yatmaktad\u0131r: Yap\u0131sal Sorgu Dili veya k\u0131saca SQL (Structured Query Language). SQL, sadece bir programlama dili olman\u0131n \u00f6tesinde, veritabanlar\u0131yla konu\u015fmam\u0131z\u0131 sa\u011flayan evrensel bir k\u00f6pr\u00fc g\u00f6revi g\u00f6r\u00fcr. Milyarlarca verinin saniyeler i\u00e7inde i\u015flenmesini, karma\u015f\u0131k raporlar\u0131n olu\u015fturulmas\u0131n\u0131 ve i\u015f kararlar\u0131n\u0131n veriyle desteklenmesini m\u00fcmk\u00fcn k\u0131lar. Peki, bu denli kritik bir rol oynayan SQL tam olarak nedir, nas\u0131l \u00e7al\u0131\u015f\u0131r ve neden bu kadar yayg\u0131n olarak kullan\u0131lmaktad\u0131r?<\/p>\n
Bu makalede, SQL’in temel prensiplerinden ba\u015flayarak tarihsel geli\u015fimine, farkl\u0131 komut kategorilerine (DDL, DML, DCL, TCL), geli\u015fmi\u015f \u00f6zelliklerine (JOIN’ler, alt sorgular, pencere fonksiyonlar\u0131), pop\u00fcler uygulamalar\u0131na ve en iyi kullan\u0131m pratiklerine derinlemesine bir bak\u0131\u015f ataca\u011f\u0131z. SQL’in sadece bir teknik ara\u00e7 olmad\u0131\u011f\u0131n\u0131, ayn\u0131 zamanda modern veri y\u00f6netiminin ve analizi d\u00fcnyas\u0131n\u0131n temel ta\u015f\u0131 oldu\u011funu ke\u015ffedece\u011fiz. \u0130ster bir yaz\u0131l\u0131m geli\u015ftirici, ister bir veri analisti, isterse bir veritaban\u0131 y\u00f6neticisi olun, SQL’i anlamak ve etkili bir \u015fekilde kullanmak, dijital \u00e7a\u011fdaki ba\u015far\u0131n\u0131z i\u00e7in vazge\u00e7ilmez bir beceridir.<\/p>\n
SQL’in k\u00f6kenleri, 1970’lerin ba\u015flar\u0131na, IBM’in San Jose Ara\u015ft\u0131rma Laboratuvar\u0131’nda Edgar F. Codd’un ili\u015fkisel veritaban\u0131 modeli \u00fczerine yapt\u0131\u011f\u0131 \u00e7\u0131\u011f\u0131r a\u00e7\u0131c\u0131 \u00e7al\u0131\u015fmalara dayanmaktad\u0131r. Codd, verilerin matematiksel k\u00fcmeler ve ili\u015fkiler (tablolar) \u015feklinde depolanabilece\u011fi ve manip\u00fcle edilebilece\u011fi bir model \u00f6nerdi. Bu model, o zamanki hiyerar\u015fik ve a\u011f tabanl\u0131 veritaban\u0131 sistemlerine k\u0131yasla \u00e7ok daha esnek ve g\u00fc\u00e7l\u00fcyd\u00fc.<\/p>\n
Codd’un teorik \u00e7al\u0131\u015fmas\u0131na dayanarak, Donald D. Chamberlin ve Raymond F. Boyce, 1974 y\u0131l\u0131nda “SEQUEL” (Structured English Query Language) adl\u0131 bir dil geli\u015ftirdiler. Bu dil, ili\u015fkisel veritabanlar\u0131 i\u00e7in ilk pratik sorgu diliydi. Daha sonra yasal nedenlerle ad\u0131 SQL olarak de\u011fi\u015ftirildi. IBM, 1970’lerin sonlar\u0131nda SQL’i temel alan System R projesiyle bu teknolojiyi daha da olgunla\u015ft\u0131rd\u0131 ve ticarile\u015fme yolunu a\u00e7t\u0131.<\/p>\n
SQL’in ger\u00e7ek anlamda yayg\u0131nla\u015fmas\u0131, 1980’lerde Oracle, Ingres ve Sybase gibi \u015firketlerin kendi ili\u015fkisel veritaban\u0131 y\u00f6netim sistemlerini (RDBMS) ve SQL uygulamalar\u0131n\u0131 piyasaya s\u00fcrmesiyle ba\u015flad\u0131. Bu h\u0131zl\u0131 benimsenme, bir standardizasyon ihtiyac\u0131n\u0131 do\u011furdu. Amerikan Ulusal Standartlar Enstit\u00fcs\u00fc (ANSI), 1986’da SQL i\u00e7in ilk standard\u0131 yay\u0131nlad\u0131 ve Uluslararas\u0131 Standardizasyon \u00d6rg\u00fct\u00fc (ISO) de bu standard\u0131 benimsedi. O zamandan beri SQL standard\u0131, d\u00fczenli aral\u0131klarla (SQL-89, SQL-92, SQL:1999, SQL:2003, SQL:2008, SQL:2011, SQL:2016, SQL:2023 gibi s\u00fcr\u00fcmlerle) g\u00fcncellenerek yeni \u00f6zellikler ve geli\u015ftirmelerle zenginle\u015ftirilmi\u015ftir. Bu standardizasyon, farkl\u0131 RDBMS’ler aras\u0131nda uyumlulu\u011fu sa\u011flam\u0131\u015f ve SQL’in evrensel bir dil olarak kabul g\u00f6rmesine yard\u0131mc\u0131 olmu\u015ftur.<\/p>\n
SQL’in g\u00fcn\u00fcm\u00fcz veri ekosistemindeki vazge\u00e7ilmez konumu, sundu\u011fu benzersiz avantajlardan kaynaklanmaktad\u0131r:<\/p>\n
SQL’i anlamak i\u00e7in \u00f6ncelikle ili\u015fkisel veritaban\u0131 modelinin temelini olu\u015fturan baz\u0131 kavramlar\u0131 bilmek gerekir:<\/p>\n
Veritaban\u0131ndaki t\u00fcm veriler, tablolarda d\u00fczenli bir \u015fekilde depolan\u0131r. Bir tablo, belirli bir varl\u0131k t\u00fcr\u00fcn\u00fc (\u00f6rne\u011fin, M\u00fc\u015fteriler, \u00dcr\u00fcnler, Sipari\u015fler) temsil eder. Her tablo, sat\u0131rlardan ve s\u00fctunlardan olu\u015fur.<\/p>\n
Bir tablodaki her s\u00fctun, varl\u0131\u011f\u0131n belirli bir \u00f6zelli\u011fini (nitelik) temsil eder. \u00d6rne\u011fin, bir “M\u00fc\u015fteriler” tablosunda “M\u00fc\u015fteriID”, “Ad”, “Soyad”, “Eposta” gibi s\u00fctunlar bulunabilir. Her s\u00fctunun belirli bir veri tipi (metin, say\u0131, tarih vb.) vard\u0131r.<\/p>\n
Bir tablodaki her sat\u0131r, varl\u0131\u011f\u0131n tek bir \u00f6rne\u011fini (kayd\u0131n\u0131) temsil eder. \u00d6rne\u011fin, “M\u00fc\u015fteriler” tablosundaki bir sat\u0131r, belirli bir m\u00fc\u015fterinin t\u00fcm bilgilerini i\u00e7erir.<\/p>\n
Bir tablodaki her sat\u0131r\u0131 benzersiz bir \u015fekilde tan\u0131mlayan bir veya daha fazla s\u00fctunun birle\u015fimidir. Birincil anahtar null (bo\u015f) olamaz ve her tabloda yaln\u0131zca bir tane birincil anahtar bulunabilir. \u00d6rne\u011fin, “M\u00fc\u015fteriler” tablosunda “M\u00fc\u015fteriID” birincil anahtar olabilir.<\/p>\n
Bir tablodaki bir veya daha fazla s\u00fctunun, ba\u015fka bir tablodaki birincil anahtara referans vermesidir. Yabanc\u0131 anahtarlar, tablolar aras\u0131ndaki ili\u015fkileri kurar ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flar. \u00d6rne\u011fin, “Sipari\u015fler” tablosundaki “M\u00fc\u015fteriID” s\u00fctunu, “M\u00fc\u015fteriler” tablosundaki “M\u00fc\u015fteriID” birincil anahtar\u0131na referans veren bir yabanc\u0131 anahtar olabilir.<\/p>\n
\u0130li\u015fkisel veritabanlar\u0131nda tablolar aras\u0131nda \u00e7e\u015fitli ili\u015fkiler kurulabilir:<\/p>\n
SQL komutlar\u0131, ger\u00e7ekle\u015ftirdikleri i\u015flevlere g\u00f6re d\u00f6rt ana kategoriye ayr\u0131l\u0131r:<\/p>\n
DDL komutlar\u0131, veritaban\u0131 \u015femas\u0131n\u0131 (yap\u0131s\u0131n\u0131) olu\u015fturmak, de\u011fi\u015ftirmek ve silmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n
CREATE<\/code>:<\/strong> Yeni veritaban\u0131 nesneleri olu\u015fturmak i\u00e7in kullan\u0131l\u0131r.\nCREATE DATABASE SatisVeritabani;\nCREATE TABLE Musteriler (\n MusteriID INT PRIMARY KEY,\n Ad VARCHAR(50),\n Soyad VARCHAR(50),\n Eposta VARCHAR(100) UNIQUE\n);<\/code><\/pre>\n<\/li>\nALTER<\/code>:<\/strong> Mevcut veritaban\u0131 nesnelerinin yap\u0131s\u0131n\u0131 de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r.\nALTER TABLE Musteriler ADD COLUMN Telefon VARCHAR(15);\nALTER TABLE Musteriler ALTER COLUMN Eposta VARCHAR(150); -- SQL Server\nALTER TABLE Musteriler MODIFY COLUMN Eposta VARCHAR(150); -- MySQL\/Oracle<\/code><\/pre>\n<\/li>\nDROP<\/code>:<\/strong> Mevcut veritaban\u0131 nesnelerini tamamen silmek i\u00e7in kullan\u0131l\u0131r.\nDROP TABLE Musteriler;\nDROP DATABASE SatisVeritabani;<\/code><\/pre>\n<\/li>\nTRUNCATE<\/code>:<\/strong> Bir tablodaki t\u00fcm sat\u0131rlar\u0131 h\u0131zl\u0131 bir \u015fekilde silmek i\u00e7in kullan\u0131l\u0131r, ancak tablonun yap\u0131s\u0131n\u0131 korur. DELETE<\/code>‘ten farkl\u0131 olarak, genellikle daha h\u0131zl\u0131d\u0131r ve her sat\u0131r i\u00e7in bir g\u00fcnl\u00fck kayd\u0131 tutmaz.\nTRUNCATE TABLE GeciciVeriler;<\/code><\/pre>\n<\/li>\n<\/ul>\nVeri \u0130\u015fleme Dili (Data Manipulation Language – DML)<\/h3>\n
DML komutlar\u0131, veritaban\u0131ndaki verileri almak, eklemek, g\u00fcncellemek ve silmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n
\nSELECT<\/code>:<\/strong> Veritaban\u0131ndan veri sorgulamak ve almak i\u00e7in kullan\u0131l\u0131r. SQL’in en s\u0131k kullan\u0131lan komutudur.\nSELECT Ad, Soyad FROM Musteriler WHERE Sehir = 'Ankara';\nSELECT * FROM Urunler ORDER BY Fiyat DESC LIMIT 10; -- En pahal\u0131 10 \u00fcr\u00fcn<\/code><\/pre>\n<\/li>\nINSERT<\/code>:<\/strong> Bir tabloya yeni sat\u0131rlar eklemek i\u00e7in kullan\u0131l\u0131r.\nINSERT INTO Musteriler (MusteriID, Ad, Soyad, Eposta)\nVALUES (1, 'Ay\u015fe', 'Y\u0131lmaz', 'ayse.yilmaz@example.com');<\/code><\/pre>\n<\/li>\nUPDATE<\/code>:<\/strong> Mevcut tablodaki verileri de\u011fi\u015ftirmek i\u00e7in kullan\u0131l\u0131r.\nUPDATE Musteriler SET Eposta = 'ayse.y@example.com' WHERE MusteriID = 1;<\/code><\/pre>\n<\/li>\nDELETE<\/code>:<\/strong> Bir tablodan mevcut sat\u0131rlar\u0131 silmek i\u00e7in kullan\u0131l\u0131r.\nDELETE FROM Musteriler WHERE MusteriID = 1;<\/code><\/pre>\n<\/li>\n<\/ul>\nVeri Kontrol Dili (Data Control Language – DCL)<\/h3>\n
DCL komutlar\u0131, veritaban\u0131 kullan\u0131c\u0131lar\u0131na izinler vermek ve geri almak i\u00e7in kullan\u0131l\u0131r.<\/p>\n
\nGRANT<\/code>:<\/strong> Kullan\u0131c\u0131lara belirli veritaban\u0131 nesneleri \u00fczerinde yetki vermek i\u00e7in kullan\u0131l\u0131r.\nGRANT SELECT, INSERT ON Urunler TO 'veri_analisti'@'localhost';<\/code><\/pre>\n<\/li>\nREVOKE<\/code>:<\/strong> Kullan\u0131c\u0131lardan daha \u00f6nce verilmi\u015f yetkileri geri almak i\u00e7in kullan\u0131l\u0131r.\nREVOKE INSERT ON Urunler FROM 'veri_analisti'@'localhost';<\/code><\/pre>\n<\/li>\n<\/ul>\n\u0130\u015flem Kontrol Dili (Transaction Control Language – TCL)<\/h3>\n
TCL komutlar\u0131, DML i\u015flemlerini grupland\u0131rarak bir i\u015flem (transaction) i\u00e7inde y\u00f6netmek i\u00e7in kullan\u0131l\u0131r. Bu, veritaban\u0131 i\u015flemlerinin atomik, tutarl\u0131, izole ve kal\u0131c\u0131 (ACID) olmas\u0131n\u0131 sa\u011flar.<\/p>\n
\nCOMMIT<\/code>:<\/strong> Bir i\u015flem i\u00e7indeki t\u00fcm de\u011fi\u015fiklikleri veritaban\u0131na kal\u0131c\u0131 olarak kaydeder.\nSTART TRANSACTION; -- veya BEGIN TRANSACTION;\nUPDATE Hesaplar SET Bakiye = Bakiye - 100 WHERE HesapID = 1;\nUPDATE Hesaplar SET Bakiye = Bakiye + 100 WHERE HesapID = 2;\nCOMMIT;<\/code><\/pre>\n<\/li>\nROLLBACK<\/code>:<\/strong> Bir i\u015flem i\u00e7indeki t\u00fcm de\u011fi\u015fiklikleri geri al\u0131r ve veritaban\u0131n\u0131 i\u015flemin ba\u015flang\u0131c\u0131ndaki durumuna d\u00f6nd\u00fcr\u00fcr.\nSTART TRANSACTION;\nINSERT INTO Loglar (Mesaj) VALUES ('Hatal\u0131 i\u015flem denemesi');\nROLLBACK; -- Log kayd\u0131 veritaban\u0131na i\u015flenmez.<\/code><\/pre>\n<\/li>\nSAVEPOINT<\/code>:<\/strong> Bir i\u015flem i\u00e7inde belirli bir noktay\u0131 i\u015faretlemek i\u00e7in kullan\u0131l\u0131r. ROLLBACK<\/code>, bu noktaya kadar geri al\u0131nabilir.\nSAVEPOINT IlkKayit;\n-- ... baz\u0131 i\u015flemler ...\nROLLBACK TO IlkKayit;<\/code><\/pre>\n<\/li>\n<\/ul>\nGeli\u015fmi\u015f SQL Kavramlar\u0131<\/h2>\n
SQL’in g\u00fcc\u00fc, temel DML i\u015flemlerinin \u00f6tesine ge\u00e7en geli\u015fmi\u015f \u00f6zelliklerinde yatmaktad\u0131r.<\/p>\n
JOIN \u0130\u015flemleri<\/h3>\n
Birden fazla tablodaki verileri, aralar\u0131ndaki ortak s\u00fctunlar (genellikle yabanc\u0131 anahtarlar) arac\u0131l\u0131\u011f\u0131yla birle\u015ftirmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n
\nINNER JOIN<\/code>:<\/strong> Her iki tabloda da e\u015fle\u015fen kay\u0131tlara sahip sat\u0131rlar\u0131 d\u00f6nd\u00fcr\u00fcr.\nSELECT M.Ad, S.SiparisTarihi\nFROM Musteriler M\nINNER JOIN Siparisler S ON M.MusteriID = S.MusteriID;<\/code><\/pre>\n<\/li>\nLEFT JOIN<\/code> (veya LEFT OUTER JOIN<\/code>):<\/strong> Sol tablodaki t\u00fcm kay\u0131tlar\u0131 ve sa\u011f tabloda e\u015fle\u015fen kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. Sa\u011f tabloda e\u015fle\u015fme yoksa NULL de\u011ferler d\u00f6ner.\nSELECT M.Ad, S.SiparisID\nFROM Musteriler M\nLEFT JOIN Siparisler S ON M.MusteriID = S.MusteriID; -- T\u00fcm m\u00fc\u015fterileri, sipari\u015fleri olmasa bile g\u00f6sterir.<\/code><\/pre>\n<\/li>\nRIGHT JOIN<\/code> (veya RIGHT OUTER JOIN<\/code>):<\/strong> Sa\u011f tablodaki t\u00fcm kay\u0131tlar\u0131 ve sol tabloda e\u015fle\u015fen kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. Sol tabloda e\u015fle\u015fme yoksa NULL de\u011ferler d\u00f6ner.<\/li>\nFULL JOIN<\/code> (veya FULL OUTER JOIN<\/code>):<\/strong> Her iki tablodaki t\u00fcm kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. E\u015fle\u015fme olmayan yerlerde NULL de\u011ferler d\u00f6ner.<\/li>\nCROSS JOIN<\/code>:<\/strong> \u0130ki tablonun kartezyen \u00e7arp\u0131m\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr; yani ilk tablonun her sat\u0131r\u0131n\u0131 ikinci tablonun her sat\u0131r\u0131yla birle\u015ftirir.<\/li>\n<\/ul>\nAlt Sorgular (Subqueries)<\/h3>\n
Ba\u015fka bir SQL sorgusu i\u00e7inde yer alan bir sorgudur. Genellikle SELECT<\/code>, INSERT<\/code>, UPDATE<\/code> veya DELETE<\/code> deyimlerinin WHERE<\/code>, FROM<\/code> veya HAVING<\/code> yan t\u00fcmcelerinde kullan\u0131l\u0131rlar.<\/p>\nSELECT UrunAdi, Fiyat\nFROM Urunler\nWHERE Fiyat > (SELECT AVG(Fiyat) FROM Urunler); -- Ortalama fiyattan pahal\u0131 \u00fcr\u00fcnler<\/code><\/pre>\nToplama Fonksiyonlar\u0131 ve Grupland\u0131rma<\/h3>\n
Veri k\u00fcmeleri \u00fczerinde hesaplamalar yapmak i\u00e7in kullan\u0131l\u0131rlar.<\/p>\n
\nCOUNT()<\/code>:<\/strong> Sat\u0131r say\u0131s\u0131n\u0131 sayar.<\/li>\nSUM()<\/code>:<\/strong> Say\u0131sal bir s\u00fctunun toplam\u0131n\u0131 hesaplar.<\/li>\nAVG()<\/code>:<\/strong> Say\u0131sal bir s\u00fctunun ortalamas\u0131n\u0131 hesaplar.<\/li>\nMIN()<\/code>:<\/strong> Bir s\u00fctundaki en k\u00fc\u00e7\u00fck de\u011feri bulur.<\/li>\nMAX()<\/code>:<\/strong> Bir s\u00fctundaki en b\u00fcy\u00fck de\u011feri bulur.<\/li>\n<\/ul>\nBu fonksiyonlar genellikle GROUP BY<\/code> yan t\u00fcmcesi ile birlikte kullan\u0131l\u0131r. GROUP BY<\/code>, sonu\u00e7 k\u00fcmesini bir veya daha fazla s\u00fctuna g\u00f6re grupland\u0131r\u0131r ve toplama fonksiyonlar\u0131n\u0131 her grup i\u00e7in ayr\u0131 ayr\u0131 uygular.<\/p>\nSELECT Kategori, COUNT(UrunID) AS UrunSayisi, AVG(Fiyat) AS OrtalamaFiyat\nFROM Urunler\nGROUP BY Kategori\nHAVING COUNT(UrunID) > 5; -- Sadece 5'ten fazla \u00fcr\u00fcn\u00fc olan kategorileri g\u00f6ster<\/code><\/pre>\nHAVING<\/code> yan t\u00fcmcesi, GROUP BY<\/code> ile olu\u015fturulan gruplar\u0131 filtrelemek i\u00e7in kullan\u0131l\u0131r. WHERE<\/code>, grupland\u0131rma yap\u0131lmadan \u00f6nce sat\u0131rlar\u0131 filtrelerken, HAVING<\/code> gruplar olu\u015fturulduktan sonra gruplar\u0131 filtreler.<\/p>\nPencere Fonksiyonlar\u0131 (Window Functions)<\/h3>\n
SQL:2003 standard\u0131yla tan\u0131t\u0131lan pencere fonksiyonlar\u0131, bir sorgu sonucunun belirli bir “penceresi” (sat\u0131rlar k\u00fcmesi) \u00fczerinde hesaplamalar yapmaya olanak tan\u0131r. Bu fonksiyonlar, toplama fonksiyonlar\u0131na benzer \u015fekilde \u00e7al\u0131\u015f\u0131r ancak sat\u0131rlar\u0131 grupland\u0131rmaz ve b\u00f6ylece her orijinal sat\u0131r i\u00e7in bir sonu\u00e7 d\u00f6nd\u00fcr\u00fcr.<\/p>\n
\nROW_NUMBER()<\/code>:<\/strong> Bir pencere i\u00e7indeki her sat\u0131ra benzersiz bir s\u0131ra numaras\u0131 atar.<\/li>\nRANK()<\/code> \/ DENSE_RANK()<\/code>:<\/strong> Bir pencere i\u00e7indeki sat\u0131rlara s\u0131ralama atar, ayn\u0131 de\u011ferlere sahip sat\u0131rlar ayn\u0131 s\u0131ray\u0131 al\u0131r.<\/li>\nLAG()<\/code> \/ LEAD()<\/code>:<\/strong> Mevcut sat\u0131ra g\u00f6re \u00f6nceki veya sonraki sat\u0131rlardaki de\u011ferleri getirir.<\/li>\n<\/ul>\nSELECT\n SiparisID,\n SiparisTarihi,\n ToplamTutar,\n SUM(ToplamTutar) OVER (ORDER BY SiparisTarihi) AS K\u00fcm\u00fclatifToplam\nFROM Siparisler;<\/code><\/pre>\n\u0130ndeksler (Indexes)<\/h3>\n
Veritaban\u0131 tablolar\u0131ndaki verilere daha h\u0131zl\u0131 eri\u015fim sa\u011flamak i\u00e7in kullan\u0131l\u0131r. T\u0131pk\u0131 bir kitab\u0131n dizini gibi, indeksler de veritaban\u0131 motorunun belirli bir de\u011feri h\u0131zl\u0131ca bulmas\u0131n\u0131 sa\u011flar. Ancak, indeksler disk alan\u0131 kaplar ve veri ekleme\/g\u00fcncelleme\/silme i\u015flemlerini yava\u015flatabilir, bu y\u00fczden dikkatli kullan\u0131lmal\u0131d\u0131r.<\/p>\n
CREATE INDEX IX_Musteriler_Soyad ON Musteriler (Soyad);<\/code><\/pre>\nG\u00f6r\u00fcn\u00fcmler (Views)<\/h3>\n
Bir veya daha fazla tablodan veri \u00e7ekmek i\u00e7in kullan\u0131lan, \u00f6nceden tan\u0131mlanm\u0131\u015f bir sanal tablodur. G\u00f6r\u00fcn\u00fcmler, karma\u015f\u0131k sorgular\u0131 basitle\u015ftirmek, hassas verileri gizlemek ve g\u00fcvenlik sa\u011flamak i\u00e7in kullan\u0131l\u0131r.<\/p>\n
CREATE VIEW AktifMusteriler AS\nSELECT MusteriID, Ad, Soyad, Eposta\nFROM Musteriler\nWHERE Durum = 'Aktif';<\/code><\/pre>\nSakl\u0131 Prosed\u00fcrler ve Fonksiyonlar (Stored Procedures & Functions)<\/h3>\n
Veritaban\u0131nda depolanan ve gerekti\u011finde \u00e7a\u011fr\u0131labilen \u00f6nceden derlenmi\u015f SQL kod bloklar\u0131d\u0131r. Tekrar kullan\u0131labilirli\u011fi art\u0131r\u0131r, performans\u0131 iyile\u015ftirir (a\u011f trafi\u011fini azalt\u0131r), g\u00fcvenli\u011fi sa\u011flar ve i\u015f mant\u0131\u011f\u0131n\u0131 merkezile\u015ftirir.<\/p>\n
-- Basit bir sakl\u0131 prosed\u00fcr \u00f6rne\u011fi (SQL Server\/MySQL benzeri)\nDELIMITER \/\/\nCREATE PROCEDURE MusteriEkle (\n IN p_Ad VARCHAR(50),\n IN p_Soyad VARCHAR(50),\n IN p_Eposta VARCHAR(100)\n)\nBEGIN\n INSERT INTO Musteriler (Ad, Soyad, Eposta) VALUES (p_Ad, p_Soyad, p_Eposta);\nEND \/\/\nDELIMITER ;\n\n-- \u00c7a\u011f\u0131rma\nCALL MusteriEkle('Deniz', 'Demir', 'deniz.demir@example.com');<\/code><\/pre>\nSQL Diyalektleri ve Uygulamalar\u0131<\/h2>\n
SQL, ANSI\/ISO taraf\u0131ndan standartla\u015ft\u0131r\u0131lm\u0131\u015f olsa da, her RDBMS sat\u0131c\u0131s\u0131 kendi uygulamas\u0131na \u00f6zg\u00fc uzant\u0131lar ve varyasyonlar ekler. Bu varyasyonlara “SQL diyalektleri” denir.<\/p>\n
\n- MySQL:<\/strong> A\u00e7\u0131k kaynakl\u0131, pop\u00fcler ve web uygulamalar\u0131nda yayg\u0131n olarak kullan\u0131l\u0131r.<\/li>\n
- PostgreSQL:<\/strong> Geli\u015fmi\u015f \u00f6zelliklere sahip, nesne-ili\u015fkisel bir veritaban\u0131d\u0131r. Genellikle daha b\u00fcy\u00fck ve karma\u015f\u0131k sistemlerde tercih edilir.<\/li>\n
- Oracle Database:<\/strong> Kurumsal d\u00fczeyde, g\u00fc\u00e7l\u00fc ve zengin \u00f6zelliklere sahip ticari bir RDBMS’dir.<\/li>\n
- Microsoft SQL Server:<\/strong> Microsoft ekosistemiyle entegre, kurumsal uygulamalarda yayg\u0131n olarak kullan\u0131lan ticari bir RDBMS’dir.<\/li>\n
- SQLite:<\/strong> Sunucusuz, hafif ve dosya tabanl\u0131 bir veritaban\u0131d\u0131r. Mobil uygulamalarda ve g\u00f6m\u00fcl\u00fc sistemlerde idealdir.<\/li>\n<\/ul>\n
Bu diyalektler aras\u0131ndaki temel SQL komutlar\u0131 (SELECT, INSERT, UPDATE, DELETE) genellikle ayn\u0131d\u0131r, ancak DDL komutlar\u0131, veri tipleri, \u00f6zel fonksiyonlar ve geli\u015fmi\u015f \u00f6zelliklerin s\u00f6zdizimi farkl\u0131l\u0131k g\u00f6sterebilir. \u00d6rne\u011fin, bir veritaban\u0131nda otomatik artan birincil anahtar tan\u0131mlama \u015fekli farkl\u0131l\u0131k g\u00f6sterebilir (AUTO_INCREMENT<\/code> MySQL’de, IDENTITY<\/code> SQL Server’da, SERIAL<\/code> PostgreSQL’de).<\/p>\nNoSQL vs. SQL<\/h3>\n
Son y\u0131llarda NoSQL (Not only SQL) veritabanlar\u0131 (MongoDB, Cassandra, Redis vb.) b\u00fcy\u00fck veri, ger\u00e7ek zamanl\u0131 uygulamalar ve esnek \u015fema ihtiya\u00e7lar\u0131 i\u00e7in pop\u00fclerlik kazanm\u0131\u015ft\u0131r. Ancak bu, SQL’in \u00f6nemini azaltmam\u0131\u015ft\u0131r. SQL veritabanlar\u0131, y\u00fcksek veri b\u00fct\u00fcnl\u00fc\u011f\u00fc gerektiren, karma\u015f\u0131k ili\u015fkisel verilerle \u00e7al\u0131\u015fan ve yap\u0131land\u0131r\u0131lm\u0131\u015f sorgulama yeteneklerine ihtiya\u00e7 duyan uygulamalar i\u00e7in hala birincil tercihtir. NoSQL ve SQL, birbirinin rakibi olmaktan ziyade, farkl\u0131 ihtiya\u00e7lara y\u00f6nelik tamamlay\u0131c\u0131 teknolojilerdir.<\/p>\n
SQL’de En \u0130yi Uygulama Y\u00f6ntemleri<\/h2>\n
Etkili ve performansl\u0131 SQL kodu yazmak i\u00e7in baz\u0131 en iyi uygulamalar\u0131 takip etmek \u00f6nemlidir:<\/p>\n
Okunabilirlik ve Bak\u0131m Kolayl\u0131\u011f\u0131<\/h3>\n\n- Tutarl\u0131 Bi\u00e7imlendirme:<\/strong> B\u00fcy\u00fck harf kullan\u0131m\u0131, girintileme ve bo\u015fluklar, sorgular\u0131n daha okunabilir olmas\u0131n\u0131 sa\u011flar.<\/li>\n
- Yorum Kullan\u0131m\u0131:<\/strong> Karma\u015f\u0131k sorgular\u0131 veya i\u015f mant\u0131\u011f\u0131n\u0131 a\u00e7\u0131klamak i\u00e7in yorumlar ekleyin.<\/li>\n
- Anlaml\u0131 Adland\u0131rma:<\/strong> Tablo, s\u00fctun, g\u00f6r\u00fcn\u00fcm ve prosed\u00fcr adlar\u0131 anla\u015f\u0131l\u0131r ve tutarl\u0131 olmal\u0131d\u0131r.<\/li>\n<\/ul>\n
Performans Optimizasyonu<\/h3>\n\n- \u0130ndeksleri Do\u011fru Kullan\u0131n:<\/strong> S\u0131k\u00e7a sorgulanan s\u00fctunlara indeks ekleyin, ancak a\u015f\u0131r\u0131 indekslemeden ka\u00e7\u0131n\u0131n.<\/li>\n
SELECT *<\/code> Kullan\u0131m\u0131ndan Ka\u00e7\u0131n\u0131n:<\/strong> Yaln\u0131zca ihtiyac\u0131n\u0131z olan s\u00fctunlar\u0131 se\u00e7in. Bu, a\u011f trafi\u011fini ve bellek kullan\u0131m\u0131n\u0131 azalt\u0131r.<\/li>\nWHERE<\/code> Yan T\u00fcmcesini Etkili Kullan\u0131n:<\/strong> Veri k\u00fcmesini olabildi\u011fince erken filtreleyin.<\/li>\n- JOIN Optimizasyonu:<\/strong> B\u00fcy\u00fck tablolar\u0131 birle\u015ftirirken dikkatli olun ve uygun JOIN t\u00fcrlerini kullan\u0131n.<\/li>\n
- Alt Sorgular\u0131 Optimize Edin:<\/strong> Baz\u0131 durumlarda alt sorgular yerine JOIN’ler veya ge\u00e7ici tablolar daha performansl\u0131 olabilir.<\/li>\n
- Sorgu Planlar\u0131n\u0131 \u0130nceleyin:<\/strong> Veritaban\u0131 motorunun sorguyu nas\u0131l y\u00fcr\u00fctt\u00fc\u011f\u00fcn\u00fc anlamak i\u00e7in sorgu planlar\u0131n\u0131 kullan\u0131n.<\/li>\n<\/ul>\n
G\u00fcvenlik<\/h3>\n\n- En Az Ayr\u0131cal\u0131k Prensibi:<\/strong> Kullan\u0131c\u0131lara ve uygulamalara yaln\u0131zca g\u00f6revlerini yerine getirmek i\u00e7in gerekli olan minimum izinleri verin.<\/li>\n
- SQL Enjeksiyonuna Kar\u015f\u0131 Koruma:<\/strong> Kullan\u0131c\u0131 girdilerini do\u011frudan SQL sorgular\u0131na eklemek yerine, parametreli sorgular veya sakl\u0131 prosed\u00fcrler kullan\u0131n.<\/li>\n
- Hassas Verileri \u015eifreleyin:<\/strong> \u00d6zellikle ki\u015fisel veya finansal bilgileri veritaban\u0131nda \u015fifreleyerek saklay\u0131n.<\/li>\n<\/ul>\n
Veri B\u00fct\u00fcnl\u00fc\u011f\u00fc<\/h3>\n\n- K\u0131s\u0131tlamalar\u0131 Kullan\u0131n:<\/strong>
PRIMARY KEY<\/code>, FOREIGN KEY<\/code>, UNIQUE<\/code>, NOT NULL<\/code> ve CHECK<\/code> k\u0131s\u0131tlamalar\u0131 ile veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc zorlay\u0131n.<\/li>\n- \u0130\u015flemleri Kullan\u0131n:<\/strong> Birden fazla DML i\u015flemini bir araya getiren mant\u0131ksal birimler i\u00e7in TCL komutlar\u0131n\u0131 (
COMMIT<\/code>, ROLLBACK<\/code>) kullan\u0131n.<\/li>\n<\/ul>\nSQL’i Kimler Kullan\u0131r?<\/h2>\n
SQL, geni\u015f bir profesyonel yelpazesi taraf\u0131ndan kullan\u0131lan temel bir beceridir:<\/p>\n
\n- Veri Analistleri ve Veri Bilimcileri:<\/strong> Verilerden i\u00e7g\u00f6r\u00fcler elde etmek, raporlar olu\u015fturmak ve modeller i\u00e7in veri haz\u0131rlamak amac\u0131yla yo\u011fun olarak SQL kullan\u0131rlar.<\/li>\n
- Yaz\u0131l\u0131m Geli\u015ftiriciler (Backend Developers):<\/strong> Uygulamalar\u0131n veritabanlar\u0131yla etkile\u015fim kurmas\u0131n\u0131 sa\u011flayan kodlar\u0131 yazarken SQL sorgular\u0131 olu\u015ftururlar.<\/li>\n
- Veritaban\u0131 Y\u00f6neticileri (DBA’ler):<\/strong> Veritabanlar\u0131n\u0131n kurulumu, bak\u0131m\u0131, performans\u0131, yedeklenmesi ve g\u00fcvenli\u011finden sorumludurlar. DDL ve DCL komutlar\u0131n\u0131 yo\u011fun olarak kullan\u0131rlar.<\/li>\n
- \u0130\u015f Zekas\u0131 (Business Intelligence – BI) Uzmanlar\u0131:<\/strong> \u0130\u015f kararlar\u0131n\u0131 desteklemek i\u00e7in veri ambarlar\u0131ndan ve veritabanlar\u0131ndan raporlar ve g\u00f6sterge tablolar\u0131 olu\u015ftururlar.<\/li>\n
- Kalite G\u00fcvence (QA) M\u00fchendisleri:<\/strong> Uygulama verilerini do\u011frulamak ve test senaryolar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmak i\u00e7in SQL kullan\u0131rlar.<\/li>\n<\/ul>\n
SQL’in Gelece\u011fi<\/h2>\n
Dijital d\u00f6n\u00fc\u015f\u00fcm\u00fcn h\u0131z kesmeden devam etti\u011fi bir d\u00fcnyada, veri her zamankinden daha de\u011ferli hale geliyor. SQL, bu veri \u00e7a\u011f\u0131n\u0131n temel ta\u015f\u0131 olmaya devam edecektir. B\u00fcy\u00fck veri platformlar\u0131 (\u00f6rne\u011fin, Hadoop, Spark) ve bulut tabanl\u0131 veritaban\u0131 hizmetleri (AWS RDS, Azure SQL Database, Google Cloud SQL) SQL uyumlulu\u011funu s\u00fcrd\u00fcrmekte ve hatta SQL benzeri sorgulama dillerini (HiveQL, Spark SQL) entegre etmektedir.<\/p>\n
SQL’in evrenselli\u011fi, g\u00fc\u00e7l\u00fc analitik yetenekleri ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flama kapasitesi, onu gelecekte de veri y\u00f6netiminin ve analizinin merkezinde tutacakt\u0131r. Geli\u015ftiriciler, analistler ve veri bilimcileri i\u00e7in SQL’i anlamak ve ustaca kullanmak, kariyerlerinde vazge\u00e7ilmez bir avantaj sa\u011flamaya devam edecektir.<\/p>\n
Sonu\u00e7<\/h2>\n
SQL, ili\u015fkisel veritabanlar\u0131yla etkile\u015fim kurmak i\u00e7in kullan\u0131lan g\u00fc\u00e7l\u00fc, deklaratif ve evrensel bir dildir. Tarihsel k\u00f6kenleri 1970’lere dayansa da, s\u00fcrekli evrim ge\u00e7iren standartlar\u0131 ve geni\u015f uygulama yelpazesi sayesinde g\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda hala merkezi bir rol oynamaktad\u0131r. DDL ile veritaban\u0131 yap\u0131lar\u0131n\u0131 tan\u0131mlamaktan, DML ile verileri manip\u00fcle etmeye, DCL ile yetkileri y\u00f6netmeye ve TCL ile i\u015flem b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamaya kadar, SQL veritaban\u0131 y\u00f6netiminin her y\u00f6n\u00fcn\u00fc kapsar.<\/p>\n
JOIN’ler, alt sorgular, toplama fonksiyonlar\u0131 ve pencere fonksiyonlar\u0131 gibi geli\u015fmi\u015f \u00f6zellikleri, SQL’i karma\u015f\u0131k veri analizleri ve i\u015f zekas\u0131 uygulamalar\u0131 i\u00e7in vazge\u00e7ilmez k\u0131lar. MySQL, PostgreSQL, Oracle ve SQL Server gibi farkl\u0131 diyalektleri olsa da, temel prensipleri ve s\u00f6zdizimi \u00e7o\u011fu platformda tutarl\u0131d\u0131r. G\u00fcvenlik, performans ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fc odakl\u0131 en iyi uygulamalar\u0131 takip etmek, SQL’in potansiyelini tam olarak kullanmak i\u00e7in kritik \u00f6neme sahiptir.<\/p>\n
Veri, modern d\u00fcnyan\u0131n yeni ya\u011f\u0131d\u0131r ve SQL, bu ya\u011f\u0131 i\u015flemek i\u00e7in kullan\u0131lan en g\u00fc\u00e7l\u00fc ara\u00e7lardan biridir. \u0130ster bir ba\u015flang\u0131\u00e7 seviyesinde olun ister deneyimli bir profesyonel, SQL becerilerinizi geli\u015ftirmek, dijital ekonomideki ba\u015far\u0131n\u0131z i\u00e7in sa\u011flam bir temel olu\u015fturacakt\u0131r. SQL, sadece bir teknik dil de\u011fil, ayn\u0131 zamanda verilerle anlaml\u0131 bir diyalog kurman\u0131n ve onlardan de\u011ferli bilgiler \u00e7\u0131karman\u0131n anahtar\u0131d\u0131r.<\/p>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"SQL Nedir?\nG\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, bilginin toplanmas\u0131, depolanmas\u0131, y\u00f6netilmesi ve analiz edilmesi, hem bireyler hem de kurumlar","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":[1505],"tags":[],"class_list":{"0":"post-34070","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-sql-2","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\n
What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\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\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu\" \/>\n<meta property=\"og:description\" content=\"SQL Nedir? G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, bilginin toplanmas\u0131, depolanmas\u0131, y\u00f6netilmesi ve analiz edilmesi, hem bireyler hem de kurumlar\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-11-10T15:40:56+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=\"18 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"What is SQL? – Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu\",\"datePublished\":\"2025-11-10T15:40:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\"},\"wordCount\":3135,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"SQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\",\"name\":\"What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-11-10T15:40:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is SQL? – Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu\"}]},{\"@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":"What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","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\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/","og_locale":"tr_TR","og_type":"article","og_title":"What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu","og_description":"SQL Nedir? G\u00fcn\u00fcm\u00fcz\u00fcn veri odakl\u0131 d\u00fcnyas\u0131nda, bilginin toplanmas\u0131, depolanmas\u0131, y\u00f6netilmesi ve analiz edilmesi, hem bireyler hem de kurumlar","og_url":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-11-10T15:40:56+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"18 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"What is SQL? – Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu","datePublished":"2025-11-10T15:40:56+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/"},"wordCount":3135,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["SQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/","url":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/","name":"What is SQL? - Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-11-10T15:40:56+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/what-is-sql-detayli-rehber-ve-kullanim-kilavuzu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"What is SQL? – Detayl\u0131 Rehber ve Kullan\u0131m K\u0131lavuzu"}]},{"@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\/34070","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=34070"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/34070\/revisions"}],"predecessor-version":[{"id":34071,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/34070\/revisions\/34071"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=34070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=34070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=34070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}