First Look Clinic: Microsoft SQL Server 2012

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.

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

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

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

This module describes some of the key BI capabilities in SQL Server 2012.

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

This module provides an introduction to cloud-based data solutions with SQL Server technologies.

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