Course 40007A:

First Look Clinic: Microsoft SQL Server 2012

Length:3 Hours
Published:July 13, 2012
Language(s):English
Audience(s):IT Professionals
Level:200
Technology:Microsoft SQL Server 2012
Type:Course
Delivery Method:Instructor-led (classroom)
Show all itemsHide all items
About this Course
This one-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.
Audience Profile
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.
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.
Course OutlineModule 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.
Before attending this course, students must have:
  • An understanding of how data systems are used in a business enterprise.
Have Questions? For advice about training and certification, connect with peers: For questions about a specific certification, chat with a Microsoft Certified Professional (MCP): To find out about recommended blogs, Web sites, and upcoming Live Meetings on popular topics, visit our community site:
Course index

Find Training Near You

Location:

Eg: Seattle, WA or Paris, France