{"id":477,"date":"2026-02-23T17:19:09","date_gmt":"2026-02-23T14:19:09","guid":{"rendered":"https:\/\/www.verigom.com\/bilgi-bankasi\/?p=477"},"modified":"2026-02-23T17:19:09","modified_gmt":"2026-02-23T14:19:09","slug":"sql-komutlari-nelerdir","status":"publish","type":"post","link":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/","title":{"rendered":"SQL Komutlar\u0131 Nelerdir?"},"content":{"rendered":"<p data-start=\"237\" data-end=\"612\">Veritabanlar\u0131, modern web sitelerinin ve uygulamalar\u0131n temel yap\u0131 ta\u015flar\u0131ndan biridir. Web projelerinden e-ticaret sitelerine, kurumsal yaz\u0131l\u0131mlardan i\u00e7erik y\u00f6netim sistemlerine kadar pek \u00e7ok sistem, verileri d\u00fczenli ve g\u00fcvenli bir \u015fekilde saklamak i\u00e7in SQL tabanl\u0131 veritabanlar\u0131n\u0131 kullan\u0131r. Bu noktada SQL komutlar\u0131, veriler \u00fczerinde i\u015flem yapmay\u0131 sa\u011flayan en temel ara\u00e7t\u0131r.<\/p>\n<p data-start=\"614\" data-end=\"944\">SQL (Structured Query Language), veritaban\u0131 olu\u015fturmak, veri eklemek, silmek, g\u00fcncellemek ve sorgulamak i\u00e7in kullan\u0131lan standart bir sorgu dilidir. \u00d6zellikle hosting hizmeti kullanan kullan\u0131c\u0131lar i\u00e7in; veritaban\u0131 y\u00f6netimi, yedekleme i\u015flemleri ve performans optimizasyonu gibi konularda SQL komutlar\u0131n\u0131 bilmek b\u00fcy\u00fck avantaj sa\u011flar.<\/p>\n<p data-start=\"946\" data-end=\"1095\">Bu i\u00e7erikte, en s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131, hangi ama\u00e7la kullan\u0131ld\u0131klar\u0131n\u0131 ve temel \u00f6rneklerle nas\u0131l \u00e7al\u0131\u015ft\u0131klar\u0131n\u0131 detayl\u0131 \u015fekilde ele alaca\u011f\u0131z.<\/p>\n<h2 data-start=\"0\" data-end=\"34\">En S\u0131k Kullan\u0131lan SQL Komutlar\u0131<\/h2>\n<p data-start=\"36\" data-end=\"373\">SQL komutlar\u0131 aras\u0131nda baz\u0131lar\u0131, veritaban\u0131 i\u015flemlerinde \u00e7ok daha s\u0131k kullan\u0131l\u0131r. \u00d6zellikle web siteleri, e-ticaret altyap\u0131lar\u0131 ve i\u00e7erik y\u00f6netim sistemlerinde en temel veri i\u015flemleri bu komutlarla ger\u00e7ekle\u015ftirilir. A\u015fa\u011f\u0131da en yayg\u0131n kullan\u0131lan SQL komutlar\u0131n\u0131, ne i\u015fe yarad\u0131klar\u0131 ve temel kullan\u0131m mant\u0131klar\u0131yla birlikte bulabilirsiniz.<\/p>\n<table>\n<thead>\n<tr>\n<th>Komut<\/th>\n<th>Komut T\u00fcr\u00fc<\/th>\n<th>Ne \u0130\u015fe Yarar?<\/th>\n<th>\u00d6rnek Kullan\u0131m<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>SELECT<\/strong><\/td>\n<td>DML<\/td>\n<td>Veritaban\u0131ndaki verileri sorgular.<\/td>\n<td><code>SELECT * FROM kullanicilar;<\/code><\/td>\n<\/tr>\n<tr>\n<td><strong>INSERT<\/strong><\/td>\n<td>DML<\/td>\n<td>Tabloya yeni veri ekler.<\/td>\n<td><code>INSERT INTO kullanicilar (ad, email) VALUES ('Ahmet', 'ahmet@mail.com');<\/code><\/td>\n<\/tr>\n<tr>\n<td><strong>UPDATE<\/strong><\/td>\n<td>DML<\/td>\n<td>Mevcut veriyi g\u00fcnceller.<\/td>\n<td><code>UPDATE kullanicilar SET email='yeni@mail.com' WHERE id=1;<\/code><\/td>\n<\/tr>\n<tr>\n<td><strong>DELETE<\/strong><\/td>\n<td>DML<\/td>\n<td>Belirtilen kayd\u0131 siler.<\/td>\n<td><code>DELETE FROM kullanicilar WHERE id=1;<\/code><\/td>\n<\/tr>\n<tr>\n<td><strong>CREATE<\/strong><\/td>\n<td>DDL<\/td>\n<td>Yeni tablo veya veritaban\u0131 olu\u015fturur.<\/td>\n<td><code>CREATE TABLE kullanicilar (id INT, ad VARCHAR(50));<\/code><\/td>\n<\/tr>\n<tr>\n<td><strong>DROP<\/strong><\/td>\n<td>DDL<\/td>\n<td>Tablo veya veritaban\u0131n\u0131 siler.<\/td>\n<td><code>DROP TABLE kullanicilar;<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>SQL komutlar\u0131, veritaban\u0131 y\u00f6netiminin temelini olu\u015fturur ve web projelerinin sa\u011fl\u0131kl\u0131 \u00e7al\u0131\u015fmas\u0131nda kritik rol oynar. SELECT ile veri sorgulamak, INSERT ile kay\u0131t eklemek, UPDATE ve DELETE ile verileri d\u00fczenlemek ya da CREATE ve DROP komutlar\u0131yla veritaban\u0131 yap\u0131s\u0131n\u0131 y\u00f6netmek; t\u00fcm bu i\u015flemler modern hosting altyap\u0131lar\u0131nda s\u0131k\u00e7a kullan\u0131l\u0131r. Temel SQL komutlar\u0131n\u0131 bilmek, hem teknik s\u00fcre\u00e7leri daha iyi anlaman\u0131z\u0131 sa\u011flar hem de olas\u0131 hatalara kar\u015f\u0131 daha bilin\u00e7li hareket etmenize yard\u0131mc\u0131 olur. \u00d6zellikle kontrol paneli ve phpMyAdmin gibi ara\u00e7lar\u0131 kullan\u0131rken SQL mant\u0131\u011f\u0131n\u0131 kavramak, veritaban\u0131 i\u015flemlerini daha g\u00fcvenli ve verimli \u015fekilde y\u00f6netmenizi sa\u011flar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Veritabanlar\u0131, modern web sitelerinin ve uygulamalar\u0131n temel yap\u0131 ta\u015flar\u0131ndan biridir. Web projelerinden e-ticaret sitelerine, kurumsal yaz\u0131l\u0131mlardan i\u00e7erik y\u00f6netim sistemlerine kadar pek \u00e7ok sistem, verileri d\u00fczenli ve g\u00fcvenli bir \u015fekilde saklamak i\u00e7in SQL tabanl\u0131 veritabanlar\u0131n\u0131 kullan\u0131r. Bu noktada SQL komutlar\u0131, veriler \u00fczerinde i\u015flem yapmay\u0131 sa\u011flayan en temel ara\u00e7t\u0131r. SQL (Structured Query Language), veritaban\u0131 olu\u015fturmak, veri eklemek, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-477","post","type-post","status-publish","format-standard","hentry","category-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131<\/title>\n<meta name=\"description\" content=\"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131\" \/>\n<meta property=\"og:description\" content=\"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/\" \/>\n<meta property=\"og:site_name\" content=\"Verigom Bilgi Bankas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-23T14:19:09+00:00\" \/>\n<meta name=\"author\" content=\"admin-vg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin-vg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/\"},\"author\":{\"name\":\"admin-vg\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/#\\\/schema\\\/person\\\/609c8b2f83e8f971fa693296b8845844\"},\"headline\":\"SQL Komutlar\u0131 Nelerdir?\",\"datePublished\":\"2026-02-23T14:19:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/\"},\"wordCount\":389,\"commentCount\":0,\"articleSection\":[\"SQL\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/\",\"url\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/\",\"name\":\"SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/#website\"},\"datePublished\":\"2026-02-23T14:19:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/#\\\/schema\\\/person\\\/609c8b2f83e8f971fa693296b8845844\"},\"description\":\"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/sql-komutlari-nelerdir\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Komutlar\u0131 Nelerdir?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/#website\",\"url\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/\",\"name\":\"Verigom Bilgi Bankas\u0131\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\\\/#\\\/schema\\\/person\\\/609c8b2f83e8f971fa693296b8845844\",\"name\":\"admin-vg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g\",\"caption\":\"admin-vg\"},\"sameAs\":[\"https:\\\/\\\/www.verigom.com\\\/bilgi-bankasi\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131","description":"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.","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:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/","og_locale":"tr_TR","og_type":"article","og_title":"SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131","og_description":"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.","og_url":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/","og_site_name":"Verigom Bilgi Bankas\u0131","article_published_time":"2026-02-23T14:19:09+00:00","author":"admin-vg","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"admin-vg","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/#article","isPartOf":{"@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/"},"author":{"name":"admin-vg","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/#\/schema\/person\/609c8b2f83e8f971fa693296b8845844"},"headline":"SQL Komutlar\u0131 Nelerdir?","datePublished":"2026-02-23T14:19:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/"},"wordCount":389,"commentCount":0,"articleSection":["SQL"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/","url":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/","name":"SQL Komutlar\u0131 Nelerdir? - Verigom Bilgi Bankas\u0131","isPartOf":{"@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/#website"},"datePublished":"2026-02-23T14:19:09+00:00","author":{"@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/#\/schema\/person\/609c8b2f83e8f971fa693296b8845844"},"description":"En s\u0131k kullan\u0131lan SQL komutlar\u0131n\u0131 \u00f6\u011frenin. SELECT, INSERT, UPDATE, DELETE ve CREATE komutlar\u0131n\u0131n ne i\u015fe yarad\u0131\u011f\u0131n\u0131 \u00f6rneklerle ke\u015ffedin.","breadcrumb":{"@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/sql-komutlari-nelerdir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/www.verigom.com\/bilgi-bankasi\/"},{"@type":"ListItem","position":2,"name":"SQL Komutlar\u0131 Nelerdir?"}]},{"@type":"WebSite","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/#website","url":"https:\/\/www.verigom.com\/bilgi-bankasi\/","name":"Verigom Bilgi Bankas\u0131","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.verigom.com\/bilgi-bankasi\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.verigom.com\/bilgi-bankasi\/#\/schema\/person\/609c8b2f83e8f971fa693296b8845844","name":"admin-vg","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fc1b2309d5f66950b578d8c70a5da68092974dc4598685a4931b617a889cb451?s=96&d=mm&r=g","caption":"admin-vg"},"sameAs":["https:\/\/www.verigom.com\/bilgi-bankasi"]}]}},"_links":{"self":[{"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/comments?post=477"}],"version-history":[{"count":3,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/477\/revisions"}],"predecessor-version":[{"id":480,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/posts\/477\/revisions\/480"}],"wp:attachment":[{"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/media?parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/categories?post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.verigom.com\/bilgi-bankasi\/wp-json\/wp\/v2\/tags?post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}