{"id":408,"date":"2016-09-06T12:48:23","date_gmt":"2016-09-06T12:48:23","guid":{"rendered":"http:\/\/localhost\/hiitplc\/?page_id=408"},"modified":"2018-01-09T20:27:13","modified_gmt":"2018-01-09T20:27:13","slug":"administering-microsoft-sql-server-2014-databases","status":"publish","type":"page","link":"https:\/\/www.hiitplc.com\/training\/administering-microsoft-sql-server-2014-databases\/","title":{"rendered":"Administering Microsoft SQL Server 2014 Databases"},"content":{"rendered":"<div id=\"pl-408\"  class=\"panel-layout\" ><div id=\"pg-408-0\"  class=\"panel-grid panel-has-style\" ><div class=\"panel-row-style panel-row-style-for-408-0\" ><div id=\"pgc-408-0-0\"  class=\"panel-grid-cell\" ><div id=\"panel-408-0-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"0\" ><div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n\t<h2 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Administering Microsoft SQL Server 2014 Databases <\/span><\/h2>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div><div id=\"pg-408-1\"  class=\"panel-grid panel-has-style\" ><div class=\"panel-row-style panel-row-style-for-408-1\" ><div id=\"pgc-408-1-0\"  class=\"panel-grid-cell\" ><div id=\"panel-408-1-0-0\" class=\"so-panel widget widget_sow-image panel-first-child panel-last-child\" data-index=\"1\" ><div class=\"so-widget-sow-image so-widget-sow-image-default-d6014b76747a-408\">\n\n<div class=\"sow-image-container\">\n\t\t<img src=\"https:\/\/www.hiitplc.com\/training\/wp-content\/uploads\/sites\/7\/2016\/09\/sql.jpg\" width=\"750\" height=\"422\" srcset=\"https:\/\/www.hiitplc.com\/training\/wp-content\/uploads\/sites\/7\/2016\/09\/sql.jpg 750w, https:\/\/www.hiitplc.com\/training\/wp-content\/uploads\/sites\/7\/2016\/09\/sql-300x169.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" alt=\"\" loading=\"lazy\" \t\tclass=\"so-widget-image\"\/>\n\t<\/div>\n\n<\/div><\/div><\/div><div id=\"pgc-408-1-1\"  class=\"panel-grid-cell\" ><div id=\"panel-408-1-1-0\" class=\"so-panel widget widget_pt_tabs pt-widget-tabs panel-first-child panel-last-child\" data-index=\"2\" >\t\t\t<div class=\"pt-tabs\">\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<ul class=\"pt-tabs__navigation  nav  nav-tabs\" role=\"tablist\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"nav-item\">\n\t\t\t\t\t\t\t\t<a class=\"nav-link  active\" data-toggle=\"tab\" href=\"#tab-overview\" role=\"tab\">Overview<\/a>\n\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"nav-item\">\n\t\t\t\t\t\t\t\t<a class=\"nav-link\" data-toggle=\"tab\" href=\"#tab-course-fee\" role=\"tab\">Course Fee<\/a>\n\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"nav-item\">\n\t\t\t\t\t\t\t\t<a class=\"nav-link\" data-toggle=\"tab\" href=\"#tab-student-reviews\" role=\"tab\">Student Reviews<\/a>\n\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<li class=\"nav-item\">\n\t\t\t\t\t\t\t\t<a class=\"nav-link\" data-toggle=\"tab\" href=\"#tab-enquire-now\" role=\"tab\">Enquire Now<\/a>\n\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t\t\t\t<\/ul>\n\n\t\t\t\t\t<div class=\"pt-tabs__content  tab-content\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"tab-pane  fade  in  active\" id=\"tab-overview\" role=\"tabpanel\">\n\t\t\t\t\t\t\t<div id=\"pl-w5a5525a124a0b\"  class=\"panel-layout\" ><div id=\"pg-w5a5525a124a0b-0\"  class=\"panel-grid panel-no-style\" ><div id=\"pgc-w5a5525a124a0b-0-0\"  class=\"panel-grid-cell\" ><div id=\"panel-w5a5525a124a0b-0-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"0\" ><div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n\t<p>SQL Server offers a cutting edge platform for enterprise data management, sophisticated development and implementation of modern business intelligence solutions.The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Pre-requisite<\/strong><\/span><strong>:\u00a0<\/strong><\/p>\n<p>No knowledge of IT is required to attend this program.<\/p>\n<div class=\"su-accordion su-u-trim\"><br \/> <div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Course Content<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p>The topics that are covered in this program include:<\/p>\n<ul>\n<li>Introduction to SQL Server 2014 Database Administration<\/li>\n<li>\u00a0Installing and Configuring SQL Server 2014<\/li>\n<li>Working with Databases and Storage<\/li>\n<li>Planning and Implementing a Backup Strategy<\/li>\n<li>Restoring SQL Server 2014 Databases<\/li>\n<li>Tracing SQL Server Activity<\/li>\n<li>Managing SQL Server Security<\/li>\n<li>Auditing Data Access and Encrypting Data<\/li>\n<li>Performing Ongoing Database Maintenance<\/li>\n<li>Automating SQL Server 2014 Management<\/li>\n<li>Monitoring SQL Server 2014 by Using Alerts and Notifications<\/li>\n<\/ul>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>For Whom<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p>This course is designed for customers who are interested in learning SQL Server 2012 or 2014<\/p>\n<ul>\n<li>It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.<\/li>\n<li>Database Administrators<\/li>\n<li>Application Developers<\/li>\n<\/ul>\n<ul>\n<li>Business Analysts<\/li>\n<li>Business Intelligence Developer<\/li>\n<li>Data Modelers<\/li>\n<li>Data Warehouse Administrators<\/li>\n<li>\u00a0Data Warehouse Analysts<\/li>\n<li>Data Warehouse Developers<\/li>\n<li>Reports Developers<\/li>\n<li>Technical Consultants<\/li>\n<li>Graduates<\/li>\n<li>Job-seekers<\/li>\n<\/ul>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Commencement Date<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p>Date: 15th January, 2018<\/p>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Duration<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p><b><u>Weekdays<\/u><\/b><\/p>\n<p>54\u00a0hours over six (6) weeks.\u00a0Three (3) hours on Mondays, Wednesdays &amp; Fridays.<\/p>\n<p><strong>Time:\u00a0<\/strong>9am &#8211;\u00a012noon<\/p>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Training Methodology<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p>Multiple training delivery methods are employed including Lectures, Demonstrations, Practical, Self Practice and workshop using real life case study with particular reference to Nigerian situations. The training is at least 80% practical.<\/p>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Payment Methods<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p>Interested individuals can pay using the following methods:<\/p>\n<ul>\n<li>Pay at the centre of your choice<\/li>\n<li>Pay to the bank using the following bank details<\/li>\n<\/ul>\n<p><strong>Account Number:<\/strong> 2011745387<\/p>\n<p><strong>Account Name:<\/strong> HiiT Plc<\/p>\n<p><strong>Bank:<\/strong> First Bank<\/p>\n<p><\/div><\/div><\/p>\n<p><div class=\"su-spoiler su-spoiler-style-fancy su-spoiler-icon-plus su-spoiler-closed\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Payment Types<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\"><\/p>\n<p><strong>Full Payment<\/strong> (Attracts 5% discount of Course Fee)<\/p>\n<p><strong>Installmental Payments<\/strong> (First Payment= 60% of Course Fee)<\/p>\n<p><\/div><\/div><\/p>\n<p><\/div>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"tab-pane  fade\" id=\"tab-course-fee\" role=\"tabpanel\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"tab-pane  fade\" id=\"tab-student-reviews\" role=\"tabpanel\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"tab-pane  fade\" id=\"tab-enquire-now\" role=\"tabpanel\">\n\t\t\t\t\t\t\t<div id=\"pl-w5a5525a124c64\"  class=\"panel-layout\" ><div id=\"pg-w5a5525a124c64-0\"  class=\"panel-grid panel-no-style\" ><div id=\"pgc-w5a5525a124c64-0-0\"  class=\"panel-grid-cell\" ><div id=\"panel-w5a5525a124c64-0-0-0\" class=\"so-panel widget widget_sow-editor panel-first-child panel-last-child\" data-index=\"0\" ><div class=\"so-widget-sow-editor so-widget-sow-editor-base\">\n<div class=\"siteorigin-widget-tinymce textwidget\">\n\t<p>\u00a0<\/p>\n<table class=\"wp-list-table widefat fixed striped forms\">\n<tbody id=\"the-list\" data-wp-lists=\"list:form\">\n<tr>\n<td class=\"shortcode column-shortcode\" data-colname=\"Shortcode\"><div class=\"wpforms-container wpforms-container-full\" id=\"wpforms-166\"><form method=\"post\" enctype=\"multipart\/form-data\" id=\"wpforms-form-166\" action=\"\/training\/wp-json\/wp\/v2\/pages\/408\" class=\"wpforms-validate wpforms-form\" data-formid=\"166\"><div class=\"wpforms-field-container\"><div class=\"wpforms-field wpforms-field-name\" id=\"wpforms-166-field_0-container\" data-field-id=\"0\" style=\"\"><label for=\"wpforms-166-field_0\" class=\"wpforms-field-label\">Name <span class=\"wpforms-required-label\">*<\/span><\/label><div class=\"wpforms-field-row wpforms-field-medium wpforms-field-required\"><div class=\"wpforms-field-row-block wpforms-one-half wpforms-first\"><input type=\"text\" name=\"wpforms[fields][0][first]\" id=\"wpforms-166-field_0\" class=\"wpforms-field-name-first wpforms-field-required\" placeholder=\"\" value=\"\"  required><label for=\"wpforms-166-field_0\" class=\"wpforms-field-sublabel \">First<\/label><\/div><div class=\"wpforms-field-row-block wpforms-one-half\"><input type=\"text\" name=\"wpforms[fields][0][last]\" id=\"wpforms-166-field_0-last\" class=\"wpforms-field-name-last wpforms-field-required\" placeholder=\"\" value=\"\"  required><label for=\"wpforms-166-field_0-last\" class=\"wpforms-field-sublabel \">Last<\/label><\/div><\/div><\/div><div class=\"wpforms-field wpforms-field-email\" id=\"wpforms-166-field_1-container\" data-field-id=\"1\" style=\"\"><label for=\"wpforms-166-field_1\" class=\"wpforms-field-label\">E-mail <span class=\"wpforms-required-label\">*<\/span><\/label><input type=\"email\" name=\"wpforms[fields][1]\" id=\"wpforms-166-field_1\" class=\"wpforms-field-medium wpforms-field-required\" value=\"\" placeholder=\"\"  required ><\/div><div class=\"wpforms-field wpforms-field-number\" id=\"wpforms-166-field_7-container\" data-field-id=\"7\" style=\"\"><label for=\"wpforms-166-field_7\" class=\"wpforms-field-label\">Mobile No: <span class=\"wpforms-required-label\">*<\/span><\/label><input type=\"number\" name=\"wpforms[fields][7]\" id=\"wpforms-166-field_7\" class=\"wpforms-field-medium wpforms-field-required\" value=\"\" placeholder=\"\"  required ><\/div><div class=\"wpforms-field wpforms-field-select\" id=\"wpforms-166-field_9-container\" data-field-id=\"9\" style=\"\"><label for=\"wpforms-166-field_9\" class=\"wpforms-field-label\">Preferred Training Location: <span class=\"wpforms-required-label\">*<\/span><\/label><select name=\"wpforms[fields][9]\" id=\"wpforms-166-field_9\" class=\"wpforms-field-medium wpforms-field-required\"  required ><option value=\"\" class=\"placeholder\" disabled  selected='selected'>Select your preferred location<\/option><option value=\"Abuja\" >Abuja<\/option><option value=\"Lagos\" >Lagos<\/option><option value=\"Kano\" >Kano<\/option><option value=\"Ibadan\" >Ibadan<\/option><\/select><\/div><div class=\"wpforms-field wpforms-field-select\" id=\"wpforms-166-field_8-container\" data-field-id=\"8\" style=\"\"><label for=\"wpforms-166-field_8\" class=\"wpforms-field-label\">Course of Interest <span class=\"wpforms-required-label\">*<\/span><\/label><select name=\"wpforms[fields][8]\" id=\"wpforms-166-field_8\" class=\"wpforms-field-medium wpforms-field-required\"  required ><option value=\"Select your course of interest\" >Select your course of interest<\/option><option value=\"Digital Literacy Certificate\" >Digital Literacy Certificate<\/option><option value=\"Diploma in Information Technology\" >Diploma in Information Technology<\/option><option value=\"CompTIA A+\" >CompTIA A+<\/option><option value=\"CompTIA N+\" >CompTIA N+<\/option><option value=\"Diploma in Web Design\" >Diploma in Web Design<\/option><option value=\"Certificate in Web Programming\" >Certificate in Web Programming<\/option><option value=\"Oracle Certified Associate\" >Oracle Certified Associate<\/option><option value=\"Oracle Certified Professional\" >Oracle Certified Professional<\/option><option value=\"Oracle Business Intelligence Enterprise Edition\" >Oracle Business Intelligence Enterprise Edition<\/option><option value=\"Microsoft Project For Project Managers\" >Microsoft Project For Project Managers<\/option><option value=\"Project Management Professional (PMP)\" >Project Management Professional (PMP)<\/option><option value=\"Cisco Certified Network Associate (CCNA)\" >Cisco Certified Network Associate (CCNA)<\/option><option value=\"Cisco Certified Network Professional (CCNP)\" >Cisco Certified Network Professional (CCNP)<\/option><option value=\"Microsoft C# Essentials\" >Microsoft C# Essentials<\/option><option value=\"ASP.NET\/ ASP.NET MVC\" >ASP.NET\/ ASP.NET MVC<\/option><option value=\"Querying Microsoft SQL Server 2014\" >Querying Microsoft SQL Server 2014<\/option><option value=\"Administering Microsoft SQL Server 2014 Databases\" >Administering Microsoft SQL Server 2014 Databases<\/option><option value=\"Oracle Certified Java SE7 Programmer I&amp;II\" >Oracle Certified Java SE7 Programmer I&II<\/option><option value=\"Oracle Certified Associate Java SE7 Programmer I\" >Oracle Certified Associate Java SE7 Programmer I<\/option><option value=\"Oracle Certified Associate Java SE7 Programmer II\" >Oracle Certified Associate Java SE7 Programmer II<\/option><option value=\"Autocad 2D &amp; 3D\" >Autocad 2D & 3D<\/option><option value=\"Search Engine Optimization (SEO)\" >Search Engine Optimization (SEO)<\/option><option value=\"Digital Marketing\" >Digital Marketing<\/option><option value=\"Graphics Design\" >Graphics Design<\/option><option value=\"HSE Level 1 (Award in Health and Safety at Work)\" >HSE Level 1 (Award in Health and Safety at Work)<\/option><option value=\"HSE level 2 (Risk assessment Practical Application)\" >HSE level 2 (Risk assessment Practical Application)<\/option><option value=\"HSE Level 3 (Award in Environmental Awareness)\" >HSE Level 3 (Award in Environmental Awareness)<\/option><option value=\"Wordpress\" >WordPress<\/option><option value=\"Mobile Apps Development Using Ionic \" >Mobile Apps Development Using Ionic <\/option><option value=\"Laravel Framework\" >Laravel Framework<\/option><\/select><\/div><div class=\"wpforms-field wpforms-field-select\" id=\"wpforms-166-field_12-container\" data-field-id=\"12\" style=\"\"><label for=\"wpforms-166-field_12\" class=\"wpforms-field-label\">Preffered Session <span class=\"wpforms-required-label\">*<\/span><\/label><select name=\"wpforms[fields][12]\" id=\"wpforms-166-field_12\" class=\"wpforms-field-medium wpforms-field-required\"  required ><option value=\"Weekdays\" >Weekdays<\/option><option value=\"Weekends\" >Weekends<\/option><option value=\"Customized\" >Customized<\/option><\/select><\/div><div class=\"wpforms-field wpforms-field-date-time\" id=\"wpforms-166-field_14-container\" data-field-id=\"14\" style=\"\"><label for=\"wpforms-166-field_14\" class=\"wpforms-field-label\">Preferred Course Commencement Date <span class=\"wpforms-required-label\">*<\/span><\/label><input type=\"text\" name=\"wpforms[fields][14][date]\" id=\"wpforms-166-field_14\" class=\"wpforms-field-medium wpforms-field-required wpforms-field-date-time-date wpforms-datepicker\" placeholder=\"\" data-date-format=\"m\/d\/Y\"  required><\/div><div class=\"wpforms-field wpforms-field-textarea\" id=\"wpforms-166-field_2-container\" data-field-id=\"2\" style=\"\"><label for=\"wpforms-166-field_2\" class=\"wpforms-field-label\">Further Enquiries<\/label><textarea name=\"wpforms[fields][2]\" id=\"wpforms-166-field_2\" class=\"wpforms-field-medium\" placeholder=\"\"  ><\/textarea><\/div><\/div><div class=\"wpforms-field wpforms-field-hp\" id=\"wpform-field-hp\"><label for=\"wpforms-field_hp\" class=\"wpforms-field-label\">Message<\/label><input type=\"text\" name=\"wpforms[hp]\" id=\"wpforms-field_hp\" class=\"wpforms-field-medium\"><\/div><div class=\"wpforms-submit-container\" ><input type=\"hidden\" name=\"wpforms[id]\" value=\"166\"><input type=\"hidden\" name=\"wpforms[author]\" value=\"1\"><button type=\"submit\" name=\"wpforms[submit]\" class=\"wpforms-submit \" id=\"wpforms-submit-166\" value=\"wpforms-submit\" >Submit<\/button><\/div><\/form><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<\/div>\n<\/div><\/div><\/div><\/div><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t<\/div><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Administering Microsoft SQL Server 2014 Databases<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-fullwidth.php","meta":{"_mi_skip_tracking":false},"_links":{"self":[{"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/pages\/408"}],"collection":[{"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/comments?post=408"}],"version-history":[{"count":0,"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/pages\/408\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hiitplc.com\/training\/wp-json\/wp\/v2\/media?parent=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}