{"id":3789,"date":"2021-10-22T02:43:49","date_gmt":"2021-10-22T02:43:49","guid":{"rendered":"https:\/\/avantgardenigeria.com\/?post_type=product&#038;p=3789"},"modified":"2025-12-27T06:32:53","modified_gmt":"2025-12-27T06:32:53","slug":"designing-optimizing-and-maintaining-a-database-administrative-solution-with-sql-server","status":"publish","type":"product","link":"https:\/\/avantgardenigeria.com\/index.php\/product\/designing-optimizing-and-maintaining-a-database-administrative-solution-with-sql-server\/","title":{"rendered":"DESIGNING, OPTIMIZING AND MAINTAINING A DATABASE ADMINISTRATIVE SOLUTION WITH SQL SERVER"},"content":{"rendered":"<h3>Objective<\/h3>\n<p>SQL Server offers a sophisticated platform for enterprise data management. Organizations rely on database administrators who know how to manage their mission -critical databases correctly. This workshop targets those who are new and old to database administration and offers the essential skills you need to administer SQL Server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><strong>Content<\/strong><\/p>\n<p><strong style=\"font-size: 16px;\">Getting Started with SQL Server<\/strong><\/p>\n<ul>\n<li>Setting up SQL Server<\/li>\n<li>Leveraging Essential Tools<\/li>\n<\/ul>\n<p><strong>Constructing and Managing Databases<\/strong><\/p>\n<ul>\n<li>Inspecting Storage Structures<\/li>\n<li>Designing File Groups<\/li>\n<li>Upgrading and Moving Databases<\/li>\n<li>Controlling Database Space<\/li>\n<\/ul>\n<p><strong>Handling Server and Database Security<\/strong><\/p>\n<ul>\n<li>Implementing Server Security<\/li>\n<li>Granting Database Access<\/li>\n<\/ul>\n<p><strong>Granting and Revoking Permissions<\/strong><\/p>\n<ul>\n<li>Managing Database \u2013 Scoped Privileges<\/li>\n<li>Defining Object-Level Permissions<\/li>\n<\/ul>\n<p><strong>Backup and Recovery<\/strong><\/p>\n<ul>\n<li>Backing Up Databases<\/li>\n<li>Restoring Databases<\/li>\n<\/ul>\n<p><strong>Streamlining Tasks with Jobs, Alerts and\u00a0<\/strong><strong>Database Mail<\/strong><\/p>\n<ul>\n<li>Configuring SQL Server Agent<\/li>\n<li>Defining Jobs to Handle Routine Tasks<\/li>\n<\/ul>\n<p><strong>Database Maintenance and Monitoring<\/strong><\/p>\n<ul>\n<li>Handling Fragmentation and Database<\/li>\n<li>Corruption<\/li>\n<li>Building Database Maintenance Plans<\/li>\n<li>Resolving Contention Problems<\/li>\n<\/ul>\n<p><strong>FOR WHOM: <\/strong>Chief Information Officers, Database Administrators, Server Managers, IT Professionals, Systems Administrators, IT Managers and others who work in environments where databases play a key role in their primary job responsibilities or develop applications that deliver content from databases.<\/p>\n<p><strong>DATE:\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 31st March \u2013 2nd April, 2026<\/strong><\/p>\n<p><strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a028th &#8211; 30th September, 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":3304,"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-3789","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\/3789","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=3789"}],"version-history":[{"count":6,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3789\/revisions"}],"predecessor-version":[{"id":5094,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product\/3789\/revisions\/5094"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media\/3304"}],"wp:attachment":[{"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/media?parent=3789"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_brand?post=3789"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_cat?post=3789"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/avantgardenigeria.com\/index.php\/wp-json\/wp\/v2\/product_tag?post=3789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}