{"id":37865,"date":"2026-01-17T13:00:45","date_gmt":"2026-01-17T10:00:45","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/"},"modified":"2026-01-17T13:00:45","modified_gmt":"2026-01-17T10:00:45","slug":"her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/","title":{"rendered":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131"},"content":{"rendered":"<h2>Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131<\/h2>\n<p>\n    Veri, modern yaz\u0131l\u0131m\u0131n kalbinde yer al\u0131r ve bu verilerle etkili bir \u015fekilde ileti\u015fim kurmak SQL (Structured Query Language) ile m\u00fcmk\u00fcnd\u00fcr. \u0130ster web, ister mobil uygulama geli\u015ftiriyor olun, g\u00fc\u00e7l\u00fc SQL bilgisi sizi her zaman bir ad\u0131m \u00f6ne ta\u015f\u0131yacakt\u0131r. Bu makalede, her geli\u015ftiricinin bilmesi gereken en temel ve s\u0131k kullan\u0131lan SQL sorgular\u0131n\u0131, pratik \u00f6rneklerle ele alarak sa\u011flam bir temel olu\u015fturmay\u0131 hedefliyoruz.\n<\/p>\n<h2>1. Veri Se\u00e7imi ve Temel Sorgular<\/h2>\n<p>\n    Veritaban\u0131ndan bilgi \u00e7ekmek, SQL&#8217;in en temel i\u015flevidir. <code>SELECT<\/code> ifadesi, hangi s\u00fctunlar\u0131 g\u00f6rmek istedi\u011finizi belirtirken, <code>FROM<\/code> ifadesi ise verilerin hangi tablodan gelece\u011fini g\u00f6sterir.\n<\/p>\n<h3>SELECT ve FROM Kullan\u0131m\u0131<\/h3>\n<p>\n    Belirli s\u00fctunlar\u0131 se\u00e7mek i\u00e7in s\u00fctun adlar\u0131n\u0131 virg\u00fclle ay\u0131rarak belirtirsiniz. T\u00fcm s\u00fctunlar\u0131 se\u00e7mek i\u00e7in ise y\u0131ld\u0131z (<code>*<\/code>) operat\u00f6r\u00fcn\u00fc kullanabilirsiniz. Performans i\u00e7in genellikle sadece ihtiyac\u0131n\u0131z olan s\u00fctunlar\u0131 se\u00e7mek daha iyi bir pratiktir.\n<\/p>\n<pre><code class=\"language-sql\"><br \/>\nSELECT urun_adi, fiyat FROM Urunler; -- Belirli s\u00fctunlar<br \/>\nSELECT * FROM Musteriler;           -- T\u00fcm s\u00fctun<\/p>\n","protected":false},"excerpt":{"rendered":"Veri, modern yaz\u0131l\u0131m\u0131n kalbinde yer al\u0131r ve bu verilerle etkili bir \u015fekilde ileti\u015fim kurmak SQL (Structured Query Language) ile m\u00fcmk\u00fcnd\u00fcr. \u0130ster we&#8230;","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-37865","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-sql-2","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>Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131 - 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\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131\" \/>\n<meta property=\"og:description\" content=\"Veri, modern yaz\u0131l\u0131m\u0131n kalbinde yer al\u0131r ve bu verilerle etkili bir \u015fekilde ileti\u015fim kurmak SQL (Structured Query Language) ile m\u00fcmk\u00fcnd\u00fcr. \u0130ster we...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-17T10:00:45+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=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131\",\"datePublished\":\"2026-01-17T10:00:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\"},\"wordCount\":199,\"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\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#respond\"]}],\"copyrightYear\":\"2026\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\",\"name\":\"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2026-01-17T10:00:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131\"}]},{\"@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":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131 - 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\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/","og_locale":"tr_TR","og_type":"article","og_title":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131","og_description":"Veri, modern yaz\u0131l\u0131m\u0131n kalbinde yer al\u0131r ve bu verilerle etkili bir \u015fekilde ileti\u015fim kurmak SQL (Structured Query Language) ile m\u00fcmk\u00fcnd\u00fcr. \u0130ster we...","og_url":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2026-01-17T10:00:45+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131","datePublished":"2026-01-17T10:00:45+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/"},"wordCount":199,"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\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#respond"]}],"copyrightYear":"2026","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/","url":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/","name":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131 - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2026-01-17T10:00:45+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/her-gelistiricinin-bilmesi-gereken-temel-sql-sorgulari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Her Geli\u015ftiricinin Bilmesi Gereken Temel SQL Sorgular\u0131"}]},{"@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\/37865","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=37865"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/37865\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=37865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=37865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=37865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}