MS-10977 - Updating Your SQL Server Skills to Microsoft SQL Server 2014

This five-day instructor-led course provides existing SQL Server 2008 database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2014. The course covers the major advancements made in the SQL Server platform since SQL Server 2008, including new features in the SQL Server 2014 release. Microsoft Azure and Office 365 are required or used as part of the lab for this course, which may not be available in all countries. Please check with your Microsoft training provider that this cloud service is available in your area. Training Providers please reference the course setup guide for more details.

*This course utilizes higher hosting resources for online labs and therefore, post-class access is limited to 30 days.

Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus. Student
Excellent presentation skills, subject matter knowledge, and command of the environment. Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect. Student

Click here to print this page »


This course requires that you meet the following prerequisites:
  • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2008.
  • Familiarity with the Windows Server 2012 operating system and networking.
  • Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2014

Overview of SQL Server 2014
SQL Server 2014 Editions and Components
Installing SQL Server 2014
Enhancements to SQL Server Management Studio

Module 2: What’s New in SQL Server Database Development

Transact-SQL Enhancements
New and Enhanced Transact-SQL Functions
Enhancements to Spatial Data Support
Storing and Querying Documents with SQL Server 2014

Module 3: In-Memory Database Capabilities

The Buffer pool Extension
Columnstore Indexes
Memory-Optimized Tables

Module 4: Scripting SQL Server 2014

New and Enhanced Dynamic Management Views
Using PowerShell to Manage SQL Server

Module 5: Implementing Security in Microsoft SQL Server 2014

Security Management Enhancements
Contained Databases

Module 6: High Availability and Data Recovery Enhancements

AlwaysOn High Availability
Enhancements to Data Recovery

Module 7: New and Enhanced Features in SQL Server Integration Services

Using the CDC Control Task for Incremental Data Loads
Deploying and Operating SSIS Packages

Module 8: Data Quality Services

Introduction to Data Quality
Using Data Quality Services to Cleanse Data
Using Data Quality Services to Match Data

Module 9: Master Data Services

Introduction to Master Data Services
Implementing a Master Data Services Model
Using the Master Data Services Add-in for Excel

Module 10: SQL Server 2014 Reporting Services

Reporting Services Overview
Reporting Services and Microsoft SharePoint Server
Introduction to Data Alerts

Module 11: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model Projects
Creating a Tabular Model
Using an Analysis Services Tabular Data Model in the Enterprise

Module 12: Self-Service BI with Microsoft Excel

PowerPivot for Excel
PowerPivot for SharePoint Server
Power Query
Power View
Power Map
Collaborative Analysis with Power BI for Office 365

Module 13: Introduction to Cloud Data Solutions

Overview of Cloud Computing
Microsoft Azure Services for Data

Module 14: Microsoft Azure SQL Database

Introduction to Microsoft Azure SQL Database
Microsoft Azure SQL Database Security
Implementing and Managing Databases

Module 15: SQL Server in Microsoft Azure Virtual Machines

Introduction to Microsoft Azure Virtual Machines
Microsoft Azure Virtual Machine Connectivity and Security
Creating Databases in a Microsoft Azure Virtual Machine

Module 16: Implementing Big Data Solutions

Introduction to Big Data
Microsoft Azure HDInsight
Consuming HDInsight Results in Excel
Obtaining Data from the Microsoft Azure Marketplace