40008
Updating your Database Skills to Microsoft SQL Server 2012


  • Duration: 3 days
  • Price: $1,557.00
  • Certifications:
  • Exams:
Course Overviewremove_circle_outline

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.

Target Audienceadd_circle_outline

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

Upon Course Completionadd_circle_outline

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 Outlineadd_circle_outline

Module 1: Introducing SQL Server 2012

This module provides an overview of SQL Server 2012.

Lessons

  • Overview of SQL Server 2012
  • SQL Server 2012 Editions and Components

After completing 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*Installing a SQL Server 2012 Named Instance

  • Performing Post-Installation Setup and Checks

Lab : Using a Data-Tier Application in a Private Cloud Scenario

  • Creating a Data-Tier Application
  • Deploying a Data-Tier Application

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 databases.

Lessons

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

Lab : Managing SQL Server

  • Using SQL Server Management Studio
  • Using SQL Server Management Studio

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 describes new Transact-SQL and data storage capabilities that you can use to develop databases.

Lessons

  • Transact-SQL Enhancements
  • New and Enhanced Transact-SQL Functions
  • Enhancements to Spatial Data Support
  • Storing and Querying Documents

Lab : Developing SQL Server Databases

  • Using Sequence Objects
  • Using the THROW Statement
  • Implementing Paging
  • Querying Documents

After completing this module, students will be able to:

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

Module 5: Performance and Tuning Enhancements This module provides an introduction to new and enhanced performance tuning features in SQL Server 2012.

Lessons

  • Performance Optimization Tools
  • Enhancements to Indexing

Lab : Optimizing SQL Server Performance

  • Creating a Columnstore Index
  • Using a Columnstore Index
  • Updating a Table with a Columnstore Index

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
  • Enhancemenst to Data Recovery

Lab : Using AlwaysOn Availability Groups

  • Creating an AlwaysOn Availability Group
  • Using an AlwaysOn Availability Group
  • Observing Availability Group Failover Behavior

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

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

Lessons

  • Security Management Enhancements
  • Contained Databases

Lab : Implementing Security

  • Implementing user-Defined Server Roles
  • Implementing Contained Databases

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

  • Creating a Database in SQL Azure
  • Using SQL Server Management Studio with SQL Azure

After completing this module, students will be able to:

  • 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 support in SQL Server 2012.

Lessons

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

Lab : Exploring BI Features*Using PowerPivot

  • Using Power View

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.
Prerequisitesadd_circle_outline

Before attending this course, students must have:

  • Experience of creating and managing database solutions in SQL Server, including basic Transact-SQL programming.
Upcoming Classes
  • Click below to see more class dates with course versions
  • See More Dates
Have questions? Let us help you.