M40008 - Updating your Database Skills to Microsoft SQL Server 2012 — A 3 day course

contact usEnquire about this course

Synopsis

The three-day instructor-led Microsoft M40008 course provides existing SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

Objectives

On completion of the Microsoft MS40008 training course, delegates should be able to:

Contents

Introducing SQL Server 2012

This module provides an overview of SQL Server 2012.

Installing SQL Server 2012

This module describes how to install SQL Server 2012.

Managing SQL Server 2012

This module describes new and enhanced features that make it easier to manage SQL Server databases.

Developing SQL Server 2012 Databases

This module describes new Transact-SQL and data storage capabilities that you can use to develop databases.

Performance and Tuning Enhancements

This module provides an introduction to new and enhanced performance tuning features in SQL Server 2012.

High Availability and Data Recovery Enhancements

This module provides an introduction to new and enhanced features for data recovery and availability.

Implementing Security in Microsoft SQL Server 2012

This module describes how to use security enhancements in SQL Server 2012.

Extending Data Solutions to the Cloud

This module provides an introduction to SQL Azure.

Overview of BI Enhancements in SQL Server 2012

This module introduces enhancements to BI support in SQL Server 2012.

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

The Microsoft 40008 course is intended for database professionals with experience of using SQL Server 2008 R2.

Prerequisites

Before attending this course, students must have:

Experience of creating database solutions in SQL Server, including basic Transact-SQL programming