Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

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.

Click here to print this page »

Prerequisites


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