{"id":14022,"date":"2025-05-07T11:20:04","date_gmt":"2025-05-07T08:20:04","guid":{"rendered":"https:\/\/www.inetmar.com\/blog\/?p=14022"},"modified":"2025-05-07T11:21:21","modified_gmt":"2025-05-07T08:21:21","slug":"sql-sorgu-nedir-populer-sql-sorgulari","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/sql-sorgu-nedir-populer-sql-sorgulari\/","title":{"rendered":"SQL Sorgu Nedir? Pop\u00fcler SQL Sorgular\u0131"},"content":{"rendered":"<p>Veritaban\u0131 y\u00f6netimi modern yaz\u0131l\u0131m ve web projelerinin temel ta\u015flar\u0131ndan biridir. SQL (Structured Query Language) ise bu sistemlerin vazge\u00e7ilmez bir par\u00e7as\u0131d\u0131r. SQL sorgular\u0131 sayesinde veritaban\u0131ndan bilgi \u00e7ekebilir, veri ekleyebilir, g\u00fcncelleyebilir ya da silebilirsiniz. Bu yaz\u0131da SQL sorgu kavram\u0131n\u0131 a\u00e7\u0131kl\u0131yor ve pop\u00fcler SQL sorgu \u00f6rnekleri ile konuyu somutla\u015ft\u0131r\u0131yoruz.<\/p>\n<h2>SQL Sorgu Nedir?<\/h2>\n<p>SQL sorgusu veritaban\u0131na belirli bir i\u015flemi yapmas\u0131n\u0131 s\u00f6yleyen komuttur. \u00d6rne\u011fin bir kullan\u0131c\u0131 listesi g\u00f6rmek, bir \u00fcr\u00fcn\u00fcn fiyat\u0131n\u0131 g\u00fcncellemek ya da kay\u0131t silmek gibi i\u015flemler SQL sorgular\u0131 ile ger\u00e7ekle\u015ftirilir.<\/p>\n<p>En temel SQL komutlar\u0131 \u015funlard\u0131r:<\/p>\n<ul>\n<li><code>SELECT<\/code> \u2013 Veri sorgulamak i\u00e7in<\/li>\n<li><code>INSERT<\/code> \u2013 Veri eklemek i\u00e7in<\/li>\n<li><code>UPDATE<\/code> \u2013 Veri g\u00fcncellemek i\u00e7in<\/li>\n<li><code>DELETE<\/code> \u2013 Veri silmek i\u00e7in<\/li>\n<li><code>WHERE<\/code>, <code>ORDER BY<\/code>, <code>GROUP BY<\/code> gibi yard\u0131mc\u0131 ifadeler \u2013 Sorguyu daraltmak ya da d\u00fczenlemek i\u00e7in<\/li>\n<\/ul>\n<h2>Pop\u00fcler SQL Sorgular\u0131<\/h2>\n<h3>1. T\u00fcm Verileri Listeleme<\/h3>\n<pre><code>SELECT * FROM kullanicilar;<\/code><\/pre>\n<h3>2. Belirli \u015eartlara G\u00f6re Veri Sorgulama<\/h3>\n<pre><code>SELECT ad, soyad FROM kullanicilar WHERE yas &gt; 25;<\/code><\/pre>\n<h3>3. Yeni Veri Ekleme<\/h3>\n<pre><code>INSERT INTO urunler (ad, fiyat) VALUES ('Kahve Makinesi', 750);<\/code><\/pre>\n<h3>4. Veri G\u00fcncelleme<\/h3>\n<pre><code>UPDATE urunler SET fiyat = 800 WHERE ad = 'Kahve Makinesi';<\/code><\/pre>\n<h3>5. Veri Silme<\/h3>\n<pre><code>DELETE FROM kullanicilar WHERE id = 10;<\/code><\/pre>\n<h3>6. Verileri S\u0131ralama<\/h3>\n<pre><code>SELECT * FROM urunler ORDER BY fiyat DESC;<\/code><\/pre>\n<h3>7. Verileri Gruplama ve Sayma<\/h3>\n<pre><code>SELECT sehir, COUNT(*) FROM kullanicilar GROUP BY sehir;<\/code><\/pre>\n<h2>SQL Sorgular\u0131 Neden \u00d6nemlidir?<\/h2>\n<p>SQL sorgular\u0131, veritaban\u0131 ile etkili bir \u015fekilde ileti\u015fim kurman\u0131z\u0131 sa\u011flar. \u00d6zellikle b\u00fcy\u00fck projelerde, do\u011fru yaz\u0131lm\u0131\u015f sorgular performans\u0131 art\u0131r\u0131r, hatalar\u0131 azalt\u0131r ve veriye h\u0131zl\u0131 eri\u015fim sa\u011flar.<\/p>\n<p>SQL \u00f6\u011frenmek, sadece yaz\u0131l\u0131mc\u0131lar i\u00e7in de\u011fil; veri analistleri, sistem y\u00f6neticileri ve hatta pazarlama uzmanlar\u0131 i\u00e7in bile \u00f6nemlidir. Bu yaz\u0131da temel kavramlar\u0131 ve pop\u00fcler SQL sorgu \u00f6rneklerini payla\u015ft\u0131k. SQL\u2019e yeni ba\u015fl\u0131yorsan\u0131z bu \u00f6rnekler \u00fczerinden pratik yaparak \u00f6\u011frenmenizi peki\u015ftirebilirsiniz.<\/p>\n<p style=\"text-align: center;\">Sizde <a href=\"https:\/\/www.inetmar.com\/sunucu\/vds-sunucu\/\" target=\"_blank\" rel=\"noopener\">VDS sat\u0131n al<\/a> diyerek kendi SQL serverinizi olu\u015fturmaya ba\u015flay\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veritaban\u0131 y\u00f6netimi modern yaz\u0131l\u0131m ve web projelerinin temel ta\u015flar\u0131ndan biridir. SQL (Structured Query Language) ise bu sistemlerin vazge\u00e7ilmez bir par\u00e7as\u0131d\u0131r. SQL sorgular\u0131 sayesinde veritaban\u0131ndan bilgi \u00e7ekebilir, veri ekleyebilir, g\u00fcncelleyebilir ya da silebilirsiniz. Bu yaz\u0131da SQL&#46;&#46;&#46;<\/p>\n","protected":false},"author":2,"featured_media":14027,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-14022","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/14022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=14022"}],"version-history":[{"count":5,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/14022\/revisions"}],"predecessor-version":[{"id":14028,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/14022\/revisions\/14028"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media\/14027"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=14022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=14022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=14022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}