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 is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading, international provider of certified online IT training, 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

Importing/exporting

Install SQL Server and related services.

Maintenance

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

Optimization

Installation Planning

Restoring

Troubleshooting


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

Permissions

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

Indexing

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