{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"SQL Birle\u015ftirme ve Alt Sorgulamalar\u0131: Nihai K\u0131lavuz","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"s3BvEI5qkb\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sql-birlestirme-ve-alt-sorgulamalari-nihai-kilavuz\/\">SQL Birle\u015ftirme ve Alt Sorgulamalar\u0131: Nihai K\u0131lavuz<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sql-birlestirme-ve-alt-sorgulamalari-nihai-kilavuz\/embed\/#?secret=s3BvEI5qkb\" width=\"600\" height=\"338\" title=\"&#8220;SQL Birle\u015ftirme ve Alt Sorgulamalar\u0131: Nihai K\u0131lavuz&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"s3BvEI5qkb\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Veri tabanlar\u0131nda gezinirken, ili\u015fkili verileri bir araya getirmek veya karma\u015f\u0131k sorgulamalar olu\u015fturmak s\u0131kl\u0131kla ihtiya\u00e7 duyulan i\u015flemlerdir. \u0130\u015fte tam da bu noktada SQL'in g\u00fc\u00e7l\u00fc ara\u00e7lar\u0131 olan birle\u015ftirmeler (joins) ve alt sorgulamalar (subqueries) devreye girer. Bu rehber, SQL'in bu temel yap\u0131 ta\u015flar\u0131n\u0131 yeni ba\u015flayanlardan uzmanlara kadar her seviyedeki kullan\u0131c\u0131 i\u00e7in ad\u0131m ad\u0131m a\u00e7\u0131klayacak, ger\u00e7ek d\u00fcnya senaryolar\u0131 ile zenginle\u015ftirecek ve performans optimizasyonuna dair ipu\u00e7lar\u0131 sunacakt\u0131r. Veri analiti\u011finde daha verimli ve etkili olmak i\u00e7in ihtiyac\u0131n\u0131z olan t\u00fcm bilgileri bu k\u0131lavuzda bulabilirsiniz."}