Download PDF
of this course

MS40008 - Updating your Database Skills to Microsoft® SQL Server® 2012 (MS40008)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration : 3 Days

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

Who Should Attend

  • This course is intended for database professionals with experience of using SQL Server 2008 R2.

Course Certifications

This course is part of the following Certifications:

Prerequisites

Before attending this course, students must have:

  • Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.

Course Objectives

After completing this course, students will be able to:

  • Describe key new and enhanced features in SQL Server 2012.

  • Install SQL Server 2012.

  • Use enhanced tools and PowerShell support to manage SQL Server 2012.

  • Use enhanced Transact-SQL and storage capabilities to develop SQL Server 2012 databases.

  • Use new and enhanced performance capabilities to optimize a SQL Server 2012 database.

  • Use new availability and data recovery technologies to provide high availability.

  • Use new and enhanced security capabilities in SQL Server 2012.

  • Use SQL Azure.

  • Describe new Business Intelligence (BI) capabilities in SQL Server 2012.

Course Content

Module 1 : Introducing SQL Server 2012

This module provides an overview of SQL Server 2012

Lessons

  • Overview of SQL Server 2012
  • SQL Server 2012 Edition s and Components

After complething this module , students will be able to :

  • Describe SQL Server 2012
  • List SQL Server 2012 Editions and Components

 

Module 2 : Installing SQL Server 2012 

This module describes how to install SQL Server 2012

Lessons 

  • Installation Options and Requirements
  • Installing SQL Server 
  • Deploying SQL Server in a Private Cloud

Lab : Installing SQL Server 

Lab : Using a Data-Tier Application in a PrivateCloud Scenario

After completing this module , students will be able to :

  • List the installation options and requirements for SQL Server 2012
  • Install SQL Server 2012
  • Describe considerations for provisioning database servers in a private cloud

 

Module 3 : Managing SQL Server 2012

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

Lessons

  • Enhancements to SQL Server Management Studio
  • New an Enhanced Dynamic Management Views
  • Using PowerShell to Manage SQL Server 

Lab : Managing SQL Server 

After completing this module , students will be able to :

  • Use enhancements to SQL Server Management Studio
  • Use new and enhanced Dynamic Management Views 
  • Use PowerShell to Manage SQL Server .

 

Module 4 : Developing SQL Server 2012 Databases

  • This module describe new Transact-SQL Functions
  • Enhancements to Spatial Data Support 
  • Storing and Querying Documents

Lab : Developing SQL Server Databases 

After completing this module , students will be able to :

  • Describe enhancements to Transact-SQL
  • Describe new and enhanced Transact-SQL functions
  • Describe Enhancements too Spatial Data Support 
  • Explain how to store and query documents with SQL Server 2012.

 

Module 5 : Performance and Tuning Enhancements

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

Lessons

  • Performance Optimization Tools
  • Enhancement to Indexing 

Lab : Optimizing SQL Server Performance

After completing this module , students will be able to :

  • Describe enhancements to performance optimization tools
  • Use indexing enhancements to increase query performance

 

Module 6 : High Availability and Data Recovery Enhancements

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

Lessons

  • AlwaysOn High Availability
  • Enhancements to Data Recovery

Lab : Using AlwaysOn Availability Groups

After completing this module , students will be able to :

  • Use ALwaysOn technologies to support high availability
  • Use enhancements to database restore capabilities 

 

Module 7 : Implementing Security in Microsoft SQL Server 2012

Lessons

  • Security Management Enhancements
  • Contained Databases

Lab  : Implementing Security 

After completing this module , students will be able to :

  • Describe security management enhancements.
  • Implement contained databases

 

Module 8 : Extending Data Solutions to the Cloud 

This module provides an introduction to SQL Azure

Lessons 

  • Introduction to SQL Azure 
  • Working with SQL Azure 

Lab : Using SQL Azure 

After completing this module , students will be able to L

  • Describe key features and benefits of SQL Azure
  • Create and manage SQL Azure databases 

 

Module 9 : Overview of BI Enhancements in SQL Server 2012 

This module introduces enhancements to BI supporrt in SQL Server 2012

Lessons

  • SQL Server 2012 for Data Warehousing
  • SQL Server 2012 for Business Intelligence 

Lab : Exploring BI Features

After completing this module , students will be able to :

  • Describe enhancements in SQL Server 2012 for data warehousing
  • Describe enhancements in SQL Server 2012 for BI

 

Course ID: MS40008

3 Days Course
SGD 2100.00
 
Singapore

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register
23 May 2018 - 25 May 2018 Singapore Singapore