Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm<\/p>\n
Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL’in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL’e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!<\/p>\n
\u00d6ncelikle, yolcu bilgilerini saklayaca\u011f\u0131m\u0131z bir SQL veri taban\u0131 olu\u015fturmam\u0131z gerekiyor. Bu tabloda her yolcunun bir ID’si, ad\u0131, ya\u015f\u0131 ve belki de di\u011fer ilgili \u00f6zellikleri (\u00f6rne\u011fin, bagaj a\u011f\u0131rl\u0131\u011f\u0131) tutabiliriz. Basitlik ad\u0131na, sadece ID, Ad ve Ya\u015f s\u00fctunlar\u0131n\u0131 i\u00e7eren bir tablo olu\u015ftural\u0131m.<\/p>\n
CREATE TABLE Yolcular (\n ID INT PRIMARY KEY,\n Ad VARCHAR(255),\n Yas INT\n);<\/pre>\n<\/code><\/p>\n
Daha sonra, bu tabloya baz\u0131 \u00f6rnek veriler ekleyelim:<\/pre>\n<\/code>INSERT INTO Yolcular (ID, Ad, Yas) VALUES
\n(1, 'Ahmet', 25),
\n(2, 'Ay\u015fe', 30),
\n(3, 'Mehmet', 20),
\n(4, 'Fatma', 28),
\n(5, 'Ali', 35),
\n(6, 'Zeynep', 22),
\n(7, 'Hasan', 40),
\n(8, 'Emine', 27);<\/code><\/p>\n
Bu veri setiyle \u00e7al\u0131\u015farak, SQL sorgular\u0131m\u0131z\u0131n sonu\u00e7lar\u0131n\u0131 do\u011frulayabilece\u011fiz.<\/p>\n
Temel SQL Sorgular\u0131 ile Son Yolcuyu Bulma: Yeni Ba\u015flayanlar \u0130\u00e7in<\/h2>\n
\u015eimdi, en basit senaryoyu ele alal\u0131m: Otob\u00fcs\u00fcm\u00fcz sadece bir yolcuyu daha alabilir ve en gen\u00e7 yolcuyu \u00f6nceliklendirmek istiyoruz. Bu durumda, ORDER BY<\/code> ve LIMIT<\/code> kullanarak en gen\u00e7 yolcuyu kolayca se\u00e7ebiliriz.<\/p>\nSELECT *\nFROM Yolcular\nORDER BY Yas ASC\nLIMIT 1;<\/pre>\n<\/code><\/p>\n
Bu sorgu, yolcular\u0131 ya\u015flar\u0131na g\u00f6re s\u0131ralar (en gen\u00e7ten en ya\u015fl\u0131ya) ve sadece ilk kayd\u0131 (en gen\u00e7 yolcuyu) d\u00f6nd\u00fcr\u00fcr. Bu, otob\u00fcse binebilecek son ki\u015finin kim oldu\u011funu g\u00f6sterir.<\/p>\n
Orta Seviye: Karma\u015f\u0131k Kriterlerle Son Yolcuyu Se\u00e7me<\/h2>\n
\u015eimdi daha karma\u015f\u0131k bir senaryo ele alal\u0131m: Otob\u00fcs\u00fcm\u00fcz\u00fcn kapasitesi 3 ki\u015fi olsun ve \u00f6ncelikle ya\u015f\u0131 30'dan k\u00fc\u00e7\u00fck olan yolcular\u0131, sonra da alfabetik s\u0131raya g\u00f6re se\u00e7mek istiyoruz. Bu senaryoda, ORDER BY<\/code> i\u00e7inde birden fazla s\u00fctunu kullanaca\u011f\u0131z.<\/p>\nSELECT *\nFROM Yolcular\nWHERE Yas < 30\nORDER BY Yas ASC, Ad ASC\nLIMIT 1 OFFSET 2;<\/pre>\n<\/code><\/p>\n
Bu sorgu, \u00f6ncelikle ya\u015f\u0131 30'dan k\u00fc\u00e7\u00fck olan yolcular\u0131 se\u00e7er (WHERE<\/code> ko\u015fulu). Daha sonra bu yolcular\u0131 \u00f6nce ya\u015flar\u0131na, sonra da adlar\u0131na g\u00f6re s\u0131ralar (ORDER BY<\/code>). LIMIT 1 OFFSET 2<\/code> ise, ilk iki kayd\u0131 atlayarak (yani, otob\u00fcse ilk binen 2 ki\u015fiyi ge\u00e7erek) \u00fc\u00e7\u00fcnc\u00fc kayd\u0131 (otob\u00fcse binebilecek son ki\u015fiyi) d\u00f6nd\u00fcr\u00fcr.<\/p>\n\u0130leri D\u00fczey: Performans Optimizasyonu ve \u0130ndeks Kullan\u0131m\u0131<\/h2>\n
Veri taban\u0131m\u0131z b\u00fcy\u00fcd\u00fck\u00e7e, sorgular\u0131m\u0131z\u0131n performans\u0131 kritik hale gelir. Performans\u0131 art\u0131rmak i\u00e7in indeksleme tekniklerini kullanabiliriz. Ya\u015f s\u00fctununa bir indeks eklemek, WHERE Yas < 30<\/code> ko\u015fuluyla yap\u0131lan sorgular\u0131n h\u0131z\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131rabilir.<\/p>\nCREATE INDEX idx_yas ON Yolcular (Yas);<\/pre>\n<\/code><\/p>\n
\u0130ndeks olu\u015fturduktan sonra, sorgular\u0131n\u0131z\u0131 tekrar \u00e7al\u0131\u015ft\u0131r\u0131n ve performans fark\u0131n\u0131 g\u00f6zlemleyin. Daha b\u00fcy\u00fck veri setlerinde, bu iyile\u015ftirme \u00e7ok daha belirgin olacakt\u0131r. Ayr\u0131ca, daha karma\u015f\u0131k sorgularda EXISTS<\/code> veya JOIN<\/code> gibi optimizasyon tekniklerini kullanarak performans\u0131 daha da art\u0131rabilirsiniz. Daha fazla bilgi i\u00e7in https:\/\/fatihsoysal.com adresini ziyaret edebilirsiniz.<\/p>\nVaka Analizi: Ger\u00e7ek D\u00fcnya Senaryolar\u0131<\/h2>\n
Bu teknikler, bir\u00e7ok ger\u00e7ek d\u00fcnya senaryosunda kullan\u0131labilir. \u00d6rne\u011fin, bir havayolu \u015firketi, u\u00e7u\u015flardaki koltuklar\u0131 doldurmak i\u00e7in bu t\u00fcr bir s\u0131ralama ve se\u00e7im yapabilir. \u00d6ncelikli yolculara (\u00f6rne\u011fin, s\u0131k u\u00e7anlara veya engelli yolculara) \u00f6ncelik vererek, en son hangi yolcunun yerle\u015ftirilece\u011fini belirleyebilirler. Benzer \u015fekilde, bir stadyumdaki koltuklar\u0131n atanmas\u0131 veya bir oteldeki oda rezervasyonlar\u0131 i\u00e7in de bu teknikler kullan\u0131labilir.<\/p>\n
\u00d6\u011frenme Yol Haritas\u0131<\/h2>\n
Yeni Ba\u015flayan:<\/strong> Temel SELECT<\/code>, ORDER BY<\/code>, LIMIT<\/code> sorgular\u0131n\u0131 \u00f6\u011frenin ve basit s\u0131ralama ve se\u00e7im i\u015flemleri yapmay\u0131 deneyin. Basit bir veri taban\u0131 olu\u015fturun ve \u00f6rnek veriler ekleyin.<\/p>\nOrta Seviye:<\/strong> WHERE<\/code> ko\u015fullar\u0131, OFFSET<\/code>, birden fazla s\u00fctuna g\u00f6re s\u0131ralama (ORDER BY<\/code>'\u0131n birden fazla s\u00fctun almas\u0131), LIMIT<\/code> ile birle\u015ftirilmesi gibi daha karma\u015f\u0131k sorgularla \u00e7al\u0131\u015f\u0131n. Farkl\u0131 s\u0131ralama kriterlerini deneyin.<\/p>\n\u0130leri D\u00fczey:<\/strong> \u0130ndeksleme, EXISTS<\/code>, JOIN<\/code>, performans optimizasyon teknikleri ve daha b\u00fcy\u00fck veri setleriyle \u00e7al\u0131\u015fmay\u0131 \u00f6\u011frenin. Karma\u015f\u0131k sorgular\u0131 analiz edin ve optimize edin.<\/p>\nG\u00fcvenlik Uyar\u0131lar\u0131<\/h2>\n
Dikkat! Veri taban\u0131n\u0131za eri\u015fimi kontrol etmek ve SQL enjeksiyonundan korunmak i\u00e7in gerekli g\u00fcvenlik \u00f6nlemlerini al\u0131n. Veri taban\u0131n\u0131zdaki verilerin g\u00fcvenli\u011fi, sizin sorumlulu\u011funuzdad\u0131r.<\/p>\n
S\u0131k\u00e7a Sorulan Sorular<\/h2>\n
* SQL'i \u00f6\u011frenmek i\u00e7in nereden ba\u015flamal\u0131y\u0131m?<\/strong> \u0130nternette bir\u00e7ok \u00fccretsiz kaynak ve kurs bulunmaktad\u0131r. Ayr\u0131ca, SQL hakk\u0131nda kapsaml\u0131 bilgi edinebilece\u011finiz kitaplar da mevcuttur.<\/p>\n* Farkl\u0131 SQL veritabanlar\u0131 aras\u0131nda fark var m\u0131?<\/strong> Evet, farkl\u0131 veritabanlar\u0131 (MySQL, PostgreSQL, SQL Server vb.) aras\u0131nda baz\u0131 farkl\u0131l\u0131klar vard\u0131r, ancak temel SQL kavramlar\u0131 genellikle ayn\u0131d\u0131r.<\/p>\n* Daha b\u00fcy\u00fck veri setlerinde performans\u0131 nas\u0131l iyile\u015ftirebilirim?<\/strong> \u0130ndeksleme, sorgu optimizasyonu, veritaban\u0131 ayar\u0131 ve uygun donan\u0131m kullan\u0131m\u0131 gibi bir\u00e7ok y\u00f6ntem bulunmaktad\u0131r.<\/p>\n* Otob\u00fcs kapasitesini dinamik olarak nas\u0131l de\u011fi\u015ftirebilirim?<\/strong> LIMIT<\/code> ifadesinde de\u011fi\u015fken kullanarak veya bir parametre ile sorguyu \u00e7al\u0131\u015ft\u0131rarak bunu yapabilirsiniz.<\/p>\n* Ba\u015fka kriterler ekleyebilir miyim?<\/strong> Evet, WHERE<\/code> ko\u015fuluna ek kriterler ekleyerek (\u00f6rne\u011fin, bagaj a\u011f\u0131rl\u0131\u011f\u0131, cinsiyet vb.) daha karma\u015f\u0131k se\u00e7im i\u015flemleri yapabilirsiniz.<\/p>\nSonu\u00e7<\/h2>\n
Bu makalede, SQL kullanarak otob\u00fcse binebilecek son ki\u015finin nas\u0131l belirlenece\u011fini farkl\u0131 senaryolar ve karma\u015f\u0131kl\u0131k seviyelerinde inceledik. SQL'in g\u00fcc\u00fcn\u00fc kullanarak, ger\u00e7ek d\u00fcnya problemlerini \u00e7\u00f6zmek i\u00e7in \u00e7e\u015fitli teknikler kullanabilece\u011fimizi g\u00f6sterdik. Umar\u0131m bu makale, SQL'i \u00f6\u011frenme yolculu\u011funuzda size yard\u0131mc\u0131 olmu\u015ftur. Daha fazla bilgi i\u00e7in https:\/\/fatihsoysal.com adresini ziyaret edebilirsiniz.<\/p>\n
Yazar: Fatih Soysal<\/p>\n","protected":false},"excerpt":{"rendered":"Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler.…","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-27988","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"\n
Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm<\/title>\n<meta name=\"description\" content=\"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\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\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm\" \/>\n<meta property=\"og:description\" content=\"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-21T15:30:18+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=\"5 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm\",\"datePublished\":\"2025-08-21T15:30:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\"},\"wordCount\":968,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\",\"name\":\"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-08-21T15:30:18+00:00\",\"description\":\"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm\"}]},{\"@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":"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm","description":"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\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\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/","og_locale":"tr_TR","og_type":"article","og_title":"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm","og_description":"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!","og_url":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-08-21T15:30:18+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm","datePublished":"2025-08-21T15:30:18+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/"},"wordCount":968,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/","url":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/","name":"Son Ki\u015fiyi Otob\u00fcs'e Bindirme: SQL ile \u00c7\u00f6z\u00fcm","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-08-21T15:30:18+00:00","description":"Bir otob\u00fcs d\u00fc\u015f\u00fcn\u00fcn; s\u0131n\u0131rl\u0131 kapasitesi var ve yolcular belirli \u00f6zelliklere sahipler. Her yolcuyu belirli kriterlere g\u00f6re otob\u00fcse yerle\u015ftirmeniz ve en son otob\u00fcse binebilecek ki\u015fiyi bulman\u0131z gerekiyor. Bu, SQL'in g\u00fcc\u00fcn\u00fc kullanarak nas\u0131l \u00e7\u00f6z\u00fclebilece\u011fini ad\u0131m ad\u0131m ele alaca\u011f\u0131m\u0131z bir problem. Bu makalede, SQL sorgular\u0131n\u0131 kullanarak bu sorunu \u00e7\u00f6zmenin farkl\u0131 y\u00f6ntemlerini ve performans kar\u015f\u0131la\u015ft\u0131rmalar\u0131n\u0131 inceleyece\u011fiz. Ayn\u0131 zamanda, SQL'e yeni ba\u015flayanlar i\u00e7in temel kavramlardan, ileri d\u00fczey kullan\u0131c\u0131lar i\u00e7in optimizasyon tekniklerine kadar geni\u015f bir yelpazede bilgi sunaca\u011f\u0131z. Haz\u0131rsan\u0131z, bu heyecan verici yolculu\u011fa ba\u015flayal\u0131m!","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/son-kisiyi-otobuse-bindirme-sql-ile-cozum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Son Ki\u015fiyi Otob\u00fcs’e Bindirme: SQL ile \u00c7\u00f6z\u00fcm"}]},{"@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\/27988","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=27988"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/27988\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=27988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=27988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=27988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}