{"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'de A\u011fa\u00e7 Yap\u0131lar\u0131 (B\u00f6l\u00fcm 2)","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"PLf3UTIAlY\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlde-agac-yapilari-bolum-2\/\">SQL&#8217;de A\u011fa\u00e7 Yap\u0131lar\u0131 (B\u00f6l\u00fcm 2)<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlde-agac-yapilari-bolum-2\/embed\/#?secret=PLf3UTIAlY\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;de A\u011fa\u00e7 Yap\u0131lar\u0131 (B\u00f6l\u00fcm 2)&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"PLf3UTIAlY\" 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":"Merhaba! Bu yaz\u0131da, SQL veritabanlar\u0131nda a\u011fa\u00e7 yap\u0131lar\u0131n\u0131 modelleme ve sorgulama konusunu daha derinlemesine inceleyece\u011fiz. \u00d6nceki yaz\u0131m\u0131zda temel kavramlar\u0131 ele alm\u0131\u015ft\u0131k. \u015eimdi ise daha geli\u015fmi\u015f tekniklere ve performans optimizasyonlar\u0131na odaklanaca\u011f\u0131z. \u00d6zellikle b\u00fcy\u00fck veri k\u00fcmeleriyle \u00e7al\u0131\u015f\u0131rken performans kritik \u00f6neme sahiptir. Bu y\u00fczden, verimli sorgulamalar yazabilmek i\u00e7in farkl\u0131 stratejiler \u00f6\u011frenmemiz gerekiyor."}