{"id":996908,"date":"2025-06-17T14:21:59","date_gmt":"2025-06-17T11:21:59","guid":{"rendered":"https:\/\/morten.com.tr\/?p=996908"},"modified":"2026-02-23T15:00:00","modified_gmt":"2026-02-23T12:00:00","slug":"administering-sql-server-2019-egitimi","status":"publish","type":"post","link":"https:\/\/www.morten.com.tr\/en\/administering-sql-server-2019-egitimi\/","title":{"rendered":"SQL Server 2019 Management Training"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"996908\" class=\"elementor elementor-996908\" 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\/Administering-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<p><b>SQL Server 2019 Management Training<\/b><\/p><p><strong>About Education<\/strong><\/p><p>This training provides comprehensive information and practical applications for the effective installation, management, monitoring, and protection of Microsoft SQL Server 2019 by system administrators and database administrators (DBAs). Throughout the training, advanced administrative topics such as SQL Server installation, configuration, backup and restore strategies, security, monitoring, data transfer, automation, replication, and high availability will be covered using practical examples. Participants will gain the knowledge and skills necessary to manage SQL Server infrastructures securely, reliably, and efficiently.<\/p><p><strong>Prerequisites<\/strong><\/p><ul><li>Basic knowledge of SQL (T-SQL query proficiency)<\/li><li>Familiarity with database concepts<\/li><li>Basic proficiency in Windows Server environments<\/li><li>Previous training in \u2018Querying SQL Server\u2019 or similar courses is advantageous.<\/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>Database administrators (DBAs)<\/li><li>System administrators and IT infrastructure specialists<\/li><li>Technical team members who manage SQL Server in production environments<\/li><li>Candidates who have set SQL Server administration as their career goal<\/li><li>Application developers, individuals seeking to better understand data infrastructure<\/li><\/ul><p><strong>Educational Content<\/strong><\/p><ol><li><strong> SQL Server Installation and Configuration<\/strong><\/li><\/ol><ul><li>SQL Server \u00f6n gereksinimleri<\/li><li>SQL Server kurulumu ve y\u00f6netimi<\/li><li>Measuring service configuration and hardware requirements<\/li><li>SQLIOSIM usage and installation automation<\/li><\/ul><ol start=\"2\"><li><strong> Database and File Management<\/strong><\/li><\/ol><ul><li>Database planning and creation<\/li><li>File\/FileGroup management<\/li><li>Metadata review, file transfer<\/li><li>Buffer Pool Extension configuration<\/li><\/ul><ol start=\"3\"><li><strong> Disaster Recovery (Backup &amp; Restore)<\/strong><\/li><\/ol><ul><li>Backup strategies<\/li><li>Transaction log architecture<\/li><li>Full, differential, and transaction log backup<\/li><li>Restore operations, time-based rollback<\/li><li>Snapshots, system database recovery<\/li><\/ul><ol start=\"4\"><li><strong> SQL Server Security and Authorisation<\/strong><\/li><\/ol><ul><li>Security model, user and role management<\/li><li>Encryption, keys and certificates<\/li><li>Fixed\/database roles and custom role definition<\/li><li>Authorisation levels and schema-based control<\/li><\/ul><ol start=\"5\"><li><strong> Monitoring and Performance Tracking<\/strong><\/li><\/ol><ul><li>Current Activity &amp; System Monitor<\/li><li>Data Collector and SQL Profiler<\/li><li>DDL triggers, Event Notification<\/li><li>Audit mechanisms and warning systems<\/li><\/ul><ol start=\"6\"><li><strong> Data Transfer<\/strong><\/li><\/ol><ul><li>Data transfer architecture<\/li><li>Import\/Export Wizard and SSIS usage<\/li><li>ETL processes with SSIS, distribution, bcp tool<\/li><\/ul><ol start=\"7\"><li><strong> Database Maintenance<\/strong><\/li><\/ol><ul><li>Data integrity checks<\/li><li>Index maintenance, file size management<\/li><li>Scheduling automatic maintenance tasks<\/li><\/ul><ol start=\"8\"><li><strong> Advanced Management Tools<\/strong><\/li><\/ol><ul><li>Policy-Based Management<\/li><li>Multi-server management<\/li><li>Resource Governor kullan\u0131m\u0131<\/li><\/ul><ol start=\"9\"><li><strong> Task Automation<\/strong><\/li><\/ol><ul><li>SQL Server Agent configuration<\/li><li>Scheduled tasks, operators<\/li><li>Automated task scripts and security<\/li><\/ul><ol start=\"10\"><li><strong> SQL Server Replication<\/strong><\/li><\/ol><ul><li>Replication architecture and definitions<\/li><li>Merge, Snapshot, Transactional replication<\/li><li>Publication &amp; Subscription<\/li><li>HTTP Merge structure<\/li><\/ul><ol start=\"11\"><li><strong> High Availability<\/strong><\/li><\/ol><ul><li>Log Shipping<\/li><li>Database Mirroring<\/li><li>SQL Server Clustering<\/li><li>Peer-to-Peer Replication<\/li><li>Always On Availability Groups<\/li><\/ul><p><strong>What You Will Gain at the End of Training<\/strong><\/p><ul><li>Learn the installation, configuration, and updating processes of SQL Server 2019 through practical application.<\/li><li>Full proficiency in database creation, management, migration and monitoring<\/li><li>Ability to develop, test and implement backup and recovery strategies<\/li><li>Understanding the SQL Server security model and effectively managing roles, users, and permissions<\/li><li>Automating tasks and creating alert systems with SQL Server Agent<\/li><li>Understanding replication and high availability solutions at the application level<\/li><li>Advanced database management practice with real-world scenarios<\/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 Administering SQL Server 2019 E\u011fitimi E\u011fitim Hakk\u0131nda Bu e\u011fitim, Microsoft SQL Server 2019\u2019un sistem y\u00f6neticileri ve veritaban\u0131 y\u00f6neticileri (DBA&#8217;ler) taraf\u0131ndan etkili \u015fekilde kurulmas\u0131, y\u00f6netilmesi, izlenmesi ve korunmas\u0131na y\u00f6nelik kapsaml\u0131 bilgi ve uygulamalar\u0131 i\u00e7erir. E\u011fitim boyunca SQL Server kurulumu, konfig\u00fcrasyonu, yedekleme-geri y\u00fckleme stratejileri, g\u00fcvenlik, izleme, veri transferi, otomasyon, replikasyon ve y\u00fcksek eri\u015filebilirlik gibi ileri&#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-996908","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>Administering SQL Server 2019 E\u011fitimi - Morten<\/title>\n<meta name=\"description\" content=\"Administering 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\/administering-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=\"Administering SQL Server 2019 E\u011fitimi\" \/>\n<meta property=\"og:description\" content=\"Administering SQL Server 2019 E\u011fitimi - Morten\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.morten.com.tr\/en\/administering-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:21:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-23T12:00:00+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\/administering-sql-server-2019-egitimi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/\"},\"author\":{\"name\":\"Ey\u00fcp \u00d6nder\",\"@id\":\"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339\"},\"headline\":\"Administering SQL Server 2019 E\u011fitimi\",\"datePublished\":\"2025-06-17T11:21:59+00:00\",\"dateModified\":\"2026-02-23T12:00:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/\"},\"wordCount\":594,\"publisher\":{\"@id\":\"https:\/\/www.morten.com.tr\/#organization\"},\"articleSection\":[\"Database\",\"E\u011fitimler\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/\",\"url\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/\",\"name\":\"Administering SQL Server 2019 E\u011fitimi - Morten\",\"isPartOf\":{\"@id\":\"https:\/\/www.morten.com.tr\/#website\"},\"datePublished\":\"2025-06-17T11:21:59+00:00\",\"dateModified\":\"2026-02-23T12:00:00+00:00\",\"description\":\"Administering SQL Server 2019 E\u011fitimi - Morten\",\"breadcrumb\":{\"@id\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.morten.com.tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Administering 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":"Administering SQL Server 2019 E\u011fitimi - Morten","description":"Administering 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\/administering-sql-server-2019-egitimi\/","og_locale":"en_US","og_type":"article","og_title":"Administering SQL Server 2019 E\u011fitimi","og_description":"Administering SQL Server 2019 E\u011fitimi - Morten","og_url":"https:\/\/www.morten.com.tr\/en\/administering-sql-server-2019-egitimi\/","og_site_name":"Morten","article_publisher":"https:\/\/www.facebook.com\/BTEgitimMorten","article_published_time":"2025-06-17T11:21:59+00:00","article_modified_time":"2026-02-23T12:00:00+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\/administering-sql-server-2019-egitimi\/#article","isPartOf":{"@id":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/"},"author":{"name":"Ey\u00fcp \u00d6nder","@id":"https:\/\/www.morten.com.tr\/#\/schema\/person\/973475f68244ef7e6d57c72f15fb1339"},"headline":"Administering SQL Server 2019 E\u011fitimi","datePublished":"2025-06-17T11:21:59+00:00","dateModified":"2026-02-23T12:00:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/"},"wordCount":594,"publisher":{"@id":"https:\/\/www.morten.com.tr\/#organization"},"articleSection":["Database","E\u011fitimler"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/","url":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/","name":"Administering SQL Server 2019 E\u011fitimi - Morten","isPartOf":{"@id":"https:\/\/www.morten.com.tr\/#website"},"datePublished":"2025-06-17T11:21:59+00:00","dateModified":"2026-02-23T12:00:00+00:00","description":"Administering SQL Server 2019 E\u011fitimi - Morten","breadcrumb":{"@id":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.morten.com.tr\/administering-sql-server-2019-egitimi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.morten.com.tr\/"},{"@type":"ListItem","position":2,"name":"Administering 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\/996908"}],"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=996908"}],"version-history":[{"count":12,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts\/996908\/revisions"}],"predecessor-version":[{"id":998031,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/posts\/996908\/revisions\/998031"}],"wp:attachment":[{"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/media?parent=996908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/categories?post=996908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.morten.com.tr\/en\/wp-json\/wp\/v2\/tags?post=996908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}