This half-day instructor-led clinic introduces the key features and enhancements in SQL Server 2012. It is designed to provide a high-level overview of the product and the key new capabilities in this release.

Course Outline

Module 1: Introduction to SQL Server 2012
This module provides an overview of SQL Server 2012.
Lessons

    Enterprise Data Scenarios and Trends
    SQL Server 2012 Overview

After completing this module, students will be able to:

    Describe enterprise data scenarios and trends.
    Describe the key components of SQL Server 2012.

Module 2: SQL Server 2012 as a Platform for Mission-Critical Data
This module describes the enhancements on SQL Server 2012 that make it easier than ever to develop and manage database applications, and to ensure high availability for mission-critical data.
Lessons

    Database Development Enhancements
    Database Manageability Enhancements
    Database Availability Enhancements

After completing this module, students will be able to:

    Describe database development enhancements in SQL Server 2012.
    Describe database manageability enhancements in SQL Server 2012.
    Describe database availability enhancements in SQL Server 2012.

Module 3: Enterprise Integration Management and Data Warehousing
This module describes how SQL Server 2012 provides EIM capabilities that make it easier to manage data quality, ensure consistency of data for key business entities, integrate data from multiple sources, and create a data warehouse as the basis for enterprise reporting, analytics, and business intelligence (BI).
Lessons

    SQL Server 2012 Data Quality Services
    SQL Server 2012 Master Data Services
    SQL Server 2012 Integration Services
    SQL Server 2012 for Data Warehousing

After completing this module, students will be able to:

    Describe how SQL Server Data Quality Services enables you to manage data quality.
    Describe how SQL Server Master Data Services enables you to ensure data consistency.
    Describe how SQL Server Integration Services enables you to build data integration solutions.
    Describe how SQL Server 2012 can be used to implement a data warehouse.

Module 4: Business Intelligence
This module describes some of the key BI capabilities in SQL Server 2012.
Lessons

    SQL Server 2012 Reporting Services
    PowerPivot and Analysis Services
    Power View

After completing this module, students will be able to:

    Describe key capabilities of SQL Server 2012 Reporting Services.
    Describe key capabilities of SQL Server 2012 Analysis Services and PowerPivot.
    Describe key capabilities of SQL Server 2012 Power View.

Module 5: Cloud-Based Data Solutions
This module provides an introduction to cloud-based data solutions with SQL Server technologies.
Lessons

    Microsoft Cloud Solutions for Data
    SQL Server 2012 and the Cloud

After completing this module, students will be able to:

    Describe Microsoft cloud solutions for data.
    Describe how SQL Server 2012 can be used in a cloud-based scenario.