Module 1: Introduction to
SQL Server 2014
This module introduces key features of SQL Server 2014.
Module 2: What’s New in SQL Server Database Development
This module describes enhancements to Transact-SQL and other database
development features since SQL Server 2008.
Module 3: In-Memory Database Capabilities
This module describes how
SQL server 2014 enables you to leverage in-memory technologies to enhance
database performance.
Module 4: Scripting SQL Server 2014
This lesson describes how
you can use dynamic management views and PowerShell to script administrative
tasks in SQL server 2014.
Module 5: Implementing Security in Microsoft SQL Server 2014
This module describes the
enhancements to security features since SQL Server 2008.
Module 6: High Availability and Data Recovery Enhancements
This module describes
enhancements to SQL Server availability and data recovery features since SQL
Server 2008.
Module 7: New and Enhanced Features in SQL Server Integration Services
This module describes
enhancements to SQL Server Integration Services since SQL Server 2008.
Module 8: Data Quality Services
This module explains how to
use the SQL Server 2014 Data Quality Services (DQS) to provide a computer
assisted process for cleansing data values and identifying and removing
duplicate data entities.
Module 9: Master Data Services
This module introduces
Master Data Services and describes its key configuration options and how to
import and export data.
Module 10: SQL Server 2014 Reporting Services
This module describes new
and enhanced features in SQL Server Reporting Services.
Module 11: Implementing an Analysis Services Tabular Data Model
This module describes
Analysis Services tabular data models and explains how to develop a tabular
data model by using the SQL Server Data Tools for BI add-in for Visual Studio.
Module 12: Self-Service BI
with Microsoft Excel
This module introduces the
self-service BI capabilities that can be delivered through Microsoft Excel 2013
and related technologies.
Module 13: Introduction to Cloud Data Solutions
This module introduces some
of the key Microsoft technologies that you can use to implement a cloud
solution for data.
Module 14: Windows Azure SQL Database
This module introduces
Windows Azure SQL Database, a Platform-as-a-Service (PaaS) solution for
cloud-based relational database storage.
Module 15: SQL Server in Windows Azure Virtual Machines
This module explores how
you can use Windows Azure virtual machines in which SQL Server is installed to
create a cloud-based solution for data.
Module 16: Implementing Big Data Solutions
This module describes the
main features of big data, and the Microsoft technologies that you can use to
build big data analytical solutions. In particular, the module focuses on
Windows Azure HDInsight and the Windows Azure Marketplace as core elements of
the Microsoft solution for big data.