40007:First Look Clinic: Microsoft® SQL Server® 2012

Code: 40007
Course duration: 1 days

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.


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


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


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


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


  • Microsoft Cloud Solutions for Data
  • SQL Server 2012 and the Cloud


Guaranteed to Run

2018-03-20 09:00 to 2018-03-23 17:00
Palm Beach County Florida (Instructor-Led)
2018-03-19 09:00 to 2018-03-23 17:00
Secaucus, New Jersey (Virtual Instructor-Led)
2018-03-01 09:00 to 2018-03-02 17:00
Palm Beach County Florida (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review