{"id":996900,"date":"2025-06-17T14:18:47","date_gmt":"2025-06-17T11:18:47","guid":{"rendered":"https:\/\/morten.com.tr\/?p=996900"},"modified":"2026-02-23T14:34:42","modified_gmt":"2026-02-23T11:34:42","slug":"querying-sql-server-2019-egitimi","status":"publish","type":"post","link":"https:\/\/www.morten.com.tr\/en\/querying-sql-server-2019-egitimi\/","title":{"rendered":"Querying SQL Server 2019,"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"996900\" class=\"elementor elementor-996900\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-46e4bd1 e-flex e-con-boxed e-con e-parent\" data-id=\"46e4bd1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"vamtam-has-theme-widget-styles elementor-element elementor-element-0b68426 elementor-align-right elementor-widget elementor-widget-button\" data-id=\"0b68426\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"\/wp-content\/uploads\/2025\/06\/Querying-SQL-Server-2019-Egitimi.pdf\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Download PDF<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-caa1c29 elementor-widget elementor-widget-text-editor\" data-id=\"caa1c29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h2>Querying SQL Server 2019,<\/h2><p><strong>About Education<\/strong><\/p><p><strong>Querying SQL Server 2019,<\/strong>This is a practical training course designed for individuals who want to learn database query languages and write effective queries in the Microsoft SQL Server environment. Throughout the training, participants will become proficient in using SQL Server Management Studio (SSMS), writing basic and advanced T-SQL queries, data grouping, multi-table queries (JOIN), data sorting and filtering.<\/p><p>The training is conducted using examples supported by real-world scenarios and aims to improve participants' query writing skills in SQL Server.<\/p><p><strong>Prerequisites<\/strong><\/p><ul><li>Basic knowledge of computer and office software<\/li><li class=\"translation-block\">No prior knowledge of SQL or databases is required.<\/li><li>Familiarity with working with data and basic algorithm logic is beneficial.<\/li><li>Those who have previously used Excel, data analysis or reporting tools may adapt more quickly.<\/li><\/ul><p><strong>Duration of Training<\/strong><\/p><p><strong>Toplam S\u00fcre:<\/strong> 5 G\u00fcn (G\u00fcnde 6 saat)<br \/><strong>Toplam E\u011fitim Saati:<\/strong> 30 saat<br \/><strong>E\u011fitim Format\u0131:<\/strong> Uygulamal\u0131 ve interaktif y\u00fcz y\u00fcze\/online ortam<\/p><p><strong>Who Should Participate?<\/strong><\/p><ul><li>Data analysts, reporting specialists, and BI developers who want to learn SQL<\/li><li>Software developers who want to acquire basic data querying skills<\/li><li>System administrators and technical team members working with SQL Server<\/li><li>All professionals who work with data but want to strengthen their technical infrastructure<\/li><li>University students, those who want to start their career in a data-driven field<\/li><\/ul><p><strong>Educational Content<\/strong><\/p><p><strong>Introduction and Basic Concepts<\/strong><\/p><ul><li>What are data, databases and DBMS?<\/li><li>Relational database structure and table logic<\/li><li>SQL language and areas of use<\/li><li>Introduction to SQL Server and SSMS interface<\/li><li>Query execution methods<\/li><\/ul><p><strong>Quick Start to T-SQL<\/strong><\/p><ul><li>What can be done with SQL?<\/li><li>Basic T-SQL components and command classification<\/li><li>Retrieving data with the SELECT command<\/li><li>Listing tables and columns<\/li><\/ul><p><strong>Data Query with SELECT<\/strong><\/p><ul><li>Simple SELECT queries<\/li><li>DISTINCT and SELECT COUNT (DISTINCT)<\/li><li>Column and table aliases<\/li><\/ul><p><strong>Operators and Filtering<\/strong><\/p><ul><li>Arithmetic operators<\/li><li>Comparison and logical operators with WHERE condition<\/li><li>AND \u2013 OR, IN, LIKE, BETWEEN, IS NULL<\/li><li>Wildcards in the LIKE operator<\/li><\/ul><p><strong>Sorting and Result Limitation<\/strong><\/p><ul><li>ORDER BY<\/li><li>OFFSET \u2013 FETCH<\/li><li>TOP command usage<\/li><\/ul><p><strong>Grouping and Working with Grouped Data<\/strong><\/p><ul><li>Aggregation functions: SUM, COUNT, MIN, MAX, AVG<\/li><li>DISTINCT ile aggregate fonksiyonlar<\/li><li>Using GROUP BY and HAVING<\/li><li>Difference between HAVING and WHERE<\/li><li>GROUPING SETS, CUBE ve ROLLUP<\/li><li>SQL query processing order<\/li><\/ul><p><strong>Query with Multiple Tables (JOIN)<\/strong><\/p><ul><li>Database schema and table relationships<\/li><li>Primary key (PK) and foreign key (FK)<\/li><li>JOIN types and usage logic<ul><li>INNER JOIN<\/li><li>LEFT \/ RIGHT JOIN<\/li><li>FULL JOIN<\/li><li>CROSS JOIN<\/li><li>SELF JOIN and advanced JOIN structures<\/li><\/ul><\/li><\/ul><p><strong>SET Operators and PIVOT Operations<\/strong><\/p><ul><li>UNION and UNION ALL<\/li><li>EXCEPT and INTERSECT<\/li><li>Data transformation operations with PIVOT and UNPIVOT<\/li><\/ul><p><strong>What You Will Gain at the End of Training<\/strong><\/p><ul><li>Ability to write queries confidently in an SQL Server environment<\/li><li>Proficiency in basic and intermediate T-SQL commands<\/li><li>Practical experience that meets real-life data query needs<\/li><li>Ability to apply JOINs, grouping, filtering and data sorting techniques<\/li><li>Ability to work with PIVOT and other advanced query techniques<\/li><li>Strong foundation in data analysis, reporting, BI, and software development<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>PDF \u0130ndir Querying SQL Server 2019 E\u011fitimi E\u011fitim Hakk\u0131nda Querying SQL Server 2019 E\u011fitimi, veri taban\u0131 sorgulama dillerine giri\u015f yapmak ve Microsoft SQL Server ortam\u0131nda etkili sorgular yazabilmek isteyen bireyler i\u00e7in tasarlanm\u0131\u015f uygulamal\u0131 bir e\u011fitimdir. E\u011fitim boyunca kat\u0131l\u0131mc\u0131lar, SQL Server Management Studio (SSMS) kullan\u0131m\u0131, temel ve ileri d\u00fczey T-SQL sorgular\u0131n\u0131n yaz\u0131lmas\u0131, veri gruplama, \u00e7oklu tablo&#8230;<\/p>","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[197,104],"tags":[],"class_list":["post-996900","post","type-post","status-publish","format-standard","hentry","category-database","category-egitimler"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.9 (Yoast SEO v25.9) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Querying SQL Server 2019 E\u011fitimi - Morten<\/title>\n<meta name=\"description\" content=\"Querying SQL Server 2019 E\u011fitimi - Morten\" \/>\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.morten.com.tr\/en\/querying-sql-server-2019-egitimi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Querying SQL Server 2019 E\u011fitimi\" \/>\n<meta property=\"og:description\" content=\"Querying SQL Server 2019 E\u011fitimi - Morten\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.morten.com.tr\/en\/querying-sql-server-2019-egitimi\/\" \/>\n<meta property=\"og:site_name\" content=\"Morten\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BTEgitimMorten\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-17T11:18:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-23T11:34:42+00:00\" \/>\n<meta name=\"author\" content=\"Ey\u00fcp \u00d6nder\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ey\u00fcp \u00d6nder\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/\"},\"author\":{\"name\":\"Ey\u00fcp \u00d6nder\",\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339\"},\"headline\":\"Querying SQL Server 2019 E\u011fitimi\",\"datePublished\":\"2025-06-17T11:18:47+00:00\",\"dateModified\":\"2026-02-23T11:34:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/\"},\"wordCount\":573,\"publisher\":{\"@id\":\"https:\/\/www.morten.com.tr\/#organization\"},\"articleSection\":[\"Database\",\"E\u011fitimler\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/\",\"url\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/\",\"name\":\"Querying SQL Server 2019 E\u011fitimi - Morten\",\"isPartOf\":{\"@id\":\"https:\/\/www.morten.com.tr\/#website\"},\"datePublished\":\"2025-06-17T11:18:47+00:00\",\"dateModified\":\"2026-02-23T11:34:42+00:00\",\"description\":\"Querying SQL Server 2019 E\u011fitimi - Morten\",\"breadcrumb\":{\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.morten.com.tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Querying SQL Server 2019 E\u011fitimi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.morten.com.tr\/#website\",\"url\":\"https:\/\/www.morten.com.tr\/\",\"name\":\"Morten\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.morten.com.tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.morten.com.tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.morten.com.tr\/#organization\",\"name\":\"Morten Bilgi ve \u0130leti\u015fim Hizmetleri A.\u015e.\",\"alternateName\":\"Morten\",\"url\":\"https:\/\/www.morten.com.tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.morten.com.tr\/wp-content\/uploads\/2024\/11\/mortenbt.webp\",\"contentUrl\":\"https:\/\/www.morten.com.tr\/wp-content\/uploads\/2024\/11\/mortenbt.webp\",\"width\":265,\"height\":116,\"caption\":\"Morten Bilgi ve \u0130leti\u015fim Hizmetleri A.\u015e.\"},\"image\":{\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/BTEgitimMorten\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339\",\"name\":\"Ey\u00fcp \u00d6nder\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9518b30bca484f7ddce034d805997e2d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9518b30bca484f7ddce034d805997e2d?s=96&d=mm&r=g\",\"caption\":\"Ey\u00fcp \u00d6nder\"},\"url\":\"https:\/\/www.morten.com.tr\/en\/author\/eyup-onder\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Querying SQL Server 2019 E\u011fitimi - Morten","description":"Querying SQL Server 2019 E\u011fitimi - Morten","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.morten.com.tr\/en\/querying-sql-server-2019-egitimi\/","og_locale":"en_US","og_type":"article","og_title":"Querying SQL Server 2019 E\u011fitimi","og_description":"Querying SQL Server 2019 E\u011fitimi - Morten","og_url":"https:\/\/www.morten.com.tr\/en\/querying-sql-server-2019-egitimi\/","og_site_name":"Morten","article_publisher":"https:\/\/www.facebook.com\/BTEgitimMorten","article_published_time":"2025-06-17T11:18:47+00:00","article_modified_time":"2026-02-23T11:34:42+00:00","author":"Ey\u00fcp \u00d6nder","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Ey\u00fcp \u00d6nder","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#article","isPartOf":{"@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/"},"author":{"name":"Ey\u00fcp \u00d6nder","@id":"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339"},"headline":"Querying SQL Server 2019 E\u011fitimi","datePublished":"2025-06-17T11:18:47+00:00","dateModified":"2026-02-23T11:34:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/"},"wordCount":573,"publisher":{"@id":"https:\/\/www.morten.com.tr\/#organization"},"articleSection":["Database","E\u011fitimler"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/","url":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/","name":"Querying SQL Server 2019 E\u011fitimi - Morten","isPartOf":{"@id":"https:\/\/www.morten.com.tr\/#website"},"datePublished":"2025-06-17T11:18:47+00:00","dateModified":"2026-02-23T11:34:42+00:00","description":"Querying SQL Server 2019 E\u011fitimi - Morten","breadcrumb":{"@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.morten.com.tr\/querying-sql-server-2019-egitimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.morten.com.tr\/"},{"@type":"ListItem","position":2,"name":"Querying SQL Server 2019 E\u011fitimi"}]},{"@type":"WebSite","@id":"https:\/\/www.morten.com.tr\/#website","url":"https:\/\/www.morten.com.tr\/","name":"Morten","description":"","publisher":{"@id":"https:\/\/www.morten.com.tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.morten.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.morten.com.tr\/#organization","name":"Morten Information and Communication Services Inc.","alternateName":"Morten","url":"https:\/\/www.morten.com.tr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.morten.com.tr\/#\/schema\/logo\/image\/","url":"https:\/\/www.morten.com.tr\/wp-content\/uploads\/2024\/11\/mortenbt.webp","contentUrl":"https:\/\/www.morten.com.tr\/wp-content\/uploads\/2024\/11\/mortenbt.webp","width":265,"height":116,"caption":"Morten Bilgi ve \u0130leti\u015fim Hizmetleri A.\u015e."},"image":{"@id":"https:\/\/www.morten.com.tr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BTEgitimMorten"]},{"@type":"Person","@id":"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339","name":"Ey\u00fcp \u00d6nder","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.morten.com.tr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9518b30bca484f7ddce034d805997e2d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9518b30bca484f7ddce034d805997e2d?s=96&d=mm&r=g","caption":"Ey\u00fcp \u00d6nder"},"url":"https:\/\/www.morten.com.tr\/en\/author\/eyup-onder\/"}]}},"_links":{"self":[{"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts\/996900"}],"collection":[{"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/comments?post=996900"}],"version-history":[{"count":9,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts\/996900\/revisions"}],"predecessor-version":[{"id":998027,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts\/996900\/revisions\/998027"}],"wp:attachment":[{"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/media?parent=996900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/categories?post=996900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/tags?post=996900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}