{"id":12220,"date":"2025-02-12T05:00:14","date_gmt":"2025-02-12T02:00:14","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/"},"modified":"2025-02-12T05:00:14","modified_gmt":"2025-02-12T02:00:14","slug":"veritabani-tasarimi-anahtarlar-ve-sql-turleri","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/","title":{"rendered":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri"},"content":{"rendered":"<p>Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri<\/p>\n<p>Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz.  Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir.  \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.<\/p>\n<h2>Birle\u015fik Anahtarlar: Veritaban\u0131n\u0131n Temeli<\/h2>\n<p>Veritabanlar\u0131nda verilerin d\u00fczenli ve tutarl\u0131 bir \u015fekilde saklanmas\u0131 i\u00e7in birle\u015fik anahtarlar kullan\u0131l\u0131r.  \u0130ki ana tip birle\u015fik anahtar vard\u0131r: birincil anahtar (primary key) ve yabanc\u0131 anahtar (foreign key).<\/p>\n<h3>Birincil Anahtar (Primary Key)<\/h3>\n<p>Birincil anahtar, bir tabloda her sat\u0131r\u0131 benzersiz bir \u015fekilde tan\u0131mlayan bir s\u00fctundur veya s\u00fctun k\u00fcmesidir.  Ba\u015fka hi\u00e7bir sat\u0131rda ayn\u0131 birincil anahtar de\u011feri bulunamaz.  Bu, veritaban\u0131n\u0131n b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc koruman\u0131n en \u00f6nemli yoludur.  \u00d6rne\u011fin, bir m\u00fc\u015fteri tablosunda, her m\u00fc\u015fteri i\u00e7in benzersiz bir m\u00fc\u015fteri kimli\u011fi (CustomerID) birincil anahtar olarak kullan\u0131labilir.  Birincil anahtar genellikle say\u0131sal bir de\u011ferdir, ancak metinsel veriler de kullan\u0131labilir.<\/p>\n<h3>Yabanc\u0131 Anahtar (Foreign Key)<\/h3>\n<p>Yabanc\u0131 anahtar ise, bir tabloda bulunan ve ba\u015fka bir tablodaki birincil anahtara referans eden s\u00fctundur.  Bu, iki tablo aras\u0131nda ili\u015fki kurulmas\u0131n\u0131 sa\u011flar.  \u00d6rne\u011fin, sipari\u015fler tablosunda, her sipari\u015fin hangi m\u00fc\u015fteriye ait oldu\u011funu g\u00f6stermek i\u00e7in m\u00fc\u015fteri tablosundaki CustomerID s\u00fctunu yabanc\u0131 anahtar olarak kullan\u0131labilir.  Bu sayede, sipari\u015fler tablosundaki bir sipari\u015fi ilgili m\u00fc\u015fteri bilgilerine kolayca ula\u015fabiliriz.  Yabanc\u0131 anahtarlar, veritaban\u0131 b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korumak ve veri tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamak i\u00e7in \u00e7ok \u00f6nemlidir.<\/p>\n<p>Sonu\u00e7 olarak, birincil ve yabanc\u0131 anahtarlar birlikte \u00e7al\u0131\u015farak veritaban\u0131n\u0131z\u0131n verimli ve g\u00fcvenilir olmas\u0131n\u0131 sa\u011flar.  Veri fazlal\u0131\u011f\u0131n\u0131 \u00f6nler ve veriler aras\u0131ndaki ili\u015fkileri net bir \u015fekilde tan\u0131mlar.  Bu sayede, veri sorgulamalar\u0131 daha h\u0131zl\u0131 ve daha etkili olur.<\/p>\n<h2>SQL Dilleri: \u00c7e\u015fitlilik ve Se\u00e7enekler<\/h2>\n<p>SQL (Structured Query Language), ili\u015fkisel veritabanlar\u0131n\u0131 y\u00f6netmek i\u00e7in kullan\u0131lan standart bir dildir.  Ancak, farkl\u0131 SQL dilleri mevcuttur.  Her birinin kendine \u00f6zg\u00fc \u00f6zellikleri ve yetenekleri vard\u0131r.  En yayg\u0131n olarak kullan\u0131lan SQL dillerinden baz\u0131lar\u0131 \u015funlard\u0131r:<\/p>\n<ul>\n<li><b>MySQL:<\/b> A\u00e7\u0131k kaynakl\u0131, pop\u00fcler ve \u00e7ok y\u00f6nl\u00fc bir SQL veritaban\u0131 y\u00f6netim sistemidir.<\/li>\n<li><b>PostgreSQL:<\/b> G\u00fc\u00e7l\u00fc, \u00f6l\u00e7eklenebilir ve a\u00e7\u0131k kaynakl\u0131 bir ili\u015fkisel veritaban\u0131 sistemidir.<\/li>\n<li><b>Oracle SQL:<\/b> Ticari bir SQL veritaban\u0131 y\u00f6netim sistemidir ve b\u00fcy\u00fck kurulu\u015flar taraf\u0131ndan s\u0131k\u00e7a kullan\u0131l\u0131r.<\/li>\n<li><b>Microsoft SQL Server:<\/b> Microsoft taraf\u0131ndan geli\u015ftirilen ticari bir SQL veritaban\u0131 y\u00f6netim sistemidir. Windows platformlar\u0131nda yayg\u0131n olarak kullan\u0131l\u0131r.<\/li>\n<li><b>SQLite:<\/b> Hafif ve yerle\u015fik veritabanlar\u0131 i\u00e7in ideal olan bir SQL veritaban\u0131 y\u00f6netim sistemidir.<\/li>\n<\/ul>\n<p>Bu dillerin her birinin kendine \u00f6zg\u00fc avantajlar\u0131 ve dezavantajlar\u0131 vard\u0131r ve se\u00e7iminiz projenizin ihtiya\u00e7lar\u0131na ba\u011fl\u0131 olarak de\u011fi\u015fir.  \u00d6rne\u011fin, k\u00fc\u00e7\u00fck bir proje i\u00e7in SQLite yeterli olabilirken, b\u00fcy\u00fck bir kurumsal uygulama i\u00e7in Oracle SQL veya PostgreSQL daha uygun olabilir.<\/p>\n<p>Bu bilgiler umar\u0131m veritaban\u0131 tasar\u0131m\u0131 konusunda daha iyi bir anlay\u0131\u015f kazanman\u0131za yard\u0131mc\u0131 olmu\u015ftur. Daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/fatihsoysal.com\">web sitemi<\/a> ziyaret edebilirsiniz. Ayr\u0131ca, SQL \u00f6\u011frenmek i\u00e7in \u00e7e\u015fitli online kaynaklar mevcuttur.  Ba\u015far\u0131lar\u0131n\u0131zda bol \u015fanslar!<\/p>\n<p>Faydal\u0131 bulabilece\u011finiz baz\u0131 kaynaklar:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.w3schools.com\/sql\/\">W3Schools SQL \u00d6\u011fretici<\/a><\/li>\n<li><a href=\"https:\/\/dev.to\/lakshmipritha\/day-38-primary-key-foreign-key-in-database-types-of-sql-languages-3g3p\">Orijinal \u0130ngilizce Makale<\/a><\/li>\n<\/ul>\n<h3>#Etiketler<\/h3>\n<p>Veritaban\u0131, SQL, Primary Key, Foreign Key, Birincil Anahtar, Yabanc\u0131 Anahtar, MySQL, PostgreSQL, Oracle SQL, Microsoft SQL Server, SQLite, Veritaban\u0131 Tasar\u0131m\u0131, \u0130li\u015fkisel Veritaban\u0131<\/p>\n","protected":false},"excerpt":{"rendered":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar&hellip;","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":[1],"tags":[],"class_list":{"0":"post-12220","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","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>Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri<\/title>\n<meta name=\"description\" content=\"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.\" \/>\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\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri\" \/>\n<meta property=\"og:description\" content=\"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-12T02:00:14+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=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri\",\"datePublished\":\"2025-02-12T02:00:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\"},\"wordCount\":623,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\",\"name\":\"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-02-12T02:00:14+00:00\",\"description\":\"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri\"}]},{\"@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":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri","description":"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.","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\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/","og_locale":"tr_TR","og_type":"article","og_title":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri","og_description":"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.","og_url":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-02-12T02:00:14+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri","datePublished":"2025-02-12T02:00:14+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/"},"wordCount":623,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/","url":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/","name":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-02-12T02:00:14+00:00","description":"Merhaba, Fatih Soysal burada! Bug\u00fcn veritaban\u0131 tasar\u0131m\u0131n\u0131n temel ta\u015flar\u0131ndan olan birle\u015fik anahtarlar (primary key ve foreign key) ve farkl\u0131 SQL dillerini inceleyece\u011fiz. Bu konular, veritaban\u0131 y\u00f6netimi ve ili\u015fkisel veritabanlar\u0131n\u0131n anla\u015f\u0131lmas\u0131 i\u00e7in olduk\u00e7a \u00f6nemlidir. \u00d6ncelikle, temel kavramlardan ba\u015flayarak konuyu ad\u0131m ad\u0131m ele alal\u0131m.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/veritabani-tasarimi-anahtarlar-ve-sql-turleri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Veritaban\u0131 Tasar\u0131m\u0131: Anahtarlar ve SQL T\u00fcrleri"}]},{"@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\/12220","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=12220"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/12220\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=12220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=12220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=12220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}