Maintaining a Microsoft SQL Server 2012 - Institute of Advanced Technology | Educartis

On Campus


Course Overview

This comprehensive course provides students with the required skills and knowledge to maintain a Microsoft SQL Server database. Through a combination of theoretical learning and hands-on practical skills, the course focuses on teaching students how to use all the features and tools related to maintaining a database. The on-campus programme is intended for database administrators, database developers and Business Intelligence professions and is tailored for SQL power users who aren't necessarily database-focused such as report writers, business analysts and client application developers. 

The world of data is constantly changing and evolving, creating a completely new dimension of growth and challenges for companies around the globe. That's why businesses in all industries are seeking skilled and knowledgeable professionals who are able to accurately record, update and track data to make use of the immense potential offered by this information. This programme will provide you with the skills required to build and implement databases across organisations, giving you a much-needed edge in this competitive field. 

Upon completion, students will receive an IAT Certificate of Competence. 
Show More

How This Course Will Benefit Your Career

At the end of this programme, students will be able to successfully: 

  • Plan, install and configure SQL Server 2012.
  •  Troubleshoot common issues.
  •  Execute multi-server queries and configure a central management server. 
  • Maintain databases
  • Monitor data by using Dynamic Management Views. 

Certification obtained

IAT Certificate of Completion 

What jobs will I qualify for?

Learners will be uniquely qualified for a number of jobs, including: 

  • SQL Report Writer
  • Senior SQL Developer
  • SQL Database Software Engineer 
  • SQL Data Analyst 

When do I start?

Next available course

Admission Criteria

To apply for this programme, students must have: 

  • A working knowledge of relational databases
  • Basic knowledge of the Microsoft Windows Operating System and its core functionality. 
  • Basic understanding of virtualisation technology (classroom labs utilise virtual machines) 

How do I apply?

There is no online application for this course. To apply, please: 

  • Fill out the application form
  • Provide two passport sized photos 
  • Provide copies of any previous education certificates 

Please send this application package to our Campus on Thika Road. 

Detailed course information

This programme is taken on campus at the Institute of Advanced Technology. The course outline is as follows: 

  • Introduction to SQL Server 2008 R2 and its Toolset
  • Installation and Configuration of Database
  • Understanding Recovery Models 
  • Backup and Restoration Techniques 
  • Importing and Exporting Data
  • Authenticating and Authorising Users
  • Performing Ongoing Database Maintenance 
  • Managing Multiple Servers 

Course Provider