40007:First Look Clinic: Microsoft® SQL Server® 2012
This course 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. The target audience for this clinic consists of business technology managers and database professionals who want to understand the key capabilities of SQL Server 2012.
Course Outlines:
Module 1: Introduction to SQL Server 2012
In this module, you will learn about the key data management workloads and trends that SQL Server 2012 addresses, and examine the different editions and components that form the SQL Server 2012 platform.
Lessons:
- Enterprise Data Scenarios and Trends
- SQL Server 2012 Overview
Module 2: SQL Server 2012 as a Platform for Mission-Critical Data
In this module, you will learn about the enhancements on SQL Server 2012 that make it easier than ever to develop and manage database applications, and to ensure high availability for your mission-critical data.
Lessons:
- Database Development Enhancements
- Database Manageability Enhancements
- Database Availability Enhancements
Module 3: Enterprise Integration Management and Data Warehousing
In this module, you will learn how SQL Server 2012 provides EIM capabilities that make it easier for you 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
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
Module 5: Cloud-Based Data Solutions
In this module, you will learn that indata-related scenarios there are several uses of cloud computing including line of business databases, datasets, and data services; and these solutions can be deployed as public cloud, private cloud, or hybrid cloud.
Lessons:
- Microsoft Cloud Solutions for Data
- SQL Server 2012 and the Cloud
40007