{"id":37470,"date":"2026-01-06T05:40:49","date_gmt":"2026-01-06T02:40:49","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=37470"},"modified":"2026-01-06T05:40:49","modified_gmt":"2026-01-06T02:40:49","slug":"mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/","title":{"rendered":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri"},"content":{"rendered":"<p><body><\/p>\n<h2>MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri<\/h2>\n<h2>Giri\u015f<\/h2>\n<p>G\u00fcn\u00fcm\u00fcz\u00fcn dijital d\u00fcnyas\u0131nda, veri her \u015feyin merkezinde yer almaktad\u0131r. Web sitelerinden mobil uygulamalara, kurumsal sistemlerden bilimsel ara\u015ft\u0131rmalara kadar her alanda b\u00fcy\u00fck miktarda veri \u00fcretilmekte ve i\u015flenmektedir. Bu verileri d\u00fczenli bir \u015fekilde depolamak, y\u00f6netmek ve anlaml\u0131 bilgilere d\u00f6n\u00fc\u015ft\u00fcrmek i\u00e7in veritabanlar\u0131 vazge\u00e7ilmez ara\u00e7lard\u0131r. \u0130li\u015fkisel veritabanlar\u0131, bu alandaki en yayg\u0131n ve g\u00fc\u00e7l\u00fc \u00e7\u00f6z\u00fcmlerden biridir ve MySQL, a\u00e7\u0131k kaynakl\u0131 ve pop\u00fcler bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir (RDBMS).<\/p>\n<p>MySQL gibi bir veritaban\u0131 ile etkile\u015fim kurman\u0131n ve ondan bilgi alman\u0131n yolu ise &#8220;sorgular&#8221; arac\u0131l\u0131\u011f\u0131ylad\u0131r. Sorgular, veritaban\u0131na belirli komutlar g\u00f6ndererek veri ekleme, g\u00fcncelleme, silme veya en \u00f6nemlisi, depolanan verileri \u00e7ekme i\u015flemlerini ger\u00e7ekle\u015ftirmemizi sa\u011flayan \u00f6zel dillerdir. Bu makale, MySQL veritaban\u0131nda sorgulama yapman\u0131n temel prensiplerini ve en s\u0131k kullan\u0131lan SQL (Structured Query Language) komutlar\u0131n\u0131 kapsaml\u0131 bir \u015fekilde ele alacakt\u0131r. Amac\u0131m\u0131z, veritaban\u0131 ile &#8220;konu\u015fmaya&#8221; ba\u015flamak isteyen herkes i\u00e7in sa\u011flam bir temel olu\u015fturmakt\u0131r. Veritaban\u0131 y\u00f6netim sistemleri ve SQL&#8217;in temel s\u00f6zdiziminden ba\u015flayarak, veri \u00e7ekme, filtreleme, s\u0131ralama, gruplama ve tablolar\u0131 birle\u015ftirme gibi kritik konular\u0131 \u00f6rneklerle a\u00e7\u0131klayaca\u011f\u0131z.<\/p>\n<h2>Temel SQL Komutlar\u0131 ve S\u00f6zdizimi<\/h2>\n<h3>SQL Nedir?<\/h3>\n<p>SQL, &#8220;Structured Query Language&#8221; kelimelerinin ba\u015f harflerinden olu\u015fan, ili\u015fkisel veritabanlar\u0131n\u0131 y\u00f6netmek ve sorgulamak i\u00e7in tasarlanm\u0131\u015f standart bir dildir. 1970&#8217;lerde IBM taraf\u0131ndan geli\u015ftirilen ve daha sonra ANSI ve ISO standartlar\u0131 haline gelen SQL, g\u00fcn\u00fcm\u00fczde t\u00fcm b\u00fcy\u00fck ili\u015fkisel veritaban\u0131 sistemleri (MySQL, PostgreSQL, Oracle, SQL Server vb.) taraf\u0131ndan desteklenmektedir. SQL, sadece veri \u00e7ekmekle kalmaz, ayn\u0131 zamanda veritaban\u0131 \u015femas\u0131n\u0131 olu\u015fturmak, de\u011fi\u015ftirmek ve verileri manip\u00fcle etmek i\u00e7in de kullan\u0131l\u0131r.<\/p>\n<p>SQL komutlar\u0131 genellikle be\u015f ana kategoriye ayr\u0131l\u0131r:<br \/>\n*   <strong>DQL (Data Query Language):<\/strong> Veri sorgulama (\u00f6rn. <code>SELECT<\/code>).<br \/>\n*   <strong>DML (Data Manipulation Language):<\/strong> Veri manip\u00fclasyonu (\u00f6rn. <code>INSERT<\/code>, <code>UPDATE<\/code>, <code>DELETE<\/code>).<br \/>\n*   <strong>DDL (Data Definition Language):<\/strong> Veritaban\u0131 yap\u0131s\u0131n\u0131 tan\u0131mlama (\u00f6rn. <code>CREATE<\/code>, <code>ALTER<\/code>, <code>DROP<\/code>).<br \/>\n*   <strong>DCL (Data Control Language):<\/strong> Veritaban\u0131 eri\u015fimini kontrol etme (\u00f6rn. <code>GRANT<\/code>, <code>REVOKE<\/code>).<br \/>\n*   <strong>TCL (Transaction Control Language):<\/strong> \u0130\u015flemleri y\u00f6netme (\u00f6rn. <code>COMMIT<\/code>, <code>ROLLBACK<\/code>).<\/p>\n<p>Bu makalede \u00f6zellikle DQL ve DML komutlar\u0131na odaklanaca\u011f\u0131z, zira bunlar veritaban\u0131yla g\u00fcnl\u00fck etkile\u015fimin temelini olu\u015fturur.<\/p>\n<h3>S\u00f6zdizimi Temelleri<\/h3>\n<p>SQL sorgular\u0131 belirli bir s\u00f6zdizimine sahiptir:<br \/>\n*   <strong>Noktal\u0131 Virg\u00fcl (;):<\/strong> Her SQL ifadesinin sonunda noktal\u0131 virg\u00fcl kullanmak iyi bir pratiktir. Bu, veritaban\u0131 sistemine bir komutun bitti\u011fini bildirir ve birden fazla komutu ayn\u0131 anda \u00e7al\u0131\u015ft\u0131rman\u0131za olanak tan\u0131r.<br \/>\n*   <strong>B\u00fcy\u00fck\/K\u00fc\u00e7\u00fck Harf Duyarl\u0131l\u0131\u011f\u0131:<\/strong> \u00c7o\u011fu SQL veritaban\u0131 sistemi (MySQL varsay\u0131lan olarak Windows&#8217;ta b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 de\u011fildir, Linux&#8217;ta tablo ve veritaban\u0131 adlar\u0131 duyarl\u0131 olabilir) anahtar kelimeler (SELECT, FROM, WHERE) konusunda b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 de\u011fildir. Ancak, tablo ve s\u00fctun adlar\u0131 i\u00e7in bu durum de\u011fi\u015febilir. Genellikle, anahtar kelimeleri b\u00fcy\u00fck harfle yazmak ve tablo\/s\u00fctun adlar\u0131n\u0131 k\u00fc\u00e7\u00fck harfle yazmak, kodun okunabilirli\u011fini art\u0131rmak i\u00e7in tercih edilen bir y\u00f6ntemdir.<br \/>\n*   <strong>Yorum Sat\u0131rlar\u0131:<\/strong> Sorgular\u0131n\u0131za a\u00e7\u0131klama eklemek i\u00e7in yorum sat\u0131rlar\u0131n\u0131 kullanabilirsiniz.<br \/>\n    *   Tek sat\u0131rl\u0131k yorumlar i\u00e7in: <code>-- Bu bir yorum sat\u0131r\u0131d\u0131r.<\/code> veya <code># Bu da bir yorum sat\u0131r\u0131d\u0131r.<\/code><br \/>\n    <em>   \u00c7ok sat\u0131rl\u0131k yorumlar i\u00e7in: <code>\/<\/em> Bu \u00e7ok sat\u0131rl\u0131 bir yorumdur. *\/<\/code><\/p>\n<p><strong>\u00d6rnek:<\/strong><\/p>\n<pre><code class=\"language-sql\">-- Bu, M\u00fc\u015fteriler tablosundan t\u00fcm verileri \u00e7eken bir sorgudur.\nSELECT * FROM Musteriler; # M\u00fc\u015fteriler tablosundaki t\u00fcm s\u00fctunlar\u0131 se\u00e7er.\n\n\/*\nBu bir blok yorumudur.\nBirden fazla sat\u0131rda a\u00e7\u0131klama yapman\u0131za olanak tan\u0131r.\n*\/<\/code><\/pre>\n<h2>Veri Sorgulama: SELECT Komutu<\/h2>\n<p><code>SELECT<\/code> komutu, bir veya daha fazla tablodan veri \u00e7ekmek i\u00e7in kullan\u0131lan en temel ve en s\u0131k ba\u015fvurdu\u011fumuz SQL komutudur.<\/p>\n<h3>SELECT * FROM tablo_ad\u0131<\/h3>\n<p>Bir tablodaki t\u00fcm s\u00fctunlar\u0131 se\u00e7mek i\u00e7in y\u0131ld\u0131z (<code>*<\/code>) karakterini kullan\u0131r\u0131z. Bu, tablonun t\u00fcm i\u00e7eri\u011fini g\u00f6rmek istedi\u011finizde kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT * FROM tablo_ad\u0131;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nDiyelim ki <code>Urunler<\/code> ad\u0131nda bir tablonuz var. Bu tablodaki t\u00fcm \u00fcr\u00fcn bilgilerini g\u00f6rmek i\u00e7in:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM Urunler;<\/code><\/pre>\n<p>Bu sorgu, <code>Urunler<\/code> tablosundaki t\u00fcm s\u00fctunlar\u0131 ve t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcrecektir.<\/p>\n<h3>Belirli S\u00fctunlar\u0131 Se\u00e7me<\/h3>\n<p>Genellikle, bir tablodaki t\u00fcm s\u00fctunlara ihtiyac\u0131n\u0131z olmaz. Sadece belirli s\u00fctunlar\u0131 se\u00e7erek gereksiz verilerin transferini \u00f6nleyebilir ve performans\u0131 art\u0131rabilirsiniz.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutun1, sutun2, ... FROM tablo_ad\u0131;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>Urunler<\/code> tablosundan sadece <code>urun_adi<\/code> ve <code>fiyat<\/code> s\u00fctunlar\u0131n\u0131 \u00e7ekmek i\u00e7in:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler;<\/code><\/pre>\n<h3>DISTINCT Anahtar Kelimesi<\/h3>\n<p><code>DISTINCT<\/code> anahtar kelimesi, se\u00e7ilen s\u00fctunlarda tekrarlayan de\u011ferleri ortadan kald\u0131rarak yaln\u0131zca benzersiz de\u011ferleri d\u00f6nd\u00fcrmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT DISTINCT sutun1 FROM tablo_ad\u0131;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>Musteriler<\/code> tablosunda hangi \u015fehirlerin bulundu\u011funu tekrars\u0131z bir \u015fekilde g\u00f6rmek i\u00e7in:<\/p>\n<pre><code class=\"language-sql\">SELECT DISTINCT sehir FROM Musteriler;<\/code><\/pre>\n<h3>AS Anahtar Kelimesi (Alias)<\/h3>\n<p><code>AS<\/code> anahtar kelimesi, s\u00fctunlara veya tablolara ge\u00e7ici olarak farkl\u0131 bir isim (takma ad) vermek i\u00e7in kullan\u0131l\u0131r. Bu, sorgu sonu\u00e7lar\u0131n\u0131n daha okunabilir olmas\u0131n\u0131 sa\u011flar veya karma\u015f\u0131k sorgularda tablo adlar\u0131n\u0131 k\u0131saltmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutun_ad\u0131 AS takma_ad FROM tablo_ad\u0131 AS tablo_takma_ad\u0131;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>Urunler<\/code> tablosundaki <code>urun_adi<\/code> s\u00fctununu &#8220;\u00dcr\u00fcn Ad\u0131&#8221; olarak, <code>fiyat<\/code> s\u00fctununu ise &#8220;Birim Fiyat&#8221; olarak g\u00f6stermek i\u00e7in:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi AS \"\u00dcr\u00fcn Ad\u0131\", fiyat AS \"Birim Fiyat\" FROM Urunler;<\/code><\/pre>\n<p>Tablo takma adlar\u0131 genellikle JOIN i\u015flemlerinde veya alt sorgularda kullan\u0131l\u0131r.<\/p>\n<h2>Veri Filtreleme: WHERE Komutu<\/h2>\n<p><code>WHERE<\/code> komutu, <code>SELECT<\/code> sorgular\u0131n\u0131n en g\u00fc\u00e7l\u00fc bile\u015fenlerinden biridir ve belirli kriterlere uyan sat\u0131rlar\u0131 filtrelemek i\u00e7in kullan\u0131l\u0131r. Bu sayede sadece ilgilendi\u011finiz verileri \u00e7ekebilirsiniz.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar FROM tablo_ad\u0131 WHERE ko\u015ful;<\/code><\/pre>\n<h3>Temel Kar\u015f\u0131la\u015ft\u0131rma Operat\u00f6rleri<\/h3>\n<p><code>WHERE<\/code> c\u00fcmleci\u011fi i\u00e7inde kullan\u0131lan ba\u015fl\u0131ca kar\u015f\u0131la\u015ft\u0131rma operat\u00f6rleri \u015funlard\u0131r:<br \/>\n*   <code>=<\/code> E\u015fittir<br \/>\n*   <code>!=<\/code> veya <code><><\/code> E\u015fit De\u011fildir<br \/>\n*   <code>><\/code> B\u00fcy\u00fckt\u00fcr<br \/>\n*   <code><<\/code> K\u00fc\u00e7\u00fckt\u00fcr<br \/>\n*   <code>>=<\/code> B\u00fcy\u00fck E\u015fittir<br \/>\n*   <code><=<\/code> K\u00fc\u00e7\u00fck E\u015fittir<\/p>\n<p><strong>\u00d6rnekler:<\/strong><br \/>\n*   Fiyat\u0131 50'den b\u00fcy\u00fck olan \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler WHERE fiyat > 50;<\/code><\/pre>\n<p>*   Stokta 100 adetten az kalan \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, stok_adedi FROM Urunler WHERE stok_adedi < 100;<\/code><\/pre>\n<p>*   Kategorisi 'Elektronik' olmayan \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, kategori FROM Urunler WHERE kategori != 'Elektronik';<\/code><\/pre>\n<h3>Mant\u0131ksal Operat\u00f6rler: AND, OR, NOT<\/h3>\n<p>Birden fazla ko\u015fulu birle\u015ftirmek veya ko\u015fullar\u0131 tersine \u00e7evirmek i\u00e7in mant\u0131ksal operat\u00f6rler kullan\u0131l\u0131r.<\/p>\n<p>*   <strong>AND:<\/strong> Her iki ko\u015ful da do\u011fruysa <code>TRUE<\/code> d\u00f6nd\u00fcr\u00fcr.<br \/>\n*   <strong>OR:<\/strong> Ko\u015fullardan en az biri do\u011fruysa <code>TRUE<\/code> d\u00f6nd\u00fcr\u00fcr.<br \/>\n*   <strong>NOT:<\/strong> Ko\u015ful do\u011fruysa <code>FALSE<\/code>, yanl\u0131\u015fsa <code>TRUE<\/code> d\u00f6nd\u00fcr\u00fcr (ko\u015fulu tersine \u00e7evirir).<\/p>\n<p><strong>\u00d6rnekler:<\/strong><br \/>\n*   Fiyat\u0131 50 ile 100 aras\u0131nda olan (50 ve 100 dahil) \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler WHERE fiyat >= 50 AND fiyat <= 100;<\/code><\/pre>\n<p>*   Kategorisi 'Elektronik' olan veya stok adedi 50'den az olan \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, kategori, stok_adedi FROM Urunler WHERE kategori = 'Elektronik' OR stok_adedi < 50;<\/code><\/pre>\n<p>*   Kategorisi 'Giyim' olmayan \u00fcr\u00fcnleri listele (NOT ile):<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, kategori FROM Urunler WHERE NOT kategori = 'Giyim';<\/code><\/pre>\n<h3>\u00d6zel Operat\u00f6rler<\/h3>\n<p>SQL'de daha karma\u015f\u0131k filtreleme senaryolar\u0131 i\u00e7in \u00f6zel operat\u00f6rler bulunur.<\/p>\n<p>*   <strong>BETWEEN:<\/strong> Belirli bir aral\u0131ktaki de\u011ferleri se\u00e7er (s\u0131n\u0131rlar dahil).<br \/>\n    <strong>S\u00f6zdizimi:<\/strong> <code>sutun BETWEEN deger1 AND deger2<\/code><br \/>\n    <strong>\u00d6rnek:<\/strong> Fiyat\u0131 50 ile 100 aras\u0131nda olan \u00fcr\u00fcnler:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler WHERE fiyat BETWEEN 50 AND 100;<\/code><\/pre>\n<p>*   <strong>LIKE:<\/strong> Metin desen e\u015fle\u015ftirmesi yapmak i\u00e7in kullan\u0131l\u0131r. Genellikle joker karakterlerle birlikte kullan\u0131l\u0131r:<br \/>\n    *   <code>%<\/code>: S\u0131f\u0131r veya daha fazla karakteri temsil eder.<br \/>\n    *   <code>_<\/code>: Tek bir karakteri temsil eder.<br \/>\n    <strong>S\u00f6zdizimi:<\/strong> <code>sutun LIKE 'desen'<\/code><br \/>\n    <strong>\u00d6rnekler:<\/strong><br \/>\n    *   Ad\u0131 'A' ile ba\u015flayan \u00fcr\u00fcnler:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi FROM Urunler WHERE urun_adi LIKE 'A%';<\/code><\/pre>\n<p>    *   Ad\u0131nda 'el' ge\u00e7en \u00fcr\u00fcnler:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi FROM Urunler WHERE urun_adi LIKE '%el%';<\/code><\/pre>\n<p>    *   Ad\u0131n\u0131n ikinci harfi 'a' olan \u00fcr\u00fcnler:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi FROM Urunler WHERE urun_adi LIKE '_a%';<\/code><\/pre>\n<p>*   <strong>IN:<\/strong> Belirtilen bir de\u011fer listesi i\u00e7indeki herhangi bir de\u011fere e\u015fit olan kay\u0131tlar\u0131 se\u00e7er.<br \/>\n    <strong>S\u00f6zdizimi:<\/strong> <code>sutun IN (deger1, deger2, ...)<\/code><br \/>\n    <strong>\u00d6rnek:<\/strong> Kategorisi 'Elektronik' veya 'Ev E\u015fyas\u0131' olan \u00fcr\u00fcnler:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, kategori FROM Urunler WHERE kategori IN ('Elektronik', 'Ev E\u015fyas\u0131');<\/code><\/pre>\n<p>*   <strong>IS NULL \/ IS NOT NULL:<\/strong> Bir s\u00fctunun de\u011ferinin <code>NULL<\/code> (bo\u015f) olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. <code>NULL<\/code> bir de\u011fer de\u011fildir, bir de\u011ferin yoklu\u011funu temsil eder, bu y\u00fczden <code>=<\/code> veya <code>!=<\/code> ile kar\u015f\u0131la\u015ft\u0131r\u0131lamaz.<br \/>\n    <strong>S\u00f6zdizimi:<\/strong> <code>sutun IS NULL<\/code> veya <code>sutun IS NOT NULL<\/code><br \/>\n    <strong>\u00d6rnek:<\/strong> A\u00e7\u0131klamas\u0131 olmayan \u00fcr\u00fcnleri listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi FROM Urunler WHERE aciklama IS NULL;<\/code><\/pre>\n<h2>Veri S\u0131ralama: ORDER BY Komutu<\/h2>\n<p><code>ORDER BY<\/code> komutu, sorgu sonu\u00e7lar\u0131n\u0131 bir veya daha fazla s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in kullan\u0131l\u0131r. Varsay\u0131lan olarak artan s\u0131rada (alfabetik veya say\u0131sal olarak k\u00fc\u00e7\u00fckten b\u00fcy\u00fc\u011fe) s\u0131ralama yapar.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar FROM tablo_ad\u0131 WHERE ko\u015ful ORDER BY sutun1 [ASC|DESC], sutun2 [ASC|DESC], ...;<\/code><\/pre>\n<h3>ASC ve DESC<\/h3>\n<p>*   <strong>ASC:<\/strong> Artan s\u0131ralama (Ascending). Bu varsay\u0131lan de\u011ferdir, belirtilmezse otomatik olarak uygulan\u0131r.<br \/>\n*   <strong>DESC:<\/strong> Azalan s\u0131ralama (Descending).<\/p>\n<p><strong>\u00d6rnekler:<\/strong><br \/>\n*   \u00dcr\u00fcnleri fiyata g\u00f6re artan s\u0131rada s\u0131rala:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler ORDER BY fiyat ASC;<\/code><\/pre>\n<p>*   \u00dcr\u00fcnleri fiyata g\u00f6re azalan s\u0131rada s\u0131rala:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler ORDER BY fiyat DESC;<\/code><\/pre>\n<p>*   \u00dcr\u00fcnleri \u00f6nce kategoriye g\u00f6re artan, sonra fiyata g\u00f6re azalan s\u0131rada s\u0131rala:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, kategori, fiyat FROM Urunler ORDER BY kategori ASC, fiyat DESC;<\/code><\/pre>\n<h2>Veri S\u0131n\u0131rland\u0131rma: LIMIT Komutu<\/h2>\n<p><code>LIMIT<\/code> komutu, bir sorgunun d\u00f6nd\u00fcrece\u011fi sat\u0131r say\u0131s\u0131n\u0131 s\u0131n\u0131rlamak i\u00e7in kullan\u0131l\u0131r. \u00d6zellikle b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken veya sayfalama (pagination) uygulamalar\u0131nda \u00e7ok kullan\u0131\u015fl\u0131d\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar FROM tablo_ad\u0131 WHERE ko\u015ful ORDER BY sutun LIMIT say\u0131;\nSELECT sutunlar FROM tablo_ad\u0131 WHERE ko\u015ful ORDER BY sutun LIMIT ba\u015flang\u0131\u00e7_offseti, say\u0131;<\/code><\/pre>\n<p>*   <code>say\u0131<\/code>: D\u00f6nd\u00fcr\u00fclecek maksimum sat\u0131r say\u0131s\u0131.<br \/>\n*   <code>ba\u015flang\u0131\u00e7_offseti<\/code>: D\u00f6nd\u00fcr\u00fclecek ilk sat\u0131rdan \u00f6nceki atlanacak sat\u0131r say\u0131s\u0131 (0'dan ba\u015flar).<\/p>\n<p><strong>\u00d6rnekler:<\/strong><br \/>\n*   En pahal\u0131 5 \u00fcr\u00fcn\u00fc listele:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler ORDER BY fiyat DESC LIMIT 5;<\/code><\/pre>\n<p>*   En pahal\u0131 \u00fcr\u00fcnlerden 6. ile 10. aras\u0131ndaki 5 \u00fcr\u00fcn\u00fc listele (ilk 5'i atla):<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat FROM Urunler ORDER BY fiyat DESC LIMIT 5, 5; -- 5 sat\u0131r\u0131 atla, sonraki 5 sat\u0131r\u0131 getir<\/code><\/pre>\n<h2>Agregasyon Fonksiyonlar\u0131: Veri \u00d6zetleme<\/h2>\n<p>Agregasyon fonksiyonlar\u0131, bir s\u00fctundaki de\u011ferler \u00fczerinde hesaplamalar yaparak tek bir \u00f6zet de\u011fer d\u00f6nd\u00fcr\u00fcr. Genellikle <code>GROUP BY<\/code> komutu ile birlikte kullan\u0131l\u0131rlar.<\/p>\n<p><em>   <strong>COUNT():<\/strong> Belirtilen kriterlere uyan sat\u0131r say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. <code>COUNT(<\/em>)<\/code> t\u00fcm sat\u0131rlar\u0131 sayarken, <code>COUNT(sutun_ad\u0131)<\/code> <code>NULL<\/code> olmayan de\u011ferleri sayar.<br \/>\n    <strong>\u00d6rnek:<\/strong> Toplam \u00fcr\u00fcn say\u0131s\u0131n\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT COUNT(*) AS toplam_urun_sayisi FROM Urunler;<\/code><\/pre>\n<p>    <strong>\u00d6rnek:<\/strong> A\u00e7\u0131klamas\u0131 olan \u00fcr\u00fcn say\u0131s\u0131n\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT COUNT(aciklama) AS aciklamali_urun_sayisi FROM Urunler;<\/code><\/pre>\n<p>*   <strong>SUM():<\/strong> Bir say\u0131sal s\u00fctundaki t\u00fcm de\u011ferlerin toplam\u0131n\u0131 hesaplar.<br \/>\n    <strong>\u00d6rnek:<\/strong> T\u00fcm \u00fcr\u00fcnlerin toplam stok de\u011ferini bul:<\/p>\n<pre><code class=\"language-sql\">SELECT SUM(stok_adedi * fiyat) AS toplam_stok_degeri FROM Urunler;<\/code><\/pre>\n<p>*   <strong>AVG():<\/strong> Bir say\u0131sal s\u00fctundaki de\u011ferlerin ortalamas\u0131n\u0131 hesaplar.<br \/>\n    <strong>\u00d6rnek:<\/strong> Ortalama \u00fcr\u00fcn fiyat\u0131n\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT AVG(fiyat) AS ortalama_fiyat FROM Urunler;<\/code><\/pre>\n<p>*   <strong>MIN():<\/strong> Bir s\u00fctundaki en k\u00fc\u00e7\u00fck de\u011feri bulur.<br \/>\n    <strong>\u00d6rnek:<\/strong> En ucuz \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT MIN(fiyat) AS en_ucuz_fiyat FROM Urunler;<\/code><\/pre>\n<p>*   <strong>MAX():<\/strong> Bir s\u00fctundaki en b\u00fcy\u00fck de\u011feri bulur.<br \/>\n    <strong>\u00d6rnek:<\/strong> En pahal\u0131 \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT MAX(fiyat) AS en_pahali_fiyat FROM Urunler;<\/code><\/pre>\n<h2>Veri Gruplama: GROUP BY Komutu<\/h2>\n<p><code>GROUP BY<\/code> komutu, sorgu sonu\u00e7lar\u0131n\u0131 bir veya daha fazla s\u00fctuna g\u00f6re grupland\u0131r\u0131r ve genellikle agregasyon fonksiyonlar\u0131yla birlikte kullan\u0131l\u0131r. Bu sayede her grup i\u00e7in ayr\u0131 ayr\u0131 \u00f6zet bilgiler elde edilebilir.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutun1, agregasyon_fonksiyonu(sutun2) FROM tablo_ad\u0131 GROUP BY sutun1;<\/code><\/pre>\n<p><strong>\u00d6rnekler:<\/strong><br \/>\n*   Her kategoride ka\u00e7 \u00fcr\u00fcn oldu\u011funu say:<\/p>\n<pre><code class=\"language-sql\">SELECT kategori, COUNT(*) AS urun_sayisi FROM Urunler GROUP BY kategori;<\/code><\/pre>\n<p>*   Her kategorideki ortalama fiyat\u0131 bul:<\/p>\n<pre><code class=\"language-sql\">SELECT kategori, AVG(fiyat) AS ortalama_fiyat FROM Urunler GROUP BY kategori;<\/code><\/pre>\n<p>*   Her kategorideki en pahal\u0131 \u00fcr\u00fcn\u00fc bul:<\/p>\n<pre><code class=\"language-sql\">SELECT kategori, MAX(fiyat) AS en_pahali_urun_fiyati FROM Urunler GROUP BY kategori;<\/code><\/pre>\n<h2>Grup Ko\u015fullar\u0131: HAVING Komutu<\/h2>\n<p><code>HAVING<\/code> komutu, <code>GROUP BY<\/code> ile olu\u015fturulan gruplar\u0131 filtrelemek i\u00e7in kullan\u0131l\u0131r. <code>WHERE<\/code> komutu bireysel sat\u0131rlar\u0131 filtrelerken, <code>HAVING<\/code> komutu gruplar \u00fczerinde filtreleme yapar ve genellikle agregasyon fonksiyonlar\u0131n\u0131n sonu\u00e7lar\u0131na g\u00f6re ko\u015ful belirtir.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar, agregasyon_fonksiyonu(sutun)\nFROM tablo_ad\u0131\nGROUP BY sutunlar\nHAVING ko\u015ful;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n*   \u00dcr\u00fcn say\u0131s\u0131 2'den fazla olan kategorileri ve \u00fcr\u00fcn say\u0131lar\u0131n\u0131 listele:<\/p>\n<pre><code class=\"language-sql\">SELECT kategori, COUNT(*) AS urun_sayisi\n    FROM Urunler\n    GROUP BY kategori\n    HAVING urun_sayisi > 2; -- Veya HAVING COUNT(*) > 2;<\/code><\/pre>\n<p>*   Ortalama fiyat\u0131 100'den y\u00fcksek olan kategorileri ve ortalama fiyatlar\u0131n\u0131 listele:<\/p>\n<pre><code class=\"language-sql\">SELECT kategori, AVG(fiyat) AS ortalama_fiyat\n    FROM Urunler\n    GROUP BY kategori\n    HAVING ortalama_fiyat > 100;<\/code><\/pre>\n<h2>Tablolar\u0131 Birle\u015ftirme: JOIN Komutlar\u0131<\/h2>\n<p>\u0130li\u015fkisel veritabanlar\u0131n\u0131n g\u00fcc\u00fc, verilerin farkl\u0131 tablolarda tutulmas\u0131 ve bu tablolar\u0131n ili\u015fkiler arac\u0131l\u0131\u011f\u0131yla birle\u015ftirilebilmesidir. <code>JOIN<\/code> komutlar\u0131, birden fazla tablodan verileri bir araya getirmek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<h3>\u0130li\u015fkisel Veritabanlar\u0131 ve Anahtarlar<\/h3>\n<p>*   <strong>Birincil Anahtar (Primary Key - PK):<\/strong> Bir tablodaki her sat\u0131r\u0131 benzersiz \u015fekilde tan\u0131mlayan bir s\u00fctun veya s\u00fctun k\u00fcmesidir. Genellikle <code>id<\/code> olarak adland\u0131r\u0131l\u0131r ve <code>NOT NULL<\/code> ile <code>UNIQUE<\/code> \u00f6zelliklerine sahiptir.<br \/>\n*   <strong>Yabanc\u0131 Anahtar (Foreign Key - FK):<\/strong> Bir tablodaki bir s\u00fctun veya s\u00fctun k\u00fcmesidir ve ba\u015fka bir tablonun birincil anahtar\u0131na at\u0131fta bulunur. Bu, tablolar aras\u0131nda ili\u015fki kurmay\u0131 sa\u011flar.<\/p>\n<h3>INNER JOIN<\/h3>\n<p><code>INNER JOIN<\/code>, her iki tabloda da e\u015fle\u015fen kay\u0131tlara sahip sat\u0131rlar\u0131 d\u00f6nd\u00fcr\u00fcr. E\u015fle\u015fmeyen kay\u0131tlar sonu\u00e7 k\u00fcmesine dahil edilmez.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar\nFROM tablo1\nINNER JOIN tablo2 ON tablo1.ortak_sutun = tablo2.ortak_sutun;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>Siparisler<\/code> ve <code>Musteriler<\/code> tablolar\u0131n\u0131 <code>musteri_id<\/code> s\u00fctunu \u00fczerinden birle\u015ftirerek sipari\u015fleri ve ilgili m\u00fc\u015fteri adlar\u0131n\u0131 listele:<\/p>\n<pre><code class=\"language-sql\">SELECT S.siparis_id, M.musteri_adi, S.siparis_tarihi\nFROM Siparisler AS S\nINNER JOIN Musteriler AS M ON S.musteri_id = M.musteri_id;<\/code><\/pre>\n<h3>LEFT JOIN (LEFT OUTER JOIN)<\/h3>\n<p><code>LEFT JOIN<\/code>, sol tablodaki (FROM'dan sonraki ilk tablo) t\u00fcm kay\u0131tlar\u0131 ve sa\u011f tablodaki e\u015fle\u015fen kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. Sa\u011f tabloda e\u015fle\u015fme bulunamazsa, sa\u011f tablonun s\u00fctunlar\u0131 i\u00e7in <code>NULL<\/code> de\u011ferleri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar\nFROM tablo1\nLEFT JOIN tablo2 ON tablo1.ortak_sutun = tablo2.ortak_sutun;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nT\u00fcm m\u00fc\u015fterileri ve varsa sipari\u015flerini listele. Sipari\u015fi olmayan m\u00fc\u015fteriler de listede g\u00f6r\u00fcnmeli:<\/p>\n<pre><code class=\"language-sql\">SELECT M.musteri_adi, S.siparis_id\nFROM Musteriler AS M\nLEFT JOIN Siparisler AS S ON M.musteri_id = S.musteri_id;<\/code><\/pre>\n<h3>RIGHT JOIN (RIGHT OUTER JOIN)<\/h3>\n<p><code>RIGHT JOIN<\/code>, sa\u011f tablodaki (JOIN'den sonraki tablo) t\u00fcm kay\u0131tlar\u0131 ve sol tablodaki e\u015fle\u015fen kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. Sol tabloda e\u015fle\u015fme bulunamazsa, sol tablonun s\u00fctunlar\u0131 i\u00e7in <code>NULL<\/code> de\u011ferleri d\u00f6nd\u00fcr\u00fcl\u00fcr.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT sutunlar\nFROM tablo1\nRIGHT JOIN tablo2 ON tablo1.ortak_sutun = tablo2.ortak_sutun;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nT\u00fcm sipari\u015fleri ve varsa ilgili m\u00fc\u015fteri adlar\u0131n\u0131 listele. M\u00fc\u015fterisi silinmi\u015f veya hatal\u0131 sipari\u015fler de listede g\u00f6r\u00fcnmeli (e\u011fer <code>musteri_id<\/code> sol tabloda <code>NULL<\/code> ise):<\/p>\n<pre><code class=\"language-sql\">SELECT M.musteri_adi, S.siparis_id\nFROM Musteriler AS M\nRIGHT JOIN Siparisler AS S ON M.musteri_id = S.musteri_id;<\/code><\/pre>\n<h3>FULL JOIN (FULL OUTER JOIN)<\/h3>\n<p><code>FULL JOIN<\/code>, her iki tablodaki t\u00fcm kay\u0131tlar\u0131 d\u00f6nd\u00fcr\u00fcr. E\u015fle\u015fme olmayan yerlerde <code>NULL<\/code> de\u011ferleri ile doldurur. MySQL, do\u011frudan <code>FULL OUTER JOIN<\/code> anahtar kelimesini desteklemez. Bunun yerine, <code>LEFT JOIN<\/code> ve <code>RIGHT JOIN<\/code> sonu\u00e7lar\u0131n\u0131 <code>UNION<\/code> operat\u00f6r\u00fc ile birle\u015ftirerek sim\u00fcle edilebilir.<\/p>\n<p><strong>MySQL'de Sim\u00fclasyon \u00d6rne\u011fi:<\/strong><\/p>\n<pre><code class=\"language-sql\">SELECT M.musteri_adi, S.siparis_id\nFROM Musteriler AS M\nLEFT JOIN Siparisler AS S ON M.musteri_id = S.musteri_id\nUNION\nSELECT M.musteri_adi, S.siparis_id\nFROM Musteriler AS M\nRIGHT JOIN Siparisler AS S ON M.musteri_id = S.musteri_id;<\/code><\/pre>\n<h2>Veri Manip\u00fclasyonu: INSERT, UPDATE, DELETE<\/h2>\n<p><code>INSERT<\/code>, <code>UPDATE<\/code> ve <code>DELETE<\/code> komutlar\u0131, veritaban\u0131ndaki verileri de\u011fi\u015ftirmek (eklemek, g\u00fcncellemek, silmek) i\u00e7in kullan\u0131lan DML (Data Manipulation Language) komutlar\u0131d\u0131r.<\/p>\n<h3>INSERT INTO<\/h3>\n<p>Yeni bir sat\u0131r\u0131 bir tabloya eklemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">INSERT INTO tablo_ad\u0131 (sutun1, sutun2, ...) VALUES (deger1, deger2, ...);<\/code><\/pre>\n<p>T\u00fcm s\u00fctunlara de\u011fer ekliyorsan\u0131z, s\u00fctun adlar\u0131n\u0131 belirtmek zorunda de\u011filsiniz, ancak de\u011ferlerin s\u0131ras\u0131 tablodaki s\u00fctun s\u0131ras\u0131yla e\u015fle\u015fmelidir.<\/p>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nYeni bir \u00fcr\u00fcn ekle:<\/p>\n<pre><code class=\"language-sql\">INSERT INTO Urunler (urun_adi, kategori, fiyat, stok_adedi)\nVALUES ('Ak\u0131ll\u0131 Saat', 'Elektronik', 1200.00, 50);<\/code><\/pre>\n<h3>UPDATE<\/h3>\n<p>Mevcut bir tablodaki kay\u0131tlar\u0131 g\u00fcncellemek i\u00e7in kullan\u0131l\u0131r. <code>WHERE<\/code> ko\u015fulu belirtilmezse, tablodaki T\u00dcM kay\u0131tlar g\u00fcncellenir, bu y\u00fczden dikkatli olunmal\u0131d\u0131r.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">UPDATE tablo_ad\u0131 SET sutun1 = yeni_deger1, sutun2 = yeni_deger2 WHERE ko\u015ful;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>urun_id<\/code>'si 101 olan \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 ve stok adedini g\u00fcncelle:<\/p>\n<pre><code class=\"language-sql\">UPDATE Urunler\nSET fiyat = 1250.00, stok_adedi = 45\nWHERE urun_id = 101;<\/code><\/pre>\n<h3>DELETE FROM<\/h3>\n<p>Bir tablodan mevcut kay\u0131tlar\u0131 silmek i\u00e7in kullan\u0131l\u0131r. <code>WHERE<\/code> ko\u015fulu belirtilmezse, tablodaki T\u00dcM kay\u0131tlar silinir.<\/p>\n<p><strong>S\u00f6zdizimi:<\/strong><\/p>\n<pre><code class=\"language-sql\">DELETE FROM tablo_ad\u0131 WHERE ko\u015ful;<\/code><\/pre>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>urun_id<\/code>'si 105 olan \u00fcr\u00fcn\u00fc sil:<\/p>\n<pre><code class=\"language-sql\">DELETE FROM Urunler WHERE urun_id = 105;<\/code><\/pre>\n<p>T\u00fcm sat\u0131rlar\u0131 silmek i\u00e7in <code>DELETE FROM tablo_ad\u0131;<\/code> komutunu kullanabilirsiniz. Ancak, <code>TRUNCATE TABLE tablo_ad\u0131;<\/code> komutu daha h\u0131zl\u0131d\u0131r ve otomatik artan ID'leri s\u0131f\u0131rlar. <code>DELETE<\/code> i\u015flemi her sat\u0131r i\u00e7in bir kay\u0131t tutarken, <code>TRUNCATE<\/code> tabloyu tamamen yeniden olu\u015fturur.<\/p>\n<h2>Geli\u015fmi\u015f Sorgulama Kavramlar\u0131 (K\u0131saca)<\/h2>\n<p>Veritaban\u0131 sorgulama d\u00fcnyas\u0131 olduk\u00e7a geni\u015ftir. Temel komutlar\u0131n \u00f6tesinde, daha karma\u015f\u0131k senaryolar\u0131 y\u00f6netmek i\u00e7in kullan\u0131labilecek baz\u0131 geli\u015fmi\u015f kavramlar \u015funlard\u0131r:<\/p>\n<h3>Alt Sorgular (Subqueries)<\/h3>\n<p>Bir alt sorgu (veya i\u00e7 sorgu), ba\u015fka bir SQL sorgusu i\u00e7inde yer alan bir sorgudur. Bir sorgunun \u00e7\u0131kt\u0131s\u0131, di\u011fer sorgunun <code>WHERE<\/code>, <code>FROM<\/code> veya <code>SELECT<\/code> c\u00fcmleci\u011finde girdi olarak kullan\u0131labilir.<\/p>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nOrtalama fiyattan daha pahal\u0131 olan \u00fcr\u00fcnleri bul:<\/p>\n<pre><code class=\"language-sql\">SELECT urun_adi, fiyat\nFROM Urunler\nWHERE fiyat > (SELECT AVG(fiyat) FROM Urunler);<\/code><\/pre>\n<h3>VIEW'ler<\/h3>\n<p>Bir <code>VIEW<\/code>, bir veya daha fazla tablodan veri \u00e7ekmek i\u00e7in kullan\u0131lan bir sanal tablodur. <code>VIEW<\/code>'ler, karma\u015f\u0131k sorgular\u0131 basitle\u015ftirmek, g\u00fcvenlik sa\u011flamak (kullan\u0131c\u0131lara sadece belirli s\u00fctunlar\u0131 veya sat\u0131rlar\u0131 g\u00f6stermek) ve veritaban\u0131 \u015femas\u0131n\u0131 gizlemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p><strong>\u00d6rnek:<\/strong><br \/>\nSadece \u00fcr\u00fcn ad\u0131 ve fiyat\u0131n\u0131 i\u00e7eren bir g\u00f6r\u00fcn\u00fcm olu\u015ftur:<\/p>\n<pre><code class=\"language-sql\">CREATE VIEW UrunFiyatlari AS\nSELECT urun_adi, fiyat FROM Urunler WHERE stok_adedi > 0;<\/code><\/pre>\n<p>Daha sonra bu g\u00f6r\u00fcn\u00fcm\u00fc normal bir tablo gibi sorgulayabilirsiniz:<\/p>\n<pre><code class=\"language-sql\">SELECT * FROM UrunFiyatlari WHERE fiyat < 50;<\/code><\/pre>\n<h3>INDEX'ler<\/h3>\n<p><code>INDEX<\/code>'ler, bir veritaban\u0131 tablosundaki verilerin al\u0131nmas\u0131n\u0131 h\u0131zland\u0131rmak i\u00e7in kullan\u0131lan \u00f6zel arama tablolar\u0131d\u0131r. T\u0131pk\u0131 bir kitab\u0131n dizini gibi, belirli bir s\u00fctundaki de\u011ferleri h\u0131zl\u0131ca bulmay\u0131 sa\u011flarlar. Ancak, <code>INSERT<\/code>, <code>UPDATE<\/code> ve <code>DELETE<\/code> i\u015flemlerinde ek y\u00fck olu\u015fturduklar\u0131 i\u00e7in dikkatli kullan\u0131lmal\u0131d\u0131rlar.<\/p>\n<p><strong>\u00d6rnek:<\/strong><br \/>\n<code>Urunler<\/code> tablosunun <code>urun_adi<\/code> s\u00fctununa bir indeks ekle:<\/p>\n<pre><code class=\"language-sql\">CREATE INDEX idx_urun_adi ON Urunler (urun_adi);<\/code><\/pre>\n<h2>En \u0130yi Uygulamalar ve Performans \u0130pu\u00e7lar\u0131<\/h2>\n<p>Etkili ve performansl\u0131 MySQL sorgular\u0131 yazmak i\u00e7in baz\u0131 en iyi uygulamalar:<\/p>\n<p><em>   <strong><code>SELECT <\/em><\/code> Kullanmaktan Ka\u00e7\u0131n\u0131n:<\/strong> Yaln\u0131zca ihtiyac\u0131n\u0131z olan s\u00fctunlar\u0131 se\u00e7in. Bu, a\u011f trafi\u011fini azalt\u0131r, bellek kullan\u0131m\u0131n\u0131 d\u00fc\u015f\u00fcr\u00fcr ve performans\u0131 art\u0131r\u0131r.<br \/>\n*   <strong><code>WHERE<\/code> ve <code>JOIN<\/code> Ko\u015fullar\u0131nda \u0130ndeksleri Kullan\u0131n:<\/strong> S\u0131k\u00e7a filtreleme veya birle\u015ftirme yapt\u0131\u011f\u0131n\u0131z s\u00fctunlara indeks eklemek sorgu h\u0131z\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r. Ancak \u00e7ok fazla indeks de yazma i\u015flemlerini yava\u015flatabilir.<br \/>\n*   <strong>Sorgular\u0131 Optimize Edin (<code>EXPLAIN<\/code>):<\/strong> MySQL'in <code>EXPLAIN<\/code> komutu, bir sorgunun nas\u0131l y\u00fcr\u00fct\u00fclece\u011fini (hangi indeksleri kullanaca\u011f\u0131n\u0131, tablolar\u0131 hangi s\u0131rayla tarayaca\u011f\u0131n\u0131 vb.) g\u00f6sterir. Bu, performans darbo\u011fazlar\u0131n\u0131 belirlemenize yard\u0131mc\u0131 olur.<\/p>\n<pre><code class=\"language-sql\">EXPLAIN SELECT urun_adi, fiyat FROM Urunler WHERE fiyat > 100;<\/code><\/pre>\n<p>*   <strong>Karma\u015f\u0131k <code>JOIN<\/code>'lerden Ka\u00e7\u0131n\u0131n (M\u00fcmk\u00fcnse):<\/strong> \u00c7ok say\u0131da tabloyu birle\u015ftiren sorgular karma\u015f\u0131k hale gelebilir ve performans\u0131 d\u00fc\u015f\u00fcrebilir. Gerekirse alt sorgular veya <code>VIEW<\/code>'ler kullanmay\u0131 d\u00fc\u015f\u00fcn\u00fcn.<br \/>\n*   <strong>SQL Injection'a Kar\u015f\u0131 Savunma:<\/strong> Kullan\u0131c\u0131 girdilerini do\u011frudan SQL sorgular\u0131na eklemek yerine, parametreli sorgular veya haz\u0131r ifadeler (prepared statements) kullan\u0131n. Bu, k\u00f6t\u00fc niyetli kullan\u0131c\u0131lar\u0131n veritaban\u0131n\u0131za zarar vermesini engeller.<br \/>\n*   <strong>Veritaban\u0131 \u015eemas\u0131n\u0131 \u0130yi Tasarlay\u0131n:<\/strong> \u0130yi normalle\u015ftirilmi\u015f (veya kontroll\u00fc denormalize edilmi\u015f) bir veritaban\u0131 \u015femas\u0131, daha basit ve daha h\u0131zl\u0131 sorgular yazman\u0131za olanak tan\u0131r.<br \/>\n*   <strong>K\u00fc\u00e7\u00fck Veri K\u00fcmeleriyle Test Edin:<\/strong> Sorgular\u0131 geli\u015ftirirken ve test ederken, b\u00fcy\u00fck veri k\u00fcmeleri yerine daha k\u00fc\u00e7\u00fck, temsili veri k\u00fcmeleri kullan\u0131n.<\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>Bu makale, MySQL sorgular\u0131n\u0131n temelini olu\u015fturan <code>SELECT<\/code>, <code>WHERE<\/code>, <code>ORDER BY<\/code>, <code>LIMIT<\/code>, agregasyon fonksiyonlar\u0131, <code>GROUP BY<\/code>, <code>HAVING<\/code>, <code>JOIN<\/code> t\u00fcrleri ve temel DML komutlar\u0131 (<code>INSERT<\/code>, <code>UPDATE<\/code>, <code>DELETE<\/code>) gibi kritik konular\u0131 kapsaml\u0131 bir \u015fekilde ele alm\u0131\u015ft\u0131r. Veritaban\u0131 ile etkile\u015fim kurman\u0131n ve ondan anlaml\u0131 bilgiler \u00e7\u0131karman\u0131n anahtar\u0131 olan bu komutlar, modern veri y\u00f6netiminin vazge\u00e7ilmez bir par\u00e7as\u0131d\u0131r.<\/p>\n<p>MySQL sorgulama yetene\u011fi, bir veritaban\u0131 y\u00f6neticisi, yaz\u0131l\u0131m geli\u015ftiricisi veya veri analisti i\u00e7in temel bir beceridir. Veritabanlar\u0131ndan veri \u00e7ekme, manip\u00fcle etme ve \u00f6zetleme becerisi, uygulamalar geli\u015ftirmekten i\u015f kararlar\u0131 almaya kadar geni\u015f bir yelpazede kritik \u00f6neme sahiptir.<\/p>\n<p>SQL \u00f6\u011frenmek, sadece s\u00f6zdizimini ezberlemekten ibaret de\u011fildir; ayn\u0131 zamanda veritabanlar\u0131n\u0131n nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131, verilerin nas\u0131l ili\u015fkili oldu\u011funu ve en verimli sorgular\u0131 nas\u0131l yazaca\u011f\u0131n\u0131z\u0131 anlamay\u0131 gerektirir. Bu makalede sunulan bilgiler, MySQL ile sorgulama yolculu\u011funuza ba\u015flaman\u0131z i\u00e7in sa\u011flam bir temel sa\u011flam\u0131\u015ft\u0131r. Unutmay\u0131n ki pratik yapmak ve ger\u00e7ek d\u00fcnya senaryolar\u0131nda bu komutlar\u0131 uygulamak, bilginizi peki\u015ftirmenin en iyi yoludur. Sorgular\u0131n\u0131z\u0131 yazmaya devam edin, yeni komutlar\u0131 ke\u015ffedin ve veritaban\u0131 d\u00fcnyas\u0131nda ustala\u015f\u0131n.<\/p>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri\nGiri\u015f\nG\u00fcn\u00fcm\u00fcz\u00fcn dijital d\u00fcnyas\u0131nda, veri her \u015feyin merkezinde yer almaktad","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":[138],"tags":[],"class_list":{"0":"post-37470","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri - 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\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri\" \/>\n<meta property=\"og:description\" content=\"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri Giri\u015f G\u00fcn\u00fcm\u00fcz\u00fcn dijital d\u00fcnyas\u0131nda, veri her \u015feyin merkezinde yer almaktad\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-06T02:40:49+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=\"13 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri\",\"datePublished\":\"2026-01-06T02:40:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\"},\"wordCount\":2941,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"MySQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\",\"name\":\"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-06T02:40:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri\"}]},{\"@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":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri - 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\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/","og_locale":"tr_TR","og_type":"article","og_title":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri","og_description":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri Giri\u015f G\u00fcn\u00fcm\u00fcz\u00fcn dijital d\u00fcnyas\u0131nda, veri her \u015feyin merkezinde yer almaktad","og_url":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-06T02:40:49+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"13 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri","datePublished":"2026-01-06T02:40:49+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/"},"wordCount":2941,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["MySQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/","url":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/","name":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-06T02:40:49+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-sorgularina-giris-veritabani-ile-konusmanin-temelleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Sorgular\u0131na Giri\u015f: Veritaban\u0131 ile Konu\u015fman\u0131n Temelleri"}]},{"@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\/37470","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=37470"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37470\/revisions"}],"predecessor-version":[{"id":37471,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37470\/revisions\/37471"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=37470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=37470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=37470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}