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.
Target Audience:
This course is intended for technology managers and database professionals who want to understand the key capabilities of SQL Server 2012. In many cases, it is assumed that senior technical managers may attend this clinic in order to assess the further training that their technology-focused employees will need in order to adopt SQL Server 2012.
Pre-requisites:
Before attending this course, students must have an understanding of how data systems are used in a business enterprise
At Course Completion:
After completing this course, students will be able to:
Describe key new and enhanced features in SQL Server 2012
Describe the mission-critical database platform capabilities of SQL Server 2012
Describe the enterprise integration management and data warehousing capabilities of SQL Server 2012
Describe the business intelligence capabilities of SQL Server 2012
Describe how SQL Server 2012 can be used in a cloud-based data solution
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