Updating your Database and Business Intelligence Skills to SQL Server 2012

Upgrade your database and business intelligence (BI) skills to Microsoft SQL Server 2012. In this course, existing SQL Server database professionals will gain the knowledge and skills to use new and enhanced capabilities in SQL Server 2012, including Database and Business Intelligence features.

This course incorporates material from the Official Microsoft Learning Products (OMLPs):

  • 40008: Updating your Database Skills to Microsoft SQL Server 2012
  • 40009: Updating your Business Intelligence Skills to Microsoft SQL Server 2012


  • 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
  • New BI capabilities in SQL Server 2012
  • Use new and enhanced features in SQL Server Integration Services
  • Manage data quality by using SQL Server Data Quality Services
  • Use new and enhanced features of SQL Server Reporting Services
  • Create tabular data models with PowerPivot and DAX
  • Implement a tabular data model in SQL Server Analysis Services
  • Use Power View to create interactive data visualizations
  • Integrate Microsoft cloud technologies into a BI solution using SQL Azure

Target Audience

Database and BI professionals with experience using SQL Server 2008 R2


  • Experience creating database solutions in SQL Server, including basic Transact-SQL programming
  • Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modeling, and reporting

Expected Duration

5 day

Course Objectives

1: SQL Server 2012

  • SQL Server 2012 Editions and Components

2: Installing SQL Server 2012

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

3: Managing SQL Server 2012

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

4: Developing SQL Server 2012 Databases

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

5: Performance and Tuning Enhancements

  • Performance Optimization Tools
  • Enhancements to Indexing
  • Columnstore Index

6: High Availability and Data Recovery Enhancements

  • AlwaysOn High Availability
  • Enhancements to Data Recovery

7: Implementing Security in Microsoft SQL Server 2012

  • Security Management Enhancements
  • Contained Databases

8: SQL Server 2012 for Business Intelligence

  • SQL Server 2012 for Enterprise Integration Management
  • SQL Server 2012 for Data Warehousing
  • SQL Server 2012 for Data Analysis and Reporting

9: New and Enhanced Features in SQL Server Integration Services

  • Using the CDC Control Task for Incremental Data Loads
  • Deploying and Operating SSIS Packages

10: Data Quality Services

  • Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Match Data

11: SQL Server 2012 Reporting Services

  • Reporting Services
  • Reporting Services and Microsoft SharePoint Server
  • Data Alerts

12: Creating Tabular Data Models with PowerPivot

  • Tabular Data Models and PowerPivot Technologies
  • Using PowerPivot
  • Using DAX in a PowerPivot Data Model

13: Implementing an Analysis Services Tabular Data Model

  • Analysis Services Tabular Data Model Projects
  • Developing an Analysis Services Tabular Data Model

14: Creating Data Visualizations with Power View

  • Power View
  • Visualizing Data with Power View

15: Using Cloud Technologies in a BI Solution

  • Cloud Data Sources
  • SQL Azure
  • SQL Azure Reporting Services
  • Windows Azure Marketplace DataMarket