Enable Technology


Microsoft SQL Server 2012 Database Administration

Course Overview

This course is is aimed at those who administer and maintain SQL Server databases. It is matched against the Microsoft Exam 70-462 syllabus.

Duration: 3 day course

Course Content

Identifying the SQL Server Platform and Tools
Overview of SQL Server Features
Create Filegroups and Partitions

Deploying SQL Server
Install SQL Server
Migrate SQL Server From a Previous Version

Configuring SQL Server
Configure Server Properties
Configure Memory and CPU
Configure Database Mail

Managing Databases in SQL Server 2012
Create a Contained Database
Configure Database Options

Managing SQL Server Security
Configure Server Security
Create Server Roles
 Configure Database Security

Implementing Advanced Security Settings
Create Certificate-Based Logins
Apply Auditing and Policy-Based Management Strategies

Applying Encryption and Compression
Apply Encryption on Databases
Compress a Database Table

Working with Indexes and Log Files
Work with Full Text Indexes
Configure Advanced Storage and Indexing Settings
Configure Log Files

Working with Backup and Restore
Perform a Backup
Restore a Database
Import and Export Data
Configure the SQL Server Agent

Implementing High Availability
Work with Clustering
Work with Replication
Work with Mirroring and AlwaysOn
Work with Central Management Servers

Optimizing Server Performance
Manage Server Performance
Optimize Indexes

Troubleshooting Issues and Recovering Databases
Troubleshoot Database Issues
Perform a Database Recovery

Performing Advanced Database Management Tasks
Manage Database Infrastructure
Configure SSIS

Email us about this courses         Telephone on 01952 305730

Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.

West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;