{"id":3805,"date":"2021-10-22T02:59:54","date_gmt":"2021-10-22T02:59:54","guid":{"rendered":"https:\/\/avantgardenigeria.com\/?post_type=product&#038;p=3805"},"modified":"2025-12-26T21:40:05","modified_gmt":"2025-12-26T21:40:05","slug":"securing-sql-server-2017","status":"publish","type":"product","link":"https:\/\/avantgardenigeria.com\/index.php\/product\/securing-sql-server-2017\/","title":{"rendered":"SECURING SQL SERVER 2017"},"content":{"rendered":"<h3>Objective<\/h3>\n<p>SQL Server 2017 provides enhanced security features to ensure that each instance is secure. Using SQL Server 2017 security features, administrators can guarantee that access to a SQL Server instance is granted only to specified users, using either Windows Authentication or Mixed Mode Authentication by creating logins and then mapping the logins to the databases within the instance. Administrators also have the ability to encrypt a SQL Server instance using transparent data encryption (TDE) and to encrypt the data within a database using encryption certificates and asymmetric and symmetric keys. This workshop demonstrates how to create SQL Server logins, database users, and how to grant permissions, including server and database roles.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><strong>Content<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong style=\"font-size: 16px;\">Introduction to SQL Server 2017 Database Administration<\/strong><\/p>\n<ul>\n<li>Database Management Tools and Techniques<\/li>\n<li>Installing and Configuring SQL Server 2017<\/li>\n<li>Work with Databases and Storage<\/li>\n<\/ul>\n<p><strong>SQL Server Operations and Management<\/strong><\/p>\n<ul>\n<li>Import and Export Data<\/li>\n<li>Restore SQL Server 2017 Databases<\/li>\n<li>Plan and Implement a Backup Strategy<\/li>\n<li>Monitor SQL Server 2017<\/li>\n<\/ul>\n<p><strong>Server Security<\/strong><\/p>\n<ul>\n<li>Tracing SQL Server Activity<\/li>\n<li>Manage SQL Server Security<\/li>\n<li>Audit Data Access and Encrypt Data<\/li>\n<\/ul>\n<p><strong>SQL Server Maintenance<\/strong><\/p>\n<ul>\n<li>Perform Ongoing Database Maintenance<\/li>\n<li>Automate SQL Server 2017 Management<\/li>\n<li>Monitor SQL Server 2017 Using Alters and Notifications<\/li>\n<\/ul>\n<p><strong>FOR WHOM: <\/strong>CIOs, Heads of Departments, IT Professionals, System Analysts, Network Administrators, Servers Managers, Network Engineers, Systems\/Security Administrators, IT Development Managers and others who perform related functions.<\/p>\n<p><strong>DATE:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 13th &#8211; 15th April, 2026<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 12th &#8211; 14th October, 2026<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/avantgardenigeria.com\/index.php\/registration\/\"><img decoding=\"async\" class=\"alignnone wp-image-3464\" src=\"https:\/\/avantgardenigeria.com\/wp-content\/uploads\/2017\/12\/register-1.jpeg\" alt=\"\" width=\"202\" height=\"67\" \/><\/a><\/p>\n","protected":false},"featured_media":3268,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"product_brand":[],"product_cat":[33],"product_tag":[],"class_list":{"0":"post-3805","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-ict-workshop","7":"desktop-align-left","8":"tablet-align-left","9":"mobile-align-left","11":"first","12":"instock","13":"shipping-taxable","14":"purchasable","15":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/comments?post=3805"}],"version-history":[{"count":5,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3805\/revisions"}],"predecessor-version":[{"id":5087,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3805\/revisions\/5087"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media\/3268"}],"wp:attachment":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media?parent=3805"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_brand?post=3805"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_cat?post=3805"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_tag?post=3805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}