Administering SQL Server 2012 Databases Course

Administering SQL Server 2012 Databases Online Courses


2KO South Africa offers online Administering SQL 2012  courses in South Africa. We also offer full time SQL 2012 database courses in Cape Town for groups of four or more delegates. 2KO South Africa's SQL database course is offered to our international and local students. 2KO Africa delivers top-quality computer training across most IT Platforms, as well as a large catalogue of online courses which are available internationally, to ensure the best Administering SQL 2012 certification training in South Africa.


2KO South Africa's SQL 2012 course in South Africa was created specifically for those individuals (Database Professionals) who install, maintain and configure as their primary job function. Any participants setting up database systems and/or responsible for efficient system operation, regular database back ups stored effectively, and securing data from unauthorized access is also a candidate for this 2KO Africa training course on SQL 2012.

Below is a partial list of job functions associated to this 2KO Africa training course: 

Audit SQL Server instances

Back up databases

Configure additional SQL Server components, Instances and Services

Deploying a SQL Server

Implementing strategies, columnstores and High-Availability and Disaster Recovery solutions


Install SQL Server and related services.


Management, configuration, permissions, alerts, logins and roles.


Installation Planning



The 2KO Africa SQL 2012 Administering Databases course prepares students for Microsoft Exam 70-462

As the participant in the 2KO Africa SQL 2012 Administering course will learn:

Installation Planning

Installing SQL Server and related services

Implementation of a migration strategy

How to configure additional SQL Server components

Managing the SQL Server Agent

Database management and configuration

How to configure SQL Server instances

Implementing a SQL Server clustered instance

SQL Server instances management

How to properly Identify and resolve concurrency problems

The collection of and how to analyze troubleshooting data

Auditing SQL Server instances

Configure and maintain a back up strategy

Database restoration

Implementing and maintaining indexes

Importing and exporting data

Managing logins and server roles

Managing database permissions

Managing users and database roles

Troubleshooting security

Implementing AlwaysOn, database mirroring and replication


Microsoft 70-462: Administering SQL Server 2012 Databases


Module 1

Introduction to SQL Server 2012

SQL Server

SQL Server Tools

Management Studio Demo

Data Tools

Exam Scenarios

Module Review


Module 2

Installing SQL Server

SQL Architecture

Hardware Requirements

Software Requirements

Installation Process

Troubleshooting Installation

Upgrading and Unattended Installations

Configuration Demo

Exam Scenarios

Module Review


Module 3

Backup and Restore a Database

Database Architecture

Database Backup

Restoration Process

Restoring System Database

Backup and Recovery Demo

Exam Scenarios

Module Review


Module 4

Tracing Access to SQL Server

Auditing Options

Introduction to SQL Audit

Audit Objects and Implementation

Extended Events

Tracing Activity Demo

Exam Scenarios

Module Review


Module 5

Importing and Exporting Data

Introduction to Data Transfer

ETL Tools

Improving Data Transfer

Copying Database Methods

Transferring Data Demo

Exam Scenarios

Module Review


Module 6

SQL Server Security

Security and Authentication

Server and Database Roles


Securing SQL Server Demo

Exam Scenarios

Module Review


Module 7

Automating SQL Server

SQL Server Agent

Database Mail

Operators, Alerts and Jobs

Database Configuration Demo

Exam Scenarios

Module Review


Module 8

Monitoring SQL Server

Dynamic Management Views and Functions

Profiler Trace

Database Tuning Advisor

Activity and Performance Monitor

Data Collection

Monitoring Demo

Exam Scenarios

Module Review


Module 9

Maintaining SQL Server

Checking Database Integrity


Ongoing Maintenance

Managing and Maintaining Demo

Exam Scenarios

Module Review


Module 10

Troubleshooting SQL Server

Service Issues

Connectivity Issues

Locking Issues

Troubleshooting Demo

Exam Scenarios

Module Review

Program Review